首页 > 代码库 > MySQL创建用户、授权等

MySQL创建用户、授权等

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