I had the same problem and none of the above solutions worked for me. I think one can end up in this position with older versions of mysql already installed.
I also tried: /usr/local/Cellar/mysql/5.1.52/bin/mysql_secure_installationīut I also get ERROR 1045 (28000): Access denied for user (using password: NO) How to solve this problem? Solution no. This is a brand new installation on a brand new machine and as far as I know the new installation must be accessible without a root password. I’ve tried to access mysqladmin or mysql using -u root -proot as well,īut it doesn’t work with or without password. I get: /usr/local/Cellar/mysql/5.1.52/bin/mysqladmin: connect to server at 'localhost'įailed error: 'Access denied for user (using password: NO)' However when I try to connect to the server using: /usr/local/Cellar/mysql/5.1.52/bin/mysqladmin -u root password 'mypass' I’m trying to setup up MySQL on mac os 10.6 using Homebrew by brew install mysql 5.1.52.Įverything goes well and I am also successful with the mysql_install_db.
