phpmyadmin password
-
- New here
- Posts: 2
- Joined: Sun Aug 10, 2008 1:40 pm
phpmyadmin password
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
-
- Know my way around
- Posts: 179
- Joined: Fri Jan 18, 2008 7:53 pm
Re: phpmyadmin password
the username for MySQL admintrator account is "root" and the default password is "admin".crming wrote:#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
btw.
SETUP:
- QNAP TS-119 Version 4.1 RC
- QNAP TS-119 Version 4.1 RC
-
- Starting out
- Posts: 13
- Joined: Sat Aug 30, 2008 4:51 am
Re: phpmyadmin password
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?
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?
-
- Starting out
- Posts: 13
- Joined: Sat Aug 30, 2008 4:51 am
Re: phpmyadmin password
Solved
Leave the password blank
Leave the password blank
- fribse
- Experience counts
- Posts: 2090
- Joined: Mon Feb 11, 2008 2:50 am
- Location: Greve, Denmark
- Contact:
Re: phpmyadmin password
If you loose the password, you can reset it via the adminwebinterface.
Oh, and remember to set the password if you have it blank
Oh, and remember to set the password if you have it blank
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
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
-
- First post
- Posts: 1
- Joined: Wed Sep 21, 2011 10:04 pm
Re: phpmyadmin password
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
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
-
- Getting the hang of things
- Posts: 80
- Joined: Sat Aug 01, 2009 6:11 am
Re: phpmyadmin password
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:
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?
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
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.Login without a password is forbidden by configuration (see AllowNoPassword)
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?
-
- Getting the hang of things
- Posts: 80
- Joined: Sat Aug 01, 2009 6:11 am
Re: phpmyadmin password
Still not letting me in after a removal and reinstall of phpMyAdmin...same errors.
-
- Getting the hang of things
- Posts: 80
- Joined: Sat Aug 01, 2009 6:11 am
Re: phpmyadmin password
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';
-
- New here
- Posts: 3
- Joined: Tue May 28, 2013 2:57 am
Re: phpmyadmin password
*snip*
See reason attached to post.
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
Reason: Removed for destructive nature of the method used
- doktornotor
- Ask me anything
- Posts: 7472
- Joined: Tue Apr 24, 2012 5:44 am
Re: phpmyadmin password
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.
Moderators, lock the corpse please. Doing more harm than good with random "advise" on "fixing" the issue.
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!
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!