mysql创建多个实例，其实就是把data文件，sock,port指向不同的文件和端口 mysql安装过程看 http://blog.csdn.net/tangpengtao/article/details/6650424 先创建3307的data目录 [root@localhost mysql-5.5.15]# mkdir -p/usr/local/mysql3307 [root@localhost
mysql创建多个实例，其实就是把data文件，sock,port指向不同的文件和端口
mysql安装过程看 http://blog.csdn.net/tangpengtao/article/details/6650424
先创建3307的data目录
[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
-- configuring 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
-- configuring done
-- generating done
-- build files have been written to: /home/raycloud/software/mysql-5.5.15
[  0%] built target info_bin
[root@localhost mysql-5.5.15]# make install
mysql 初始化安装
/usr/local/mysql/scripts/mysql_install_db \
--defaults-file=/etc/my.cnf \
--basedir=/usr/local/mysql \
--datadir=/var/mysql/data \
--user=mysql
进入到my.cnf然后vi my.cnf
[mysqld3]
port            = 3307  
socket          = /tmp/mysql3307.sock
skip-external-locking
key_buffer_size = 256m
max_allowed_packet = 1m
table_open_cache = 256
sort_buffer_size = 1m
read_buffer_size = 1m
read_rnd_buffer_size = 4m
myisam_sort_buffer_size = 64m
thread_cache_size = 8
query_cache_size= 16m
#wait_timeout=100
#interactive_timeout=100
max_connections=1400
user=root
datadir=/var/mysql3307/data
启动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
查看mysql服务是否启动
[root@localhost etc]# ps -ef |grep 3307
root      7459  1624  0 20:18 pts/1    00:00:00 /bin/sh /usr/bin/mysqld_safe --user=root --port=3307 --socket=/tmp/mysql3307.sock --datadir=/var/mysql3307/data
root      7488  7459  0 20:18 pts/1    00:00:00 /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 20:19 pts/1    00:00:00 grep 3307
[root@localhost etc]#
进入mysqlclient 修改密码
[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>
停止mysql 3307
[root@localhost etc]# mysqladmin -uroot --socket=/tmp/mysql3307.sock --port=3307 -p shutdown
enter password:
[root@localhost etc]#
启动3307数据库
[root@localhost etc]# /usr/local/mysql/bin/mysqld_multi  --defaults-file=/etc/my.cnf start  3
tags - mysql , mysql安装 原文地址：linux安装多个mysql实例, 感谢原作者分享。