Managing MySQL Databases in Your Apex Managed Panel

Your MySQL databases are central to your website’s functionality, storing valuable data and powering dynamic features. The MySQL Databases section in Your Apex Managed Panel makes managing databases and database users both intuitive and efficient. With tools to add databases, adjust user settings, and access PHPMyAdmin, you’ll have everything you need for seamless database management.

Here’s a complete guide to help you make the most of this powerful tool.

Adding and Managing MySQL Databases

The Databases section provides you with full control over managing your MySQL databases. Each database is displayed in a sortable table, which shows key information, including:

• Database Name: The name of each database for easy identification.
• Size: The amount of storage being used by the database.
• Last Updated Time: The most recent activity associated with the database.

Adding a New Database

It’s quick and easy to create a new database:

1. Click the Add Database button, available above the table.
2. Enter a name for the new database.
3. Save your changes to finalize the creation process.

Managing Existing Databases

Use the Actions buttons next to each database to:

• Rename Database: Adjust the database name for better organization or clarity.
• Delete Database: Remove any databases that are no longer required.

For large lists, the search bar helps you locate specific databases by name within seconds.

Adding and Managing MySQL Users

The Users section lets you manage individual database users and their access permissions. User details are displayed in a sortable table, which includes:

• User: The unique username assigned to each database user.
• Assigned Databases: The databases that the user has access to.

Adding a New MySQL User

To create a new user:

1. Click the Add User button located above the user table.
2. Enter a username and password for the new user.
3. Assign the user to one or more databases.
4. Define their access privileges.

Managing User Access

For existing users, the Actions buttons allow you to:

• Manage Privileges: Adjust control levels for each user, such as read and write permissions.
• Edit User: Update the username or password for enhanced security.
• Show Access Details: Review the credentials and database assignments.
• Delete User: Remove any users whose access is no longer needed.

Similar to databases, the search bar helps quickly locate specific users by name.

Accessing PHPMyAdmin

For direct database management, you can log into PHPMyAdmin with a single click. The PHPMyAdmin login button is conveniently located on the right-hand side of the page. This tool allows you to:

• Run SQL queries.
• View and edit database tables.
• Backup or import data.

PHPMyAdmin helps you get into the finer details of your database management, while the MySQL Databases section provides an overview and control tools for higher-level management.

Simplified Database Management

The MySQL Databases section in Your Apex Managed Panel simplifies complex database operations, making it accessible for all users. Whether you’re adding databases, managing users, or exploring advanced features like SQL queries in PHPMyAdmin, the panel offers intuitive tools to streamline the process.

For any questions or additional support, our dedicated Apex Managed Hosting support team is always here to help. Start managing your databases effectively and confidently with Your Apex Managed Panel today!