终端输入:
cd /usr/local/mysql/
bin/mysql -u root -p
注意!!
错误用法:
cd /usr/local/mysql/bin/
mysql -u root -p
出现
Enter password:
注意:输入安装时给的默认密码,而不是系统密码!!
ALTER USER USER() IDENTIFIED BY 'myroot';
myroot是想要修改的密码
注意:
1. 新密码用' '
否则会报错:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'XXX'
2. 结尾不要忘记加上;!!