摘要：mysql>grant all privileges on *.* to root@"%" identified by "123456";mysql>flush privileges; 阅读全文

摘要：mysql> mysqldump [options] db_name [tables] 备份某个数据库或具体到某个数据表mysql> mysqldump [options] --databases db1 [db2 db3 ..] 备份多个数据库mysql> mysqldump [options] --all-databases 备份所有的数据库备份存储过程和函数：>mysqldump -uroot -h127.0.0.1 -uroot -p123456 -ntd -R db_name> ./db_name_procedure_function.sql备份数据：& 阅读全文

摘要：What you should try to do is locate and edit the my.cnf file your server is currently using. In the[mysqld]section alter the max_allowed_packet settings to something like[mysqld]max_allowed_packet=32MDon't forget to restart the server after altering the configuration. 阅读全文