查看建表语句 show create table XXXX;

yum list mysql* 发现没有最新的 （那么先删除已经安装的 yum remove mysql mysql-* ） wget http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm yum localinstall -y mysql-community-release-el6-5.noarc...

show variables like '%char%'; vi /etc/my.cnf 这个地方是gbk 你的终端都是gbk的 不然中文显示不了 [client] default-character-set=gbk [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql ...

to begin

Isolation.REPEATABLE_READ mysql默认级别， 仅次于Isolation.SERIALIZABLE Isolation.SERIALIZABLE: 别人无法update 否则: Deadlock found when trying to get lock; try restarting transaction ...

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections show full processlist:查看有多少个线程实例 service mysqld stop service mysqld start show global variables lik...

GRANT ALL PRIVILEGES ON haze_test.* TO 'haze_test_user'@'localhost' IDENTIFIED BY 'abcd@5678' WITH GRANT OPTION; flush privileges;