MySQL 8.0创建用户与授权分2步

1. create user 'username'@'%' identified by 'password';
2. grant all on databasename.* to 'username'@'%';
3. flush privileges;

5.6

• 密码重置

show databases;
use mysql;
update user set authentication_string=PASSWORD("自定义密码") where user='root';
update user set plugin="mysql_native_password";（这句话需要先检查下 plugin 字段是不是 mysql_native_password）
flush privileges;
quit;


ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345';

• 备份

mysqldump --host=旧主机 -u用户名 -p密码 --opt 数据库名 | mysql --host=新主机 -u用户名 -p密码 -C 新数据库名
mysqldump -uroot -p123 test > test.dump

• 创建库和授权

创建用户
CREATE USER 'user'@'localhost'   IDENTIFIED BY 'password';
create database databasename default character set = 'utf8mb4';

grant all on databasename.* to 'username'@'%' identified by 'password';