PHPMyAdmin / MySQL

14-01-2011, 19:54

Hi,

Just installed PHPMyAdmin on my NAS drive which has MySQL built it.

I'm trying to logon for the first time tro change the default password and create a DB but I'm not sure of the default ID and password.

I think the default ID is root but the password is unknown.

Google suggests many things like <blank> but other sugestions say I need to create it somehow.

Is there a file I need to modify somewhere?

Kymmy · 14-01-2011, 20:40

The password will be your Mysql root password which is different to the normal root password..

If it's a *nix file system then try this
http://www.cyberciti.biz/tips/recove...-password.html

14-01-2011, 20:53

Hi Kymmy,

That's kinda catch-22 - the MySQL is built into my NAS device and there are no options for setting user ID / password - just a simple enable / disable.

Will check the link...

haydnwalker · 14-01-2011, 22:51

do you have a password for your nas box, as its possible the software has set the nas password and mysql password the same?

Kymmy · 15-01-2011, 09:04

It might help if you tell us exactly which model NAS

15-01-2011, 09:20

Quote:

Originally Posted by haydnwalker

do you have a password for your nas box, as its possible the software has set the nas password and mysql password the same?

Think I tried thatbut just tried it again anyway - nope "Cannot log in to the MySQL server"

---------- Post added at 09:20 ---------- Previous post was at 09:19 ----------

Quote:

Originally Posted by Kymmy

It might help if you tell us exactly which model NAS

Synology 207

Kymmy · 15-01-2011, 09:24

http://forum.synology.com/enu/viewto...p?f=20&t=11600

15-01-2011, 09:53

Thanks for that Kymmy - I had tried some of that already - changing the ['AllowNoPassword'] to true but I think what did it was the reset of the MySQL password in admin panel of my device!

Success! I'm in - now to secure it with a password!