mysql
zhangchengtest
这个作者很懒,什么都没留下…
展开
-
mysql常用sql语句
查看建表语句show create table XXXX;原创 2015-04-15 21:44:15 · 85 阅读 · 0 评论 -
mysql的安装
yum list mysql*发现没有最新的(那么先删除已经安装的yum remove mysql mysql-* )wget http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpmyum localinstall -y mysql-community-release-el6-5.noarc...原创 2015-04-23 09:57:50 · 83 阅读 · 0 评论 -
mysql 字符集
show variables like '%char%'; vi /etc/my.cnf这个地方是gbk 你的终端都是gbk的 不然中文显示不了[client]default-character-set=gbk[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql...原创 2015-04-23 11:30:19 · 81 阅读 · 0 评论 -
mysql配置主从
to begin原创 2015-04-30 13:45:44 · 76 阅读 · 0 评论 -
事务的理解
Isolation.REPEATABLE_READmysql默认级别, 仅次于Isolation.SERIALIZABLEIsolation.SERIALIZABLE: 别人无法update 否则: Deadlock found when trying to get lock; try restarting transaction...原创 2015-06-02 16:02:13 · 89 阅读 · 0 评论 -
java连接mysql 连接数太多
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connectionsshow full processlist:查看有多少个线程实例service mysqld stopservice mysqld startshow global variables lik...原创 2015-08-03 12:00:26 · 1523 阅读 · 0 评论 -
mysql 创建新用户 赋予权限
GRANT ALL PRIVILEGES ON haze_test.* TO 'haze_test_user'@'localhost' IDENTIFIED BY 'abcd@5678' WITH GRANT OPTION; flush privileges;原创 2015-09-02 10:28:50 · 127 阅读 · 0 评论