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

Centos mini 6.5 install mysql5.6.4

1. Download the installation package

Address of cloud disk: http://pan.baidu.com/s/1bpsgXUf

Package tools are required for installation

Yum-y install wget vim lrzsz tar

two。 Replace the yum source (if an individual installs some packets in yum, if there is a problem, change the yum source of Aliyun)

Change it to Aliyun yum source here

Cd / etc/yum.repos.d/

Mv CentOS-Bose.repo CentOS-Bose.repo.bak

Wget-O CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo

Yum makecache

3. Create a mysql user

Useradd mysql / / existing does not need to be created

4. Uninstall the original mysql rpm package

Rpm-qa | grep mysql / / query whether there are related packages

Yum-y remove * mysql* / / I uninstalled it with yum here.

5. Turn off the firewall, turn off selinux

Service iptables stop / / personal habit to turn off the firewall

Sed-I's etc/selinux/config SelinuxplenforcingAccording to SELINUXAfter

Setenforce 0

6. Install the required dependency packages

Yum-y install make gcc gcc-c++ gcc-gfortran flexbison file libtool libtool-libs autoconf kernel-devel libjpeg libjpeg-devellibpng libpng-devel libpng10 libpng10-devel gd gd-devel freetype freetype-devellibxml2 libxml2-devel zlib zlib-devel glib2 glib2-devel bzip2 bzip2-devellibevent libevent-devel ncurses ncurses-devel curl curl-devel e2fsprogse2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-develgettext gettext-devel ncurses-devel gmp-devel pspell-devel unzip libcap lsof

7. Install cmake

Cmake is required to configure compilation after the Mysql5.6 version

Tar-zxvf cmake-2.8.5.tar.gz

Cd cmake-2.8.5

. / configure

Gmake & & gmake install

8. Start installing mysql

Tar-zxvf mysql-5.6.4-m7.tar.gz

Cd mysql-5.6.4-m7

Cmake\

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\

-DMYSQL_DATADIR=/usr/local/mysql/data\

-DSYSCONFDIR=/etc\

-DMYSQL_USER=mysql\

-DWITH_MYISAM_STORAGE_ENGINE=1\

-DWITH_INNOBASE_STORAGE_ENGINE=1\

-DWITH_MEMORY_STORAGE_ENGINE=1\

-DWITH_READLINE=1\

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock\

-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

=

Installation of a single instance

9. After installation, related operations

Modify mysql installation directory permissions

Chmod + w / usr/local/msyql

Chown-R msyql.msyql / usr/local/mysql

/ / when starting the MySQL service, the my.cnf will be searched in a certain order, first in the / etc directory. If you can't find it, it will search for "$basedir/my.cnf", which is / usr/local/mysql/my.cnf under the installation directory, which is the default location of the configuration file for the new version of MySQL! Note: after the minimum installation of the CentOS 6.x operating system is complete, there will be a my.cnf in the / etc directory, and this file needs to be renamed to something else. Such as: / etc/my.cnf.bak, otherwise, the file will interfere with the correct configuration of the MySQL installed by the source code, resulting in failure to start. Since we have uninstalled the mysq library after the minimum installation, there is no need to do so.

Cd support-files/

If there is still my.cnf, please back it up.

Mv / etc/my.cnf / etc/my.cnf.bak

Copy the configuration file to etc

Cp my-medium.cnf / etc/my.cnf

/ / execute the initialization configuration script, create the database and table that comes with the system, and pay attention to the path of the configuration file.

/ usr/local/mysql/scripts/mysql_install_db-defaults-file=/etc/my.cnf--basedir=/usr/local/mysql-datadir=/usr/local/mysql/data-user=mysql

/ / copy the support-files service script under the mysql installation directory to the init.d directory

# copy script

Cp support-files/mysql.server / etc/init.d/mysqld

# Grant permissions

Chmod + x / etc/init.d/mysqld

# set Boot Startup

Chkconfig mysqld on

# start MySQL

Service mysqld start or / etc/init.d/mysql start

