Need to restart mysql database without root user access
I am a new developer to a company and out of the blue, it says that the MYSQL servers are offline for one of our ecommerce sites. They haven't had a developer here for 4 years so I wouldn't even know where to get the root access to this account. Is it possible to restart the MySQL service without root access or from the cPanel dashboard?
-
Hey there! Unfortunately no - you have to be the root user to restart services on the machine. If you need to reset those login credentials, contacting your hosting provider would be the best step. 0 -
Hello John, If your user has sudo privileges, you can manage (stop, start, restart) services. The term "sudo" must be used before each command. For example: If you want to restart mysql service, For MySQL service named mysql: sudo systemctl restart mysql For MySQL service named mysqld: sudo systemctl restart mysqld Note: The exact service name might vary based on your MySQL installation and Linux distribution. Remember to replace mysql or mysqld with the appropriate service name based on your server's configuration. 0 -
You would still need the root password to use "sudo" which I don't think they have. 0
Please sign in to leave a comment.
Comments
3 comments