对于多个不同机器访问数据库的权限,需要在权限分配时指定其主机名,并同时指定密码。
如:hadoop02、hadoop03两台机器要登录mysql,需要赋权:
1 2 3 |
GRANT ALL PRIVILEGES ON *.* TO 'root'@'hadoop02' identified by 'yourpassword'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'hadoop03' identified by 'yourpassword'; FLUSH PRIVILEGES; |
使用通配符无效,这一条不太科学。以后有机会再验证:
1 2 |
#本命令为何无效? GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identified by 'yourpassword'; |