Detailed tutorial on installing MySQL 8.0.20 database on CentOS 7

Related reading:

MySQL8.0.20 installation tutorial and detailed tutorial on installation issues https://www.jb51.net/article/186202.htm

MySQL8.0.20 download and installation and problems encountered (with pictures and text) https://www.jb51.net/article/186208.htm

Steps to install Mysql8.0.20 on CentOS7:

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-20.html

The download speed from the official website is sometimes slow, you can also download it by clicking the link directly: mysql 8.0.20

Download 8.0.20MySQL package (bundle version) from the official website

1. Create a mysql folder:

[root@localhost ~]# mkdir /usr/local/mysql
[root@localhost ~]# cd /usr/local/mysql/

Place the downloaded mysql package in the created MySQL folder:

[root@localhost mysql]# ll
Total usage: 815000
-rw-r--r--. 1 root root 834560000 May 13 10:44 mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar

Check whether the MD5 code of the installed version of MySQL corresponds to the one on the official website:

[root@localhost mysql]# md5sum mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar 
c8d062c1f74d9aab7dbdd5300b202b6e mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar

Unzip the mysql package to get several installation packages:

[root@localhost mysql]# tar -xvf mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar 
mysql-community-libs-8.0.20-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.20-1.el7.x86_64.rpm
mysql-community-test-8.0.20-1.el7.x86_64.rpm
mysql-community-common-8.0.20-1.el7.x86_64.rpm
mysql-community-devel-8.0.20-1.el7.x86_64.rpm
mysql-community-client-8.0.20-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm
mysql-community-server-8.0.20-1.el7.x86_64.rpm
[root@localhost mysql]# ll
Total usage: 1630004
-rw-r--r--. 1 root root 834560000 May 13 10:44 mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
-rw-r--r--. 1 7155 31415 48822048 Mar 27 20:14 mysql-community-client-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 623508 Mar 27 20:14 mysql-community-common-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 8129988 Mar 27 20:14 mysql-community-devel-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 23599996 Mar 27 20:14 mysql-community-embedded-compat-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 4667884 Mar 27 20:14 mysql-community-libs-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 1277128 Mar 27 20:14 mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 512057468 Mar 27 20:15 mysql-community-server-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 235369940 Mar 27 20:16 mysql-community-test-8.0.20-1.el7.x86_64.rpm

The installation order is common, libs, libs-compat, client, server:

WARNING:mysql-community-common-8.0.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, Key ID ********: NOKEY
Preparing... ################################# [100%]
Upgrading/installing...
 1:mysql-community-common-8.0.20-1.e################################### [100%]
WARNING:mysql-community-libs-8.0.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, Key ID ********: NOKEY
Preparing... ################################# [100%]
Upgrading/installing...
 1:mysql-community-libs-8.0.20-1.el7################################### [100%]
WARNING:mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, Key ID ********: NOKEY
Preparing... ################################# [100%]
Upgrading/installing...
 1:mysql-community-libs-compat-8.0.2################################### [100%]
WARNING:mysql-community-client-8.0.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, Key ID ********: NOKEY
Preparing... ################################# [100%]
Upgrading/installing...
 1:mysql-community-client-8.0.20-1.e################################### [100%]
WARNING:mysql-community-server-8.0.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, Key ID ********: NOKEY
Preparing... ################################# [100%]
Upgrading/installing...
 1:mysql-community-server-8.0.20-1.e################################### [100%]

Edit the /etc/my.cnf file:
Add a line at the bottom:

lower_case_table_names=1

initialize:

[root@localhost mysql]# mysqld --initialize
[root@localhost mysql]#

Change the permissions:

