Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Mysql problem

Discussion in 'General Discussion' started by shann, May 9, 2004.

  1. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    166
    cPanel Access Level:
    Website Owner
    Hi,

    Everytime I reboot our server, we need to resart mysql manuall in order to work. Do you guys any the causes.

    I have find this info in log file.

    030619 14:27:09 Can't start server: Bind on TCP/IP port: Address already in use
    030619 14:27:09 Do you already have another mysqld server running on port: 3306
    ?

    Do you guys know the problem?.

    Thanks
    Shan
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Lewisville, Tx
    Sounds like it is shutting down hard and not clearing the pid file. Might want to check your configurations and make sure the mysql.sock is setup correctly and the pid files are being created and deleted with ons/offs.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    166
    cPanel Access Level:
    Website Owner
    Thank You for your info.

    I have jsut noticed that from /tmp/mysql to /var/lib/mysql, there is no link.

    would this cause the problem.

    thanks
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    774
    Likes Received:
    4
    Trophy Points:
    318
    Location:
    N.W. Iowa
    you may need to create a symbolic link to the socket file.

    Mickalo
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice