1 MySQL安裝配置
1.1.1 Linux MySQL源碼安裝缺少ncurses-devel包
1.1.2 Linux平台卸載MySQL總結
1.1.3 Linux 卸載mysql-libs包出現錯誤
2 MySQL管理配置
2.1.1 MySQL修改root賬號密碼
2.1.2 MySQL查看數據庫相關信息
2.1.3 查看mysql數據庫版本方法總結
2.1.4 Linux mysql 5.6： ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
2.1.5 MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)的真正原因
2.1.6 Linux平台更改MySQL數據庫數據存儲目錄
3 MySQL備份恢復
3.1 mysqldump
3.1.1 MySQL備份還原——mysqldump工具介紹
3.1.2 mysqldump: Error: Binlogging on server not active
3.1.3 mysqldump：Couldn't execute 'show create table `tablename`': Table tablename' doesn't exist (1146)
3.2 AtuoMySQLBackup
3.2.1 MySQL備份還原——AutoMySQLBackup介紹
3.2.2 Automysqlbackup: WARNING: Turning off multicore support, since pigz isn’t there.
3.2.3 AutoMySQLBackup 3.0 Bug:"du: WARNING: use --si, not -H"
3.2.4 mysqldump: Got error: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts' when using LOCK TABLES
4 MySQL錯誤總結
4.1.1 mysql: unknown variable 'character-set-client=utf8'
4.1.2 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
