开发常用一些命令参数1

sbin/iptables -I INPUT -p tcp --dport 8000 -j ACCEPT #开启8011端口
/etc/rc.d/init.d/iptables save #保存配置
/etc/rc.d/init.d/iptables restart #重启服务


远程debug    Linux
catalina.sh 第一行加
declare -x CATALINA_OPTS="-Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=8000" 

eclipse   --debug--自己看

stop slave;
show master status;（主机执行  查询状态）
change master to master_host='192.168.30.17',master_user='mysync',master_password='12345', master_log_file='mysql-bin.000005',master_log_pos=438414;
change master to master_host='192.168.30.20',master_user='bakc',master_password='123456', master_log_file='mysql-bin.000002',master_log_pos=8442;
start slave;
show slave status\G

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345' WITH GRANT OPTION


nohup launcher> launcher.log 2>&1 & 　

scp -P 22 -r root@192.168.30.17:/root/mysql/ /root/mysql

CREATE USER 'mysync'@'host' IDENTIFIED BY '12345';
grant all privileges on *.* to mysync@"%" identified by "12345";


修改mysqlroot密码
1、修改/ect/my.cnf
加上如下
skip-grant-tables
2、从起服务器
执行mysql
mysql> use mysql
mysql> UPDATE user SET Password = password ( 'rrz20160420' ) WHERE User = 'root' ;
mysql> flush privileges ;
3、重启服务器 登录
4、赋全程权限
  mysql> SET PASSWORD = PASSWORD('rrz20160420'); 
  mysql>  grant all on *.* to root@'%' identified by '12345';
 
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY  '12345' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO root@127.0.0.1 IDENTIFIED BY '12345' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '12345' WITH GRANT OPTION;

ffmpeg
scp -P 22 -r root@192.168.30.15:/root/mysql /app/mysql

mysql增量备份------------------------------------
cd /data/home/mysqlbak
rq=` date +%Y%m%d% `
/usr/local/mysql/bin/mysqldump sqldb --flush-logs -uroot -p'123456' -h'10.241.92.172' --opt > 777city_$rq.sql

注 sqldb   数据库名称
-------------------------end


binlog-do-db=rrz #需要记录进制日志的数据库.如果有多个数据库可用逗号分隔,或者使用多个binlog-do-db选项
binlog-ignore-db=mysql #不需要记录进制日志的数据库.如果有多个数据库可用逗号分隔,或者使用多个binlog-do-db选项
replicate-do-rrz #需要进行同步的数据库.如果有多个数据库可用逗号分隔,或者使用多个replicate-do-db选项
replicate-ignore-db=mysql,information_schema #不需要同步的数据库.如果有多个数据库可用逗号分隔,或者使用多个replicate-ignore-db选项
#同步参数:
#保证slave挂在任何一台master上都会接收到另一个master的写入信息
log-slave-updates
slave-skip-errors=all #过滤掉一些没啥大问题的错误