Mysql 创建用户

为什么80%的码农都做不了架构师？>>>   

1. 创建本地账户

CREATE USER “test”@”localhost” IDENTIFIED BY “1234”;

2.创建本地与远程账户

CREATE USER “test”@”%” IDENTIFIED BY “1234”;

3.将指定数据库权限赋值给指定用户(本地),远程的用"%".

grant select,update on dataBaseName.* to “test”@”localhost” identified by “1234”; 
-- 刷新数据库权限信息
flush privileges;

4.赋值全部权限(本地),远程的用"%".

grant all privileges  on testDB.* to “test”@”localhost” identified by “1234”; 
flush privileges; #刷新系统权限表

 

 

 

 

转载于:https://my.oschina.net/lmxy1990/blog/1928969