Page 1 of 1

Using Phpmyadmin > cannot login due to Error 1045 - acces

Posted: Thu Dec 11, 2003 1:40 am
by tekquest
Hi guys,

I recently installed mysql and installed phpmyadmin into my document root directory for apache.

When I open the browser to my phpadmin page (http://192.168.2.15/phpmyadmin/index.php) I get the following error:

Error
MySQL said:
#1045 - Access denied for user: 'root@localhost' (Using password: NO)

I can access the mysql database from "mysql control centre" and modify tables etc.

I have read extensively about modifying the config.inc.php file to include the root password / username, but after my attemps to put the admin user and password on every like it requests a password, it still returns the above error message.

Does anyone have a working Phpmyadmin config file they could post? (quote out your passwords of course), I cant find any examples from searching.

I would appreciate any input anyone might be able to give.

Thanks for reading,

Luke.

Posted: Thu Dec 11, 2003 2:33 am
by twigletmac
Which type of authenticaiton are you using for phpMyAdmin? config, cookie or auth?

Mac

Posted: Thu Dec 11, 2003 5:09 am
by tekquest
Hi!

Thanks for your reply, I believe it mentioned I could use "http, auth or cookie" and I choose Http, should I be using auth?

Posted: Sun Dec 14, 2003 7:15 pm
by tekquest
got it!

changed it to http under the line:

$cfg['servers'][$i]['auth-type'] = 'http';

works and I can see the phpmyadmin pages! :-D