发现问题
今天在MAC上安装完MYSQL后,MYSQL默认给分配了一个默认密码,但当自己在终端上使用默认密码登录的时候,总会提示一个授权失败的错误:Access denied for user ‘root’@’localhost’ (using passwor)如图:
解决问题
首先,进入到/usr/local/mysql/support-file,然后按以下步骤操作:
# cd /usr/local/mysql/support-file && ./mysql.server stop
# sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables &
mysql > UPDATE mysql.user SET authentication_string=PASSWORD('root123*') WHERE User='root';
mysql > FLUSH PRIVILEGES;
mysql > \q
# cd /usr/local/mysql/support-file && ./mysql.server start
# /usr/local/mysql/bin/mysql -u root -p
passwd: 输入密码