1.安装的MySQL的的的的
新建目录存储下载的包mkdir mysql cd mysql
1. wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm (下载mysql源安装包)
2.rpm -ivh mysql57-community-release-el7-8.noarch.rpm (安装源文件)
3.yum repolist启用| grep“mysql。* - community。*”(检查mysql源是否安装成功)
4.yum安装的MySQL的的的社区服务器(安装的MySQL的的的)
5. service mysqld start(启动服务)
2.修改根默认密码
1 grep'临时密码'/var/log/mysqld.log(获取mysql默认密码 后面的为密码)
2. mysql -uroot -p(登陆mysql)
3.ALTER USER'root'@'localhost'ENFENTIFIED BY'Jl61525354!';(修改mysql默认密码)
4. grant ALL PRIVILEGES ON *.* TO 'landa'@'%' IDENTIFIED BY 'Hgee2016#' WITH GRANT OPTION;(添加远程用户
)
5.flush privileges;(使授权立刻生效)
最后一步(防火墙)
1. yum install firewalld firewall-config(安装firewalld )
2.systemctl status firewalld(查看状态)
3.firewall-cmd --zone = public --list-ports(查看端口号)(或firewall-cmd --list-ports)
4.firewall-cmd --zone = public --add-port = 3306 / tcp --permanent (永久开放3306端口号)或( firewall-cmd --add-port=3306/tcp)
5.firewall-cmd --reload(重新加载)
6.firewall-cmd --zone = public --list-ports(查看开放的端口号信息)
更多防火墙知识参考: https://blog.csdn.net/u010260737/article/details/84488743
本地Navicat的连接测试成功