进入mysql:
mysql -uroot -p
用户管理:
use mysql;
查看用户
select host,user,password from user;
创建用户
create user 'phpfzh'@'localhost' identified by '123456';
刷新
flush privileges;
为用户创建数据库
create database phpfzh default charset utf8 collate utf8_general_ci;
查看全部数据库名
show databases;
为用户分配全部权限
grant all on phpfzh.* to phpfzh@localhost identified by '123456';
grant 权限1,权限2,…权限n on 数据库名称.表名称 to 用户名@用户地址 identified by ‘连接口令’;
授予用户在本地服务器对该数据库的全部权限
grant all privileges on `phpfzh`.* to 'phpfzh'@'localhost' identified by '123456';
授予用户通过外网IP对于该数据库的全部权限
grant all privileges on `testdb`.* to 'test'@'%' identified by '123456';
这里的% 是指任意ip