B站地址：https://www.bilibili.com/video/BV1qS4y1h77S/?spm_id_from=333.337.search-card.all.click&vd_source=79bbd5b76bfd74c2ef1501653cee29d6
下面這個檔案和mysql有衝突，需要優先查詢並刪除：
阿里雲系統：cenos 7 64位數；
安裝包：mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz
安裝過程：
Session stopped - Press <Return> to exit tab - Press R to restart session - Press S to save terminal output to file ┌──────────────────────────────────────────────────────────────────────┐ │ • MobaXterm Personal Edition v23.4 • │ │ (SSH client, X server and network tools) │ │ │ │ ⮞ SSH session to root@47.120.61.196 │ │ • Direct SSH : ✓ │ │ • SSH compression : ✓ │ │ • SSH-browser : ✓ │ │ • X11-forwarding : ✗ (disabled or not supported by server) │ │ │ │ ⮞ For more info, ctrl+click on help or visit our website. │ └──────────────────────────────────────────────────────────────────────┘ Welcome to Alibaba Cloud Elastic Compute Service ! [root@iZf8zi6zcbssmm6c2nrhapZ ~]# cd / [root@iZf8zi6zcbssmm6c2nrhapZ /]# rpm -qa|grep mariadb mariadb-libs-5.5.68-1.el7.x86_64 [root@iZf8zi6zcbssmm6c2nrhapZ /]# rpm -e --nodeps mariadb-libs [root@iZf8zi6zcbssmm6c2nrhapZ /]# rpm -qa|grep mariadb [root@iZf8zi6zcbssmm6c2nrhapZ /]# mkdir -p /soft/mysql8 [root@iZf8zi6zcbssmm6c2nrhapZ /]# mkdir -p /evir/mysql8 [root@iZf8zi6zcbssmm6c2nrhapZ /]# tar -xf /soft/mysql8/mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz -C /evir/mysql8/ [root@iZf8zi6zcbssmm6c2nrhapZ /]# cd /evir/mysql8/ [root@iZf8zi6zcbssmm6c2nrhapZ mysql8]# ls -alt total 12 drwxr-xr-x 9 root root 4096 Apr 8 19:23 mysql-8.0.30-linux-glibc2.12-x86_64 drwxr-xr-x 3 root root 4096 Apr 8 19:22 . drwxr-xr-x 3 root root 4096 Apr 8 19:20 .. [root@iZf8zi6zcbssmm6c2nrhapZ mysql8]# mv mysql-8.0.30-linux-glibc2.12-x86_64 msql8030 [root@iZf8zi6zcbssmm6c2nrhapZ mysql8]# ls -alt total 12 drwxr-xr-x 3 root root 4096 Apr 8 19:23 . drwxr-xr-x 9 root root 4096 Apr 8 19:23 msql8030 drwxr-xr-x 3 root root 4096 Apr 8 19:20 .. [root@iZf8zi6zcbssmm6c2nrhapZ mysql8]# mv msql8030 mysql8030 [root@iZf8zi6zcbssmm6c2nrhapZ mysql8]# ls -alt total 12 drwxr-xr-x 3 root root 4096 Apr 8 19:24 . drwxr-xr-x 9 root root 4096 Apr 8 19:23 mysql8030 drwxr-xr-x 3 root root 4096 Apr 8 19:20 .. [root@iZf8zi6zcbssmm6c2nrhapZ mysql8]# cd mysql8030/ [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# ls -alt total 324 drwxr-xr-x 3 root root 4096 Apr 8 19:24 .. drwxr-xr-x 9 root root 4096 Apr 8 19:23 . drwxr-xr-x 2 7161 31415 4096 Jul 7 2022 bin drwxr-xr-x 6 7161 31415 4096 Jul 7 2022 lib drwxr-xr-x 28 7161 31415 4096 Jul 7 2022 share drwxr-xr-x 2 7161 31415 4096 Jul 7 2022 support-files drwxr-xr-x 2 7161 31415 4096 Jul 7 2022 docs drwxr-xr-x 3 7161 31415 4096 Jul 7 2022 include drwxr-xr-x 4 7161 31415 4096 Jul 7 2022 man -rw-r--r-- 1 7161 31415 287624 Jul 7 2022 LICENSE -rw-r--r-- 1 7161 31415 666 Jul 7 2022 README [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# mkdir data [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# ls -alt total 328 drwxr-xr-x 10 root root 4096 Apr 8 19:24 . drwxr-xr-x 2 root root 4096 Apr 8 19:24 data drwxr-xr-x 3 root root 4096 Apr 8 19:24 .. drwxr-xr-x 2 7161 31415 4096 Jul 7 2022 bin drwxr-xr-x 6 7161 31415 4096 Jul 7 2022 lib drwxr-xr-x 28 7161 31415 4096 Jul 7 2022 share drwxr-xr-x 2 7161 31415 4096 Jul 7 2022 support-files drwxr-xr-x 2 7161 31415 4096 Jul 7 2022 docs drwxr-xr-x 3 7161 31415 4096 Jul 7 2022 include drwxr-xr-x 4 7161 31415 4096 Jul 7 2022 man -rw-r--r-- 1 7161 31415 287624 Jul 7 2022 LICENSE -rw-r--r-- 1 7161 31415 666 Jul 7 2022 README [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# chmod -R 777 /evir/mysql8/mysql8030/data/ [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# groupadd mysql [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# useradd -g mysql mysql [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# chown -R mysql.mysql /evir/mysql8/mysql8030 [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# cd bin [root@iZf8zi6zcbssmm6c2nrhapZ bin]# ls -a;l;t . myisamchk mysql mysql_config_editor mysqldump mysql_secure_installation mysql_upgrade .. myisam_ftdump mysqladmin mysqld mysqldumpslow mysqlshow perror ibd2sdi myisamlog mysqlbinlog mysqld-debug mysqlimport mysqlslap zlib_decompress innochecksum myisampack mysqlcheck mysqld_multi mysql_migrate_keyring mysql_ssl_rsa_setup lz4_decompress my_print_defaults mysql_config mysqld_safe mysqlpump mysql_tzinfo_to_sql -bash: l: command not found -bash: t: command not found [root@iZf8zi6zcbssmm6c2nrhapZ bin]# ls -alt total 799844 drwxr-xr-x 10 mysql mysql 4096 Apr 8 19:24 .. drwxr-xr-x 2 mysql mysql 4096 Jul 7 2022 . -rwxr-xr-x 1 mysql mysql 120809811 Jul 7 2022 mysqld -rwxr-xr-x 1 mysql mysql 9545230 Jul 7 2022 mysqlpump -rwxr-xr-x 1 mysql mysql 9061267 Jul 7 2022 mysqlbinlog -rwxr-xr-x 1 mysql mysql 8484338 Jul 7 2022 mysql_migrate_keyring -rwxr-xr-x 1 mysql mysql 8651431 Jul 7 2022 mysql -rwxr-xr-x 1 mysql mysql 8501953 Jul 7 2022 mysql_upgrade -rwxr-xr-x 1 mysql mysql 8345092 Jul 7 2022 mysqldump -rwxr-xr-x 1 mysql mysql 8252148 Jul 7 2022 mysqlcheck -rwxr-xr-x 1 mysql mysql 475435 Jul 7 2022 mysql_config_editor -rwxr-xr-x 1 mysql mysql 8221011 Jul 7 2022 mysqlshow -rwxr-xr-x 1 mysql mysql 8246840 Jul 7 2022 mysqlslap -rwxr-xr-x 1 mysql mysql 8231447 Jul 7 2022 mysqladmin -rwxr-xr-x 1 mysql mysql 8220044 Jul 7 2022 mysqlimport -rwxr-xr-x 1 mysql mysql 8204842 Jul 7 2022 mysql_secure_installation -rwxr-xr-x 1 mysql mysql 752994 Jul 7 2022 ibd2sdi -rwxr-xr-x 1 mysql mysql 335783 Jul 7 2022 mysql_tzinfo_to_sql -rwxr-xr-x 1 mysql mysql 591949 Jul 7 2022 innochecksum -rwxr-xr-x 1 mysql mysql 1231617 Jul 7 2022 perror -rwxr-xr-x 1 mysql mysql 7216223 Jul 7 2022 myisampack -rwxr-xr-x 1 mysql mysql 7393374 Jul 7 2022 myisamchk -rwxr-xr-x 1 mysql mysql 7130273 Jul 7 2022 myisam_ftdump -rwxr-xr-x 1 mysql mysql 7097799 Jul 7 2022 myisamlog -rwxr-xr-x 1 mysql mysql 388414 Jul 7 2022 lz4_decompress -rwxr-xr-x 1 mysql mysql 485400 Jul 7 2022 my_print_defaults -rwxr-xr-x 1 mysql mysql 352135 Jul 7 2022 zlib_decompress -rwxr-xr-x 1 mysql mysql 575427 Jul 7 2022 mysql_ssl_rsa_setup -rwxr-xr-x 1 mysql mysql 5084 Jul 7 2022 mysql_config -rwxr-xr-x 1 mysql mysql 27492 Jul 7 2022 mysqld_multi -rwxr-xr-x 1 mysql mysql 29183 Jul 7 2022 mysqld_safe -rwxr-xr-x 1 mysql mysql 7669 Jul 7 2022 mysqldumpslow -rwxr-xr-x 1 mysql mysql 562094871 Jul 7 2022 mysqld-debug [root@iZf8zi6zcbssmm6c2nrhapZ bin]# ./mysqld --user=mysql --basedir=/evir/mysql8/mysql8030/ --datadir=/evir/mysql8/mysql8030/data/ --lower-case -table-names=1 --initialize ./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory [root@iZf8zi6zcbssmm6c2nrhapZ bin]# yum -y install numactl.x86_64 Loaded plugins: fastestmirror Determining fastest mirrors base | 3.6 kB 00:00:00 epel | 4.7 kB 00:00:00 extras | 2.9 kB 00:00:00 updates | 2.9 kB 00:00:00 (1/7): epel/x86_64/group_gz | 100 kB 00:00:00 (2/7): epel/x86_64/updateinfo | 1.0 MB 00:00:00 (3/7): base/7/x86_64/group_gz | 153 kB 00:00:00 (4/7): epel/x86_64/primary_db | 7.0 MB 00:00:00 (5/7): extras/7/x86_64/primary_db | 253 kB 00:00:00 (6/7): updates/7/x86_64/primary_db | 26 MB 00:00:00 (7/7): base/7/x86_64/primary_db | 6.1 MB 00:00:00 Resolving Dependencies --> Running transaction check ---> Package numactl.x86_64 0:2.0.12-5.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ===================================================================================================================================================== Package Arch Version Repository Size ===================================================================================================================================================== Installing: numactl x86_64 2.0.12-5.el7 base 66 k Transaction Summary ===================================================================================================================================================== Install 1 Package Total download size: 66 k Installed size: 141 k Downloading packages: numactl-2.0.12-5.el7.x86_64.rpm | 66 kB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction ** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows: 2:postfix-2.10.1-9.el7.x86_64 has missing requires of libmysqlclient.so.18()(64bit) 2:postfix-2.10.1-9.el7.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_18)(64bit) Installing : numactl-2.0.12-5.el7.x86_64 1/1 Verifying : numactl-2.0.12-5.el7.x86_64 1/1 Installed: numactl.x86_64 0:2.0.12-5.el7 Complete! [root@iZf8zi6zcbssmm6c2nrhapZ bin]# yum install libaio-devel.x86_64 Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile Resolving Dependencies --> Running transaction check ---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed --> Processing Dependency: libaio(x86-64) = 0.3.109-13.el7 for package: libaio-devel-0.3.109-13.el7.x86_64 --> Running transaction check ---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ===================================================================================================================================================== Package Arch Version Repository Size ===================================================================================================================================================== Installing: libaio-devel x86_64 0.3.109-13.el7 base 13 k Installing for dependencies: libaio x86_64 0.3.109-13.el7 base 24 k Transaction Summary ===================================================================================================================================================== Install 1 Package (+1 Dependent package) Total download size: 37 k Installed size: 46 k Is this ok [y/d/N]: y Downloading packages: (1/2): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:00 (2/2): libaio-devel-0.3.109-13.el7.x86_64.rpm | 13 kB 00:00:00 ----------------------------------------------------------------------------------------------------------------------------------------------------- Total 290 kB/s | 37 kB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : libaio-0.3.109-13.el7.x86_64 1/2 Installing : libaio-devel-0.3.109-13.el7.x86_64 2/2 Verifying : libaio-0.3.109-13.el7.x86_64 1/2 Verifying : libaio-devel-0.3.109-13.el7.x86_64 2/2 Installed: libaio-devel.x86_64 0:0.3.109-13.el7 Dependency Installed: libaio.x86_64 0:0.3.109-13.el7 Complete! [root@iZf8zi6zcbssmm6c2nrhapZ bin]# rpm -qa|grep libaio libaio-0.3.109-13.el7.x86_64 libaio-devel-0.3.109-13.el7.x86_64 [root@iZf8zi6zcbssmm6c2nrhapZ bin]# ./mysqld --user=mysql --basedir=/evir/mysql8/mysql8030/ --datadir=/evir/mysql8/mysql8030/data/ --lower-case -table-names=1 --initialize 2024-04-08T11:28:31.062502Z 0 [System] [MY-013169] [Server] /evir/mysql8/mysql8030/bin/mysqld (mysqld 8.0.30) initializing of server in progress as p rocess 5464 2024-04-08T11:28:31.250296Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-04-08T11:28:32.800425Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-04-08T11:28:34.668583Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 0xw*/-k:EcjZ [root@iZf8zi6zcbssmm6c2nrhapZ bin]# ^C [root@iZf8zi6zcbssmm6c2nrhapZ bin]# vim /etc/my.cnf [root@iZf8zi6zcbssmm6c2nrhapZ bin]# cd .. [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# cp -a ./support-files/mysql.server /etc/init.d/mysql [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# chmod +x /etc/init.d/mysql [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# service mysql start Starting MySQL.Logging to '/evir/mysql8/mysql8030/data/iZf8zi6zcbssmm6c2nrhapZ.err'. .The server quit without updating PID file (/evir/mysql8/my[FAILED]data//iZf8zi6zcbssmm6c2nrhapZ.pid). [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# chmod -R 777 /evir/mysql8/mysql8030/data [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# service mysql start Starting MySQL..The server quit without updating PID file ([FAILED]sql8/mysql8030/data//iZf8zi6zcbssmm6c2nrhapZ.pid). [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# vim /etc/my.cnf [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# service mysql start Starting MySQL.. [ OK ] [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# service mysql status MySQL running (8173) [ OK ] [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]# ^C [root@iZf8zi6zcbssmm6c2nrhapZ mysql8030]#
參照文件：https://blog.csdn.net/studio_1/article/details/128345934
[root@iZf8zi6zcbssmm6c2nrhapZ bin]# ln -s /evir/mysql8/mysql8030/bin/mysql /usr/bin [root@iZf8zi6zcbssmm6c2nrhapZ bin]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.30 Copyright (c) 2000, 2022, Oracle and/or its affiliates. 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> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456sww#'; Query OK, 0 rows affected (0.01 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.01 sec) mysql>
