I just installed MySQL on Ubuntu and the root user can't log in :)
How can I recover or find out my password? Using blank for password does not work.
You can reset the root password by running the server with
--skip-grant-tables and logging in without a password by running the following as root (or with sudo):
# service mysql stop # mysqld_safe --skip-grant-tables & $ mysql -u root mysql> use mysql; mysql> update user set password=PASSWORD("YOUR-NEW-ROOT-PASSWORD") where User='root'; mysql> flush privileges; mysql> quit # service mysql stop # service mysql start $ mysql -u root -p
Now you should be able to login as root with your new password.
It is also possible to find the query that reset the password in
/root/.mysql_history of the user who reset the password, but the above will always work.