Managing MySQL Database On Synology NAS: Difference between revisions

From Littledamien Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
[[Category:NAS]] [[Category:MySQL]]
[[Category:Synology NAS]] [[Category:MySQL]]
== Overview ==
== Overview ==


Revision as of 23:32, 18 February 2018

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=2224"