After MySQL5.6.x starts successfully, root does not have a password by default. We need to set the root password. Before setting up, we need to set PATH, otherwise, we can't call mysql directly.

Modify / etc/profile file

Vim / etc/profile

Add at the end of the file

PATH=/usr/local/mysql/bin:$PATH

Export PATH

# Let the configuration take effect immediately

Source / etc/profile

# Log in test. There is no password by default. Enter directly and then enter.

Mysql-uroot-p

Set the mysqlroot user password

Mysqladmin-u root password "newpass"

# if root has already set a password, use the following methods

Mysqladmin-u root password oldpass "newpass"

# verify the mysql installation path

Ls-ld / usr/local/mysql/

Installation of multiple instances

Then the above source package installation is complete and starts.

1. Create a multi-instance database folder

Mkdir-pv/usr/local/mysql/data/ {3306, 3307, 3308}

Chown-Rmysql.mysql / usr/local/mysql/data/

2. Initialize the database

Cd/usr/local/mysql

Scripts/mysql_install_db--user=mysql-basedir=/usr/local/mysql-datadir=/usr/local/mysql/data/3306/

Scripts/mysql_install_db--user=mysql-basedir=/usr/local/mysql-datadir=/usr/local/mysql/data/3307/

Scripts/mysql_install_db--user=mysql-basedir=/usr/local/mysql-datadir=/usr/local/mysql/data/3308/

3. Prepare profile # provide multiple profile templates

Cd bin

. / mysqld_multi--example > / usr/local/mysql/data/multi.cnf

4. Modify the template file (comment out the unused ones)

Vim / usr/local/mysql/data/multi.cnf

[mysqld_multi] cd

Mysqld = / usr/local/mysql/bin/mysqld_safe

Mysqladmin = / usr/local/mysql/bin/mysqladmin

User = root

# password = root # must be enabled after the password is set, otherwise there will be a problem with the command to stop (the password of the three instance databases is the same)

[mysqld1]

Socket = / tmp/mysql.sock1

Port = 3306

Pid-file = / usr/local/mysql/data/3306/mysql.pid

Datadir = / usr/local/mysql/data/3306/

[mysqld2]

Socket = / tmp/mysql.sock2

Port = 3307

Pid-file = / usr/local/mysql/data/3307/mysql.pid

Datadir = / usr/local/mysql/data/3307/

# language = / usr/local/mysql/share/mysql/english

# user = unix_user1

[mysqld3]

# mysqld = / path/to/mysqld_safe

# ledir = / path/to/mysqld-binary/

# mysqladmin = / path/to/mysqladmin

Socket = / tmp/mysql.sock3

Port = 3308

Pid-file = / usr/local/mysql/data/3308/mysql.pid

Datadir = / usr/local/mysql/data/3308/

# language = / usr/local/mysql/share/mysql/swedish

# user = unix_user2

5. Modify / etc/profile file

Vim / etc/profile

Add at the end of the file

PATH=/usr/local/mysql/bin:$PATH

# Let the configuration take effect immediately

Source / etc/profile

6. Start the msyql database

Mysqld_multi--defaults-file=/usr/local/mysql/data/multi.cnf start 1,2,3

View port statu

Netstat-anpt | grep mysqld

Tcp 0 0 0.0.0.0 3307 0.0.0.015 * LISTEN 25470/mysqld

Tcp 0 0 0.0.0.0 3308 0.0.0.015 * LISTEN 25476/mysqld

Tcp 0 0 0.0.0.0 3306 0.0.0.015 * LISTEN 25453/mysqld

7, set the mysql password

Mysqladmin-uroot-S / tmp/mysql.sock1 password "root"

Mysqladmin-uroot-S / tmp/mysql.sock2 password "root"

Mysqladmin-uroot-S / tmp/mysql.sock3 password "root"

8, enter the database

Mysql-S/tmp/mysql.sock1-proot

9. There are three ways to close the database.

Mysqladmin-S/tmp/mysql.sock1 shutdown-proot

Mysqld_multi--defaults-file=/usr/local/mysql/data/multi.cnf stop 1,2,3

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.