Shulou(Shulou.com)06/01 Report--

This article mainly introduces the method of installing MySQL 8.0 in Ubuntu 18.04. what is introduced in this article is very detailed and has a certain reference value. Interested friends must read it!

MySQL Community Server is a free, open source, popular, cross-platform database management system. It supports both SQL and NoSQL and has a pluggable storage engine architecture. In addition, it provides multiple database connectors for different programming languages, allowing you to develop applications in any known language and many other features.

It has many use cases in the fields of document storage, cloud computing, high availability systems, Internet of things, hadoop, big data, data warehouse, LAMP or LEMP stack, to support high-capacity websites / applications, etc.

In this article, we will explain the new installation of the MySQL 8.0 database system on Ubuntu 18.04Bionic Beaver.

Step 1: add a MySQL Apt repository

There is an APT repository for installing MySQL servers, clients, and other components. You need to add this MySQL repository to the list of package sources on your system; first download the repository package using the wget tool on the command line.

$wget-c https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb

Then use the following dpkg command to install the MySQL repository package.

$sudo dpkg-I mysql-apt-config_0.8.10-1_all.deb

Note that during package installation, you are prompted to select the MySQL server version and other components, such as clusters, shared client libraries, or the MySQL workbench that you want to configure for installation.

Mysql-8.0 will automatically select the MySQL server version, then scroll down to the last option, Ok, and click [Enter] to complete the configuration and installation of the release package, as shown in the screenshot.

Step 2: install the MySQL server in Ubuntu 18.04

Next, download the latest package information from all configured repositories, including the recently added MySQL repository.

$sudo apt update

Then run the following command to install the package for the MySQL community server, client, and database public files.

$sudo apt-get install mysql-server

Through the installation process, you will be asked to enter the password of the root user for your MySQL server, please re-enter the password to confirm, and then press the [Enter] key.

Next, the MySQL server authentication plug-in configuration message is displayed, which reads and uses the right arrow to select Ok, and then press [Enter] to continue.

You will then be asked to select the default authentication plug-in to use, then use the right arrow to select Ok and press [Enter] to complete the package configuration.

Step 3: secure the MySQL server installation

By default, the MySQL installation is not safe. To protect it, run the security script that came with the binary package. You will be asked to enter the root password that you set during installation. Then choose whether or not to use the VALIDATE PASSWORD plug-in.

You can also change the previously set root password (as we did in this example). Then enter the following security questions for yes/y:

Delete anonymous users? (press y | Y for yes, any other key for no): y

Prohibit remote login? (press y | Y for yes, any other key for no): y

Delete the test database and access it? (press y | Y for yes, any other key for no): y

Reload the permissions table now? (press y | Y for yes, any other key for no): y

Start the script by issuing the following command.

$sudo mysql_secure_installation

Step 4: manage the MySQL server through Systemd

On Ubuntu, after the package is installed, its service usually starts automatically once the package is configured. You can use the following command to check if the MySQL server is up and running.

$sudo systemctl status mysql

If for some reason it does not start automatically, use the following command to start and enable it to start when the system starts, as shown below.

$sudo systemctl status mysql $sudo systemctl enable mysql

Step 5: install additional MySQL products and components

In addition, you can install additional MySQL components for use with the server, such as mysql-workbench-community,libmysqlclient18 and many other components.

$sudo apt-get update $sudo apt-get install mysql-workbench-community libmysqlclient18

Finally, to access MySQL shell, issue the following command.

$sudo mysql-u root-p

The above is all the contents of the method of installing MySQL 8.0 in Ubuntu 18.04. thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.