mySQL password root password reset : Log on to your system as the Unix user that the mysqld server runs as or as root / administrator Locate the .pid file that contains the server's process ID. The exact location and name of this file depend on your distribution, host name, and configuration. Common locations are /var/lib/mysql/ , /var/run/mysqld/ , and /usr/local/mysql/data/ . Generally, the file name has an extension of .pid and begins with either mysqld or your system's host name. in freebsd it is usually located at /var/db/mysql/servername.pid . You can also obtain the mysql process id (pid) by using the following command - ps - aux | grep mysql Issue command : shell > kill `cat /var/db/mysql/servername.pid` or shell # kill mysql-pid Create a text file containing the following statements. Replace the password with the password that you want to use. UPDATE mysql.user SET Password=PASSWORD('...