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

This article mainly tells you how to install multi-instance mysql database. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on how to install multi-instance mysql database can bring you some practical help.

1. Experimental environment

System: cetos6.5

Software: mysql-5.5.32.tar.gz

Second, the experimental steps

1.1 install cmake software

Tar xf cmake-2.8.8.tar.gz

Cd cmake-2.8.8

. / configure

Gmake

Gmake install

1.2 create users and groups and install mysql dependency packages

Groupadd mysql

Useradd mysql-s / sbin/nologin-M msyql

Yum-y install ncurses-devel

1.3 decompress, compile and install mysql

Tar xf mysql-5.5.32.tar.gz

Cd mysql-5.5.32.tar.gz

Cmake. -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32\

-DMYSQL_DATADIR=/application/mysql-5.5.32/data\

-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock\

-DDEFAULT_CHARSET=utf8\

-DDEFAULT_COLLATION=utf8_general_ci\

-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii\

-DENABLED_LOCAL_INFILE=ON\

-DWITH_INNOBASE_STORAGE_ENGINE=1\

-DWITH_FEDERATED_STORAGE_ENGINE=1\

-DWITH_BLACKHOLE_STORAGE_ENGINE=1\

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1\

-DWITHOUT_PARTITION_STORAGE_ENGINE=1\

-DWITH_FAST_MUTEXES=1\

-DWITH_ZLIB=bundled\

-DENABLED_LOCAL_INFILE=1\

-DWITH_READLINE=1\

-DWITH_EMBEDDED_SERVER=1\

-DWITH_DEBUG=0

Make & & make install

1.4 configuration environment variables are written to the / etc/profile file

PATH= "/ application/mysql/bin:$PATH"

1.5 create a multi-instance directory startup script configuration file and its authorization

/ data/

├── 3306

│ ├── data

│ ├── my.cnf

│ └── mysql

└── 3307

├── data

├── my.cnf

└── mysql

Chown-R mysql.mysql / data/

Find / data/-type f-name "mysql" | xargs chmod + x

/ data/3306/mysql start-start the mysql process

/ data/3307/mysql start-start the mysql process

1.6 Log in to mysql via socket multi-instance

Mysql-S / data/3306/mysql.sock

Mysql-S / data/3307/mysql.sock

1.7 change password

Mysqladmin-uroot-S / data/3306/mysql.sock password '123'

Mysqladmin-uroot-S / data/3307/mysql.sock password '123'

1.8 login method after changing password

Mysql-uroot-p-S / data/3306/mysql.sock

Mysql-uroot-p-S / data/3307/mysql.sock

1.9 achieve a successful login

~] # mysql-uroot-p-S / data/3306/mysql.sock

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 2

Server version: 5.5.32 Source distributio

Copyright (c) 2000, 2013, 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 >

~] # mysql-uroot-p-S / data/3307/mysql.sock

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 2

Server version: 5.5.32 Source distributio

Copyright (c) 2000, 2013, 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 >

How to install multi-instance mysql database will first tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.