linux下mysql环境搭建,linux环境下搭建mysql多个版本

墨色风雨

实例1，用版本1, 如 4.3

# 配置 /data/mysql_data/mysql1_3306/my.cnf

# 启动 /data/bins/mysql1/bin/mysqld_safe --defaults-file=/data/mysql_data/mysql1_3306/my.cnf &

[mysqld_safe]

nice = 0

pid-file = /data/mysql_data/mysql1_3306/mysqld.pid

[mysqld]

bind-address = 127.0.0.1

user = mysql

basedir = /data/bins/mysql1

datadir = /data/mysql_data/mysql1_3306

socket = /data/mysql_data/mysql1_3306/mysql.sock

port = 3306

实例2，用版本2，如 5.7

# 配置 /data/mysql_data/mysql2_3307/my.cnf

# 启动 /data/bins/mysql2/bin/mysqld_safe --defaults-file=/data/mysql_data/mysql2_3307/my.cnf &

[mysqld_safe]

nice = 0

pid-file = /data/mysql_data/mysql2_3307/mysqld.pid

[mysqld]

bind-address = 127.0.0.1

user = mysql

basedir = /data/bins/mysql2

datadir = /data/mysql_data/mysql2_3307

socket = /data/mysql_data/mysql2_3307/mysql.sock

port = 3307

basedir，mysql 安装目录。datadir, mysql 数据库实例存放目录。