mysql给远程登录权限

mysql> grant allon *.* to root@'%' identified by 'IE1d2gjFP2FC';

ERROR 2006 (HY000):MySQL server has gone away

No connection.Trying to reconnect...

Connection id:    6

Current database:mysql

 

Query OK, 0 rowsaffected (1.05 sec)

 

mysql> SELECTUser, Password, Host FROM user;

+------+-------------------------------------------+-----------+

| User |Password                                 | Host      |

+------+-------------------------------------------+-----------+

| root |*F7EB974AD296B55A6177F309A2328DD36382E17A | localhost |

| root |*F7EB974AD296B55A6177F309A2328DD36382E17A | %         |

+------+-------------------------------------------+-----------+

2 rows in set (0.00sec)

 

mysql>