LB1234
asked on
#1045 - Access denied for user 'root'@'localhost' (using password: NO) - please help
I'm EXTREMELY new to MySQL. I just installed a wamp server on my windows 7 machine as instructed. Everything else works but this Myphpadmin. I'm getting this error but have no idea how to fix it. Please assist. Thanks!
ASKER
( ! ) Warning: mysql_connect() [function.mysql-connect]: Access denied for user '??'@'localhost' (using password: YES) in C:\wamp\www\php_sandbox\te
Call Stack
# Time Memory Function Location
1 0.0020 676512 {main}( ) ..\test.php:0
2 0.0020 677600 mysql_connect ( ) ..\test.php:40
NO DB CONNECTION:
1045 Access denied for user '??'@'localhost' (using password: YES)
( ! ) Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in C:\wamp\www\php_sandbox\te
Call Stack
# Time Memory Function Location
1 0.0020 676512 {main}( ) ..\test.php:0
2 0.0091 678112 mysql_select_db ( ) ..\test.php:48
NO DB SELECTION:
1045 Access denied for user '??'@'localhost' (using password: YES)
NO DATA BASE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Marqus, but at no point did i set a username or password (nor was i prompted for one during the WAMP installing). It was all next > next > finish basically.
Here's what i have for the lines you mentioned. If I enter something for username and password, what should it be? As mentioned, there won't be any corresponding values elsewhere.
$cfg['Servers'][$i]['user' ] = 'root';
$cfg['Servers'][$i]['passw ord'] = '';
$cfg['Servers'][$i]['Allow NoPassword '] = true;
Here's what i have for the lines you mentioned. If I enter something for username and password, what should it be? As mentioned, there won't be any corresponding values elsewhere.
$cfg['Servers'][$i]['user'
$cfg['Servers'][$i]['passw
$cfg['Servers'][$i]['Allow
Well. Can you access to phpMyAdmin and open Privileges tab? If yes, do it and check values you find there and tell me about, please.
ASKER
I don't know what's happened but it works now :(
I didn't do anything, but I wish i knew what the resolution was.
Thanks all for your help!
I didn't do anything, but I wish i knew what the resolution was.
Thanks all for your help!
Something it happens... :-) Good luck with your project.
Regarding the post at ID:36536672... You got this message:
1045 Access denied for user '??'@'localhost' (using password: YES)
See lines 21-25 of the script. You might want to put your own credentials in there.
1045 Access denied for user '??'@'localhost' (using password: YES)
See lines 21-25 of the script. You might want to put your own credentials in there.
Thanks for points, but since I have not solved your problem you can consider to request attention of a moderator to change your decision and split points between me and Ray. I have to notice that in your original question you got error saying 'using password: NO' and later you got an error saying 'using password: YES': this sounds strange to me...
Open in new window