Detailed tutorial on installing mysql-8.0.20 under Linux

**

Install mysql-8.0.20 under Linux

**

Environment Introduction

Operating system: CentOS 7
mysql download address: https://dev.mysql.com/downloads/mysql/
Download version: https://www.jb51.net/softs/609101.html

https://www.jb51.net/softs/609101.html

Uninstall mysql

Check whether mysql has been installed, command: find / -name mysql

If installed, uninstall:

Delete the relevant directories:

Delete the configuration file:

Delete the mysql user and user group (if there is a process, kill it and then delete it)

Uninstall complete!

Install mysql

Put the mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz package in the /usr/local/env/mysql directory and unzip it. If there is no mysql directory, create a new one.

Rename after decompression

Add user group: mysql, user: mysql, and add it to the mysql user group

The useradd -r parameter indicates that the mysql user is a system user and cannot be used to log in to the system.
The useradd -g parameter means adding the mysql user to the mysql user group.

Check libaio

If not installed, install it with the following command:
yum search libaio

Configure my.cnf file

Copy the following information into the my.cnf file

Create a data folder

Change the user and group of the mysql directory to mysql

Initialize mysqld and generate an initialization password

Set startup

Copy the mysql.server script to the resource directory and grant execution permissions:

Add the mysqld service to the system service and check whether it is effective:

The above information is effective!
Start mysqld:

Configuring environment variables

Open the /etc/profile configuration file and add the following content:
#mysql environment variables
PATH=$PATH:/usr/local/env/mysql/mysql/bin
export PATH

If you have JDK, modify it as follows:

Execute the command to make it effective:

Check whether the configuration is successful. The following shows that the configuration is successful.

Because skip-grant-tables is added to my.cnf, it is a password-free login

If you have a password to log in, add # before skip-grant-tables in my.cnf

To change your login password:

If an error occurs during the execution of the above command, use flush privileges; and then execute the above command again.
Stop the service and log in with a password:

Restart the service:

This is an unsuccessful connection using navicat:

Enable remote login:

Use navicat to connect again:

Connection successful!

Summarize

This is the end of this article about the detailed tutorial on installing mysql-8.0.20 under Linux. For more relevant content about installing mysql8.0.20 in Linux, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!