CentOS 7 compilation installs MySQL and adds MySQL to system service

Install the dependency package first to avoid problems during the installation process

[[email protected] liuzhen]# yum-y install gcc gcc-c++[[email protected] liuzhen]# yum-y install Cmake[[email protected] liuzhen]# yum-y install Ncurses-devel[[email protected] liuzhen]# yum-y install autoconf[[email protected] liuzhen]# Yu M-y Install Perl Perl-devel

The above dependency package installation can also be done in one line

[Email protected] liuzhen]# yum-y install gcc gcc-c++ cmake ncurses-devel autoconf perl perl-devel

MySQL Source: https://dev.mysql.com/downloads/mysql/5.6.html#downloads

SOURCE Package Address: https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.35.tar.gz

Create MySQL installation directory and data storage directory

[Email protected] liuzhen]# mkdir/usr/local/mysql[[email protected] liuzhen]# Mkdir/usr/local/mysql/data

mkdir Creating a Folder

-M: Set access permissions on the new directory

-P: If some directories in the path do not already exist, the system will automatically set up those directories that do not already exist.

Create a user, user group

[[email protected] liuzhen]# groupadd mysql[[email protected] liuzhen]# useradd-r-g MySQL MySQL

The Useradd command is used to establish the user account and create the user's starting directory, which is the ultimate user. New User password is empty

-G: Specifies the starting group to which the user belongs.

-D: Specifies the start directory at which the user logged in.

-S: Specifies the shell to use when the user is logged in. -s/sbin/nologin is not allowed to login shell

-G After the first MySQL is the group name, the second MySQL is the new user name, the new user information can be found in the/etc/passwd file

Unzip the file to the current folder

Tar backup, compression and decompression, Linux command, also a tool

-Z: Indicates that the TAR package is compressed by gzip, so the decompression needs to use Gunzip decompression

-X: Extract the files from the tar package

-V: Show more information

-F xxx.tar.gz: Specifies that the file being processed is xxx.tar.gz

tar.gz with tar zxvf decompression, tar.bz2 with tar jxvf decompression

Start installation

[Code] [[email protected] liuzhen]# TAR-ZXVF mysql-5.6.35.tar.gz[[email protected] liuzhen]# CD Mysql-5.6.35[[email protected] mysql-5.6.35]# CMake. -dcmake_install_prefix=/usr/local/mysql-dinstall_datadir=/usr/local/mysql/data-ddefault_charset=utf8-ddefault_ Collation=utf8_general_ci-dextra_charsets=all-denabled_local_infile=1[[email protected] mysql-5.6.35]# make & & Make Install

CMake parameter Description:

-dcmake_install_prefix=/usr/local/mysql//default installation directory

-dinstall_datadir=/usr/local/mysql/data//Database storage directory

-ddefault_charset=utf8//using UTF8 characters

-DDEFAULT_COLLATION=UTF8_GENERAL_CI//Check character

-dextra_charsets=all//Install all extended character sets

-denabled_local_infile=1//Allow import of data from local

-dmysql_user=mysql

-dmysql_tcp_port=3306

CMake detailed configuration Please refer to the MySQL website

Precautions:

If the installation fails to recompile, you need to clear the old object file and cache information.

[[email protected] mysql-5.6.35]# make Clean[[email protected] mysql-5.6.35]# rm-f cmakecache.txt[[email protected] mysq l-5.6.35]# rm-rf/etc/my.cnf

Set directory Permissions

[Email protected] liuzhen]# cd/usr/local/mysql[[email protected] mysql]# chown-r mysql:mysql. [Email protected] mysql]# chown-r mysql:mysql data

The chown command changes a file or directory's owner and owner group.

-R: Recursively alters the owner of the specified directory and all subdirectories and files under it.

-V: Displays the work done by the Chown command.

To add the MySQL startup service to the system service

[[email protected] liuzhen]# Cd/usr/local/mysql[[email protected] mysql]# CP support-files/my-default.cnf/etc/my.cnf

To create the underlying table:

[Email protected] liuzhen]# cd/usr/local/mysql[[email protected] mysql]#  ./scripts/mysql_install_db--user= Mysql

Configuring Environment variables

[Email protected] liuzhen]# Vi/etc/profile

Add the following two values at the bottom of the

Export Mysql_home= "/usr/local/mysql"

Export path= "$PATH: $MYSQL _home/bin"

and then save

Make the modified profile effective immediately

[Email protected] liuzhen]# Source/etc/profile

