Mysql with non local access

You'll need to edit the my.cnf file located in etc/mysql via ssh and change the line that reads "bind-address = 127.0.0.1" and alter the IP address to "0.0.0.0" then stop and restart the MySQL add-on. It's not so much an "add-on" as much as a "switch" to turn on the already built-in MySQL server when apps like Photos II are either not installed or Not running. It's like the MySQLON add-on for OS4 from what I can see of it.

However you had make pretty sure you have access via phpMyAdmin secured down pretty tight, as the database has root users with no passwords. They are only local users, but if somebody was able to hack in and change that somehow...

You can't password protect those root accounts as NTGR haven't changed the behaviour of these accounts with regards their use with Photos II (and possibly other built-in add-ons) from OS4. If you specify a password for the root account, Photos II will stop working. And Possibly others services like Anti-Virus too.

I would log in with phpMyAdmin as root, with no password (or via Terminal over SSH as root using your admin password) and create yourself a new MySQL Super-User with password protection. Then disable phpMyAdmin's "log in as root" and "allow log-ins without a password" settings.

...

Check out the linked article on setting up phpMyAdmin. Refer to the "Using Set-up script" section (You will need to create the pma user in advance, and need to import the "create-tables.sql" from the "examples" folder on the NAS, if you want to use phpMyAdmin as your general administration interface.

IP-OF-YOUR-NAS:7082/doc/html/setup.html#setup_script

In step 7 Change the following command:

chmod o-rw config.inc.php          # remove world read and write permissions

to read:

chmod o-w config.inc.php          # remove world read and write permissions

or phpMyAdmin won't be able to read it's own config file.

The add-on (phpMyAdmin) installs to "/data/apps/phpmyadminr6" and the working folder you'll need for the instructions in the guide is "/data/apps/phpmyadminr6/web".