Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to install mysql8.0 in Ubuntu Server16.04. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Graphic and text tutorial of mysql8.0 installation and configuration under Ubuntu Server 16.04

1. Download the installation files from the Mysql website. There are two ways to choose:

Install using APT installation

Install using the complete installation package

Sudo dpkg-I mysql-apt-config_0.8.6-1_all.deb

two。 Update the system installation source

Sudo apt-get update

3. Install the Mysql service

Sudo apt-get install mysql-server

4. Modify the character set of Mysql Server

To modify the character set, first find the location where Mysql is installed, using the following command:

Whereis mysql

The location where Mysql is installed is as follows:

Change the directory to what is shown under / etc/mysql:

Modify the mysqld.cnf under the mysql.conf.d folder, append character-set-server=utf8 to the end of the file, and then save it.

5. Restart the Mysql service

Service mysql restart

6. Log in to Mysql

Mysql-u root-p

After entering the password, you can log in normally!

7. Modify Client character set

In order for Chinese characters to be displayed properly, the client character encoding needs to be modified. After the login is successful, enter charset utf8 under the console window.

8. test

After entering status in the console, the following information can be displayed.

This is the end of this article on "how to install mysql8.0 in Ubuntu Server16.04". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.