mysql5.7多实例安装_linux上mysql5.7多实例安装详细步骤

#linux上mysql5.7多实例安装详细步骤

一步一步的教你如何在一台服务器上安装多个mysql实例

步骤

1、解压上传的mysql安装包：

tar -zxvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz

2、将解压好的mysql移动到/usr/local/mysql

cp mysql-5.7.25-linux-glibc2.12-x86_64 /usr/local/mysql

3、在/home/mysql/下创建数据文件

mkdir data330{6…8}

4、编辑my.cnf文件 存放/etc/

[client]

port=3306

socket=/tmp/mysql.sock

[mysqld_multi]

mysqld = /usr/local/mysql/bin/mysqld_safe

mysqladmin = /usr/local/mysql/bin/mysqladmin

log = /home/mysql/mysqld_multi.log

[mysqld]

user=mysql

basedir = /usr/local/mysql

sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

[mysqld3306]

mysqld=mysqld

mysqladmin=mysqladmin

datadir=/home/mysql/data3306/data

port=3306

server_id=3306

socket=/tmp/data3306.sock

log-output=file

slow_query_log = 1

long_query_time = 1

slow_query_log_file = /home/mysql/mysql3306/log/slow.log

log-error = /home/mysql/mysql3306/log/error.log

binlog_format = mixed

log-bin = /home/mysql/mysql3306/log/mysql3306_bin

[mysqld3308]

mysqld=mysqld

mysqladmin=mysqladmin

datadir=/home/mysql/data3308/data

port=3308

server_id=3308

socket=/tmp/data3308.sock

log-output=file

slow_query_log = 1

long_query_time = 1

slow_query_log_file = /home/mysql/mysql3308/log/slow.log

log-error = /home/mysql/mysql3308/log/error.log

binlog_format = mixed

log-bin = /home/mysql/mysql3308/log/mysql3308_bin

单独实例初始化使用文件，要与my.cnf文件配置一致 存放//home/mysql/data3306/

[client]

port= 3306

socket= /home/mysql/data3306/mysql.sock

default-character-set=utf8

[mysqld]

user=mysql

port=3306

basedir=/usr/local/mysql

datadir=/home/mysql/data3306/data

server_id=3306

socket=/home/mysql/data3306/mysql.sock

log-output=file

slow_query_log=1

long_query_time=1

slow_query_log_file=/home/mysql/data3306/log/slow.log

symbolic-links=0

log-error=/home/mysql/data3306/log/error.log

log-bin=/home/mysql/data3306/log/bin.log

pid-file=/home/mysql/data3306/mysql3306.pid

binlog_format=mixed

lower-case-table_names=1

log-bin-trust-function-creators=1

sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

character-set-server=utf8

max_connections=1000

max_allowed_packet = 1024M

5、在对应的data3306创建日志文件夹及文件

6、开始赋权限；chown mysql:mysql -R /home/mysql/

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

7、初始化数据库：

/usr/local/mysql/bin/mysqld --defaults-file=/home/mysql/data3306/3306.cnf --initialize --basedir=/usr/local/mysql/ --datadir=/home/mysql/data3306/data

这里会生成默认密码,可以去error.log中看，

./mysqld_safe --defaults-file=/home/mysql/data3306/3306.cnf &

这里生成mysql.sock文件

/usr/local/mysql/bin/mysqld --defaults-file=/home/mysql/data3306/3308.cnf --initialize --basedir=/usr/local/mysql/ --datadir=/home/mysql/data3308/data

./mysqld_safe --defaults-file=/home/mysql/data3306/3306.cnf &

8、以上基本完成mysql的初始化，马上就可以连接了

mysql -uroot -p -S /home/mysql/data3308/mysql.sock

输入刚刚生成的初始化密码

( mysql -uroot -p -S /home/mysql/data3306/mysql.sock 同样)

9、然后连接上mysql你就可以修改密码了，

set password=‘123456’; 现在root的密码就是123456了

10、远程连接，你可以赋予一个用户远程权限

grant all privileges on . to ‘test’@’%’ identified by ‘test’ with grant option;

flush privileges;

可以用远程工具(navicat等)

输入远程地址、端口、用户名密码连接测试就可以了。

注意：如果生成不了mysql.sock文件时，一定要注意第6步文件权限可以使用命令：ll

查看。再查看用户状态是否ok。

相关问题:解决方案：https://help.aliyun.com/knowledge_detail/41106.html?spm=a2c6h.13066369.0.0.301f105bl8OVfn