1
$ yum install -y wget
2
$ wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz

1
$ tar zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz -C /usr/local/mysql

1
$ mkdir -p /usr/local/mysql/data
2
$ groupadd mysql && useradd -r -g mysql mysql
3
$ chown -R mysql:mysql /usr/local/mysql/

1
$ cd /usr/local/mysql
2
$ ./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize
3
# 记录密码：(wat#<IyB2;j
4
2025-01-06T02:40:19.301346Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: (wat#<IyB2;j

1
$ vi /etc/profile
2
# 增加以下两行
3
export MYSQL_HOME=/usr/local/mysql
4
export PATH=$PATH:$MYSQL_HOME/bin
5
$ source /etc/profile

1
$ vi /etc/my.cnf
2
[mysqld]
3
basedir = /usr/local/mysql
4
datadir = /usr/local/mysql/data
5
socket = /usr/local/mysql/mysql.sock
6
character-set-server=utf8
7
port = 3306
8
bind-address = 0.0.0.0
9
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
10

11
[client]
12
socket = /usr/local/mysql/mysql.sock
13
default-character-set=utf8

1
$ cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
2
$ chmod +x /etc/init.d/mysqld
3
$ chkconfig --add mysqld

1
$ vi /usr/lib/systemd/system/mysql.service
2
[Unit]
3
Description=MySQL Server
4
Documentation=man:mysqld(8)
5
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
6
After=network.target
7
After=syslog.target
8

9
[Install]
10
WantedBy=multi-user.target
11

12
[Service]
13
User=mysql
14
Group=mysql
15
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
16
LimitNOFILE = 5000

1
$ systemctl stop firewalld
2
$ setenforce 0
3
$ systemctl daemon-reload
4
$ systemctl start mysql
5
$ systemctl enable mysql

1
$ mysql -uroot -p
2
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
3
Query OK, 0 rows affected (0.10 sec)
4
mysql> FLUSH PRIVILEGES;
5
Query OK, 0 rows affected (0.01 sec)
6
mysql> exit
7
Bye

1
$ mysql -uroot -p新密码
2
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
3
Query OK, 0 rows affected (0.04 sec)
4
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新密码';
5
Query OK, 0 rows affected (0.10 sec)
6
mysql> FLUSH PRIVILEGES;
7
Query OK, 0 rows affected (0.01 sec)
8
mysql> exit
9
Bye