1.首先在CentOS端进入数据库
mysql -u root -p"youpassword"
2.进行授权操作
GRANT ALL PRIVILEGES ON 数据库名.表名 TO 'root'@'IP地址' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
- 如果想让root用户只能在指定IP下才能登陆，如111.111.111.111，即
GRANT ALL PRIVILEGES ON 数据库名.表名 TO 'root'@'111.111.111.111' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
- 如果想让root用户只能在任何IP下都能登陆，将IP地址替换为%，即
GRANT ALL PRIVILEGES ON 数据库名.表名 TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
- 如果想给所有数据库的所有表的所有操作权限均授权给root这个用户，那么数据库名和表名均为*，即
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
3.重载授权表完成
FLUSH PRIVILEGES;
网友评论