MySQL 8: Creating Users and Granting Privileges

下面是CreateUseruser123,database名user123,Password工23456为例:

create database user123 default charset utf8 collate utf8_general_ci;  #先建立一个库
create user 'user23'@'%' identified by 'a123456';  #CreateUser,Password
grant all privileges on user123.* to 'user123'@'%' with grant option;   #授权某个库给User

grant all privileges on *.* to 'tone'@'%' with grant option;   #授权全部库给该User
flush privileges;

Leave a Comment

Your email address will not be published.