安装参考:https://blog.csdn.net/wqc19920906/article/details/131202905
注意点 1
必须先更改密码,而且密码是大小写字幕特殊符号数字四者都要有,然后才能再去修改密码等级…
注意点 2
MySQL版本8.0.21,在给新用户授权时,执行如下语句:
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
报错如下:
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 ‘identified by ‘password’ with grant option’
原因分析 :高版本的MySQL把将创建账户和赋予权限分开了。
解决方法:分开执行。
#创建账户
create user 'root'@'%' identified by '123456';
#赋予权限
grant all privileges on *.* to 'root'@'%' with grant option;
#刷新
flush privileges;