1、下载官方安装包
mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
官方链接 https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
2、在/usr/local目录下创建mysql文件夹
mkdir mysql
3、上传mysql安装包,这里可以采用FTP进行上传。上传位置为/usr/local/mysql
4、解压安装包
tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
5、卸载自带的maraidb-lib-版本号
rpm -qa|grep mariadb
mariadb-libs-版本号
rpm -e --nodeps mariadb-libs-版本号
rpm -qa|grep mariadb
若卸载不了可使用 yum remove 包名 -y 命令
6、安装mysql-community-common-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
7、安装mysql-community-libs-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
8、安装mysql-community-client-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
9、安装libaio
yum install libaio
执行后按照提示输入 y
10、安装mysql-community-server-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
11、初始化数据库
mysqld --initialize --user=mysql
12、启动mysql
systemctl start mysqld.service
set password=password('123456');
13、登录mysql
mysql -uroot -p
14、创建用户并赋权
grant all on *.* to 'testa'@'%' identified by '123456';
15、刷新权限
flush privileges;
跳过密码
vim /etc/my.cnf mysqld下面添加一行代码:skip-grant-tables
service mysqld restart
mysql -uroot -p 直接回车
use mysql;
show tables;
desc user;
update user set password=password('123456') where user='root'; 或者使用下面的
update user set authentication_string=password('123456') where user='root';
flush privileges;
exit;
去掉vim /etc/my.cnf mysqld下面代码:skip-grant-tables