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';
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';