1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

how to safely restart mysql

Discussion in 'Plesk for Linux - 8.x and Older' started by manarak, Feb 19, 2006.

  1. manarak

    manarak Guest

    Hi all

    I would like to know how to safely restart mysql, including setting up the new socket.

    the command "mysqld restart" does not renew the socket, so that websites do not have access to mysql anymore.

    so, what's the correct procedure to restart mysql and return to normal operations without rebooting?
  2. canadahost

    canadahost Guest

    service mysqld stop
    service mysqld start
  3. manarak

    manarak Guest

    Hi, apparently this doesn't do the trick.

    If server is running and I try to restart mysqld or if I try the stop/start variant above, I will get the "cannot connect" error.
    If I reboot the server, the socket is created properly.

    What must I do so that the socket is created automatically when I restart mysql?