4
MySql8.x允许外部访问
source link: https://zhangyiming748.github.io/post/remote_mysql8/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
MySql8.x允许外部访问
登陆后使用mysql
库
use mysql
更新域属性
update user set host='%' where user ='root';
应用当前表到内存
FLUSH PRIVILEGES;
执行授权语句
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK