Detailed introduction to centos compilation and installation of mysql5.6 and sample code sharing for installing multiple mysql-Mysql Tutorial-php.cn

Detailed introduction to centos compilation and installation of mysql5.6 and sample code sharing for installing multiple mysql

黄舟

Release： 2017-03-25 13:51:46

Original

1089 people have browsed it

This article mainly introduces centos compilation and installation of mysql 5.6 and the detailed explanation of installing multiple mysql instances. Friends in need can refer to the following

--1. Create new groups and users for mysql

# useradd -M -s /sbin/nologin mysql

Copy after login

--2. Install the required libraries and compiler

# yum install ncurses-devel openssl-devel cmake -y

Copy after login

--3. Unzip

# tar zxvf mysql-5.6.35.tar.gz
# cd mysql-5.6.35

Copy after login

--4. Compile and install

# cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DMYSQL_USER=mysql \
-DWITH_DEBUG=0 \
-DWITH_SSL=system
# make
# make install

Copy after login

--5. Copy the template as a configuration file

# cp support-files/my-default.cnf /etc/my.cnf

Copy after login

--6.Set mysql permissions

# chown -R mysql.mysql /usr/local/mysql/

Copy after login

--7.Initializemysql database

# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
# chown -R root /usr/local/mysql/
# chown -R mysql /usr/local/mysql/data/

Copy after login

--8.Set mysql to boot Self-start

# cp support-files/mysql.server /etc/init.d/mysqld
# chmod +x /etc/init.d/mysqld
# chkconfig mysqld on

Copy after login

--9. Test and run mysql

#service mysqld start

Copy after login

--10. Modify the mysql administrator password

#/usr/local/mysql/bin/mysqladmin -u root password &#39;要设置的密码&#39;

Copy after login

--11. Log in using user mysql

# /usr/local/mysql/bin/mysql -u root -p

Copy after login

--12. Add environment variable

# echo &#39;PATH=/usr/local/mysql/bin/:$PATH&#39; >>/etc/profile
# source /etc/profile

Copy after login

Centos 6.5 minimum compilation and installation MYSQL 5.5.35 Configure multiple examples

# 1 1. Close the firewall r

2. Close selinux

1234567 [root@mysql ~]# service iptables stop
iptables: Setting chains to policy ACCEPT: filter   [ OK ]
iptables: Flushing firewall rules:       [ OK ]
iptables: Unloading modules:        [ OK ]
[root@mysql ~]# chkconfig iptables off
[root@mysql ~]# chkconfig iptables --list
iptables  0:off 1:off 2:off 3:off 4:off 5:off 6:off

Copy after login

Modify the following line;

12 [root@mysql ~]# setenforce 0
[root@mysql ~]# vim /etc/sysconfig/selinux

Copy after login

3. Install mysql dependency packages and compilation tools;

SELINUX=disabled
12 [root@mysql ~]# getenforce 
Permissive

Copy after login

4. Preparation before installation;

4.1.Installation path:

1234 [root@mysql ~]# yum install libaio-devel -y
[root@mysql ~]# yum install -y ncurses-devel
[root@mysql ~]# yum install -y gcc gcc-c++ 
[root@mysql ~]# yum install -y cmake

Copy after login

4.2.Database path:

1 [root@mysql ~]# mkdir /usr/local/mysql

Copy after login

4.3.Creation Users and user groups

1 [root@mysql ~]# mkdir /data/mysql -p

Copy after login

4.4. Grant permissions to the data storage directory

12 [root@mysql ~]# groupadd mysql
[root@mysql ~]# useradd -r -g mysql -s /bin/false mysql

Copy after login

5. Compile and install mysql 5.5.35

1 [root@mysql ~]# chown mysql:mysql -R /data/mysql

Copy after login

6. Create multiple The storage location of the instance database file;

1234567 [root@mysql ~]# yum install -y lrzsz
root@mysql ~]# mkdir /package
[root@mysql ~]# cd /package/
[root@mysql package]# tar xf mysql-5.5.32.tar.gz 
[root@mysql package]# cd mysql-5.5.32
[root@mysql mysql-5.5.32]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql 
-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock 
-DDEFAULT_CHARSET=utf8 
-DDEFAULT_COLLATION=utf8_general_ci 
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk 
-DWITH_INNOBASE_STORAGE_ENGINE=1 
-DWITH_READLINE=1 
-DENABLED_LOCAL_INFILE=1 
-DMYSQL_DATADIR=/data/mysql/ 
-DMYSQL_USER=mysql 
-DMYSQL_TCP_PORT=3306
[root@mysql mysql-5.5.32]# make && make install

Copy after login

7. Modify the configuration file (my.cnf) with the following lines and place it in the 3306 and 3307 directories respectively;

12345678 [root@mysql ~]# mkdir -p /data/{3306,3307}/data
[root@mysql ~]# tree /data
/data
|-- 3306
|  `-- data
`-- 3307
  `-- data
4 directories, 0 files

Copy after login

8. Initialize the database;

Note: You need to specify different data directories when initializing the database

123456789 [root@mysql 3306]# vim my.cnf 
[client]
port      = 3306
socket     = /data/3306/mysql.sock
[mysqld]
port      = 3306
socket     = /data/3306/mysql.sock
datadir     = /data/3306
server-id    = 3306

Copy after login

9. To start multiple instances, the startup script can be added to the boot auto-start file.

123 [root@mysql mysql-5.5.32]# cd /usr/local/mysql/
[root@mysql mysql]# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/3306
[root@mysql mysql]# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/3307

Copy after login

9.1. View port;

12 [root@mysql mysql]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/3306/my.cnf 2>&1 >/dev/null &  
[root@mysql mysql]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/3307/my.cnf 2>&1 >/dev/null &

Copy after login

10. Log in to multi-instance database

12345678 [root@mysql mysql]# netstat -tunlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address        Foreign Address       State    PID/Program name  
tcp    0   0 0.0.0.0:3307        0.0.0.0:*          LISTEN   11621/mysqld    
tcp    0   0 0.0.0.0:22         0.0.0.0:*          LISTEN   1266/sshd      
tcp    0   0 0.0.0.0:3306        0.0.0.0:*          LISTEN   11338/mysqld    
tcp    0   0 :::22            :::*            LISTEN   1266/sshd      
udp    0   0 0.0.0.0:68         0.0.0.0:*                969/dhclient

Copy after login

11. Close mysql multi-instance mode

12 [root@mysql mysql]# /usr/local/mysql/bin/mysql -u root -p -P 3306 -S /data/3306/mysql.sock
[root@mysql mysql]# /usr/local/mysql/bin/mysql -u root -p -P 3307 -S /data/3307/mysql.sock

Copy after login

The above is the detailed content of Detailed introduction to centos compilation and installation of mysql5.6 and sample code sharing for installing multiple mysql. For more information, please follow other related articles on the PHP Chinese website!