Using Phpmyadmin > cannot login due to Error 1045 - acces

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
tekquest
Forum Newbie
Posts: 3
Joined: Thu Dec 11, 2003 1:40 am

Using Phpmyadmin > cannot login due to Error 1045 - acces

Post 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.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Which type of authenticaiton are you using for phpMyAdmin? config, cookie or auth?

Mac
tekquest
Forum Newbie
Posts: 3
Joined: Thu Dec 11, 2003 1:40 am

Post 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?
tekquest
Forum Newbie
Posts: 3
Joined: Thu Dec 11, 2003 1:40 am

Post 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
Post Reply