How to Create and Manage MySQL Databases in Webuzo
MySQL databases store dynamic content for your website — posts, users, products, settings. This guide covers creating, managing, and maintaining databases in Webuzo.
Creating a New Database
Step 1: Access Database Management
Webuzo > Databases > MySQL Databases.
Step 2: Create Database
Enter a name > Create Database. Note: name may be prefixed with your username.
Step 3: Create Database User
In MySQL Users section > enter username > set strong password > Create User.
Step 4: Assign User to Database
Select user and database > Add > choose ALL PRIVILEGES > Apply.
Your database is ready with connection settings: Host localhost, your database name, username, and password.
Managing Databases
Viewing: See all databases with sizes and associated users.
Checking Size: Monitor sizes to stay within plan limits. Large databases may indicate spam accumulation or unoptimized tables.
Deleting: Click Delete > confirm. Warning: permanently removes all data.
Importing and Exporting
Export (Backup)
phpMyAdmin > select database > Export > Quick or Custom > Go to download .sql file.
Import (Restore)
phpMyAdmin > select database > Import > choose .sql file > Go. For files over 50 MB, upload via FTP and import via command line.
Database Maintenance
Optimize Tables (Monthly)
phpMyAdmin > select database > Check All > Optimize table. Removes overhead from deletes/updates.
Repair Tables
Select problematic tables > Repair table.
Check Tables
Select tables > Check table to verify integrity.
Connection Settings for Applications
| Setting | Value |
|---|---|
| Host | localhost |
| Name | Your database name |
| User | Your database username |
| Password | Your database password |
| Port | 3306 (default) |
Example wp-config.php:
define('DB_NAME', 'youruser_wordpress');
define('DB_USER', 'youruser_wpuser');
define('DB_PASSWORD', 'your_secure_password');
define('DB_HOST', 'localhost');Related Articles
Need help? Contact our support team at {{SUPPORT_URL}}/client/support.