你的位置:首页 > 数据库

[数据库]MySQL 博客文章目录(2015


 

MySQL安装配置

Linux MySQL源码安装缺少ncurses-devel包

Linux平台卸载MySQL总结

Linux 卸载mysql-libs包出现错误

MySQL管理配置

MySQL修改root账号密码

MySQL查看数据库相关信息

查看mysql数据库版本方法总结

Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)的真正原因

Linux平台更改MySQL数据库数据存储目录

 

MySQL备份恢复

 

MySqldump

 

MySQL备份还原——mysqldump工具介绍

mysqldump: Error: Binlogging on server not active

 

AtuoMySQLBackup

 

MySQL备份还原——AutoMySQLBackup介绍

Automysqlbackup: WARNING: Turning off multicore support, since pigz isn’t there.

AutoMySQLBackup 3.0 Bug:"du: WARNING: use --si, not -H"

mysqldump: Got error: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts' when using LOCK TABLES

 

MySQL错误总结

 

mysql: unknown variable 'character-set-client=utf8'

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)