卸载centos7默认安装的MariaDB,因为和mysql有冲突
#rpm -qa | grep mariamariadb-libs-5.5.52-1.el7.x86_64
#yum remove mariadb-libs -y
下载最新的mysql官方yum源
https://dev.mysql.com/downloads/repo/yum/
安装:yum localinstall mysql57-community-release-el7-9.noarch.rpm
用yum info命令搜索mysql-community-server,确认详细的信息
yum info mysql-community-server
最后:yum install mysql-community-server -y
可以看到默认需要依赖的安装包:
设置开机启动mysql服务:
systemctl enable mysqld.service
systemctl daemon-reload
启动mysql服务:
systemctl start mysqld.service
停止:
systemctl stop mysqld.service
查看mysql运行状态:
systemctl status mysqld.service
配置mysql,重置root密码,默认生成的密码在/var/log/mysqld.log,首先以这个密码登录mysql来修改root密码
mysql -uroot -p
如果不修改密码执行mysql命令,mysql5.7会提示:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
可见mysql的安全性做的越来越高,接下来修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxxxx';
修改mysql编码,修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置
character_set_server=utf8
init_connect='SET NAMES utf8'
开启log日志,配置my.cnf
log-bin=mysql-bin.log(默认在数据目录/var/lib/mysql)
server-id=序列号(必须配置)
重启:systemctl restart mysqld.service