Ubuntu Server 16.04 MySQL 8.0 installation and configuration graphic tutorial

Ubuntu Server 16.04 MySQL 8.0 installation and configuration graphic tutorial

1. Download the installation file from the MySQL official website. There are two options:

• Install using APT
• Install using the complete installation package

sudo dpkg -i mysql-apt-config_0.8.6-1_all.deb

2. Update the system installation source

sudo apt-get update

3. Install MySQL service

sudo apt-get install mysql-server

4. Modify the character set of MySQL Server

To modify the character set, first find the installation location of MySQL. You can use the following command:

whereis mysql

The following is the installation location of MySQL:

Change the directory to /etc/mysql as shown below:

Modify mysqld.cnf in the mysql.conf.d folder, add character-set-server=utf8 at the end of the file, and 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 and use it normally!

7. Modify the Client character set

In order to display Chinese characters normally, you need to modify the client character encoding. After successful login, enter charset utf8 in the console window.

8. Testing

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

Wonderful topic sharing: Installation tutorials for different versions of MySQL Installation tutorials for MySQL 5.7 versions Installation tutorials for MySQL 5.6 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.