mysql的编译安装(二)
usr/local/mysql
show variables like 'server_id';
查看server-id
mysql> show variables like 'server_id';
手动修改server-id
mysql> set global server_id=2; #此处的数值和my.cnf里设置的一样就行
mysql> slave start;
6）change master之后，查看slave的状态，发现slave_IO_running 为NO
需要注意的是，做完上述操作之后最后重启mysql进程
（初始化数据目录）
#bin/mysql_install_db --user=mysql --datadir=/usr/local/mysql/var21001/
#bin/mysql_install_db --user=mysql --datadir=/usr/local/mysql/var21002/
#bin/mysql_install_db --user=mysql --datadir=/usr/local/mysql/var21003/
#bin/mysql_install_db --user=mysql --datadir=/usr/local/mysql/var(默认)
#chown -R root .
#chown -R mysql var21001/ var21002/ var21003/
#chgrp -R mysql .
#bin/mysqld_safe --user=mysql &
www.2cto.com
（到此安装完成）
#bin/mysqladmin -uroot -poldpwd password 1qaz@WSX
grant shutdown on *.* to admin@localhost identified by 'pwd_shutdown';
FLUSH PRIVILEGES;
linux 客户端执行SQL命令：source /home/software/user_login.sql
grant all privileges on *.* to 'root'@'%' identified by '123456';
FLUSH PRIVILEGES;
GRANT SHUTDOWN ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'pwd_shutdown';
FLUSH PRIVILEGES;
drop user ''@'localhost.localdomain';
drop user ''@'localhost';
drop user root@localhost.localdomain;
GRANT SHUTDOWN ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'pwd_shutdown';
www.2cto.com
set password for root@'localhost' =password('1qaz@WSX');
set password for root@'127.0.0.1' =password('1qaz@WSX');
flush privileges;
//set password for root@'localhost' =password('XXX');
//set password for root@'127.0.0.1' =password('XXX');
主从权限增加
GRANT REPLICATION SLAVE ON *.* TO 'repsync'@'%' IDENTIFIED BY '*********';
===================================多实例安装=======================================