mysql8.0常用命令

登录mysql

$ mysql -u root -p
$ 密码

查看所有用户

mysql> use mysql；
mysql> select * from user;

创建用户

#创建用户‘htrace22’（`%`表示所有ip均可链接，可制定为具体的ip地址）
mysql> CREATE USER `htrace22`@`%` IDENTIFIED BY '密码';  

#创建用户‘hszk’并指定加密方式为'mysql_native_password'
mysql> CREATE USER 'hszk'@'%' IDENTIFIED WITH mysql_native_password   BY '密码'; 

赋权限给用户

#授权‘htrace22’用户，拥有所有数据库的所有操作权限
mysql> GRANT ALL ON *.* TO `htrace22`@`%` WITH GRANT OPTION; 

#授权‘hszk’用户，拥有‘parkinglot’数据库的所有操作权限
mysql> GRANT ALL PRIVILEGES ON parkinglot.* TO 'hszk'@'%';

修改用户密码的加密方式为mysql_native_password

mysql> ALTER USER 'htrace2'@'%' IDENTIFIED BY 'htrace@20182' PASSWORD EXPIRE NEVER;
mysql> ALTER USER 'htrace2'@'%' IDENTIFIED WITH mysql_native_password BY 'htrace@20182'; 
mysql> FLUSH PRIVILEGES;

删除用户

mysql> DROP USER 'htrace2'@'%'