CentOS 7下RPM方式安装MySQL8

电玩女神 2023-10-18 21:40 19阅读 0赞

##  ##

下载地址：https://dev.mysql.com/downloads/mysql/

\[root@mysql8 opt\]\# tar -xvf mysql-8.0.16-2.el7.x86\_64.rpm-bundle.tar  
mysql-community-libs-8.0.16-2.el7.x86\_64.rpm  
mysql-community-embedded-compat-8.0.16-2.el7.x86\_64.rpm  
mysql-community-devel-8.0.16-2.el7.x86\_64.rpm  
mysql-community-server-8.0.16-2.el7.x86\_64.rpm  
mysql-community-libs-compat-8.0.16-2.el7.x86\_64.rpm  
mysql-community-client-8.0.16-2.el7.x86\_64.rpm  
mysql-community-common-8.0.16-2.el7.x86\_64.rpm  
mysql-community-test-8.0.16-2.el7.x86\_64.rpm  
\[root@mysql8 opt\]\# ls  
mysql-8.0.16-2.el7.x86\_64.rpm-bundle.tar mysql-community-devel-8.0.16-2.el7.x86\_64.rpm mysql-community-libs-compat-8.0.16-2.el7.x86\_64.rpm rh  
mysql-community-client-8.0.16-2.el7.x86\_64.rpm mysql-community-embedded-compat-8.0.16-2.el7.x86\_64.rpm mysql-community-server-8.0.16-2.el7.x86\_64.rpm  
mysql-community-common-8.0.16-2.el7.x86\_64.rpm mysql-community-libs-8.0.16-2.el7.x86\_64.rpm mysql-community-test-8.0.16-2.el7.x86\_64.rpm  
\[root@mysql8 opt\]\# rpm -ivh mysql-community-common-8.0.16-2.el7.x86\_64.rpm  
warning: mysql-community-common-8.0.16-2.el7.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
Preparing... \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
Updating / installing...  
1:mysql-community-common-8.0.16-2.e\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
\[root@mysql8 opt\]\# rpm -ivh mysql-community-libs-8.0.16-2.el7.x86\_64.rpm  
warning: mysql-community-libs-8.0.16-2.el7.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
error: Failed dependencies:  
mariadb-libs is obsoleted by mysql-community-libs-8.0.16-2.el7.x86\_64  
\[root@mysql8 opt\]\# rpm -q mariadb-libs  
mariadb-libs-5.5.60-1.el7\_5.x86\_64  
\[root@mysql8 opt\]\# rpm -e mariadb-libs-5.5.60-1.el7\_5.x86\_64  
error: Failed dependencies:  
libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86\_64  
libmysqlclient.so.18(libmysqlclient\_18)(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86\_64  
\[root@mysql8 opt\]\# rpm -ev mariadb-libs-5.5.60-1.el7\_5.x86\_64  
error: Failed dependencies:  
libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86\_64  
libmysqlclient.so.18(libmysqlclient\_18)(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86\_64  
\[root@mysql8 opt\]\# rpm -e postfix-2:2.10.1-7.el7.x86\_64  
\[root@mysql8 opt\]\# rpm -e mariadb-libs-5.5.60-1.el7\_5.x86\_64  
\[root@mysql8 opt\]\# rpm -ivh mysql-community-libs-8.0.16-2.el7.x86\_64.rpm  
warning: mysql-community-libs-8.0.16-2.el7.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
Preparing... \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
Updating / installing...  
1:mysql-community-libs-8.0.16-2.el7\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
\[root@mysql8 opt\]\# rpm -ivh mysql-community-client-8.0.16-2.el7.x86\_64.rpm  
warning: mysql-community-client-8.0.16-2.el7.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
Preparing... \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
Updating / installing...  
1:mysql-community-client-8.0.16-2.e\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
\[root@mysql8 opt\]\# rpm -ivh mysql-community-server-8.0.16-2.el7.x86\_64.rpm  
warning: mysql-community-server-8.0.16-2.el7.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
Preparing... \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
Updating / installing...  
1:mysql-community-server-8.0.16-2.e\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
\[root@mysql8 opt\]\# service mysqld status  
Redirecting to /bin/systemctl status mysqld.service  
● mysqld.service - MySQL Server  
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)  
Active: inactive (dead)  
Docs: man:mysqld(8)  
http://dev.mysql.com/doc/refman/en/using-systemd.html  
\[root@mysql8 opt\]\# service mysqld start  
Redirecting to /bin/systemctl start mysqld.service  
\[root@mysql8 opt\]\# grep password /var/log/mysqld.log  
2019-07-14T20:33:00.077696Z 5 \[Note\] \[MY-010454\] \[Server\] A temporary password is generated for root@localhost: 74f1j>pghmvG  
\[root@mysql8 opt\]\# mysql -p  
Enter password:  
Welcome to the MySQL monitor. Commands end with ; or \\g.  
Your MySQL connection id is 8  
Server version: 8.0.16

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> SET PASSWORD = 'StrongPass';  
Query OK, 0 rows affected (0.01 sec)