MYSQL8 常用操作

• 创建数据库

mysql> create database if not exists meeting;

• 创建账号

mysql> CREATE USER meeting IDENTIFIED BY 'pass123';

• 授权

mysql> grant execute,insert,update,delete,drop,create,drop,alter on meeting.* to 'meeting'@'%' with grant option;
mysql> flush privileges;

• 修改密码

mysql> alter user 'meeting'@'%' identified with mysql_native_password by 'pass456';

• 特别注意

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'

如遇上以上问题请使用update语句先清空authentication_string字段，然后再修改密码即可

mysql> update user set authentication_string='' where user='root'; 

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';

 

 

 

转载于:https://www.cnblogs.com/doraman/p/11116012.html