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

The source package compiles and installs the MySQL5.6 script, one machine installs two MySQL databases, and specifies the port, installation path and socket file location at compile time.

The installed MySQL installation files can be packaged and copied to other machines, which only need to be initialized when other machines are used, and you can give relevant directory permissions.

Install MySQL for port 3306:

#! / bin/bash

Groupadd mysql

Useradd-g mysql mysql-s / sbin/nologin

Mkdir / data/3306

Chown-R mysql.mysql / data/3306

Chmod 755 / data/3306

# mount-o loop / tmp/turbolinux12.iso / mnt/

Yum-y install make gcc-c++ cmake bison-devel ncurses-devel openssl openssl-devel bison

Tar zxf / tmp/mysql-5.6.16.tar.gz-C / usr/local/src/

Mv / usr/local/src/mysql-5.6.16/ / usr/local/src/mysql-master

# read-n1 var press any key to continue

Read-N1 var

Cd / usr/local/src/mysql-master

Cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-master/\

-DMYSQL_DATADIR=/data/3306/data\

-DMYSQL_TCP_PORT=3306\

-DMYSQL_UNIX_ADDR=/var/run/mysqld/mysql-master.sock\

-DSYSCONFDIR=/usr/local/mysql-master\

-DDEFAULT_CHARSET=gbk\

-DDEFAULT_COLLATION=gbk_chinese_ci\

-DWITH_EXTRA_CHARSETS=ALL\

-DMYSQL_USER=mysql

Read-N1 var

Make

Read-N1 var

Make install

Read-N1 var

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

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

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

Read-N1 var

Chmod + x / etc/init.d/mysqld-master

Chkconfig-add mysqld-master

Chkconfig mysqld-master on

/ etc/init.d/mysqld-master start

Install mysql for port 3307:

#! / bin/bash

Groupadd mysql

Useradd-g mysql mysql-s / sbin/nologin

Mkdir / data/3307

Chown-R mysql.mysql / data/3307

Chmod 755 / data/3307

# mount-o loop / tmp/turbolinux12.iso / mnt/

Yum-y install make gcc-c++ cmake bison-devel ncurses-devel openssl openssl-devel bison

Tar zxf / tmp/mysql-5.6.16.tar.gz-C / usr/local/src/

Mv / usr/local/src/mysql-5.6.16/ / usr/local/src/mysql-slave

Read-N1 var

Cd / usr/local/src/mysql-slave

Cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-slave/\

-DMYSQL_DATADIR=/data/3307/data\

-DMYSQL_TCP_PORT=3307\

-DMYSQL_UNIX_ADDR=/var/run/mysqld/mysql-slave.sock\

-DSYSCONFDIR=/usr/local/mysql-slave\

-DDEFAULT_CHARSET=gbk\

-DDEFAULT_COLLATION=gbk_chinese_ci\

-DWITH_EXTRA_CHARSETS=ALL\

-DMYSQL_USER=mysql

Read-N1 var

Make

Read-N1 var

Make install

Read-N1 var

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

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

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

Read-N1 var

Chmod + x / etc/init.d/mysqld-slave

Chkconfig-add mysqld-slave

Chkconfig mysqld-slave on

/ etc/init.d/mysqld-slave start

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.