MySQL创建用户、授权等

用于MySQL5.6命令行执行成功:

MySQL创建用户、授权等
create database wp_people;

create user wp_people@localhost identified by yrwb ;

use mysql;

update user set Password=PASSWORD("yrwb") where user=wp_people;

grant all privileges on wp_people.* to wp_people@localhost identified by yrwb;

flush privileges; 
新建用户分配权限等

 

MySQL创建用户、授权等,布布扣,bubuko.com

MySQL创建用户、授权等

上一篇:sql server 的datediff函数


下一篇:SQLSERVER连接池内部机制