Enable passwordless access to MySQL

Question

How can I delete my password for MySQL? I dont want to have a password to connect to the database. My server is running Ubuntu.

Answer 1

Personally, I think instead it's better to set a password and save it in /root/.my.cnf:

First:

mysqladmin -u root password 'asdfghjkl'

Then edit root's .my.cnf file:

[client]
password = asdfghjkl

Now you have a password but you're no longer prompted for it. My default MySQL server install is a totally random unique password for each MySQL server, saved in the .my.cnf file like this.

Answer 2

If you DO have a password set for MySQL, follow the instructions at Recover MySQL root Password, and then set your password to null:

update user set password=PASSWORD("") where User='root';

Answer 3

I'm pretty sure that by default there is no password if your the admin user and accessing it locally. Are you finding something different than that?

Does this work?

#> mysqladmin -u root password ''