How to Find Your MySQL Database Details on cPanel?

Locating your MySQL database details in cPanel is essential for managing your applications effectively. Here’s how to find the necessary information:

Step 1: Log in to cPanel

1. Open Your Web Browser:
• Navigate to your cPanel URL (e.g., https://yourdomain.com/cpanel).
2. Enter Your Credentials:
• Log in using your cPanel username and password.

Step 2: Locate the Databases Section

1. Find the Databases Section:
• In the cPanel dashboard, scroll down to the "Databases" section.

Step 3: Click on MySQL Databases

1. Select MySQL Databases:
• Click on the "MySQL Databases" icon. This will take you to the database management area.

Step 4: View Your Database Details

1. List of Databases:
• In the MySQL Databases section, you’ll see a list of all databases associated with your cPanel account.
2. Database Name:
• The name of each database will be displayed here, typically in the format username_database.
3. Database Users:
• Scroll down to the "Current Users" section to see the users associated with each database.
4. Database Host:
• Generally, the database host is a local host for cPanel accounts unless specified otherwise by your hosting provider.
5. Privileges:
• You can check user privileges by selecting a user from the "Add User to Database" section and clicking "Add." You’ll see the privileges granted to that user for the selected database.

Step 5: Access phpMyAdmin (Optional)

1. Open phpMyAdmin:
• If you need to view or manage your database directly, click on the "phpMyAdmin" icon in the Databases section.
2. Select Your Database:
• In phpMyAdmin, select your database from the left sidebar to view tables and data.

Conclusion

Finding your MySQL database details in cPanel is a straightforward process. By following these steps, you can easily locate your database names, users, and other essential information needed for your applications. Always ensure your database credentials are kept secure and manage user privileges wisely.