64-bit CentOs7 source code installation mysql-5.6.35 process sharing

First install the dependent packages to avoid problems during the installation process

[root@bogon liuzhen]# yum -y install gcc gcc-c++
[root@bogon liuzhen]# yum -y install cmake
[root@bogon liuzhen]# yum -y install ncurses-devel
[root@bogon liuzhen]# yum -y install autoconf
[root@bogon liuzhen]# yum -y install perl perl-devel
The above dependency package installation can also be done in one line

[root@bogon liuzhen]# yum -y install gcc gcc-c++ cmake ncurses-devel autoconf perl perl-devel

MySQL source code download address: 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 the mysql installation directory and data storage directory

[root@bogon liuzhen]# mkdir /usr/local/mysql
[root@bogon liuzhen]# mkdir /usr/local/mysql/data

mkdir create folder

-m: Set access permissions for newly created directories

-p: If some directories in the path do not exist yet, the system will automatically create those directories that do not exist yet

Create users and user groups

[root@bogon liuzhen]# groupadd mysql
[root@bogon liuzhen]# useradd -r -g mysql mysql

The useradd command is used to create a user account and the user's home directory. The command has the authority to be used by the ultimate user. New user password is empty

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

-d: Specifies the starting directory when the user logs in.

-s: Specifies the shell used by the user after logging in. -s /sbin/nologin is to prevent login shell

The first mysql after -g is the group name, and the second mysql is the newly created user name. The newly created 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 tarball is compressed with gzip, so you need to use gunzip to decompress it.

-x : Extract files from the tarball

-v : show detailed information

-f xxx.tar.gz: specifies that the file to be processed is xxx.tar.gz

Decompress tar.gz with tar zxvf and tar.bz2 with tar jxvf

Start Installation

