mysql创建用户设置权限

1、创建数据库

create database wordpress;

2、创建用户

create user wordpress@localhost;

3、设置密码

alter user 'wordpress'@'localhost' identified by '该用户的密码';

4、配置权限

GRANT ALL PRIVILEGES ON wordpress.* to 'wordpress'@'localhost' IDENTIFIED BY '该用户的密码';

5、刷新权限配置

flush PRIVILEGES;