SQL Services

This section of WHM lets you manage SQL databases on your server.

• Additional MySQL Access Hosts — This feature allows your users to remotely access MySQL databases on your web server, or a remote MySQL server that you have set up using the Setup Remote MySQL Server feature.

• Change a User or Database Password — This feature allows you to change passwords for a database or a database user. As this feature does not require the old password, this can be useful if a password is compromised or forgotten.

• MySQL Root Password — This feature allows you to set a root MySQL password. By default, no root password is set. You should ensure that a very secure password is used, because if this password were to be compromised, the attacker would have access to any database associated with your server. You will not need to remember this password unless you plan on logging into any of your databases as the root user.

• Repair a Database — This feature will attempt fix a database that is not properly functioning by examining and repairing tables that may have been corrupted.

• Reset Local MySQL Root Password — This feature will allow you to reset your local MySQL root password in the event that it is lost or compromised.

• Setup Remote MySQL Server — This feature allows you to place your MySQL databases on a remote server that is running MySQL. Using a separate server for MySQL can be useful for busy servers or servers with large databases, allowing you to offload MySQL-related work to the remote MySQL server.

• Show MySQL Processes — This feature is a list of any processes that are currently being run on any database on your server.

• phpMyAdmin — phpMyAdmin is a MySQL database management system. It allows you to access and edit information contained within any database on your server(s). You can find the documentation for using phpMyAdmin at http://wiki.cihar.com/pma/Welcome_to_phpMyAdmin_Wiki.