PyMySQL can’t connect to MySQL on localhost

by

Two guesses:

  1. Run mysqladmin variables | grep socket to get where the socket is located, and try setting up a connection like so:

    pymysql.connect(db='base', user="root", passwd='pwd', unix_socket="/tmp/mysql.sock")

  2. Run mysqladmin variables | grep port and verify that the port is 3306. If not, you can set the port manually like so:

    pymysql.connect(db='base', user="root", passwd='pwd', host="localhost", port=XXXX)

More Related Contents:

  1. How to insert a space delimited text file into mysql using Python? [closed]
  2. How do I connect to a MySQL Database in Python?
  3. imploding a list for use in a python MySQLDB IN clause
  4. Why do integers in database row tuple have an ‘L’ suffix?
  5. Database does not update automatically with MySQL and Python
  6. Python: best practice and securest way to connect to MySQL and execute queries
  7. Not all parameters were used in the SQL statement (Python, MySQL)
  8. Mac OS X – EnvironmentError: mysql_config not found
  9. mysql-python install error: Cannot open include file ‘config-win.h’
  10. Integrating MySQL with Python in Windows
  11. Install mysql-python (Windows)
  12. Python MySQL connector – unread result found when using fetchone
  13. Installing MySQL Python on Mac OS X
  14. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  15. SQLAlchemy ON DUPLICATE KEY UPDATE
  16. Python 3.4.0 with MySQL database
  17. How can I use executemany to insert into MySQL a list of dictionaries in Python
  18. Installing MySQL-python
  19. Executing “SELECT … WHERE … IN …” using MySQLdb
  20. Insert list into my database using Python [duplicate]
  21. Print the actual query MySQLdb runs?
  22. MySQL Improperly Configured Reason: unsafe use of relative path
  23. Python Pandas to_sql, how to create a table with a primary key?
  24. Speeding (Bulk) Insert into MySQL with Python
  25. How can I insert NULL data into MySQL database with Python?
  26. How to use python mysqldb to insert many rows at once
  27. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  28. Warning raised by inserting 4-byte unicode to mysql
  29. pip install mysqlclient : Microsoft Visual C++ 14.0 is required
  30. Installing mysql-python on Centos

Leave a Comment