Editing 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.
[[Category:MySQL]][[Category:MariaDB]][[Category:Synology]]