Linux系统安装MySQL8.0.26

目录

1、下载Linux版MySQL安装包

mysql下载地址

2、上传MySQL安装包 ​编辑

3、创建目录,并解压

4、安装mysql的安装包

5、启动MySQL服务

6、查询自动生成的root用户密码

7、修改root用户密码

8、创建用户

9、并给root用户分配权限

10、重新连接MySQL

---

1、下载Linux版MySQL安装包

mysql下载地址

2、上传MySQL安装包 

使用Xshell连接linux系统输入rz，按回撤上传下载mysql文件

3、创建目录,并解压

mkdir mysql

tar -xvf mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar -C mysql

4、安装mysql的安装包

cd mysql

rpm -ivh mysql-community-common-8.0.26-1.el7.x86_64.rpm 

rpm -ivh mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm 

rpm -ivh mysql-community-libs-8.0.26-1.el7.x86_64.rpm 

rpm -ivh mysql-community-libs-compat-8.0.26-1.el7.x86_64.rpm

yum install openssl-devel

rpm -ivh  mysql-community-devel-8.0.26-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.26-1.el7.x86_64.rpm

rpm -ivh  mysql-community-server-8.0.26-1.el7.x86_64.rpm

5、启动MySQL服务

1.启动：
systemctl start mysqld

2.重启：
systemctl restart mysqld

3.停止：
systemctl stop mysqld

6、查询自动生成的root用户密码

grep 'temporary password' /var/log/mysqld.log

7、修改root用户密码

ALTER  USER  'root'@'localhost'  IDENTIFIED BY '123456';

8、创建用户

create user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

9、并给root用户分配权限

grant all on *.* to 'root'@'%';

10、重新连接MySQL

mysql -u root -p