Mysql数据库账户权限设置

修改数据库.表名 SET password=加密(‘密码’) where user=’root’;

UPDATE mysql.user SET password = PASSWORD('123') WHERE user='root'; flush PRIVILEGES;

备注: flush PRIVILEGES; 表示:刷新数据表,不添加,修改的sql语句不会立即生效

GRANT ALL PRIVILEGES ON testdb.* TO 'testuser'@'localhost' IDENTIFIED BY '123'; flush PRIVILEGES;

GRANT ALL PRIVILEGES ON testdb.* TO 'testuser'@'127.0.0.1' IDENTIFIED BY '123'; flush PRIVILEGES;

GRANT ALL PRIVILEGES ON testdb.* TO 'testuser'@'%' IDENTIFIED BY '123'; flush PRIVILEGES;

3.设置只读权限

GRANT SELECT ON testdb.* TO 'testuser'@'192.168.0.%' IDENTIFIED BY '123'; flush PRIVILEGES;

巴特西