Ubuntu 18.0.4 MySQL 8.0.20 installation and configuration method graphic tutorial

The installation and configuration method of MySQL 8.0.20 is organized into a graphic tutorial for your reference.

1. Preparation

1. Check whether mysql has been installed

The current computer does not have mysql installed.

2. Download MySQL 8.0.

According to the MySQL installation guide, it is found that MySQL version 5.7 is only compatible with Ubuntu 17.04.
MySQL 8.0 is compatible with Ubuntu 18.04 at most.

Click to download at the address (download from the official website):

The file is very small, only 34K.

2. Install MySQL

1. Double-click to open and install.

Select mysql-8.0 here.

Just wait for the installation to complete!

2. Open the terminal and execute the following commands respectively

sudo apt-get update 

sudo apt-get install mysql-server

During the installation process, if any questions appear, just select yes.

3. Set password and confirm password

Use the Tab key to jump to "OK" and then press Enter.

4. Select the encryption method for your password

Select option 2 here and press Enter.

3. Start and enter mysql

Start: service mysql start
Enter: mysql -uroot -p

4. Check the character set used by MySQL and exit MySQL

View the character set:

show variables like '%character%';

Exit mysql:

exit 

5. Commands to start, stop, restart, and enter MySQL service

start up:

sudo service mysql start

stop:

sudo service mysql stop

Restart:

sudo service mysql restart

Enter:

mysql -uroot -p

At this point, the installation of MySQL on Ubuntu 18.0.4 is complete!

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.