本文主要阐述数据库创建,用户创建,用户授权以及更改用户host。
创建数据库
- 登陆mysql:
mysql -u root -p - 创建db1数据库:
create database db1;
创建用户
- 创建localhost用户u1,密码123456:
create user ‘u1’@‘localhost’ identified by ‘123456’; - 创建远程用户u2,密码123:
create user ‘u2’@’%’ identified by ‘123’;
授权
- grant all privileges on db1.* to u1;(给本地用户u1授权)
- grant all privileges on db1.* to u2;(给远程用户u2授权)
刷新授权
- flush privileges;
查看授权
- show grants for u1;
- show grants for u2;
附:改localhost用户为远程用户
- mysql -u root -p
- use mysql;
- update user set host=’%’ where user=‘用户名’;
- flush privileges;
- select user, host from mysql.user; 或select host from user where user=‘用户名’