第十一集 MySQL grant用戶授權 * * * * * ~~~ 一.Mysql用戶授權 創建用戶: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass' create user 'test'@'localhost' identified by '123'; 給從服務器設置授權用戶 1.grant all on *.* to user@192.168.10.2 identified by "pass"; 2.grant replication slave on *.* to user@192.168.10.2 identified by "pass"; 查看用戶授權表 select user,host,password from mysql.user; 二.Mysql bin-log日志 開啟Mysql bin-log日志 vi /etc/my.cnf [mysqld] port=3306 socket=/var/lib/mysql/mysql.sock log-slow-queries=mysql-slow.log //設置一個時間,超過這個時間的查詢就保存到這日志里.方便調優 log-error=mysql.err log=mysql.log log-bin=mysql-bin 查看bin-log日志 show variables like "%log%"; Mysql中查看ls /var/lib/mysql system ls log-bin保存在/var/lib/mysql下 與bin-log有關的日志刷新 flush logs; 此時就會多一個最新的bin-log日志 show master status 查看最后一個bin日志 reset master; 清空所有的bin-log日志 mysqlbinlog --no-defaults mysql-00001.bin 用mysqlbinlog mysql-00001.bin時報錯,說是字符集有問題 mysqlbinlog mysql-bin.000002 |mysql -uroot -p t1 三.Mysql主從復制 四.Mysql分區技術 ~~~