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

    Join Date
    May 2000
    Posts
    1
    Rep Power
    0
    I lease web space from a company that does not support Mysql, but allows me to install it in my web space. When I execute a perl script which calls Mysql, it calls the default Mysql server, not mine. How do I work around this? I'm using DBI to make the call - do I need to install that module pointing to my Mysql server?

    Also, after my install the other night, I was able to login to the mysql prompt and create my tables, but today I can't, I get theis error:

    ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
    (111)

    Thanks in advance for any advice!!
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    1
    Rep Power
    0
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by Zeit:
    I lease web space from a company that does not support Mysql, but allows me to install it in my web space. When I execute a perl script which calls Mysql, it calls the default Mysql server, not mine. How do I work around this? I'm using DBI to make the call - do I need to install that module pointing to my Mysql server?

    Also, after my install the other night, I was able to login to the mysql prompt and create my tables, but today I can't, I get theis error:

    ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
    (111)

    Thanks in advance for any advice!!
    [/quote]

    well you schould call mysql using an option like --socket=/dir/where/your/socket/is
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    27
    Rep Power
    0
    try to change the port your MySQL server runs on....

    eg not 3306 but another port
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    13
    Rep Power
    0
    hi everybody...

    i also tried running multiple servers...all was ok but when i tried to run the server it saying mysqld already running how to solve this..........

    socket,tcp port and data dir all are specified and distinct from another mysql session...

    pls help

Similar Threads

  1. Replies: 5
    Last Post: January 28th, 2004, 09:46 AM
  2. mysql server on different machine than hosting
    By metro in forum MySQL Help
    Replies: 6
    Last Post: February 19th, 2003, 12:34 AM
  3. Replies: 6
    Last Post: January 29th, 2003, 01:34 PM
  4. Replies: 2
    Last Post: December 28th, 2002, 01:55 AM
  5. Can't connect to MySQL server on '24.*.*.*'
    By zytariuk in forum MySQL Help
    Replies: 9
    Last Post: May 1st, 2002, 07:30 AM

IMN logo majestic logo threadwatch logo seochat tools logo