Help Mysql Important

Discussion in 'MySQL' started by newzone, Jun 5, 2008.

  1. #1
    I need help for this error , Mysql can't be started :


    ..failed or took more than 6s.

    Please take a look at the syslog.

    /usr/bin/mysqladmin: connect to server at 'localhost' failed

    error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

    Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
     
    newzone, Jun 5, 2008 IP
  2. GLD

    GLD Well-Known Member

    Messages:
    307
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    140
    #2
    Are you sure your connection information is correct? Try putting in the actual host url instead of 'localhost'
     
    GLD, Jun 5, 2008 IP
  3. newzone

    newzone Well-Known Member

    Messages:
    2,865
    Likes Received:
    52
    Best Answers:
    0
    Trophy Points:
    135
    Digital Goods:
    1
    #3
    i tried with localhost and dedicated ip but no result
     
    newzone, Jun 5, 2008 IP
  4. newzone

    newzone Well-Known Member

    Messages:
    2,865
    Likes Received:
    52
    Best Answers:
    0
    Trophy Points:
    135
    Digital Goods:
    1
    #4
    The syslog sais, something like this :

     
    newzone, Jun 6, 2008 IP
  5. suraj4u

    suraj4u Well-Known Member

    Messages:
    514
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    120
    #5
    Connect using the port number also

    localhost:port
    ip:port
     
    suraj4u, Jun 6, 2008 IP
  6. newzone

    newzone Well-Known Member

    Messages:
    2,865
    Likes Received:
    52
    Best Answers:
    0
    Trophy Points:
    135
    Digital Goods:
    1
    #6
    i think is a problem with gmysql , the server is using pdns ,

    if i change in etc/mysql/my.cnf

    user = mysql to user = root , the first IP is working and mysql will start but the domain and the second nameserver still not working properly

    mysql starts even if is on the second IP

    what can be wrong ? now i think is something with pdns or ?
     
    newzone, Jun 6, 2008 IP
  7. suraj4u

    suraj4u Well-Known Member

    Messages:
    514
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    120
    #7
    smilies u attacked my post

    localhost:port
    ip:port
     
    suraj4u, Jun 9, 2008 IP
  8. newzone

    newzone Well-Known Member

    Messages:
    2,865
    Likes Received:
    52
    Best Answers:
    0
    Trophy Points:
    135
    Digital Goods:
    1
    #8
    thanks , i paid someone to fix it :(
     
    newzone, Jun 9, 2008 IP