Mysql creates multiple instances. In fact, it points the DATA file, SOCK, and PORT to different files and ports. For mysql installation process, see blog. csdn. nettangpengtaoarticledetails6650424 first create a 3307 data directory [root@localhostmysql-5.5.15] # mkdir-pusrlocalmysql3307 [root @ localhost
When mysql creates multiple instances, the DATA file, SOCK, PORT pointing to different files and PORT mysql installation process to see the http://blog.csdn.net/tangpengtao/article/details/6650424 first create a 3307 data directory [root @ localhost mysql-5.5.15] # mkdir-p/usr/local/mysql3307 [root @ localhost
When mysql creates multiple instances, it actually points the DATA file, SOCK, and PORT to different files and ports.
Mysql installation process see http://blog.csdn.net/tangpengtao/article/details/6650424
Create a 3307 data directory first
[Root @ localhost mysql-5.5.15] # mkdir-p/usr/local/mysql3307
[Root @ localhost mysql-5.5.15] #
[Root @ localhost mysql-5.5.15] #
[Root @ localhost mysql-5.5.15] # chmod + w/usr/local/mysql3307
[Root @ localhost mysql-5.5.15] # chown-R mysql: mysql/usr/local/mysql3307
[Root @ localhost mysql-5.5.15] #
[Root @ localhost mysql-5.5.15] # mkdir-p/var/mysql3307/
Mkdir-p/var/mysql3307/data/
Mkdir-p/var/mysql3307/log/
Chown-R mysql: mysql/var/mysql3307/
[Root @ localhost mysql-5.5.15] # mkdir-p/var/mysql3307/data/
[Root @ localhost mysql-5.5.15] # mkdir-p/var/mysql3307/log/
[Root @ localhost mysql-5.5.15] # chown-R mysql: mysql/var/mysql3307/
Mkdir-p/usr/local/mysql3307
Chmod + w/usr/local/mysql3307
Chown-R mysql: mysql/usr/local/mysql3307
Mkdir-p/var/mysql3307/
Mkdir-p/var/mysql3307/data/
Mkdir-p/var/mysql3307/log/
Chown-R mysql: mysql/var/mysql3307/
[Root @ localhost mysql-5.5.15] # cmake-DCMAKE_INSTALL_PREFIX =/usr/local/mysql3307 \
>-DMYSQL_UNIX_ADDR =/tmp/mysql3307.sock \
>-DDEFAULT_CHARSET = utf8 \
>-DDEFAULT_COLLATION = utf8_general_ci \
>-DWITH_EXTRA_CHARSETS: STRING = utf8, gbk \
>-DWITH_MYISAM_STORAGE_ENGINE = 1 \
>-DWITH_INNOBASE_STORAGE_ENGINE = 1 \
>-DWITH_READLINE = 1 \
>-DENABLED_LOCAL_INFILE = 1 \
>-DMYSQL_DATADIR =/var/mysql3307/data \
>;
-- MySQL 5.5.15
-- Processing ing done
-- Generating done
-- Build files have been written to:/home/raycloud/software/mysql-5.5.15
[Root @ localhost mysql-5.5.15] #
[Root @ localhost mysql-5.5.15] # make
-- MySQL 5.5.15
-- Processing ing done
-- Generating done
-- Build files have been written to:/home/raycloud/software/mysql-5.5.15
[2, 0%] Built target INFO_BIN
[Root @ localhost mysql-5.5.15] # make install
Mysql initialization and Installation
/Usr/local/mysql/scripts/mysql_install_db \
-- Defaults-file =/etc/my. cnf \
-- Basedir =/usr/local/mysql \
-- Datadir =/var/mysql/data \
-- User = mysql
Go to my. cnf and then vi my. cnf.
[Mysqld3]
Port = 3307
Socket =/tmp/mysql3307.sock
Skip-external-locking
Key_buffer_size = 256 M
Max_allowed_packet = 1 M
Table_open_cache = 256
Sort_buffer_size = 1 M
Read_buffer_size = 1 M
Read_rnd_buffer_size = 4 M
Myisam_sort_buffer_size = 64 M
Thread_cache_size = 8
Query_cache_size = 16 M
# Wait_timeout = 100
# Interactive_timeout = 100
Max_connections = 1400
User = root
Datadir =/var/mysql3307/data
Start mysql
[Root @ localhost etc] # mysqld_safe -- user = root -- port = 3307 -- socket =/tmp/mysql3307.sock -- datadir =/var/mysql3307/data &
[2] 7459
[Root @ localhost etc] # Starting mysqld daemon with databases from/var/mysql3307/data
Check whether the mysql service is started
[Root @ localhost, etc] # ps-ef | grep 3307
Root 7459 1624 0 00:00:00 pts/1/bin/sh/usr/bin/mysqld_safe -- user = root -- port = 3307 -- socket =/tmp/mysql3307.sock -- datadir =/var/ mysql3307/data
Root 7488 7459 0 00:00:00 pts/1/usr/libexec/mysqld -- basedir =/usr -- datadir =/var/mysql3307/data -- user = root -- pid-file =/var /mysql3307/data/localhost. localdomain. pid -- skip-external-locking -- port = 3307 -- socket =/tmp/mysql3307.sock
Root 7502 1624 0 00:00:00 pts/1 grep 3307
[Root @ localhost etc] #
Go to mysqlclient to change the password
[Root @ localhost etc] # mysql-uroot -- socket =/tmp/mysql3307.sock -- port = 3307-p
Enter password:
Mysql> use mysql;
Database changed
Mysql> update user set password = password ('yourpassword') where user = 'root ';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
Mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
Mysql> set character_set_results = utf8
->
->
->;
Query OK, 0 rows affected (0.00 sec)
Mysql> show variables like '% char % ';
+ -------------------------- + ---------------------------- +
| Variable_name | Value |
+ -------------------------- + ---------------------------- +
| Character_set_client | utf8 |
| Character_set_connection | utf8 |
| Character_set_database | utf8 |
| Character_set_filesystem | binary |
| Character_set_results | utf8 |
| Character_set_server | utf8 |
| Character_set_system | utf8 |
| Character_sets_dir |/usr/share/mysql/charsets/|
+ -------------------------- + ---------------------------- +
8 rows in set (0.00 sec)
Mysql>
Stop mysql 3307
[Root @ localhost etc] # mysqladmin-uroot -- socket =/tmp/mysql3307.sock -- port = 3307-p shutdown
Enter password:
[Root @ localhost etc] #
Start database 3307
[Root @ localhost etc] #/usr/local/mysql/bin/mysqld_multi -- defaults-file =/etc/my. cnf start 3
Install Tags-mysql and mysql
Original article address: Install Multiple MYSQL instances in linux. Thank you for sharing it with me.