Restart MySQL user only

popeye

• January 10, 2017 04:11

Hi is there any way i can restart a cpanel users MySQL instead of restarting it all via WHM Only reason i ask is because one customers uses remote MySQL and gets blocked but when MySQL is restarted it works fine.

• 

  SysSachin

  • January 10, 2017 12:26

  Hello, No, it's not possible to restart MySQL service for some users only. You need to find out exact root cause of MySQL connection issue. You can check mysql process using the command mysqladmin proc

  0
• 

  popeye

  • January 10, 2017 13:03

  Thanks i thought you could only restart all of MySQL

  0
• 

  cPanelMichael

  • January 10, 2017 16:10

  Hello, Correct, MySQL runs as a service so restarting it is a global action. You should review /var/lib/mysql/$hostname.err to help determine why that MySQL user is encountering an issue with the remote connection. Thank you.

  0

Please sign in to leave a comment.