测试，且增新端口3307

一、创建新的库目录、初始化数据库、赋权

mkdir /usr/local/mysql/var_3307

/usr/local/mysql/bin/mysql_install_db --datadir=/usr/local/mysql/var_3307

chown -R mysql:mysql /usr/local/mysql/var_3307

二、创建新的配置文件

vi /etc/my_3307.cnf

加入以下内容：

[client]

port = 3307

socket = /tmp/mysql_3307.sock

[mysqld]

port = 3307

socket = /tmp/mysql_3307.sock

datadir = /usr/local/mysql/var_3307

innodb_data_home_dir = /usr/local/mysql/var_3307

innodb_log_group_home_dir = /usr/local/mysql/var_3307

skip-locking

key_buffer = 384M

max_allowed_packet = 1M

table_cache = 512

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size = 8M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size = 32M

thread_concurrency = 8

log-bin=mysql-bin

server-id = 1

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[isamchk]

key_buffer = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M

[myisamchk]

key_buffer = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

红色标出的部分，都是必要改动和添加的内容，其他可根据需求修改

三、启停mysql服务，开启3307端口

启动

/usr/local/mysql/bin/mysqld_safe --defaults-extra-file=/etc/my_3307.cnf &

停止

/usr/local/mysql/bin/mysqladmin -uroot -S /tmp/mysql_3307.sock shutdown

四、测试

登陆mysql

/usr/local/mysql/bin/mysql -S /tmp/mysql_3307.sock -P 3307

创建一个新数据库

create database 数据库名;

退出之后，返回/usr/local/mysql/var_3307 目录，有新的[数据库名]目录，表示以上配置启用执行正常.

注意：

如果启用mysql服务失败，发生如下报错：

tail -f /usr/local/mysql/var_3307/localhost.localdomain.err

十有八九是权限问题

cd /usr/local/mysql/var_3307

chown -R mysql:mysql *