1.安装MYSQL结束后,弹出对话框
2.root@localhost:后的是MYSQL默认给出的随机密码,第一次登陆必须使用随机密码!
3.登陆方式,使用终端方式登陆$ /usr/local/MySQL/bin/mysql -u root -p
4.输入随机密码 上图的为Gs8)MUQw3s>#
5.进入mysql命令行,不管输入什么都会报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
6.原因是必须修改新密码,否则不能进行后面操作,请进行如下3步
1: SET PASSWORD = PASSWORD(‘your new password‘);
2: ALTER USER ‘root‘@‘localhost‘ PASSWORD EXPIRE NEVER;
3: flush privileges;
your new password替换成你要改的新密码
7.密码修改完成,你可以使用工具来登陆mysql了
假如你忘记了初始化密码这里有个笨办法------将MYSQL直接删除重新安装,删除步骤如下
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
vim /etc/hostconfig (and removed the line MYSQLCOM=-YES-)
rm -rf ~/Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*