1 给用户username设置权限
USE mysql;
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
2 开发3306端口
#firewall-cmd --zone=public --add-port=3306/tcp --permanent
显示success
#firewall-cmd --reload
显示success
3 重新连接
2022-11-08 08:18:01
1 给用户username设置权限
USE mysql;
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
2 开发3306端口
#firewall-cmd --zone=public --add-port=3306/tcp --permanent
显示success
#firewall-cmd --reload
显示success
3 重新连接