Managing MySQL Database On Synology NAS

Overview

Notes on configuring and managing MySQL database on Synology NAS through the Synology DSM.

Installation

Install phpMyAdmin through the Synology DSM Package Center.

• DSM > Package Center > Explore > All > Third-Party > phpMyAdmin > Install button

Once phpMyAdmin is installed, you can connect to it via http://HostName/phpMyAdmin.

Create a password for root.

• mysql database > user table > click on the user name under the User column
• Click Change Password button on the next page.

Ultimately it's probably easier to manage the database with a tool like MySQLWorkbench than to use phpMyAdmin. Make sure to allow access for that user from remote machines on the LAN.

Synology DSM firewall

DSM > Control Panel > Security > Firewall tab

• Enable Firewall: CHECKED
• Firewall Profile: custom
• Next to Firewall Profile click the Edit Rules button > Create Rule
  • Ports: Select from a list of built-in applications
    • Select MariaDB (port 3307)
  • Source IP: Specific IP
    • Select appropriate range on the LAN
  • Action: Allow