一、下载
可以到Mysql官网下载
mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar
包,上传至Linux服务器。
二、先查看系统是否自带mysql,如有则删除
rpm -qa | grep mysql
三、检查并删除的冲突依赖
rpm -qa | grep postfix
rpm -qa | grep mariadb
四、卸载软件方法
rpm -e --nodeps 软件名称
五、安装依赖
yum install perl-Module-Install.noarch
yum install net-tools
六、按照以下顺序安装Mysql的客户端和服务器
rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
七、启动/停止MySQL
systemctl start/stop mysqld
八、查看Mysql服务的状态
service mysqld status
systemctl status mysqld
九、设置开机启动
systemctl enable mysqld
十、查看临时密码
grep password /var/log/mysqld.log
结果的最后面的一串较为复杂的字符串即为临时密码。
十一、使用临时密码登录mysql后,修改密码
set password = password("Xx_123456");
十二、开启远程连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Xx_123456' WITH GRANT OPTION;
十三、刷新权限
flush privileges;