mac mysql 1045 28000,错误1045（28000）：在MAC OSX上对用户'root'@'localhost'的访问被拒绝（使用密码：否）...

I'm trying to reinstall mysql on my MAC OS X Yosemite. for this I followed the instruction as mentioned below

sudo rm /usr/local/mysql

sudo rm -rf /usr/local/mysql*

sudo rm -rf /Library/StartupItems/MySQLCOM

sudo rm -rf /Library/PreferencePanes/MySQL*

vim /etc/hostconfig and removed the line MYSQLCOM=-YES-

rm -rf ~/Library/PreferencePanes/MySQL*

sudo rm -rf /Library/Receipts/mysql*

sudo rm -rf /Library/Receipts/MySQL*

sudo rm -rf /var/db/receipts/com.mysql.*

I also tried

brew uninstall mysql

after this I installed mysql using homebrew using command brew install mysql.

After installation when I tried to run mysql -u root It throws the following error

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using

password: NO)

I didn't set password for mysql.I don't know what's going wrong.Any suggestion will be appreciated. Thank you

解决方案

I installed mysql with homebrew and got the same problem as you because mysql has had an existing database with an existing password there. See this article for more details.

$ brew services stop mysql

$ pkill mysqld

$ rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!!

$ brew postinstall mysql

$ brew services restart mysql

$ mysql -uroot