phpmyadmin add-on which username and password ?

tried with root/ no pw -> got a message that nopasswords are not allowed
set allownopassword to true and get the "#2002 Connection to the MySQL server not allowed"

can I set/change the root password somewhere?

hmm change the login type to config and configured the config root password. after saving the config I log in and get:
Error
MySQL said:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

I now see that there is a update of the php package fixing location of MySQL socket. I hope I get a free update for this non working package I just bought...

This sounds like a setup problem, really.
There are some things to consider first: Is your (obviously local) MySQL server actually up and running? On the ReadyNAS MySQL isn't started by default but rather is either activated by add-ons that need it or manually using the "MySQL On" add-on which can be found in the Community Add-ons section.

Next thing is that on the ReadyNAS the default password for the "root" MySQL user is empty. PhpMyAdmin by default prevents logins using empty passwords for security reasons. To change this, you have to set the "Allow empty passwords" checkbox while configuring your MySQL server. This is done on the third tab on the configuration screen when using the "Configure PhpMyAdmin" link from the installed add-ons list.

Lastly on the ReadyNAS MySQL is configured to not use any TCP/IP connections at all. Thus you have to communicate with the server using a socket connection. Unfortunately the socket on the ReadyNAS is not in the standard location /tmp/mysqld.sock but rather in /var/run/mysqld/mysqld.sock. Thus you have to tell PhpMyAdmin the location of the socket on the first tab of the server config screen of PhpMyAdmin.

-Stefan

Hi Stefan, thank you for your reply.

I installed the MysqlOn addon, changed the socket like you said and the allowemptypasswords was allready checked. It works now!

I tried enabling ssl but that doesn't seem to work.

Perhaps this instruction should be added to the configuration instruction that comes with the addon...

RezzZ wrote:
I tried enabling ssl but that doesn't seem to work.

This may be a limitation of either PHP or MySQL (or both, for their ReadyNAS specific setup), can't say for sure right now. I'll look into it and let you know what I find ;)

-Stefan

Thank you and thanks again for the quick support!