1、配置yum源,在mysql官网中下载yum源rpm安装包:
https://dev.mysql.com/downloads/repo/yum/
使用shell命令
下载mysql源安装包:
wget
https://dev.mysql.com/downloads/repo/yum/
mysql57-community-release-el7-11.noarch.rpm
安装mysql源:
yum localinstall
mysql57-community-release-el7-11.noarch.rpm
检查mysql源是否安装成功:
yum repolist enabled | grep "mysql.*-community.*"
表示安装成功;
2、安装MYSQL
shell命令:
yum install mysql-community-server
3、启动MYSQL服务
shell命令:
systemctl start mysqld
查看mysql启动状态:
systemctl status mysqld
4、设置开机启动
shell命令:
systemctl enable mysqld
systemctl daemon-reload
5、重置MYSQL登录密码
Shell命令:
vi /etc/my.cnf
在[mysqld]后加上:
skip-grant-tables
重新启动mysql
#
service mysqld restart
登录并修改root密码
#mysql
user mysql
update userset Password = password('123456') where user='root';
flush privileges;
quit;
6、将mysql的登录设置修改回去
把my.cnf 中的skip-grant-tables去掉
7、重新启动mysql
service mysqld restart
8、设置远程客户端可以访问权限
进入mysql命令,
输入命令:
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;
命令解释:
防火墙开发3306端口,重启即可