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

This article mainly explains "how to install and set up MySQL in Linux system". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to install and set up MySQL in Linux system".

About MySQL: MySQL is a small relational database management system developed, released and supported by MySQL AB. MySQL is a fast, multi-threaded, multi-user and robust SQL database server. The MySQL server supports the use of mission-critical, heavy-duty production systems, or it can be embedded in a large configuration (mass- deployed) software.

Characteristics of MySQL:

Collection-oriented operation mode of ①

② open source code

③ is highly non-procedural.

④ provides multiple uses in a single grammatical structure

⑤ language is concise, easy to use and easy to learn.

Linux system installation MySQL detailed steps: download the mysql package Note in MySQL Server 8.0.12, the compression algorithm is changed from Gzip to XZ; and the file extension of the generic binary is changed from .tar.gz to .tar.xz.

Installation environment preparation phase

Extract the xz file to a tar file

[root@centOS1 opt] # xz-d mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz [root@centOS1 opt] # ll total consumption 3300864 drwxr-xr-x. 2 root root 4096 March 5 20:08 gcctemp-rwxr-xr-x. 1 root root 51681321 March 12 20:49 gzhxvts1.zip-rwxrwxrwx. 1 root root 603019898 June 14 2018 mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz-rwxr-xr-x. 1 root root 2651712000 March 14 16:55 mysql-8.0.19-linux-glibc2.12-x86_64.tar 12345678 extract the tar file

[root@centOS1 opt] # tar-xvf mysql-8.0.19-linux-glibc2.12-x86_64.tar 12 move the extracted mysql to / usr/local/ and rename it to mysql

[root@centOS1 opt] # mv mysql-8.0.19-linux-glibc2.12-x86_64 / usr/local/mysql 1 go to the mysql folder and create a data folder under the mysql folder

[root@centOS1 opt] # cd / usr/local/mysql/ [root@centOS1 mysql] # ll total consumption 432 drwxr-xr-x. 2 7161 31415 4096 December 10 07:32 bin drwxr-xr-x. 2 7161 31415 4096 December 10 07:32 docs drwxr-xr-x. 3 7161 31415 4096 December 10 07:32 include drwxr-xr-x. 6 7161 31415 4096 December 10 07:32 lib-rw-r--r--. 1 7161 31415 405571 December 10 03:53 LICENSE drwxr-xr-x. 4 7161 31415 4096 December 10 07:32 man-rw-r--r--. 1 7161 31415 687 December 10 03:53 README drwxr-xr-x. 28 7161 31415 4096 December 10 07:32 share drwxr-xr-x. 2 7161 31415 4096 December 10 07:32 support-files [root@centOS1 mysql] # mkdir data 12345678910111213 create mysql users and mysql groups and authorize mysql and all files below to mysql groupadd mysql-create mysql user group

[root@centOS1 mysql] # groupadd mysql 1useradd-r-g mysql mysql-create mysql users and add them to the mysql user group

[root@centOS1 mysql] # useradd-r-g mysql mysql 1 sets a password for mysql users

[root@centOS1 local] # passwd mysql 1chown-R mysql mysql/-Grant mysql directory access to the myql user

[root@centOS1 mysql] # chown-R mysql/ usr/local/mysql/ 1chgrp-R mysql mysql/-the user group that changed the mysql directory belongs to the mysql group

[root@centOS1 mysql] # chgrp-R mysql/ usr/local/mysql/ 1 adds environment variables to mysql

[root@centOS1 mysql] # vim / etc/profile 1 add the following code for editing content

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.