phpMyAdmin asking for username/password to load the page

[douglazb]

I have installed phpMyAdmin on Fedora 11 using YUM, along with MySQL, PHP and Apache.

The web and database servers are operating fine.

However, when loading the web page http://localhost/phpMyAdmin/ a box appears asking for a username and password.

I have tried many combination's including the root with no success. What value does it want, or what setting is wrong.

In studying the file httpd.conf in somehow loads the file phpMyAdmin.conf

The httpd.con reads:

<Directory "/var/www/html">
Options Indexes FollowSymLinks
AllowOverride None
Order allow,deny
Allow from all
</Directory>

The phpMyAdmin.conf reads:

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>
   order deny,allow
   deny from all
   allow from 127.0.0.1
   allow from 192.168.0.50
   allow from ::1
</Directory>

The static IP address for this computer is 192.168.0.50

So the page loads with the following statement:

Wrong username/password. Access denied.

I've searched and searched for a solution to this and cannot find one. Any suggestions?

Thanks in advance,

Douglas

[SteveGYBE]

Just a thought - it is asking for a MySQL user and password, not your Linux user and password. So what user do you supply when trying to run "mysql" from the command line? Although MySQL has a user called "root", it is not the same as your Linux "root" - it has its own user database.

[douglazb]

I agree with what you are saying. At this point, I have not assigned a password to the root user in the database, only the Fedora root user has a password. I tried the username root and leaving the password blank, that failed to work.

I think the error is with Apache, and it's permission setting to view the web page.

[BlueC]

No it's not an apache, it is asking for your mysql username and password which if you haven't set them up yet then you NEED to.

Tip: run "mysql_secure_installation" from the shell. It will help set up your initial mysql users and remove the unsafe default users. Once done, you can login to phpmyadmin using the user created when you run that script.

[douglazb]

Bingo! That was my error - all fixed - thank you very much! Problem solved.