Ok, here is what I have found after hours of ripping my hair out with this! As other posters have said, both tables must be INNODB. The foreign key field must have an index on it. The foeign key field and the field being referenced must be of the same type (I only use integer) ...
This line will make it so ONLY the localhost can connect to the database. A great security feature, but this prevents anyone trying to connect outside the server not to see a database running. I commented out the line, restarted mysqld, and worked like a charm. ...
Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party....
Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party....
Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party....
Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party....
Abhijit Mapgaonkar March 03, 2007 04:06AM Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Cristea Cristina June 11, 2008 03:32AM Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql...
Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party....
MySQL Workbench Documentation MySQL Reference Manual MySQL Workbench MySQL NDB Cluster MySQL Connectors Topic Guides About MySQL Contact Us How to Buy Partners Job Opportunities Site Map © 2022 Oracle Privacy / Do Not Sell My Info | Terms of Use | Trademark Policy | Cookie 喜好设置...
P.S. more info athttp://sv3.3dbuzz.com/vbforum/showthread.php?s=&threadid=98911 Thanks onlinehtmlbook Subject Written By Posted ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ...