问题描述
当我尝试通过SQLAlchemy使用MySQLPython时出现错误
When I try to use MySQLPython (via SQLAlchemy) I get the error
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/MySQL_python-1.2.3c1-py2.6-macosx-10.6-x86_64.egg/MySQLdb/connections.py", line 188, in __init__
super(Connection, self).__init__(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (OperationalError) (2002, "Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)") None None
但是我的机器上没有其他mysql客户端能正常运行！
but no other mysql client on my machine sees it fine!
我的my.cnf文件指出:
My my.cnf file states:
[client]
port = 3306
socket = /tmp/mysql/mysql.sock
[safe_mysqld]
socket = /tmp/mysql/mysql.sock
[mysqld_safe]
socket = /tmp/mysql/mysql.sock
[mysqld]
socket = /tmp/mysql/mysql.sock
port = 3306
并且mysql.sock文件确实位于/tmp/mysql
and the mysql.sock file is, indeed, located in /tmp/mysql
我确认〜/.my.cnf和/var/lib/mysql/my.cnf没有覆盖它. mysql5客户端程序等在连接时没有问题，并且使用jdbc/mysql连接在同一台机器上进行groovy/grails安装也没有问题
I verified that ~/.my.cnf and /var/lib/mysql/my.cnf aren't overriding it. The mysql5 client program, etc, has no trouble connecting and neither does a groovy/grails installation on the same machine using jdbc/mysql connection
thrilllap-2:~ swirsky$ mysql5
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.47 Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)
mysql>
为什么MySQLdb for python无法解决这个问题?如果没有my.cnf文件，该怎么看?
Why can't MySQLdb for python figure this out? Where would it look if not the my.cnf files?
推荐答案
您是否尝试过将选项read_default_file='~/.my.cnf'添加到您的connect()调用中，以告知Python数据库驱动程序读取您的配置文件?我认为默认情况下它将忽略该文件.
Have you tried adding the option read_default_file='~/.my.cnf' to your connect() call, to tell the Python database driver to read your configuration file? I think that otherwise it ignores the file by default.
这篇关于MySQLPython忽略了my.cnf文件.它从哪里获得信息?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！