how to safely restart mysql

[manarak]

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?

 

[canadahost]

service mysqld stop
service mysqld start

 

[manarak]

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?