MySQL配置文件是: /etc/mysql/mysql.conf.d/mysqld.cnf
想允许被可远程访问,就把bind-address = 127.0.0.1改为bind-address = 0.0.0.0
想修改远程访问端口,就把port = 3306这一行的3306改为你要去用的端口号
想允许使用root远程访问,
先使用mysql -u root -p 命令登录到MySQL,然后:
CREATE USER IF NOT EXISTS ‘root’@‘localhost’ IDENTIFIED BY ‘yourpassword’;
CREATE USER IF NOT EXISTS ‘root’@‘%’ IDENTIFIED BY ‘yourpassword’;
GRANT ALL PRIVILEGES ON . TO ‘root’@‘localhost’ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
想修改root的密码为简单弱密码,用下面的指令
SHOW VARIABLES LIKE ‘validate_password%’;
set global validate_password.policy=LOW;
如果还是访问不了,可能是防火墙挡住了,就在终端窗口用下面的指令试试:
sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent
sudo firewall-cmd --reload
sudo firewall-cmd --permanent --add-service=mysql
sudo firewall-cmd --reload