一、開啟MySQL遠程連接
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'passWord' WITH GRANT OPTION;
修改mysql 的user 表後需要 flush privileges; 才能生效 二、遠程連接MySQL速度慢的解決方法
[MySQLd]
skip-name-resolve
skip-grant-tables 三、用MySQLadmin 修改新密碼
mysqladmin -u root passWord 'admin' 四、MySQL同步故障解決Slave_SQL_Running: No
解決辦法I：
1.首先停掉Slave服務：slave stop
show master status; | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | | mysql-bin.000020 | 1052 | | | MySQL> change master to
> master_log_pos=1052;
slave start;
解決辦法II：
MySQL> slave stop;
MySQL> set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
MySQL> slave start; 五、主從服務器配置
[MySQLd]
log-bin=MySQL-bin
server-id=1
binlog-do-db=test
binlog-ignore-db=mysql [MySQLd]
log-bin=MySQL-bin
server-id=2
master-host=192.168.1.5
master-port=3306
master-user=root
master-passWord=123456
master-connect-retry=60
replicate-do-db=test
replicate-ignore-db=MySQL 六、快速清空記錄多的表
truncate tableName 七、數據的導入與導出
MySQLdump -u用戶名 -p密碼 數據庫名>數據庫備份名
source 16643 < ~/data.sql 八、MySQL創建utf-8格式的數據庫
先MySQL進入：
GBK: create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
UTF8: CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
