Install MySQL Visually Using 1Panel¶
MySQL is a popular open-source relational database management system (RDBMS) suitable for various application scenarios. 1Panel provides visual installation and management capabilities, making deployment and maintenance easier.
1. Open the App Store¶
After entering the 1Panel console, click App Store in the left menu.
2. Search for MySQL and Install¶
In the App Store (on the homepage or under the Database category), find and click the MySQL application card to enter the details page, then select Install.
3. Configure Installation Parameters¶
You can configure the following as needed:
- Name: Default application name
- Version: Select the required version
- Root Password: Randomly generated by default
- Port: Default 3306 (can be modified as needed)
- Port External Access: When enabled, allows external access to the database
After confirming the settings are correct, click Confirm to start installation.
4. Create a MySQL Database¶
After installation, go to the Databases page in the left menu, click Create Database, and fill in the relevant information according to actual needs:
- Name: Database name
- Character Set: Default utf8mb4
- Collation: Empty by default (will automatically use the default collation of the selected character set)
- Username: Same as the database name by default
- Password: Randomly generated by default
- Privileges: All Hosts or Specified IP
After configuration, click Confirm to create the database.
5. Connect to the MySQL Database¶
Click on the database to view connection information for client or program access.
6. View and Manage Backups¶
- Supports viewing the backup list; click Backup to back up the database.
- A compression password can be set during backup, and backup files support operations such as Restore and Download.
7. Import Database Backups¶
Supports Import Backup, allowing you to select Upload Local File or Existing Backup File on Server for import.
8. Add Remote Databases¶
- Supports adding remote MySQL databases to the panel for management
- Added remote databases also support backup and restore operations
- When installing applications, you can also select added remote databases for use
9. Sync Databases from Remote Servers¶
Supports syncing databases from remote servers to local, enabling cross-server data synchronization.
10. Modify User Password and Privileges¶
Maintenance operations such as Change Password and Modify Privileges can be performed on database users.
11. Visual Management with phpMyAdmin / Adminer¶
You can perform more comprehensive visual management of the database through phpMyAdmin or Adminer.
12. Schedule Regular Database Backups¶
In Scheduled Tasks, select the Backup Database type to configure automatic scheduled backups for target databases.
Take 1Panel Further
Running 1Panel OSS? Pro Edition adds WAF protection, unlimited AI agents, multi-node management, and priority support — starting at $80/year.