MySQL installation method

MySQL installation tutorial under Linux CENTOS7 Environment

Fate Acquaintance-(like-minded) font: [Increase decrease] Type: Reprint time: 2017-03-17 I want to comment

This article mainly for you in detail the Linux CENTOS7 environment MySQL installation tutorial, with a certain reference value, interested in small partners can refer to

Detailed introduction to installing MySQL steps in Linux centos7 environment

Install MySQL

MySQL has two different places from windows

1), My.ini Save to/etc/my.ini

2), user rights, individual user execution

First, to find out if MySQL was previously installed, use the following command:

Rpm–qa | Grep-i MySQL

If the following package is displayed, the MySQL is installed

mysql-4.1.12-3.rhel4.1

mysqlclient10-3.23.58-4.rhel4.1

Download MySQL Unpacking package

Mysql-5.7.17-linux-glibc2.5-x86_64.tar (download to http://mirrors.sohu.com website)

Website: http://mirrors.sohu.com/mysql/MySQL-5.7/

can also be downloaded under the Linux operating system, enter the following command

wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

Create a directory software for the MySQL package that we will download later, go to the Directory Input command first:cd/software

After the download is complete, you will see a copy of the MySQL installation package file in the software directory

Third, the establishment of users, as well as the MySQL directory

1, Groupadd MySQL #建立一个mysql的组

2, Useradd-r-G mysqlmysql #建立mysql用户, and put the user into the MySQL group

3, passwd MySQL #给mysql用户设置一个密码

Iv. unpacking the MySQL installation package

1, first move the tar.gz package to the/usr/local directory, enter the command

Mv/software/mysql/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz/usr/local

2, Decompression tar.gz bag

First go to the/usr/local directory, enter the command cd/usr/local

Decompression command tarzxvfmysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

Enter View Directory command ll

You'll find out more catalogs mysql-5.7.17-linux-glibc2.5-x86_64

Note: There is no data directory, the My.ini file is in the Support-files directory

3. Change the catalogue name to/usr/local/mysql

(This is the default installation directory for MySQL under Linux)

Change the extracted file name to MySQL

Input command: MV mysql-5.7.17-linux-glibc2.5-x86_64 MySQL

V. Configuration-related boot configuration files

The first thing to do is to go to the support-files/file directory

Input command: CD support-files/

1. Copy my.cnf to/ETC/MY.CNF (automatically read when MySQL starts)

Enter Command cpmy-default.cnf/etc/my.cnf

2, solve garbled problem

Input command:vi/etc/my.cnf (enter editable state)

Change:

[MySQL]

Default-character-set=utf8 (indicates troubleshooting client garbled issues)

[Mysqld]

Default-storage-engine=innodb

Character_set_server=utf8 (indicates troubleshooting service-side garbled issues)

3, copy Mysql.server to/etc/init.d/directory "purpose to achieve mysqld-install such boot automatic execution effect"

Input command CP mysql.server/etc/init.d/mysql (MySQL is the service name)

Note: The/etc/init.d/directory, equivalent to registry Hkey_local_machine\system\controlset001\services Records, has those services

4. Modify/etc/init.d/mysql Parameters

Enter Command vi/etc/init.d/mysql

Given with two directory locations

Basedir=/usr/local/mysql

Datadir=/usr/local/mysql/data

5, to the directory/usr/local/mysql change owner

Input command chown-r mysql:mysql/usr/local/mysql/

Vi. initializing the MySQL database

1. Initialize MySQL

mysql_install_db (old version of the procedure)

New version: Initialization

Enter the command ./mysqld--initialize--user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data

Generate a data directory that represents the successful initialization of the database

and the root user of MySQL generates a temporary password: (record the temporary password XXX)

2. Encrypt the database

Enter the command ./mysql_ssl_rsa_setup--datadir=/usr/local/mysql/data

3. Start MySQL

Enter the command ./mysqld_safe--user=mysql & (& commit to run MySQL service in the background)

Vii. entering the client

1. Login

Enter the command ./mysql-uroot-p

And then enter your temporary password.

2. Change the password

Input command set Password=password (' xxxx ')

Eight, window remote access to the Linux virtual machine MySQL

Let's take a look at the database structure

1. Turn off the firewall (or open the port to the firewall) so that window can connect

Input command systemctl stop Firewalld.service

2. Authorization to Windows

Input command mysql>grant all privileges on * * [email protected] '% ' identified by ' 123456 ';

"One more Telnet user record"

Mysql>flush privileges;

3. Remotely link the database, or restart (init 6).

Input command:mysql–hip address-uroot-p123456

Nine, set the boot automatically start the MySQL service

1. Add MySQL Service

Input command chkconfig--add mysql "Mysqld-install"

2. Set up MySQL service for automatic

Input command chkconfig MySQL on

3. Restart Check

Init 6ps–ef | grep MySQL

X. Setting path

Enter Command vi/etc/profile

Input command exportpath= $JAVA _home/bin:/usr/local/mysql/bin: $PATH

After we have configured the MySQL environment variable, we will not have to go to the/usr/local/mysql/bin directory to log in, and now we can login MySQL in any directory.

Here we have successfully installed MySQL in the Linux CENTOS7 environment.

Thank you Bo friends for their support!

The above is the whole content of this article, I hope that everyone's learning has helped, but also hope that we support the script home.

MySQL installation method