debian安装mysql一机双实例

1、下载、安装master实例
mysql 5.7.21 debian8.6 x64 安装.note

2、安装salver实例
cp -rp /usr/local/mysql /usr/local/mysql-salver
cp -rp /etc/my.cnf /etc/my-savler.cnf

删除salver下的master数据
rm -rf /usr/local/mysql-salver/data/
rm -rf /usr/local/mysql-salver/redolog/
rm -rf /usr/local/mysql-salver/undolog/
rm -rf /usr/local/mysql-salver/log/

3、配置my-savler.cnf
[client]
port=3307
socket=/usr/local/mysql-salver/tmp/mysql.sock
[mysqld]
basedir=/usr/local/mysql-salver
datadir=/usr/local/mysql-salver/data/mysql
socket=/usr/local/mysql-salver/tmp/mysql.sock
pid-file=/usr/local/mysql-salver/mysqld.pid

数据库错误日志文件

log_error=/usr/local/mysql-salver/logs/error.log
pid-file=/usr/local/mysql-salver/mysqld.pid

设置redoLog文件所在目录, redoLog记录事务具体操作内容

innodb_log_group_home_dir=/usr/local/mysql-salver/redolog

设置undoLog文件所在目录, undoLog用于事务回滚操作

innodb_undo_directory=/usr/local/mysql-salver/undolog

4、参数配置
bin/mysqld —defaults-file=/etc/my-salver.cnf —initialize —user=mysql —basedir=/usr/local/mysql-salver —datadir=/usr/local/mysql-salver/data/mysql
注意 这一步 会生成 临时密码 例如：root@localhost: stdFPy(rD1FZ
bin/mysql_ssl_rsa_setup —defaults-file=/etc/my-salver.cnf —datadir=/usr/local/mysql-salver/data/mysql
注意 这两步操作 —defaults-file= 要放在最前面

5、启动服务
bin/mysqld_safe —defaults-file=/etc/my-salver.cnf —user=mysql &
注意：在启动服务的时候最好看下日志文件，看一下启动情况、以及可能出现的异常

连接数据库

bin/mysql -uroot -p
输入前面生成的 临时密码

设置root密码

set password=password(‘A123456’);
grant all privileges on . to ‘root’@’%’ identified by ‘A123456’;
flush privileges;