What is my MySQL root password?

Question

Where or how do I check MySQL root password? I don't have a .my.cnf file, I can't login to SQL console (it requires a password), I can't do anything.

Answer 1

There is no way to lookup the password. It is encrypted. On many systems the root password is blank by default. On other systems you would have been asked to set the root password when you installed mysql. The password reset procedure is described here (http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html).

Answer 2

If you manage to get a shell you can set it this way:

Start mysql with:

mysqld_safe --skip-grant-tables

Log in mysql

mysql --user=root mysql

Update the root password:

UPDATE user SET Password=PASSWORD('newpwd') WHERE User='root';
flush privileges;
exit;

Answer 3

I think that you may look at your /root/.mysql_history or on your applications web, ... using mysql maybe you will find some useful information there.

If you are on a Debian or Ubuntu you could set a new root password like this:

sudo dpkg-reconfigure mysql-server

Answer 4

You can start the MySQL daemon with --skip-grant-tables, access it and change the root password then restart it,

mysqld_safe --skip-grant-tables &

Answer 5

By default, it's the following pair:

• username: "root"
• password: ""