Page 1 of 1

phpmyadmin password

Posted: Thu Aug 28, 2008 12:55 am
by crming
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)

Re: phpmyadmin password

Posted: Thu Aug 28, 2008 5:17 am
by ApacheSwiss
crming wrote:#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
the username for MySQL admintrator account is "root" and the default password is "admin".
btw.

Re: phpmyadmin password

Posted: Sun Aug 31, 2008 8:56 pm
by GMAN20
I've got the same problem. Just enabled the Web server and MySQ.

Tried to access the phpMyadmin screen which loads up ok but I enter a username of root and password of admin and it fails:-

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

Any ideas?

Re: phpmyadmin password

Posted: Sun Aug 31, 2008 9:03 pm
by GMAN20
Solved

Leave the password blank :)

Re: phpmyadmin password

Posted: Tue Sep 02, 2008 10:24 pm
by fribse
If you loose the password, you can reset it via the adminwebinterface.
Oh, and remember to set the password if you have it blank :mrgreen:

Re: phpmyadmin password

Posted: Sat Oct 01, 2011 10:30 pm
by samuelthan
I had this problem after i first install phpmyadmin.
Found out that i forgot to ENABLE MySql Server :)

Once i tick that box ... APPLY it ....
Reenter the default password and username. I'm logged in to PhpmyAdmin

Re: phpmyadmin password

Posted: Sat Sep 08, 2012 4:54 am
by meanderingthemaze
I am having the same issue, cannot log in to phpMyAdmin.
Web Server Enabled - CHECK (default ports)
MySQL Server Enabled - CHECK (I even re-initialized the database and reset root password to default)
phpMyAdmin Updated to most recent version - CHECK
QNAP Updated to most recent version - CHECK

Errors I'm getting:
#2013 Cannot log in to the MySQL server
Login without a password is forbidden by configuration (see AllowNoPassword)
Weird thing is that the user and password lines of the config.inc.php file seem to be commented out. Also, there is no line to set the AllowNoPassword feature. So, this is making me think that maybe I'm in the wrong config file. I tried uncommenting the user/pass lines and that didn't fix it either.

I think I'm going to try to uninstall and reinstall the whole thing next. Hopefully that fixes whatever bug I've got. Any other ideas?

Re: phpmyadmin password

Posted: Sat Sep 08, 2012 5:28 am
by meanderingthemaze
Still not letting me in after a removal and reinstall of phpMyAdmin...same errors.

Re: phpmyadmin password

Posted: Sat Sep 08, 2012 5:33 am
by meanderingthemaze
Wow lucked out and a hail mary guess got me back in. I had to change the host in the config.inc.php file from 127.0.0.1 to localhost. Check this line if you're having issues too:

Code: Select all

$cfg['Servers'][$i]['host'] = 'localhost';

Re: phpmyadmin password

Posted: Sun Jul 13, 2014 12:44 am
by themole
*snip*

See reason attached to post.

Re: phpmyadmin password

Posted: Sun Jul 13, 2014 12:47 am
by doktornotor
Who the hell revived the 6 years old thread with completely broken advise? The default password is NOT blank and there's zero reason to allow blank passwords anywhere. If you forgot the MySQL password, use the MySQL password reset function from the GUI!

Moderators, lock the corpse please. Doing more harm than good with random "advise" on "fixing" the issue. :roll: :x