linux 下安装两个mysql

来源：百度知道 编辑：UC知道 时间：2024/05/31 19:52:07
如何在linux安装两个mysql，越详细越好。
没看明白楼下的说明.最好具体点.我是菜鸟! 最好是北京的.有电话联系最好.能解决问题者.高分送上.

和一般安装一样，只要不在同一个目录，使用不同的端口就行了。mysql安装默认的端口是3306，你在配置时修改成其他端口就ok了

同一个mysql启动两个进程。

编辑 my.cnf（linux) my.ini（window）

vi /etc/my.cnf

[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

# Here follows entries for some specific programs

[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
user= root
password = gthsskd0345
# The MySQL server
[mysqld1]

port = 3306
socket = /tmp/mysql.sock
datadir = /usr/local/mysql/data/
skip-locking
key_buffer = 600M
max_allowed_packet = 16M
table_cache = 1024
sort_buffer_size = 1M
read_buffer_size = 512k
read_rnd_buffer_size = 512k

join_buffer_size = 8M

myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 128M
max_connections = 300
back_log