Recently a little bit of the Python mysqldb found Python could not connect to MySQL localhost and PHP and the command line is not a problem; asked the next group of friends they let me use 127.0.0.1 as host I tested it was successful but I still can't understand Why PHP and command line can but Python but not. And my previous Python connection to localhost was also successful.
It occurred to me that the former C:\Windows\System32\drivers\etc's localhost was pointing to 127.0.0.1, perhaps the problem
#127.0.0.1 localhost#::1 localhost
But I'll add this.
127.0.0.1 localhost#::1 localhost
It doesn't seem to work. Although the use of 127.0.0.1 can solve the problem but it is unclear why, is the my.ini of the setup problem or Python problem: solve.
This article is from the "Jiawu notes" blog, so be sure to keep this source http://jiawu.blog.51cto.com/9349234/1549416
PHP can connect to MySQL python cannot connect to localhost database