Q & A

Sometimes we get the question from a customer to check something in there database, noone knew there even was a root password for the database. This is a quick way to change the PW.FreeBSD:
In the /etc/rc.conf

mysql_args=”–skip-grant-tables –skip-networking”

And restart the MySQL server. now you can login with mysql -u root -p

Change the PW:

use mysql;

UPDATE USER SET Password=PASSWORD(‘yournewpassword’) WHERE USER=’root’;

Now remove the arguments again from the rc.conf and restart. Voillia.

For linux et start the server like this:

mysqld –user=mysql –skip-grant-tables –skip-networking &