下面是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;