![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
wwwsmef1
这个作者很懒,什么都没留下…
展开
-
mysql 远程登录
在本地用 Navicat 打开mysql中的mysql 执行:update user set host = ‘%’ where user = ‘root’;flush privileges;原创 2022-05-12 13:02:00 · 110 阅读 · 0 评论 -
ubuntumysql 远程
iptables -I INPUT -p tcp --dport 3306-j ACCEPT/etc/mysql/mysql.conf.d/mysqld.cnf: bind-address = 127.0.0.1改成0.0.0.0CREATE USER 'root'@'%' IDENTIFIED BY 'pass!';grant all privileges on *.* to 'root'@'%';两个root用户 localhost % 授权成功grant all priv...原创 2021-08-17 14:11:53 · 84 阅读 · 0 评论