Database Management

Create and manage MySQL/MariaDB databases with ease using WisPanel's database management interface.

Creating a Database

1. Click Create Database
2. Enter database name
3. Configure options:
   • Prefix: Auto-add prefix to all databases (recommended)
   • Database User: Create new or select existing
   • User Password: Strong password (auto-generated recommended)
   • User Privileges: Select all or custom
4. Click Create
5. Database ready for use immediately

Managing Databases

View Database Info

• Database name and size
• Character set (utf8mb4 recommended)
• Collation (utf8mb4_unicode_ci)
• User permissions
• Creation date

Reset Password

1. Right-click database
2. Click Reset Password
3. Enter new password
4. Confirm change
5. Update application credentials

Access phpMyAdmin

1. Click Open in phpMyAdmin
2. Automatically authenticated
3. Full database management available
4. Create tables, import/export, query builder

Remote Access

1. Enable Remote Access for database user
2. Specify allowed IPs (or % for any)
3. Remote connections require proper credentials
4. Check firewall port 3306 is open

Delete Database

1. Backup data first
2. Right-click > Delete
3. Confirm deletion
4. Irreversible action

Best Practices

• Use prefix to organize databases
• Create separate users per database
• Use strong passwords (20+ characters)
• Regular backups recommended
• Review permissions periodically

[Screenshot: database-management.png] [Screenshot: database-user-creation.png]