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

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; 

新建用户分配权限等

04-29 03:11