写在前面:
由于mysql被oracle公司收购,centos7以后默认自带mariadb而不是mysql。mariadb是mysql的一个分支,全面兼容mysql。故如果想要在centos7安装mysql,需要先删掉mariadb,避免发生冲突。
安装流程:
1.卸载mariadb:
rpm -qa|grep mariadb
rpm -e --nodeps 上一句的结果
卸载mariadb后,/etc/my.cnf应不存在。
2.下载并安装yum源:
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
3.升级GPG并下载mysql客户端:
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum -y install mysql-server
4.启动mysql并查看状态
systemctl start mysqld.service
systemctl status mysqld.service
出现该结果代表成功
5.本地连接mysql
grep "password" /var/log/mysqld.log
mysql -uroot -p上一句的结果
6.修改密码并开启远程访问权限
ALTER USER 'root'@'localhost' IDENTIFIED BY 'passwd';
grant all privileges on *.* to '%'@'%' identified by 'passwd' with grant option;
flush privileges;
7.远程连接mysql:
mysql -hx.x.x.x --Port=3306 -uroot -p