在安装mysql的机器上运行:
d:\mysql\bin\>mysql -h localhost -u root
单台授权:
grant all privileges on *.* to 'root'@'10.24.23.55' identified by '1234' with grant option;
注意授权后必须flush privileges;否则无法立即生效。
多台授权:
//赋予任何主机访问数据的权限
mysql>
grant all privileges on *.* to 'root'@'%' identified by '1234' with grant option;
如果用以下则会报错:(上面是新建用户)
grant all privileges on *.* to 'root'@'%' with grant option;
----->ERROR 1133 (42000): Can't find any matching row in the user table
//修改生效
mysql> flush privileges;