mysql登录设置_MySQL 登录配置

GRANT

ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'abc';

mysql>

select user, host, password from mysql.user;

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

|

user | host      | password         |

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

|

root | localhost | 7b49a39922703c30 |

|

root | wengdev01 |                  |

|

root | 127.0.0.1 |                  |

|      | localhost |                  |

|      | wengdev01 |                  |

|

root | %         | 7b49a39922703c30 |

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

6

rows in set (0.00 sec)

DELETE FROM mysql.user WHERE Host <> '%'

and user = 'root';

mysql>

select user, host, password from mysql.user;

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

|

user | host | password         |

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

|

root | %    | 7b49a39922703c30 |

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

1

row in set (0.00 sec)

mysql>

FLUSH PRIVILEGES;

Query

OK, 0 rows affected (0.00 sec)