[code]
[root@bogon liuzhen]# tar -zxvf mysql-5.6.35.tar.gz
[root@bogon liuzhen]# cd mysql-5.6.35
[root@bogon 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
[root@bogon 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 //Use utf8 characters

-DDEFAULT_COLLATION=utf8_general_ci //Check character

-DEXTRA_CHARSETS=all //Install all extended character sets

-DENABLED_LOCAL_INFILE=1 //Allow data to be imported from local

-DMYSQL_USER=mysql

-DMYSQL_TCP_PORT=3306

For detailed configuration of CMAKE, please refer to the MySQL official website

Note:

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

[root@bogon mysql-5.6.35]# make clean
[root@bogon mysql-5.6.35]# rm -f CMakeCache.txt
[root@bogon mysql-5.6.35]# rm -rf /etc/my.cnf

Setting Directory Permissions

[root@bogon liuzhen]# cd /usr/local/mysql
[root@bogon mysql]# chown -R mysql:mysql .
[root@bogon mysql]# chown -R mysql:mysql data

The chown command changes the owner and group of a file or directory.

-R: Recursively change the owner of the specified directory and all its subdirectories and files.

-v : Displays the work done by the chown command.

Add the mysql startup service to the system service

[root@bogon liuzhen]# cd /usr/local/mysql
[root@bogon mysql]# cp support-files/my-default.cnf /etc/my.cnf

Create the base table:

[root@bogon liuzhen]# cd /usr/local/mysql
[root@bogon mysql]# ./scripts/mysql_install_db --user=mysql

Configuring environment variables

[root@bogon liuzhen]# vi /etc/profile

Add the following two values ​​at the bottom

export MYSQL_HOME="/usr/local/mysql"

export PATH="$PATH:$MYSQL_HOME/bin"

Then save

Make the modified profile file take effect immediately

[root@bogon liuzhen]# source /etc/profile

Add mysql to the folder of the service that can be controlled to start, and name it mysql, which is the service name that can be controlled by service. Now you can use service mysql start to control the start of mysql.

/etc/init.d is a link to /etc/rc.d/init.d. Adding a file to /etc/init.d will add the same file to /etc/rc.d/init.d.

[root@bogon liuzhen]# cd /usr/local/mysql/
[root@bogon mysql]# cp support-files/mysql.server /etc/init.d/mysql

The chkconfig command is mainly used to update (start or stop) and query the run-level information of system services. Keep in mind that chkconfig does not automatically disable or enable a service immediately, it simply changes the symbolic link.

--add: Add the specified system service so that the chkconfig command can manage it, and at the same time add related data to the system startup narrative file. The service script must be stored in the /etc/ini.d/ directory

Add the mysql service to the service list managed by the boot command

[root@bogon liuzhen]# chkconfig --add mysql
Start mysql service automatically at boot

on: The service has level restrictions, please check chkconfig for details

[root@bogon liuzhen]# chkconfig mysql on

Now you can start mysql using the following command

[root@bogon liuzhen]# service mysql start
Stop mysql service

[root@bogon liuzhen]# service mysql stop
Restart mysql service

[root@bogon liuzhen]# service mysql restart

The following two commands have the same effect:

systemctl [stop|start|restart] service name

service service name [stop|start|restart]

Press Enter to set a new password in the next prompt.

[root@bogon liuzhen]# mysqladmin -u root password
New password:
Confirm new password:
[root@bogon liuzhen]#

Connect to mysql

[root@bogon mysql]# mysql -u root -p
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) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql>

Add remote connection capability for root

mysql>use mysql;
mysql>desc user;
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root"; //Add remote connection capability to root.
mysql>update user set Password = password('xxxxxx') where User='root';
mysql>select Host,User,Password from user where User='root';
mysql>flush privileges; //Refresh privileges
mysql>exit //Exit

The following four other GRANT examples

Assign permissions for SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP to user user1 from 192.168.155.1 on table tablename in database dbname, and set the password to 123456.

There are many other permissions for table operations, such as ALTER, etc.

mysql>GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON dbname.tablename TO 'user1'@'192.168.155.1' IDENTIFIED BY '123456';
Assign permissions for all operations on all tables in database dbname to user user2 from 192.168.155.1, and set the password to 123456.

mysql>GRANT ALL PRIVILEGES ON dbname.* TO 'user2'@'192.168.155.1' IDENTIFIED BY '123456';
Assign permissions for all operations on all tables in all databases to user user3 from 192.168.155.1, and set the password to 123456.

mysql>GRANT ALL PRIVILEGES ON *.* TO 'user3'@'192.168.155.1' IDENTIFIED BY '123456';
Assign permissions to the local user user4 to perform all operations on all tables in all databases, and set the password to 123456.

mysql>GRANT ALL PRIVILEGES ON *.* TO 'user4'@'localhost' IDENTIFIED BY '123456';

Enable external access to the firewall mysql3306 port

After CentOS was upgraded to 7, firewalld was used instead of the original iptables. The following is a record of how to open Linux ports using firewalld

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

--add-port : Add port and communication protocol, the format is: port/communication protocol, the protocol is tcp or udp

--permanent : Permanent effect. Without this parameter, port access will fail after the system restarts.

[root@bogon /]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
Restart the firewall

[root@bogon /]# firewall-cmd --reload
-----------------------------------------------------------------------

How to change the root password after forgetting it

Stop the mysql service, or run the command systemctl stop mysql

[root@bogon /]# service mysql stop
Enter /usr/local/mysql

[root@bogon /]# cd /usr/local/mysql/
Start mysql through mysqld_safe, and do not start the grant-tables authorization table when starting mysql

[root@bogon mysql]# ./bin/mysqld_safe --basedir=/usr/local/mysql \
--datadir=/usr/local/mysql/data \
--skip-grant-tables &
Login to mysql

[root@bogon /]# mysql -u root mysql
Change root password

mysql>UPDATE user SET password=PASSWORD("new_password") WHERE user='root';
Refresh permissions

mysql> FLUSH PRIVILEGES;
Exit mysql

mysql>exit;