Poised-flw的前端博客

添加mysql用户 (5.6下测试有效)

*　首先登录root账户

mysql -u root -p
#　输入密码

添加账户

# 添加一个名叫`testUser`的账户，并且设定密码为：`123456`
insert into mysql.user(Host,User,Password) values("localhost","testUser",password("123456"));
# 刷新权限表
flush privileges;

登录新账户验证

mysql -u testUser -p
# 输入密码123456

权限控制

用root账户创建数据库

create database testDB;

把testDB授权给testUser用户

# 这里是授权所有权限all(select/update/delete...),　可单独授予：`select,update`
grant all privileges on testDB.* to testUser@localhost identified by '123456';
# 刷新权限表
flush privileges;

删除用户

先登录root账户

DELETE FROM user WHERE User="testUser" and Host="localhost";
flush privileges;
# 顺便删掉数据库
drop database testDB;

修改密码

# 登录root账户
update mysql.user set password=password('新密码') where User="testUser" and Host="localhost";
flush privileges;

5.7下添加用户

第一步

GRANT USAGE ON *.* TO 'tmpusr'@'localhost' IDENTIFIED BY 'newpassword' WITH GRANT OPTION;
#tmpusr 用户名
#newpassword 密码

第二步

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON databaseName.*  TO 'tmpusr'@'localhost' IDENTIFIED BY 'newpassword';

第三步

FLUSH PRIVILEGES;