阿里云 centOS7下安装MySQL教程

1.下载
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
2.安装MySQL源
yum localinstall mysql57-community-release-el7-8.noarch.rpm
3.检查mysql源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
4.安装MySQL
yum install mysql-community-server
5.启动MySQL服务
systemctl start mysqld
6.查看MySQL的启动状态
systemctl status mysqld


如果启动报这个错（Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.）
同时查看/var/log/mysqld.log日志中报错（大概是mysql.user表未找到）,是因为数据库未初始化
初始化数据库步骤
查看/etc/my.cnf文件，找到datadir指向的路径（一般是datadir=/var/lib/mysql），进入到这个路径，并将里面的数据全部清空
重新初始化数据库
mysqld --initialize --explicit_defaults_for_timestamp
在/var/log/mysqld.log日志中查找root用户的登录密码grep 'temporary password' /var/log/mysqld.log,此时就可以重新登录了
如果在登录时报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
很有是刚刚初始化datadir目录时的权限有问题（在/var/log/mysqld.log可以看到），此时可以使用chmod -R 777 /var/lib/mysql改变权限
登录后需要重置密码ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';