mysql命令

mysql rpm 安装
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h chupiao2 password 'new-password'

/usr/share/mysql 
cp my-medium.cnf /etc/my.cnf

show plugins;
 show variables where variable_name like '%char%'
root远程登录
update user set host = '%' where user = 'root'

FLUSH   PRIVILEGES;

 主从复制： my.cnf
 主：192.168.0.91
 log-bin=mysql-bin 启动二进制文件
 server-id=1 服务器ID
登录mysql，在mysql中添加一个backup的账号，并授权给从服务器
grant replication slave on *.* to 'backup'@'192.168.0.131' identified by 'backup'; 创建backup

GRANT REPLICATION SLAVE ON *.* TO repl@10.20.147.111 IDENTIFIED BY '111111';

show master status；
 mysql-bin.000001 |     1215

  mysql-bin.000004 |      107 
从：192.168.0.131

log-bin=mysql-bin 启动二进制文件

server-id=10 服务器ID
重启

  change master to master_host='192.168.0.91',master_user='backup',master_password='backup',master_log_file='mysql-bin.000002',master_log_pos=107;
  4)、启动slave同步。

mysql> start slave;
5)、检查主从同步，如果您看到Slave_IO_Running和Slave_SQL_Running均为Yes，则主从复制连接正常。
mysql> show slave status\G

测试：
mysql> create database mysqltest;

mysql> use mysqltest;

mysql> create table user(id int(5),name char(10));

mysql> insert into user values (00001,'zhangsan');
可以参考
http://2526575.blog.51cto.com/2516575/689199