当前位置：网站首页>Configure MySQL remote access

Configure MySQL remote access

2022-04-21 07:41:00 【Sound God】

Connect to database 

mysql -uroot -proot -h127.0.0.1

choice mysql database 

use mysql

Inquire about user surface , see host and user situation 

select user,host from user;

Insert picture description here

All users can only access locally , We need to put the of users who need remote access host Change to %

update user set host='%' where user='root';

Modify host after , We want it to take effect immediately 

flush privileges;

Reference article ：https://www.cnblogs.com/ymworkroom/p/10716919.html

版权声明
本文为[Sound God]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204210623448922.html

边栏推荐

猜你喜欢

随机推荐