MariaDB (Synology NAS)

MariaDB (Synology NAS)

The MariaDB10 database engine comes standard with SYNOLOGY NAS devices.
Notes Note: The instructions below may vary depending on the application version.

Install MariaDB10

  1. Connect to the SYNOLOGY NAS using a browser.
  2. Log in with an "Administrator" user account. Note: With other user account types, you will not have access to certain operations.
  3. Open the Package Center
  4. Search for the MariaDB10 package (in the Utilities category)
  5. Click on "Install" on the MariaDB10 icon.


Configure MariaDB10

  1. Open MariaDB10 by clicking on the icon on the home page to start the configuration.

  2. Enter and confirm your password .
  3. Enable the TCP/IP connection and confirm port 3306



  4. Complete the installation


Install phpMyAdmin

phpMyAdmin is a utility for administering your MySQL and MariaDB databases. With phpMyAdmin, you can manage security, create users, and manage your MariaDB databases. You can install phpMyAdmin directly on your NAS.
  1. Connect to the SYNOLOGY NAS using a browser.
  2. Log in with an "Administrator" user account. Note: With other user account types, you will not have access to certain operations.
  3. Open the package center
  4. In the search box type phpMyAdmin, locate the phpMyAdmin icon and then click Install.

Add a user to MariaDB using phpMyAdmin

For security reasons, it is best practice for your applications to connect to your MariaDB database using specific usernames and to avoid automatically logging in as "root". To add a user to MariaDB:
  1. Connect to the NAS using a browser.
  2. Log in with an "Administrator" user account (default: "admin"). Note: with a different user account, you will not have access to certain operations.
  3. Open the phpMySQL application and log in with the root user.

  4. In phpMyAdmin, open the Users tab and click on Add user account .
  5. In the Connection Information area, enter a Username , a Password , and confirm the password (Enter again). Keep the default option , Native MySQL Authentication .


    Note: Do not check the "Create a database for this user" option ; the database will be automatically created by Cheel ERP.
  6. In the Global Privileges area, select the Select All option.

  7. Register the new user by clicking Run at the bottom of the page.

Configure a Cheel ERP database

  1. In the File menu, under Organizations, click on + to add an Organization.
  2. In the Organization creation wizard, at the Select database location step, specify the following connection elements:
    - Location: Custom Server
    - Database engine: MariaDB, MySQL
    - Server: <IP address or name of the MariaDB or MySQL server>
    - Port: 3306 (usually)