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

Allow connections in MySQL server

Using phpMyAdmin, go to the User table in the mysql database.

Copy root@localhost and change the host to the IP of the machine the LAN making queries.

Run FLUSH PRIVILEGES;

Test the connection

Enter the MySQL server connection properties in a MySQL client (e.g. MySQL Workbench) on the client machine. Test the connection.