CENTOS 安装MySQL

tar -vzxf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz

ln -s mysql-5.7.29-linux-glibc2.12-x86_64 mysql

groupadd mysql
useradd -r -g mysql -s /bin/false mysql

cd /usr/local/mysql
chown -R mysql:mysql ./

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

[root@db-7-51 mysql]# ./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize

……省略……
2022-07-12T03:27:31.727756Z 1 [Note] A temporary password is generated for root@localhost: yZho-p8Zsmuv
# 命令输出中有生成的临时密码: yZho-p8Zsmuv

./support-files/mysql.server start

[root@db-7-51 mysql]# ./support-files/mysql.server start
Starting MySQL.2022-07-12T03:28:10.588141Z mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'.
 ERROR! The server quit without updating PID file (/var/lib/mysql/db-7-51.pid).

[root@db-7-51 mysql]# mkdir -p /var/log/mariadb/
[root@db-7-51 mysql]# touch /var/log/mariadb/mariadb.log
[root@db-7-51 mysql]# chown mysql:mysql /var/log/mariadb/mariadb.log
[root@db-7-51 mysql]# ./support-files/mysql.server start
Starting MySQL.2022-07-12T03:29:34.161359Z mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.
 ERROR! The server quit without updating PID file (/var/lib/mysql/db-7-51.pid).

2022-07-12T03:30:04.916037Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
……
2022-07-12T03:30:05.591286Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2022-07-12T03:30:05.591295Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2022-07-12T03:30:05.591331Z 0 [ERROR] Aborting

vim /etc/my.cnf

# 将以下配置复制到my.cnf

[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port = 3306
socket=/tmp/mysql.sock
 
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/tmp/mysqld/mysqld.pid
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
[client]
default-character-set=utf8
 
[mysql]
default-character-set=utf8
 
[mysqld]
log-bin=mysql-bin 
binlog-format=ROW 
server_id=1 
max_connections=1000
 
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake

[root@db-7-51 mysql]# mkdir -p /tmp/mysqld/
[root@db-7-51 mysql]# touch /tmp/mysqld/mysqld.pid
[root@db-7-51 mysql]# chown -R mysql:mysql /tmp/mysqld/
[root@db-7-51 mysql]# chmod 777 /tmp/mysqld/mysqld.pid
[root@db-7-51 mysql]# chown -R mysql:mysql /var/log
[root@db-7-51 mysql]# chmod 777 /var/log/mysqld.log

[root@db-7-51 mysql]# ./support-files/mysql.server start
Starting MySQL. SUCCESS!

[root@db-7-51 mysql]cp support-files/mysql.server /etc/init.d/mysql

[root@db-7-51 mysql] ln -s  /usr/local/mysql/bin/mysql    /usr/bin

[root@db-7-51 mysql]# mysql -uroot -pyZho-p8Zsmuv
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.29-log

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
# 修改密码为 123456
mysql> set password = password('123456');
Query OK, 0 rows affected, 1 warning (0.01 sec)

# 设置密码有效期永不过期
mysql> alter user 'root'@'localhost' password expire never;
Query OK, 0 rows affected (0.00 sec)

# 应用修改
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

# 修改后可以使用新密码重新登录，可以正常执行命令

[root@db-7-51 mysql]# mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.29-log MySQL Community Server (GPL)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

# 支持root用户允许远程连接mysql数据库
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;