mysql
null_3866
这个作者很懒,什么都没留下…
展开
-
MySQL server PID file could not be found!
启动mysqld报错:MySQL server PID file could not be found! 原因:有一些mysql进程没有被清理掉,执行:killall -9 mysql*原创 2014-05-12 16:42:13 · 97 阅读 · 0 评论 -
MySQL 1364 错误提示:#1364 - Field "details" doesn't have a default value
C++操作操作mysql,输出mysql错误码和错误描述:MYSQL mysql;sprintf("errno:%d, error: %s", mysql_errno(&mysql),mysql_error(&mysql)); 检查my.cnf里面是否有“STRICT_TRANS_TABLES”,如果有,就是它惹的祸了。 解决办法有两种: 第一种:数据库设...原创 2014-05-13 11:33:31 · 1218 阅读 · 0 评论 -
修改mysql数据库编码的python脚本
#-*- coding:utf8 -*-#统一数据库内容所有表项的编码import MySQLdbhost = "localhost"passwd = "xxxx"user = "xxx"dbname = "xxx"db = MySQLdb.connect(host=host, user=user, passwd=passwd, db=dbname)cu...原创 2014-02-18 09:34:37 · 123 阅读 · 0 评论 -
CentOS6.4上mysql的安装与配置
mysql的安装与启动,参考:http://www.cnblogs.com/xiaoluo501395377/archive/2013/04/07/3003278.html安装完后配置编码,参考:http://www.cnblogs.com/ccmao/archive/2011/12/16/2290489.html,在centos下应该修改/etc/my.conf文件,如下:[clie...原创 2014-03-04 22:32:40 · 98 阅读 · 0 评论 -
安装MySQLDb报错
_mysql.c:36:23: error: my_config.h: No such file or directory_mysql.c:38:19: error: mysql.h: No such file or directory_mysql.c:39:26: error: mysqld_error.h: No such file or directory_mysql.c:4...原创 2014-03-04 22:47:01 · 263 阅读 · 0 评论 -
django.db.utils.OperationalError: (1044, "Access denied for user 'xxx'@'localhos
django.db.utils.OperationalError: (1044, "Access denied for user 'xxx'@'localhost' to database 'xxx'") 解决方案,在Mysql里面写入本地访问权限:GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'localhost' IDENTIFIED BY 'm...原创 2014-03-04 23:16:29 · 3317 阅读 · 1 评论