mac 本机安装双mysql实例

查找/创建my.cnf文件

mysql --verbose --help|grep -A 1 'Default options'

创建 my-master.cnf 和 my-slave.cnf 文件

直接使用vim创建编辑 sudo vi /etc/my-master.cnf

>>>编辑
[client]
port = 3307
socket = /usr/local/mysql-master/tmp/mysql.sock

[mysqld]
user = root
port = 3307
socket = /usr/local/mysql-master/tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /usr/local/mysql-master/data

[mysqld_safe]
log-error = /usr/local/mysql-master/data/mysqld.local.err
pid-file = /usr/local/mysql-master/data/mysqld.local.pid

以上配置文件需要两个文件夹，使用命令行创建

sudo mkdir -p /usr/local/mysql-master/{data,tmp}
sudo chown -R mysql:mysql /usr/local/mysql-master

找到mysql 的安装目录 (一般在/usr/local/mysql)复制mysql整个文件到新文件夹mysql-master

sudo cp -pr /usr/local/mysql /usr/local/mysql-master

初始化 (记录下mysql的初始密码)

sudo mysqld --defaults-file=/etc/my-master.cnf --initialize

	..略..
返回默认密码:wna*LOC7A6YC
[Server] A temporary password is generated for root@localhost: wna*LOC7A6YC

启动数据库

sudo mysqld_safe --defaults-file=/etc/my-master.cnf &

关闭数据库

mysqladmin -uroot -p -S /usr/local/mysql-master/tmp/mysql.sock shutdown

登录进入

mysql -uroot -p123456 -h127.0.0.1 -P3308

重置密码

mysql>  ALTER USER USER() IDENTIFIED BY '123456';

查询端口号

mysql> show global variables like 'port';