mysql8.0安装

1.下载mysql8.0

wget https://cdn.mysql.com//archives/mysql-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz

2.解压

tar xf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
mv mysql-8.0.11-linux-glibc2.12-x86_64 mysql
mv mysql /usr/local/

3.创建mysql用户组和用户

sudo groupadd mysql
sudo useradd -g mysql mysql

4.改变mysql目录权限

sudo chown -R mysql.mysql /usr/local/mysql/

5.初始化mysql

bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

可能出现以下错误：
bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
可以安装：

sudo apt install libaio*

输出如下：

2023-02-23T02:16:00.851836Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.11) initializing of server in progress as process 21653
2023-02-23T02:16:11.853475Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 9JZWudsxYc#s
2023-02-23T02:16:21.064487Z 0 [System] [MY-013170] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.11) initializing of server has completed

注意：这里要记住mysql的密码，后面修改密码需要

6.修改配置文件
a.首先通过命令查看mysql读物配置文件顺序：

bin/mysql --help | grep my.cnf

显示如下：

order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cn

b.修改配置文件

sudo vim /etc/mysql/my.cnf

c.改成如下

[mysqld]
    basedir = /usr/local/mysql
    datadir = /usr/local/mysql/data
    socket = /usr/local/mysql/mysql.sock
    character-set-server=utf8
    port = 3306
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    skip-name-resolve
[client]
    socket = /usr/local/mysql/mysql.sock
    default-character-set=utf8

7.建立mysql服务

cp  /user/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld

8.修改环境变量
a.在/etc/profile追加

export PATH=$PATH:/usr/local/mysql/bin

b.生效

source /etc/profile 

9.启动mysql

mysqld

10.修改mysql密码
a.安装客户端

sudo apt install mysql-client

b.使用上面的密码登录

mysql -uroot -p9JZWudsxYc#s

c.修改密码

alter user 'root'@'localhost' identified by '123456';

11.再使用新设置的密码登录即可