首页 > 数据库技术 > 详细

【Mac MySql异常】Bug 1045 (28000): Access denied to user 'root'@'localhost' on MAC OSX (use password: no) (ERROR 1045 (28000):

时间:2021-09-07 16:46:57      阅读:26      评论:0      收藏:0      [点我收藏+]

  1、清除本地MySql相关  

  重装Mysql之前先删除本地MySql的相关文件。

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.*

  也可以直接在设置偏好设置里面执行Uninstall,记得在弹窗中,勾选清楚相关文件

技术分享图片

 

  2、安装MySql  

$ 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

 

【Mac MySql异常】Bug 1045 (28000): Access denied to user 'root'@'localhost' on MAC OSX (use password: no) (ERROR 1045 (28000):

原文:https://www.cnblogs.com/xjf125/p/15237435.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!