测试，且增新端口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 *
评论