Managing MySQL Database On Synology NAS

From Littledamien Wiki
Revision as of 00:11, 31 January 2017 by Video8 (talk | contribs) (Created page with "Category:NAS Category:MySQL == Overview == Notes on configuring and managing MySQL database on Synology NAS through the Synology DSM. == Installation == Install php...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.

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