Linux系统下受权MySQL账户拜候指定数据库[服务器安全]

需求:

1、在MySQL中成立数据库mydata

2、新建MySQL账户admin密码123456

3、赋予账户admin对数据库mydata具有完好操作权限

======================================================================

操作以下:

1、登录MySQL数据库

      mysq  -uroot  -p    #在终端号令行输入

      123456         #输入密码

2、show databases;     #显示数据库列表

3、create database mydata;     #成立数据库mydata

4、insert into mysql.user(Host,User,Password) values('localhost','admin',password('123456'));    #新建账户admin,密码123456

5、flush privileges;    #革新系统受权表

6、grant all on mydata.* to 'admin'@'%' identified by '123456' with grant option;    #答应账户admin从任何主机衔接到数据库mydata

至此,账号admin对数据库mydata具有完好管理权限.

========================================================================  

扩大:

      grant all on mydata.* to 'admin'@'192.168.1.1' identified by '123456' with grant option;    #账户admin只能从192.168.1.1衔接到数据库mydata 

      grant all on mydata.* to 'admin'@'localhost' identified by '123456' with grant option;     #账户admin只能从本机衔接到数据库mydata

      update mysql.user set password=password(1234) where User="admin" and Host="localhost";   #改正账号admin密码为1234

      revoke all on mydata.* from 'admin'@'%';           #禁止用户admin从任何主机拜候数据库mydata  

      revoke all on mydata.* from 'admin'@'192.168.1.1';     #禁止用户admin从192.168.1.1拜候数据库mydata 

      dalete  from  mysql.user  where  user="admin" and Host="localhost";    #删除用户admin

======================================================================

备注:在Windows中操作办法近似,请大家自行测试.