Thank you giacomo… that was very helpful.
Since it was a bit tricky getting MySQL root access I will list the steps I did here for anyone facing the same issue, please correct if I did something that doesn’t make sense, but it worked for me:
MYSQL SET root PASSWORD STEPS:
Passwords in these files should all match (in clear text):
etc/my.pwd
/root/.mycnf
/var/lib/nethserver/secrets/mysql
Use the following steps to reset the MySQL root password and grant ‘%’ access:
ref: How To Reset Your MySQL or MariaDB Root Password | DigitalOcean
[Login to NS terminal, can be done remotely]
$ sudo systemctl stop mysql
$ sudo mysqld_safe --skip-grant-tables &
$ mysql -u root
mysql> FLUSH PRIVILEGES;
mysql> SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘new_password’);
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘password’;
mysql> exit
[Use ‘kill’ to stop the mysqld processes]
$ ps aux | grep mysqld
$ kill [pid of mysqld]
[start mysqld from NS: Status:Services: mysqld “Start”]
[Use phpmyadmin to set GRANT ALL on user root]
To install phpmyadmin follow the instructions here: phpmyadmin [NethServer Wiki]
Please note, above will grant root user access from ANY network address to the entire MySQL system. You may not want to do that. You’ll also have to configure NS at Security: Network Services: mysqld and set the ‘zone’ the mysqld service can operate in (green: LAN, red: WAN)
I hope that helps…
On a side note, phpmyadmin is so popular and useful it probably should be part of the Software Center packages that can be installed easily.
Good day to all!