Managing MySQL Databases in PanelAlpha
A step-by-step guide
Evans
Last Update 5 days ago
A MySQL database stores all your website's dynamic content, including:
- WordPress posts and pages
- User accounts and profiles
- Plugin settings and data
- Comments and metadata
- WooCommerce products and orders
Getting to Your Databases in PanelAlpha
- Navigate to the My Hosting tab
- Click on MySQL Databases in the left sidebar
- View all your existing databases and management options
Creating a New MySQL Database
- In the MySQL Databases section, click Add Database
- Enter a database name
(use descriptive names like "wordpress_blog" or "shop_db") - Click Add Database to generate the database
- Your new database will appear in the list
Naming Databases Best Practices
Good Database Names:
Good Database Names:
- wp_myblog - Clear purpose indication
- store_production - Environment indicator
- client_website_db - Client/project identifier
- Generic names like "database1"
- Special characters (use underscores instead)
- Spaces in database names
Managing Database Users
Creating Database Users
Creating Database Users
- Database users are separate accounts that can access your databases with specific permissions.
- Navigate to MySQL Database -> Users section
- Click Add User
- Fill in the details:
- Username: Descriptive identifier
- Password: Strong, unique password
- Privileges: Select appropriate permissions
- Click Add User
- The database user will now be created and will be visible from the PanelAlpha dashboard.
Understanding Database Privileges
Common Permission Levels:
Full Access (ALL PRIVILEGES):
Common Permission Levels:
Full Access (ALL PRIVILEGES):
- Complete control over the database
- Can create, read, update, and delete
- Required for WordPress installations
- Can only view data
- Useful for reporting tools
- Enhanced security for read-only applications
- SELECT - Read data
- INSERT - Add new records
- UPDATE - Modify existing records
- DELETE - Remove records
- CREATE - Make new tables
- DROP - Delete tables
Linking Users to Databases
Click on Users
- Click on Manage Privileges for the user
- Select the database to link the user to from the dropdown
- Choose permission level, e.g., full
- Click Update
- The database user will now be linked to your database
- In addition, you will be able to view what privileges the database user has from the PanelAlpha dashboard.
- If you have any questions, please reach out to support by opening a support ticket or via live chat.
NEXT ARTICLE: Accessing phpMyAdmin