For 2023 (and 2024 ...) - we are now fully retired from IT training. We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.
Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!
I am also active in many other area and still look after a lot of web sites - you can find an index ((here)) |
Cant connect to local MySQL server through socket /tmp/mysql.sock
Q Have you ever had the error message Can't connect to local MySQL server through socket '/tmp/mysql.sock' from your PHP program. It's one that I see quite often, but it doesn't seem all that well documented ... so what's the cause, and the cure?
A The error message seems to occur if you delete your MySQL installation and re-install - something we do very frequently during our training. You need to remember to delete the /etc/my.cnf ~/my.cnf and data and spool directories before you re-install if you want a clean start.
If you have the error message above and want a temporary fix, try connecting to "127.0.0.1" and you'll probably find it will work ;-) (written 2009-10-17, updated 2009-10-18)
Associated topics are indexed as below, or enter http://melksh.am/nnnn for individual articles S153 - Sourcing, Running and Configuring MySQL [192] Current MySQL and PHP paths and upgrades - (2005-01-28) [334] Symbolic links and hard links - (2005-06-02) [489] Which MySQL server am I using? - (2005-11-07) [515] MySQL - an FAQ - (2005-12-03) [535] MySQL permissions and privileges - (2005-12-20) [591] Key facts - SQL and MySQL - (2006-02-04) [907] Browser -> httpd -> Tomcat -> MySQL. Restarting. - (2006-10-28) [1095] Apache httpd , browser, MySQL and MySQL client downloads - (2007-02-28) [1123] mysqldump and mysqlrestore - (2007-03-30) [1131] MySQL - Password security (authentication protocol) - (2007-04-02) [1689] Some sideways thoughts on the news - (2008-06-27) [1731] Apache httpd, MySQL, PHP - installation procedure - (2008-08-01) [1771] More HowTo diagrams - MySQL, Tomcat and Java - (2008-08-24) [1935] Summary of MySQL installation on a Linux system - (2008-12-11) [2085] MySQL - licensing issues, even with using the name - (2009-03-16) [2209] Monitoring and Tuning your MySQL installation - (2009-05-31) [2426] Which version of MySQL am I running? - (2009-09-26) [2444] Potted MySQL installation - (2009-10-09) [2445] Securing MySQL on a production server - (2009-10-09) [4390] Checking MySQL database backups have worked (not failed) - (2015-01-10) [4406] Fixing damaged MySQL tables - Error 1712 and Error 2013 - (2015-01-25) [4487] Starting MySQL. ERROR! The server quit without updating PID file - how we fixed it. - (2015-05-06)
Some other Articles
Python - how it saves on compile timeLuac - getting lua to start fast by precompilingMothers Day or Mothering Sunday?New Web Site for Melksham Chamber of CommerceCant connect to local MySQL server through socket /tmp/mysql.sockRailway ArithmeticBright EyesLua examples - coroutines, error handling, objects, etcFor loops in LuaDark to dark
|
4759 posts, page by page
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96 at 50 posts per page
This is a page archived from The Horse's Mouth at
http://www.wellho.net/horse/ -
the diary and writings of Graham Ellis.
Every attempt was made to provide current information at the time the
page was written, but things do move forward in our business - new software
releases, price changes, new techniques. Please check back via
our main site for current courses,
prices, versions, etc - any mention of a price in "The Horse's Mouth"
cannot be taken as an offer to supply at that price.
Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).
|
|