I have a MySQL server with the MySQL root password is an empty string. If I try to connect to MySQL without a password, I am denied. Like this:
# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) # mysql -p Enter password: <-- I just hit enter, without typing anything Welcome to the MySQL monitor. Commands end with ; or \g. mysql>
How can I get MySQL to let me connect without prompting me for the password first? I have other servers where I can connect just fine without prompting for any password, and those other servers aren't using a .my.cnf file either.