Add MySQL to the folder that controls the startup service and name MySQL, which is the service-controllable name, to start MySQL with the service MySQL start control

/ETC/INIT.D is a link to/etc/rc.d/init.d, adding a file in/ETC/INIT.D will synchronize to add an identical file under/ETC/RC.D/INIT.D

[[email protected] liuzhen]# Cd/usr/local/mysql/[[email protected] mysql]# CP support-files/mysql.server/etc/init.d/ Mysql

The Chkconfig command is primarily used to update (start or stop) and query run-level information for system services. Remember that Chkconfig does not immediately automatically disable or activate a service, it simply changes the symbolic connection

--add: Adds the specified system service, allows the chkconfig instruction to manage it, and simultaneously adds the relevant data to the system-initiated narrative file. Service scripts must be stored in the/etc/ini.d/directory

To add the MySQL service to the list of services that are managed by the boot command

[[email protected] liuzhen]# chkconfig--add MySQL

Boot from MySQL service

On: For the service has a level limit, specific query chkconfig detailed

[[email protected] liuzhen]# chkconfig MySQL on

You can now start MySQL using the following command

[[Email protected] liuzhen]# service MySQL start

Stop MySQL Service

[[Email protected] liuzhen]# service MySQL stop

Restart MySQL Service

[[Email protected] liuzhen]# service MySQL restart

The following two commands work the same way

Systemctl [Stop|start|restart] Service Name

Service name [Stop|start|restart]

Enter to set a new password in the next prompt

[Email protected] liuzhen]# mysqladmin-u root passwordnew password:confirm new password: [[email protected] liuzhen]#

Connect to MySQL

[Email protected] mysql]#   

Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 2
Server version:5.6.35 Source Distribution

Copyright (c), Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Mysql>

The ability to add remote connections for root

Mysql>Use mysql;mysql>desc User;mysql> GRANT All privileges on * * to Root@"%"Identified by"Root";//the ability to add remote connections for root. Mysql>update UserSetPassword = Password ('xxxxxx')whereUser='Root'; MySQL>SelectHost,user,password fromUserwhereUser='Root'; MySQL>flush privileges;//Refresh PermissionsMysql>exit//Exit

The remaining four grant examples

Assign the user User1 from 192.168.155.1 the ability to perform operations such as Select,insert,update,delete,create,drop on the TableName table dbname the database, and set the password to 123456.

There are a lot of permissions to table operations like alter and so on

' User1 ' @'192.168.155.1'123456';

Assign the user user2 from 192.168.155.1 to all operations on the database dbname all tables, and set the password to 123456.

' User2 ' @'192.168.155.1'123456';

Assign the user User3 from 192.168.155.1 to all operations on all tables in all databases, and set the password to 123456.

' User3 ' @'192.168.155.1'123456';

Assign the native user user4 permissions to all operations on all tables in all databases, and set the password to 123456.

' User4 '@'localhost'123456';

Open external access to firewall mysql3306 ports

After upgrading to 7, CentOS replaced the original iptables with Firewalld. Below is a note on how to open Linux ports using FIREWALLD

--zone: Scope, the network region defines the trusted level of the network connection. This is a one-to-many relationship, which means that a connection can only be part of a region, and a region can be used for many connections

--add-port: Add port and communication protocol in the format: Port/Communication Protocol, protocol TCP or UDP

--permanent: Permanent, without this parameter the port access fails after the system restarts

[Email protected]/]# firewall-cmd--zone= public --add-port=3306/tcp--permanent

Restarting the firewall

[Email protected]/]# Firewall-cmd--reload

-----------------------------------------------------------------------

How to change your password after you forget the root password

Stop MySQL service, or command systemctl stop MySQL

[[Email protected]/]# service MySQL stop

Enter/usr/local/mysql

[Email protected]/]# cd/usr/local/mysql/

Start MySQL via Mysqld_safe and do not start the Grant-tables authorization form when you start MySQL

[Email protected] mysql]#/bin/mysqld_safe--basedir=/usr/local/mysql \

--datadir=/usr/local/mysql/data \
--skip-grant-tables &
Log in to MySQL

[[email protected]/]# mysql-u root MySQL

Change root password

Mysql>update user SET Password=password ("new_password") WHERE user='root  ';

Refresh Permissions

Mysql>flush privileges;

Quit MySQL

Reprinted from Http://www.jb51.net/article/104419.htm

CentOS 7 compilation installs MySQL and adds MySQL to system service