CentOS 7 安装MySQL5.7.16

注意MySQL版本的不同，安装过程会有不同

1. 检验是否安装过mysql

rpm -qa | grep -i mysql

若存在MariaDB(系统自带)或MySQL，则删除

rpm -qa|grep mariadb
yum remove mariadb...  # 删除显示的mariadbXXX
# 如 ：yum remove mariadb-libs-5.5.52-1.el7.x86_64
或者 
rpm -qa |grep mysql
rpm -e mariadb...   # 删除显示的mysqlXXX,或者mariadbXXX
#如 ： rpm -e mariadb-5.5.52-1.el7.x86_64
rm -rf /var/lib/mysql/ # 删除此目录下的文件

2. 下载并安装mysql

安装顺序依次为common→libs→client→server

rpm -ivh mysql-community-common-XXX
rpm -ivh mysql-community-libs-XXX
rpm -ivh mysql-community-client-XXX
rpm -ivh mysql-community-server-XXX

3. mysql服务初始化

mysqld --initialize --user=mysql

出现如下错误

[Warning]TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details)
[ERROR] --initialize specified but the data directory has files in it. Aborting.
[ERROR] Aborting

解决 : 删除/var/lib/mysql/目录里的文件
rm -rf /var/lib/mysql/*   
再初始化     
mysqld --initialize --user=mysql

4. 获取初始密码

cat /var/log/mysqld.log    #密码位于最后一行，右下角

5. 开启mysql

systemctl start mysqld.service   # 开启
systemctl restart mysqld.service  #重启
systemctl stop mysqld.service  # 关闭

6. 登入并修改密码

mysql -uroot -p
#输入默认密码(多试几次)
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';  # 修改密码

mysqladmin --version    # 查看MySQL版本
ps -ef |grep mysql    # 查看mysql进程
systemctl list-unit-files | grep mysqld  # 查看是否自启动