Managing MySQL Database On Synology NAS

From Littledamien Wiki
Jump to navigation Jump to search

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.

Retrieved from "https://wiki.dbarchowsky.com/index.php?title=Managing_MySQL_Database_On_Synology_NAS&oldid=2191"