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

This article mainly shows you "how to install and configure mysql8.018 on linux", the content is easy to understand, clear, hope to help you solve your doubts, let the editor lead you to study and learn "how to install and configure mysql8.018 on linux" this article.

Introduction to installation under windows: check it out-"introduction to installation of mysql8.018 under windows

Linux platform:

The following actions take mysql 8.0.18 and the system Ubuntu 16.04.6 LTS (GNU/Linux 4.4.0-142-generic x86ip64) as an example:

a. Automatic installation

Sudo apt-get install mysql-serversudo apt-get install mysql-clientsudo apt-get install libmysqlclient-dev

b. Download the installation package and install the deb file by yourself

1. download

The Linux version can be downloaded from the official website. Mysql is divided into Enterprise Enterprise Edition and Community Community Edition. The community version is a free download, ordinary users can use the community version, and enterprise users can use the enterprise version.

Download address of Community Edition, https://dev.mysql.com/downloads/

Select Mysql Community Server

Enter the download interface. If you need a historical version of mysql, click Looking for previous GA versions on the right to select the desired mysql version. No.

Then select the operating system and the operating system version on the current page, and then click download.

This paper takes the 64-bit system under Ubuntu16.04 as an example.

Do not register to log in, just skip it.

When the download is complete, upload the download file mysql-server_8.0.18-1ubuntu16.04_amd64.deb-bundle.tar to the server.

Of course, it can also be downloaded directly under Ubuntu via wget. Copy download link, execute, wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-server_8.0.18-1ubuntu16.04_amd64.deb-bundle.tar

two。 Installation

After the server prepares to install the files, install several dependency packages needed for the mysql installation.

Sudo apt-get install libaio1sudo apt-get install libmecab2sudo apt-get install libjson-perlsudo apt-get install libnuma1

Create a temporary directory, copy the downloaded tar to the installation path, and extract it to tar-xvf mysql-server_8.0.18-1ubuntu16.04_amd64.deb-bundle.tar

Start the installation (according to the following order, some deb have successive dependencies), and the remaining unlisted deb can not be installed if not necessary.

Sudo dpkg-I mysql-common_8.0.18-1ubuntu16.04_amd64.debsudo dpkg-I libmysqlclient21_8.0.18-1ubuntu16.04_amd64.debsudo dpkg-I libmysqlclient-dev_8.0.18-1ubuntu16.04_amd64.debsudo dpkg-I mysql-community-client-core_8.0.18-1ubuntu16.04_amd64.debsudo dpkg-I mysql-community-client_8.0.18-1ubuntu16.04_amd64.debsudo dpkg-I mysql-client_8.0.18 -1ubuntu16.04_amd64.deb sudo dpkg-I mysql-community-server-core_8.0.18-1ubuntu16.04_amd64.deb sudo dpkg-I mysql-community-server_8.0.18-1ubuntu16.04_amd64.deb sudo dpkg-I mysql-server_8.0.18-1ubuntu16.04_amd64.deb

Note: when performing the installation of mysql-community-server_8.0.18-1ubuntu16.04_amd64.deb, the following input box will pop up to prompt for the root account password.

After entering the password, the current version of mysql will be prompted to choose the encryption method related to mysql authorization. Use Strong Password Encrypthion for Authentication is recommended. The use of enhanced encryption based on SHA256 authorization can better ensure the security of the account.

3.

Installation

Login authentication. Enter the instruction mysql-u root-p, followed by the password.

4. Common instructions and parameters

Launch: sudo service mysql start

Turn off: sudo service mysql stop

Mysql configuration storage path / etc/mysql, you can configure and modify the default port, data storage path, log path, default encoding format, and so on.

The following is the default profile

The above is all the contents of the article "how to install and configure mysql8.018 on linux". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more 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.