centos7 下安装MySQL5.7
一:安装
1:先安装wget
yum -y install wget
2:从网址获取
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
3:安装MySQL源
yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
4:在线安装MySQL
yum -y install mysql-community-server
5)启动MySQL服务
systemctl start mysqld
6)设置开启启动
systemctl enable mysqld
systemctl daemon-reload
一帆风顺的安装完成之后,登陆MySQL就悲催的发现报了如下错误:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
因此,大家可以直接进行以下操作,减少不必要的错误》~《
二:登陆MySQL
1:停止MySQL服务
systemctl stop mysqld.service
2:修改config文件,添加如下
进入config文件:
vim/etc/my.cnf
添加语句:
skip-grant-tables
3:开启MySQL服务
systemctl start mysqld.service
4:进行无密码登陆
mysql -u root
5:利用sql语句设置密码
update mysql.user set authentication_string=password('设置的密码') where user = 'root';
6:刷新服务器
flush priviledges
7:退出mysql
exit
8:停止服务
9:进入config文件,删掉在底部添加的skip-grant-tables
10:开启服务
11:登陆MySQL
mysql -u root -p