How to change MySQL database settings

If you are not satisfied with the current MySQL database configuration and want to modify it, follow these instructions:
  1. After logging into the control panel, go to the "System> SSH terminal" page and in the terminal displayed, enter your control panel username and password (Login to system).
  2. In terminal enter the following command "sudo apt-get update" and press enter.If asked for a password, enter the password for your control panel.
  3. Install the nano text editor with the following command: "sudo apt-get install nano".
  4. Open the MySQL database configuration file in the nano text editor with the following command: "sudo nano /etc/mysql/my.cnf".
  5. Make the necessary changes (make sure the changes you made are valid, otherwise the MySQL server may stop working) and press "CTRL + X + Y + Enter" to save the changes.
  6. Finally, restart the MySQL server with the following command "sudo service mysql restart". The changes you make will affect the MySQL database.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Change web hosting configuration (Upgrade or Downgrade settings)

To change (Upgrade or Downgrade) your web hosting configuration, go to the Services page  and...

How to change PHP configuration

PHP configuration settings can be changed on the "System> PHP settings" page. if you need to...

How to upload ASP.NET Core website to hosting

Installing Asp.Net Core software After entering the control panel, go to the "System> SSH...

Web Hosting Control Panel

Web Hosting Control Panel allows you to manage server configurations (domains, email, databases,...

Web Hosting Purchase Instructions

To purchase web hosting, go to the following link and select your desired configuration. When...