phpMyAdmin connect problem

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I am trying to use phpMyAdmin but not getting past the start up screen.

I am getting the following error:

#1045 Access denied for user: root@localhost (Using Password: NO)

I have went through  to ensure that I have entered the
correct host, username and password. It is the part in the error
message, 'Using password: NO', that I dont understand. How do I
configure it to use passwords if that is the problem?

Does anybody recognise this problem, it would be great to hear.



Re: phpMyAdmin connect problem

I'd also like to add that I am using Apache, PHP and MySQL from my home
computer. It is a pretty default installation of all.


Re: phpMyAdmin connect problem wrote:
Quoted text here. Click to load it

There are two passwords - see your file and look for the entires:

$cfg['Servers'][$i]['controlpass']   = '';    // access to the "mysql/user"
                                               // and "mysql/db" tables).
                                               // The controluser is also
                                               // used for all relational
                                               // features (pmadb)
$cfg['Servers'][$i]['password']      = '';    // MySQL password (only needed

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

Re: phpMyAdmin connect problem

On 25 Aug 2005 16:03:26 -0700, wrote:

Quoted text here. Click to load it

First check your file to see what type of authentication is
used. look for $cfg['Servers'][$i]['auth_type'] you have three to choose
from, HTTP, cookie or config.

Because if you use HTTP or cookie authentication you don't need to put your
user/password in the file. you enter it when you start up

If you use the config method you only need to enter your user/pass into the
following two fields $cfg['Servers'][$i]['user']= '';  
$cfg['Servers'][$i]['password'] = '';
Check that the input is *Between* the two single quotes, I spent ages the
first time I set this up because I had brain fade and  thought that they
were a single double quote :-0.

The other two areas that ask for authentication
$cfg['Servers'][$i]['controluser']   = '';  
$cfg['Servers'][$i]['controlpass']   = ''; are only needed to open up
further features in phpMyadmin, check the documentation that comes with the
program to see if you want this activated, because if you do, you will need
to follow the instructions provided to create a number of tables.

Site Timeline