[root@localhost mysql]# chown -R mysql:mysql /var/lib/mysql
[root@localhost mysql]# ll /var/lib/
Total dosage 8
drwxr-xr-x. 4 root root 32 May 13 10:07 AccountsService
drwxr-xr-x. 2 root root 6 August 3, 2017 alsa
drwxr-xr-x. 2 root root 274 May 13 10:14 alternatives
drwx------. 3 root root 18 May 13 10:17 authconfig
drwxr-xr-x. 2 root root 6 August 3, 2017 bluetooth
drwxr-xr-x. 2 chrony chrony 6 August 4, 2017 chrony
drwxr-xr-x. 3 root root 17 May 13 10:06 color
drwxr-xr-x. 4 colord colord 67 May 13 10:23 colord
drwxr-xr-x. 2 root root 6 Nov 7 2016 dbus
drwxr-xr-x. 2 root root 6 August 4, 2017 dhclient
drwxr-xr-x. 2 root root 6 August 3, 2017 dnsmasq
drwxr-xr-x. 3 root root 34 May 13 10:24 flatpak
drwxr-xr-x. 2 root root 6 June 24, 2014 fprint
drwxr-xr-x. 2 root root 6 November 5, 2016 games
drwxrwx--T. 5 gdm gdm 70 May 13 10:23 gdm
drwxr-xr-x. 2 geoclue geoclue 6 August 2, 2017 geoclue
drwxr-xr-x. 4 root root 55 May 13 02:22 gssproxy
drwxr-xr-x. 2 root root 6 August 2, 2017 hyperv
drwxr-xr-x. 2 root root 6 August 5, 2017 initramfs
drwxr-xr-x. 8 root root 90 May 13 10:07 iscsi
drwxr-xr-x. 8 root root 93 May 13 10:08 libvirt
drwxr-xr-x. 2 root root 6 November 6, 2016 lldpad
drwxr-xr-x. 2 root root 6 August 2, 2017 logrotate
drwx------. 2 root root 6 May 13 10:06 machines
drwxr-xr-x. 2 root root 37 May 13 02:22 misc
drwxr-x---. 2 root slocate 6 Nov 5 2016 mlocate
drwxr-x--x. 6 mysql mysql 4096 May 13 11:05 mysql

Start the MySQL service and check the service status, and check the status of the Active line:

[root@localhost mysql]# systemctl start mysqld.service 
[root@localhost mysql]# systemctl status mysqld.service 
● mysqld.service – MySQL Server
 Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
 Active: active (running) since Wednesday 2020-05-13 11:09:35 CST; 8s ago
 Docs: man:mysqld(8)
 http://dev.mysql.com/doc/refman/en/using-systemd.html
 Process: 16795 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 16829 (mysqld)
 Status: "Server is operational"
 CGroup: /system.slice/mysqld.service
 └─16829 /usr/sbin/mysqld

May 13 11:09:24 localhost.localdomain systemd[1]: Starting MySQL Server...
May 13 11:09:35 localhost.localdomain systemd[1]: Started MySQL Server.
[root@localhost mysql]#

View the initial password of the database:

[root@localhost mysql]# cat /var/log/mysqld.log | grep password
2020-05-13T03:05:16.041238Z 6 [Note] [MY-010454] 
[Server] A temporary password is generated for root@localhost: n_t#tk.Z?7)f

Use the initial password to log in to the database: then change the password:

[root@localhost mysql]# 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.20

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>
mysql> ALTER user 'root'@'localhost' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.04 sec)

mysql> exit
Bye
[root@localhost mysql]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.20 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> SELECT VERSION;
ERROR 1054 (42S22): Unknown column 'VERSION' in 'field list'
mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 8.0.20 |
+-----------+
1 row in set (0.00 sec)

mysql>

At this point, you can log in to the database normally, and you can search and enable the remote mode yourself.

Summarize

This is the end of this article about the detailed tutorial on how to install MySQL 8.0.20 database on CentOS 7. For more information about installing MySQL 8.0 database on CentOS 7, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!

You may also be interested in:

Install MySQL5.5 database in CentOS7 environment
Centos7 mysql database installation and configuration tutorial
Detailed tutorial on installing MySQL database in Linux environment
How to install MySQL database on Ubuntu
Detailed tutorial on installing different (two) versions of MySQL database on Windows
Windows Server 2016 MySQL database installation and configuration detailed installation tutorial
Install two MySQL5.6.35 databases under win10
Introduction to MySQL database installation method and graphical management tool

<<: How to add shortcut commands in Xshell

>>: Summary of essential breakpoint debugging techniques for JavaScript (recommended)