Configure remote QTS MariaDB 10 adminstration

< 1 min read

Using QTS to setup MariaDB 10
1. Log in to QTS as an administrator
2. Open the App Center
3. Install and Open MariaDB10
4. Finish the MariaDB 10 Setup Wizard
  1. Click Start
  2. Choose “Create a new database” and Click next
  3. Insert Root Password (For example: youPassWot)
  4. Enable TCP/IP networking
  5. (Optional) Change the Port number
    Note: The default Port number of MariaDB 10 is 3307.
  6. Click Apply.
Using SSH to allow remotely connecting
1. SSH access the NAS
2. Use the command to enter MariaDB monitor locally
  Note: Specify the port number after -P (for example: -P 3307)
  `getcfg MariaDB10 Install_Path -f /etc/config/qpkg.conf`/bin/mysql -u root -p -h localhost -S /var/run/mariadb10.sock -P 3307
3. In the MariaDB monitor, use the following command to grant the permission for remotely access.
  Note: Modify youPassWot to your Root Password
  GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘youPassWot‘;FLUSH PRIVILEGES;
4. Done

Updated on February 12, 2025

What are your Feelings

Happy
Normal
Sad

Powered by BetterDocs

No Responses