create user 'root'@'%' identified by '替换成你的密码';
grant all on *.* to `root`@`%` with grant option;
flush privileges;
--删除旧用户
drop user root@'localhost';
linux需要改配置文件:
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-address = 127.0.0.1注释掉(即在行首加#)
mysql8.0允许远程root登录
最新推荐文章于 2024-01-05 11:43:08 发布