NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
mySQL & phpMyAdmin on ReadyNAS-214
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 accoun...
Floating_Wombat wrote:
As an aside - a factory reset is not an option as I have 4TB of data on the server
If you are saying you have no backup, then I'd suggest that you reconsider that choice. A 5 TB USB drive costs about $120 USD, so it is certainly possible to back up your NAS. 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).
Floating_Wombat 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.
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.
Do you have ssh access to the NAS?
I don't use these applications on my own NAS, but the database itself should be in /apps. 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).
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
Wom
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 :smileytongue:
1/. Remove mySQL and phpMyAdmin apps using the control panel
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.
3/. Create a terminal session using a suitable SSH client - login with the adminstrator usename and password.
4/. Navigate to the root cd.. - gets you to the Home directory then cd.. to root.
5/. Navigate to /var/lib
6/. 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.
8/. Type "exit" to return to normal use operation
9/. Switch to the web based control window and install mySQL app
10/. from SSH type "mysql -u root" - this should put you into the mysql control app.
11/. type "exit" to leave mysql then "exit" to close the SSH session.
12/. install phpMyAdmin - it should now run as expected.
13/. disable SSH from the control panel
All instructions offered for use at your own risk
Wom
Floating_Wombat wrote:
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).
FWIW, that eliminates the need for SU in step 6.
It does eliminate the su step - but it also means longer in the superuser state, with more possibility of doing something drastic inadvertently. I prefer sudo but that doesn't seem to be available
Wom
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
