Mysql开启远程连接
时间:2021-07-01 10:21:17
帮助过:21人阅读
> GRANT ALL PRIVILEGES ON *.* TO
‘USERNAME‘@
‘%‘ IDENTIFIED BY
‘PASSWORD‘ WITH GRANT OPTION;
#允许单个ip 修改用户名和密码为你自己的
mysql> GRANT ALL PRIVILEGES ON *.* TO
‘USERNAME‘@
‘1.2.3.4‘ IDENTIFIED BY
‘PASSWORD‘ WITH GRANT OPTION;
#最后
mysql> FLUSH PRIVILEGES;
最后成功连上服务器的MySQL,?(•? _ •? ?)
Mysql开启远程连接
标签:自己 用户 命令 mamicode 服务 pre word 远程访问 src