mySQL 8.0.33 Installation Guide (recommended)

tar -xf mysql-8.0.33-el7-x86_64.

mv mysql-8.0.33-el7-x86_64 mysql
mv mysql /usr/local/

useradd -s /sbin/nologin mysql

chown -R mysql:mysql /usr/local/mysql/
chown mysql:mysql /etc/

# Client Configuration[client]
port = 3306                      # The default port for MySQL client connectionsocket=/usr/local/mysql/ # MySQL client connection socket file path# MySQL Server Configuration[mysqld]
user = mysql                      # System user running MySQL servicebasedir=/usr/local/mysql          # Path to MySQL installation directorydatadir=/usr/local/mysql/data     # MySQL data file storage directoryport = 3306                      # The port number of MySQL server listeningcharacter-set-server=utf8         # Server-side default character setpid-file = /usr/local/mysql/ # Path to the MySQL server process ID filesocket=/usr/local/mysql/ # The socket file path used by MySQL serverbind-address = 0.0.0.0           # The IP address bound to the MySQL server, 0.0.0.0 means listening to all available network interfacesskip-name-resolve                # Disable DNS resolution to improve connection speed, but may cause connection to be unable to be used with the hostnamemax_connections=2048             # Maximum number of concurrent connections alloweddefault-storage-engine=INNODB    # The default storage engine is set to InnoDBmax_allowed_packet=16M           # The maximum allowed packet size, unit in bytesserver-id = 1                    # Unique identifier in MySQL replication, used for master-slave replicationsql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION # SQLMode settings，DefinedMySQLHow to deal with itSQLStatement

echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile

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

cp /usr/local/mysql/support-files/ /etc//mysqld
chmod +x /etc//mysqld
systemctl daemon-reload
systemctl restart mysqld

mysqladmin -u root password "123456"

mysql -u root -p123456

CREATE USER 'root'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
flush privileges;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';