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

How to upload Python website to hosting

Installing Python After entering the control panel, go to the "System> SSH terminal" page and...

Upload PHP-MySQL website to hosting

Follow the instructions below to upload a standard PHP/MySQL website to your hosting: Log in to...

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 upload NodeJS website to hosting

Installing NodeJS After entering the control panel, go to the "System> SSH terminal" page and...

How to install a new PHP module

All available PHP modules can be enabled/disabled in the Control Panel on the "System> PHP...