473,322 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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

Hello All

I have successfully installed the following

IIS ver 6
php ver 4.4.9
MYSQL ver 5.0.67

when i tested through command line i get no error and i am view the php pages on the browser without any hitch. In the beginning when i was trying to connect to MYSQL through simple php script i was getting an authentication error which i could resolve by using OLD_PASSWORD.

Now during final stages ,
Now when i have installed phpMyAdmin ver 2.0.8.3and have also configured config.inc.php. There is persistent error i am getting which is something like

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


I have tried OLD_PASSWORD technique which won't work. I have almost wasted 2 days on this. Can someone really suggest how to come out of this and make phpMyAdmin work .
Oct 29 '08 #1
4 8294
SeeMe
18
hi,

you just blank the password. not need key in any password.
Oct 29 '08 #2
HI
Configuration in my conf.inc.php looks like this.

Expand|Select|Wrap|Line Numbers
  1. $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
  2. $cfg['Servers'][$i]['port']          = '3306';          // MySQL port - leave blank for default port
  3. $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
  4. $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
  5. $cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
  6. $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
  7.                                                     // (requires PHP >= 4.3.0)
  8. $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
  9.                                                     // (this user must have read-only
  10. $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
  11.                                                     // and "mysql/db" tables).
  12.                                                     // The controluser is also
  13.                                                     // used for all relational
  14.                                                     // features (pmadb)
  15. $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
  16. $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
  17. $cfg['Servers'][$i]['password']      = 'password';          // MySQL password (only needed
  18.                                                     // with 'config' auth_type)
  19.  
Blanking the password does,nt do any good to me. I still get the same error. User is root and Password is password in my configuration. through command line everything is ok.

pearl
Oct 29 '08 #3
hi,

you just blank the password. not need key in any password.
It's not helping that way..thanks though for early response..any other way out.
Oct 29 '08 #4
dlite922
1,584 Expert 1GB
It's not helping that way..thanks though for early response..any other way out.
can you "ping localhost" from the command line.

If it's Linux, you may not have localhost set as a host name.



Dan
Oct 30 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Henke | last post by:
I added a project to my solution that contains a user control. Now I 'd like to add the user control from that project to a form in my solution. The problem is that the control doesn't gets added...
4
by: babylon | last post by:
I created a class which inherits from UserControl.. However, I can't find it in the "My User Controls" tab in designer view... How can i add it back myself? thx...
1
by: Rene Blom | last post by:
Hello, i am trying several times to get my access '97 D-base in a access 2002 D-base but every time I get a mention that the D-bade is closed en wil be repared. Help please
2
by: Lin DeNoyer | last post by:
I am so mad at microsoft right now! They just told me - 10 days after I placed my order for an upgrade to Office 2003 Pro - that they canceled the order because the credit card info didn't match...
2
by: Charles | last post by:
Hello, I am in ASP.NET using C#. I have a user control called "progHeader.ascx" that has a label control call "pageTitle". How do I call "pageTitle" from my asp page(Inventory.aspx), with the...
2
by: ALI-R | last post by:
Hi I've created a bunch user comtrols for the footer,header,navigation bar of a webpage ,I have two problems: 1) All the controls are in the folder "Control" of the root and all the images...
8
by: David Lozzi | last post by:
Howdy, I have a user control that is a report to display data. On the page the control is inserted in, I have filter options to filter the report. When I try to do something like this, nothing...
4
by: Michael Turner | last post by:
Hi I have just added an existing project containing user controls into another solutions now they dont appear in 'my user controls' any idea why this is? I have tried building the solution. ...
1
by: Ellis Yu | last post by:
Dear all, I write my own components for my project and add them in "My User Control" under the toolbar. Some time later, I make some other new components into it and want to use them in my...
2
by: Nathan Sokalski | last post by:
When I put my *.ascx files in the same directory as Web.config and my user controls are registered in Web.config it gives me an error. Putting my *.ascx files in another directory is not hard, but...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.