#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    3
    Rep Power
    0
    Alright, so I'm sitting here trying to get apache/php4/mysql all running and have been having some problems. Up until this morning, the php code connected to the mysql database with a problem, but I had some other weird issues with php, so I ran make clean and make/make install on php. Now that all works properly again, except I get the typical

    "MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) " error message..

    There isn't any .sock file in /tmp, and restarting the mysql server doesn't put one there. Anyone have any clue what's wrong?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    73
    Rep Power
    15
    Have you tried this ???
    -------------------------------------
    /etc/inet.d/mysql start

    or else

    the path to mysqld/mysqld &

    eg.
    /usr/local/bin/mysqld &
    ----------------------------------------

    also are you using Red Hat Linux if so what verson??

  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    3
    Rep Power
    0
    mysqld started on Thu Nov 2 21:48:24 PST 2000
    /usr/sbin/mysqld: ready for connections


    ^^ I forgot to mention that mysqld is in fact running, and apparently without any error messages. This is straight out of the mail.err file. And, for the first few times there wasnt a .sock file in the /tmp directory, but on last start up, there is one now... and I STILL cant get access to the damned thing...
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    3
    Rep Power
    0
    Solved the problem. my.cnf file wasn't set up anywhere, and the mysql server was looking for the socket file other than in the /tmp directory, so I just created the my.cnf in /etc and told the server to make sure the socket file exists in /tmp and nowhere else.

    Now its time to hunt through the rest of this forum and find the answer to "document contains no data" with Netscape when trying to go to another php file in a subdirectory below...

    (it appears that the php file isn't being properly seen at two levels deep...)

    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by des:
    Have you tried this ???[/quote]

Similar Threads

  1. Custom error message for MySQL connection
    By dbr1066 in forum PHP Development
    Replies: 6
    Last Post: February 12th, 2004, 11:25 AM
  2. java / mysql connection
    By johann8401 in forum Java Help
    Replies: 2
    Last Post: February 9th, 2004, 12:27 PM
  3. ASPX and MySQL Connection err on XP Pro
    By bombaywala in forum ASP Programming
    Replies: 0
    Last Post: February 7th, 2004, 08:41 AM
  4. mysql server looses connection
    By Webbgroup in forum MySQL Help
    Replies: 1
    Last Post: January 29th, 2004, 11:19 AM

IMN logo majestic logo threadwatch logo seochat tools logo