MySQL is an open-source database management system that is widely used as the web database to store website data and organize the access to the data. The most common use of MySQL database is in association with Apache web server, PHP hypertext preprocessor with a Linux server also known as “LAMP Stack”, which is a robust web development platform for hosting websites on Linux servers.

However, in many cases, the default MySQL configuration may not be optimal for the current environment, to alter the MySQL configuration, instead of using an traditional SSH terminal and editing the configuration in /etc/mysql/my.cnf,  you may want to do it in a graphical interface on VPSrobots. When connecting to a server, VPSrobots will detect the MySQL status and list the full configurations of MySQL alongside buttons for tuning the value. Moreover, each listed configuration is followed by a short description telling you what the configuration is, what the default amount were and what you probably change them to.

Now let’s check how to set MySQL configuration in a graphical way using VPSrobots, the tutorial below assumes you’ve Connected to your VPS via VPSrobots and Deployed LAMP for the server:

  1. Log in to your server.
  2. Click MySQL from left side navigation bar.
  3. Click Edit and re-enter a valid value in the box, click Cancel to quit.
  4. Click Save Changes to make the new settings take effect.
Configure MySQL from a graphical interface on VPSrobots

Configure MySQL from a graphical interface on VPSrobots

Furthermore, VPSrobots provides three Quick Setting Modules that collects the most frequently-used MySQL, PHP, Apahce configuration on the server status page. Each setting is followed by a note on it’s default value.

Quick Setting Module for altering the most frequently-used MySQL configuration

Quick Setting Module for altering the most frequently-used MySQL configuration

Now you see how easy it is to configure MySQL using VPSrobots. In addition, VPSrobots also contains dashboards for configuring Apache and PHP: