mysql 用户创建和授权
mysql -uroot -p
\s
mysql Ver 8.0.16 for Linux on x86_64 (Source distribution)
select user,host from mysql.user;
-
创建并授权一个新用户
8.0之后,用户创建和授权要分开。不然会报错
create user 'blime2'@'%' identified by 'pls';
grant all privileges on *.* to 'blime2'@'%';