用于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;
新建用户分配权限等