phpmyadmin password

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
Locked
crming
New here
Posts: 2
Joined: Sun Aug 10, 2008 1:40 pm

phpmyadmin password

Post by crming »

#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
ApacheSwiss
Know my way around
Posts: 179
Joined: Fri Jan 18, 2008 7:53 pm

Re: phpmyadmin password

Post 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.
SETUP:
- QNAP TS-119 Version 4.1 RC
GMAN20
Starting out
Posts: 13
Joined: Sat Aug 30, 2008 4:51 am

Re: phpmyadmin password

Post 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?
GMAN20
Starting out
Posts: 13
Joined: Sat Aug 30, 2008 4:51 am

Re: phpmyadmin password

Post by GMAN20 »

Solved

Leave the password blank :)
User avatar
fribse
Experience counts
Posts: 2090
Joined: Mon Feb 11, 2008 2:50 am
Location: Greve, Denmark
Contact:

Re: phpmyadmin password

Post 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:
Best regards
Fribse

NO, RAID is NOT backup - Use RAID-Certified 24x7 drives for raid
HOWTO's:
Make automatic backup of ALL MySQL databases http://forum.qnap.com/viewtopic.php?f=32&t=15628

NAS-659 Pro II (3 GB Ram), Raid1, Survailance station, local backup destination + NAS-853A (16 GB Ram), Virtualization Station, Plex, iDrive
Network: Fritz!Box 7560 + 24p SG200 + 2x8p SG200 + 8p POE EdgeCore + 300/300 mbit Internet
samuelthan
First post
Posts: 1
Joined: Wed Sep 21, 2011 10:04 pm

Re: phpmyadmin password

Post 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
meanderingthemaze
Getting the hang of things
Posts: 80
Joined: Sat Aug 01, 2009 6:11 am

Re: phpmyadmin password

Post 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?
meanderingthemaze
Getting the hang of things
Posts: 80
Joined: Sat Aug 01, 2009 6:11 am

Re: phpmyadmin password

Post by meanderingthemaze »

Still not letting me in after a removal and reinstall of phpMyAdmin...same errors.
meanderingthemaze
Getting the hang of things
Posts: 80
Joined: Sat Aug 01, 2009 6:11 am

Re: phpmyadmin password

Post 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';
themole
New here
Posts: 3
Joined: Tue May 28, 2013 2:57 am

Re: phpmyadmin password

Post by themole »

*snip*

See reason attached to post.
Last edited by forkless on Sun Jul 13, 2014 1:06 am, edited 1 time in total.
Reason: Removed for destructive nature of the method used
User avatar
doktornotor
Ask me anything
Posts: 7472
Joined: Tue Apr 24, 2012 5:44 am

Re: phpmyadmin password

Post 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
I'm gone from this forum till QNAP stop wasting volunteers' time. Get help from QNAP helpdesk instead.
Warning: offensive signature and materials damaging QNAP reputation follow:
QNAP's FW security issues
QNAP's hardware compatibility list madness
QNAP's new logo competition
Dear QNAP, kindly fire your clueless incompetent forum "admin" And while at it, don't forget the webmaster!
Locked

Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”