OS X 初次安装MYSQL

303 阅读1分钟

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