mySQL & phpMyAdmin on ReadyNAS-214

Question

Please can someone help - I have installed mySQL and phpMyAdmin - all was well until I tried to set a password for "root" using phpMyAdmin as I was uncomfortable with using no password for the account.

Problem is that in now get "#1045 Cannot log in to the MySQL server" - which indicates an authentication error. I cannot get into mySQL now. Please can someone explain how to either reset the mySQL password or delete the data for the database and reinitialise it.

I have tried to remove and reinstall both applications but the problem persists.

Thanks

Wom

Floating_Wombat · Answer

As an aside - a factory reset is not an option as I have 4TB of data on the server&nbsp;Wom

StephenB · Answer

Floating_Wombat&nbsp;wrote:
As an aside - a factory reset is not an option as I have 4TB of data on the server
&nbsp;

If you are saying you have no backup, then I'd suggest that you reconsider that choice.&nbsp; A 5 TB USB drive costs about $120 USD, so it is certainly possible to back up your NAS.&nbsp; Compare the cost of backup against data recovery, and it becomes clear pretty quickly that backup is cheaper (and far more likely to be successful than data recovery).
&nbsp;
Floating_Wombat&nbsp;wrote:
Please can someone help - I have installed mySQL and phpMyAdmin - all was well until I tried to set a password for "root" using phpMyAdmin as I was uncomfortable with using no password for the account.&nbsp;
&nbsp;
Problem is that in now get "#1045 Cannot log in to the MySQL server" - which indicates an authentication error. I cannot get into mySQL now. Please can someone explain how to either reset the mySQL password or delete the data for the database and reinitialise it.&nbsp;
&nbsp;
I have tried to remove and reinstall both applications but the problem persists.&nbsp;

Do you have ssh access to the NAS?
&nbsp;
I don't use these applications on my own NAS, but the database itself should be in /apps.&nbsp; If you access the full data volume using SMB (which requires NAS admin credentials), you should find in in \data\.apps (which is mounted as /apps when you access the NAS with ssh).
&nbsp;

Floating_Wombat · Answer

I am looking at backup solutions - but given the lag on getting goodies.....I can get SSH access so will try the route of deleting the database&nbsp;Wom

Floating_Wombat · Answer

Dear All,I have managed to get a solution on this one. Thanks for the hints on the forums. Here is my solution to the problem - I recommend the squeamish avert their eyes&nbsp;:smileytongue:1/. Remove mySQL and phpMyAdmin apps using the control panel&nbsp;2/. Using Settings on the control panel enable SSH. Type mysql - if all is well you should get a command not recognised error from bash.&nbsp;3/. Create a terminal session using a suitable SSH client - login with the adminstrator usename and password.4/. Navigate to the root&nbsp; cd..&nbsp; - gets you to the Home directory then cd.. to root.5/. Navigate to /var/lib6/. Here is where it gets scary - enable super-user (su) - this will request a password. Use the administrator password. If all is well the "$" at the end of the command propmt will change to "#"7/. Delete the mysql and mysql-files folders.&nbsp;8/. Type "exit" to return to normal use operation9/. Switch to the web based control window and install mySQL app10/. from SSH type "mysql -u root" - this should put you into the mysql control app.&nbsp;11/. type "exit" to leave mysql then "exit" to close the SSH session.&nbsp;12/. install phpMyAdmin - it should now run as expected.&nbsp;13/. disable SSH from the control panelAll instructions offered for use at your own risk&nbsp;Wom&nbsp;&nbsp;

StephenB · Answer

Floating_Wombat&nbsp;wrote:
&nbsp;
3/. Create a terminal session using a suitable SSH client - login with the adminstrator usename and password.

You should log in as root (which uses the same password as the admin account).&nbsp;&nbsp;
&nbsp;
FWIW, that eliminates the need for SU in step 6.

Forum Discussion

mySQL & phpMyAdmin on ReadyNAS-214

7 Replies

Related Content

ReadyNas 214

Can't delete Plex application on ReadyNAS 214

Readynas 214 Virenschutz

Xraid readynas 214

ReadyNAS 214 - Update error message

NETGEAR Academy

ProSupport for Business