远程连接mysql 提示 Access denied for user 'root'@'192.168.3.20' (using password: YES)

mac2024-06-03  31

是因为没有正确的开放mysql远程权限 1. mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 用户root 密码是123456 2. mysql> FLUSH PRIVILEGES; 3.重启mysql /etc/init.d/mysql restart

最新回复(0)