MySQL
1 Manage Database Instances¶
1.1 Install Database from App Store¶
MySQL and MariaDB databases installed through the App Store will automatically appear in the database instance list.
1.2 Remote Server¶
In addition to local databases installed from the App Store, you can also add existing database service addresses. Click the Remote Server button above the list to enter the remote server management page.
1.3 Switch Database Instance¶
Click the drop-down menu above the database list to switch between different database instances and manage databases and settings under different instances.
2 Create Database¶
To create a new database, first enter the database name, select the encoding format, enter the password, and set access permissions.
- Database Name: Name of the new database, with default encoding UTF-8
- Username: Username for accessing the database
- Password: Random by default, can be modified manually
- Access Permission: Defaults to local server; options: local server, all hosts, specified IP
3 View Connection Information¶
Click the Connection Information button above the list to view the database address, port, root password, and other connection details. You can also change the root password here.
Note
Databases deployed from the App Store run in containers. Select the corresponding connection information according to the scenario shown on the page.
4 Sync from Server¶
If databases are modified using other tools or applications and the list becomes inconsistent, click Sync from Server to refresh the database list from the server.
5 WEB Management Tool¶
To manage MySQL via a web GUI, click the Manage button above the list to jump to the corresponding tool.
Supported management tools: - phpMyAdmin - Adminer
6 Backup¶
Click the backup button to back up the current database.
- Default backup path:
/opt/1panel/backup/database/mysql - Backup uses
mysqldump
7 Restore¶
Click Import Backup to upload a local file or select an existing backup for restoration.
- When restoring from an uploaded file, ensure the archive contains a
test.sqlfile, otherwise import will fail - Imported SQL files must follow standard format; SQL files exported from phpMyAdmin may lack version/encoding info and fail with
mysqldump - If import fails, try using phpMyAdmin instead
8 Permission Settings¶
Click the Permissions button in the action column to modify access permissions for a specific database. Supports access from all hosts or specified IPs.
- All Hosts: Anyone can connect remotely
- IP Address: Only specified IPs are allowed; separate multiple IPs with commas
- To enable public access, allow the MySQL port (default 3306) in the firewall
9 Change Password¶
Change the password for the current database user. Note: This does not change the root password.
10 Database Configuration¶
Click the settings button in the status bar to enter the database settings interface, including configuration editing, current status, performance tuning, port, logs, and slow query logs. You can manually adjust database configuration in the configuration interface.
- MySQL is installed via Docker; configuration file is mounted at
/opt/1panel/apps/mysql/[database-name]/conf/my.cnf - Warning: Incorrect configuration may make MySQL unavailable; modify with caution
- If the service fails to start due to invalid configuration, restore the default settings and save
11 Current Status¶
When database queries are slow, go to the database settings and click Current Status to view key metrics such as cache hit ratio and index hit ratio for performance optimization.
12 Performance Tuning¶
The system supports form-based tuning of performance parameters such as index buffer and max connections. Common optimization presets are available for direct selection based on your environment.
13 Port¶
Besides setting the port during installation, you can modify it directly in the settings interface.
14 Logs¶
- MySQL runs in Docker; logs shown are from the corresponding container. Supports time filtering, real-time follow, and download
- Slow query logs are also available in the settings interface
Take 1Panel Further
Running 1Panel OSS? Pro Edition adds WAF protection, unlimited AI agents, multi-node management, and priority support — starting at $80/year.