This guide shows you how to restart the MySQL server from WHM (Web Host Manager). Restarting MySQL is useful when applying configuration changes or resolving database connectivity issues that require a fresh server start. It's important to note that restarting MySQL will temporarily interrupt any active database connections, so it's best to perform this task during off-peak hours.

How to do it

  1. Step 1: Log in to WHM

    Open your web browser and navigate to WHM. The URL typically looks like https://your-server-ip:2087 or https://your-domain:2087. Enter your credentials to log in. Ensure you use a secure connection (HTTPS) to protect your login information.

  2. Step 2: Navigate to Restart Services

    In the WHM dashboard, use the search bar in the top left corner and type "Restart Services". This will filter the menu items, making it easier to find the option. Click on "Restart Services" from the filtered list.

  3. Step 3: Select MySQL Server

    From the list of available services, locate "SQL Server (MySQL)". This might be listed under different categories like "Databases" or "Services". Click on it to initiate the restart process. If you're unsure which service corresponds to MySQL, look for terms like "MariaDB", as some hosting providers use MariaDB as a drop-in replacement for MySQL.

  4. Step 4: Confirm the restart

    You will be prompted with a confirmation dialog asking if you are sure you want to restart the SQL Server (MySQL). Click on the "Yes" or "Restart" button to proceed. This action will stop and then start the MySQL service, which may take a few moments depending on your server's performance.

  5. Step 5: Wait for completion

    WHM will initiate the restart process. A progress bar or status message will indicate that the action is being processed. Once the MySQL server has been successfully restarted, you will see a confirmation message on the screen. It's advisable to check your website and any critical applications to ensure they are functioning correctly after the restart.

Tips:

  • Before restarting MySQL, consider notifying your team or customers if this action might impact their experience.
  • It's a good practice to back up your databases before making any changes that require a server restart.
  • If you encounter issues during the restart process, consult WHM's error logs for more information. You can access these logs by navigating to "Logs" in the WHM dashboard and selecting "Error Log".