Install MySQL 8 for Ubuntu

brief introduction

This article describes how to Ubuntu18.04 Install a newer version of MySQL8 And configure remote connections .

install

All the following installation processes adopt root Account , If not, please use sudo jurisdiction .

First of all to MySQL Official download page , Select the version and source we need as shown in the figure below , We will download to mysql-apt-config_0.8.22-1_all.deb File on server （ With the help of xftp perhaps mobaxterm）.

then , Let's install the above file , The reason why you want to install this file is to choose what version you want to install mysql And what you want to install mysql plug-in unit , After the selection , This tool will generate a list of sources , This table records MySQL Of apt The server address of the software warehouse , For subsequent apt Tools can be installed normally MySQL.

dpkg -i mysql-apt-config_0.8.22-1_all.deb

Executing the above command will have the following interface , So let's choose MySQL Server and mysql8.0, Finally, go back to the main page and choose Ok that will do .

Next, we use the following command to do the actual MySQL Installation , The installation process requires input root password , You also need to select a validation plug-in , It is recommended to select compatibility mode （Use Legacy Authentication Method）.

apt-get update
apt-get install mysql-server

The installation is smooth. We can pass mysql -uroot -p Log in to the database , Use show databases; view the database , Because just installed , We should see the following default database .

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

Remote connection

I won't say more about firewalls , It must be adjusted ,MySQL The default is only locally accessible , We need to modify this permission .

mysql -uroot -p

Log in to the database and view the permission table .

mysql> use mysql;
mysql> select host, user, authentication_string, plugin from user;

The above figure shows that you can only log in locally , We add accounts that can be accessed remotely .

mysql> create user 'root'@'%' identified by ' Your own mysql password ';
mysql> grant all privileges on *.* to 'root'@'%';
mysql> flush privileges;

At this point, we can use remote database tools such as DBeaver Connect .

uninstall

Use the following command to uninstall .

apt-get remove mysql-server

Additional explanation

This article describes how to Ubuntu18 Install and configure MySQL8.