How to Create MySQL® Profiles via WHM?

introduction

It is very important for a root user to properly manage the MySQL server connections. This involves setting up specific MySQL profiles. These profiles basically contain all the necessary details for your server to connect to a local or remote MySQL server. If you are using WHM (Web Host Manager), you get an easy way to create and manage these profiles.

What is a MySQL Profile?

A MySQL profile is essentially a collection of connection details. These details allow your system to establish a proper and secure link with a MySQL database server. The profile stores information like the server’s address, username, password, and authentication method. This feature is especially helpful for administrators who need to manage multiple database connections or external MySQL servers from their WHM interface.

Steps to Create MySQL Profiles in WHM

Here are the simple steps you need to follow to add a new MySQL profile inside your WHM root account..

You need to begin by accessing your WHM panel. Only the root user has the necessary privileges to manage MySQL profiles.

2. Navigate to SQL Services

Once you log in, look for the SQL Services option in the main navigation menu. Click on this option to see the related tools.

3. Access Manage MySQL® Profiles

Under the SQL Services section, you will find the link for Manage MySQL® Profiles. Clicking this will take you to a page that lists all the currently existing profiles.

4. Initiate the Add Profile Process

On the Manage MySQL® Profiles page, you will see a button labeled +Add Profile. Click this button to open the form for creating a new profile.

5. Fill in the Profile Details

A form will now appear asking for specific connection information. You must enter the correct details in all the fields.

Profile Name: Give a suitable and easy-to-remember name to your new MySQL profile.
Configuration Method: Decide how you want to set up the MySQL superuser. You can choose either the automatic or manual creation method.
Host: Enter the IP address or the hostname of the MySQL server you want to connect to.
SSH Port: Enter the specific SSH port number used by the server.
Username: Type the login username for the MySQL server.
Authentication Method: Select how you want to log in. The common choices are Password or an SSH Key.
Password: If you chose Password as your authentication method, you must enter the correct password here.
Escalation Method: Give elevated privileges temporarily to users who are not the root user. They can access the MySQL superuser account when needed.

6. Save the New Profile

After you have filled in all the required details, click on the Save button. The system will process the information. It will then save your new profile and add it to the list of profiles you can manage.

Conclusion

Following these clear steps ensures that your connections are always established correctly and can be managed efficiently. This way, you can maintain seamless operation of all your applications that rely on a MySQL database.

Cantech helps with smooth database management for your websites and applications. Our web hosting solutions are built to make administration easy for you. Our hosting plans come with the powerful WHM/cPanel combination. This gives you direct access to the Manage MySQL® Profiles feature and you can effortlessly manage your database connections, whether they are local or external. We focus on providing a secure and reliable platform for all your database needs.

Frequently Asked Questions

Who can create MySQL Profiles in WHM?

Only the root user of the WHM account has the necessary permissions to access and manage the Manage MySQL® Profiles feature. This is a high-level administrative function.

What kind of information is stored in a MySQL Profile?

A MySQL profile stores all the crucial connection details. This includes the server’s hostname or IP address, the SSH port, the username, the password (or SSH key), and the selected authentication method.

Can I connect to an external MySQL server using this method?

Yes. The Host field in the profile creation form lets you enter the IP address or hostname of any local or remote MySQL server. This makes managing external connections simple.

What is the ‘Escalation Method’ used for?

The Escalation Method is an advanced feature. It allows non-root users to temporarily gain elevated privileges. This is needed to access or manage the MySQL superuser account when they need to perform administrative tasks.

Where can I find the MySQL Profile management tool in WHM?

You can find the management tool by logging into WHM. Then navigate to the SQL Services section and click on the Manage MySQL® Profiles option.