mysql访问授权

在安装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;