phpMyAdmin - Login Refuses to work

J

jamie471

Verified User
Joined
Apr 12, 2005
Messages
12
Location
United Kingdom
im having problems getting phpMyAdmin to work under any of the domains on my server. It loads up the password box and no matter what username/password I try it will not login. I have tried with the user account username/password as well as with the root user/pass.

Does anyone have an example of the configuration files needed to setup phpmyadmin correctly with da?

thanks in advance
 
I have tried it with both Firefox and Internet Explorer but the result is the same, it just spits out "Wrong username/password. Access denied." after a number of login attempts. It does this constantly no matter which logins I try and I cant figure it out :|
 
phpmyadmin uses "http" authentication by default, so unless you've changed this, it will authenticate against actual mysql users. This is set in the config.inc.php file in phpmyadmin.

So, any DA user that has created a mysql database should be able to login with their DA user/password. Additionally, you should be able to use the username/password that you specified when you created the database.

You should also be able to use the credentials in /usr/local/directadmin/conf/mysql.conf.
 
ballyn said:
phpmyadmin uses "http" authentication by default, so unless you've changed this, it will authenticate against actual mysql users. This is set in the config.inc.php file in phpmyadmin.

So, any DA user that has created a mysql database should be able to login with their DA user/password. Additionally, you should be able to use the username/password that you specified when you created the database.

You should also be able to use the credentials in /usr/local/directadmin/conf/mysql.conf.
Click to expand...

I am trying it with the users directadmin logins and it just says access denied. Even with the credentials in /usr/local/directadmin/conf/mysql.conf it wont let me in. Have you got an example conf.inc.php file from phpmyadmin that is working ok on a directadmin server that I can look through?
 
Relevant setting is
Code: 
$cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?

This is really straight default settings from the distribution. DA will copy
Code: 
/usr/local/directadmin/data/templates/config.inc.php
into the directory if you use the phpMyAdmin.sh script supplied by DA.

You might want to re-run that script (change the VER to 2.6.2-rc1 and grab the tarball, dropping it into /usr/local/directadmin/scripts/packages/ if you want the latest) and then try again.
 
BTW, what version of mysql are you running?

I vaguely recall reading something about the controluser and controlpass under older versions of mysql, but I've never needed them.
 
I am using MySQL 4.0.23 and phpMyAdmin 2.6.2-rc1. Ive checked the settings against the ones you posted above but the result is still the same - "Wrong username/password. Access denied." when trying the users DA user/pass.

Is there anything else which could be causing this problem? I really am stumped to why I cant get this to work at all :S
 
Just to make sure, MySQL is running and can be accessed by other scripts and command line?

Has it ever worked? If so, what is the last few things you did before it stopped working?

It could also be the localhost problem, you might try chaning the location from 'localhost' to 'http://127.0.0.1' in phpMyAdmin's configuration.
 
I am able to access mySQL from the command line, along with creating/removing databases and users from within DA.

I have changed the localhost to 127.0.0.1 but the result is exactly the same. I have not (as yet) managed to get phpMyAdmin to work since I got the server. When I first got the server, half of the essential deamons were missing (exim, proftpd, mysql) and it took me over 19 hours to get them installed and working. I guess its just my luck to get yet another server which hasnt been configured/installed correctly from the start :(
 
Ok, I have managed to get an install of phpMyAdmin "working". Looking around, there was two main version of config.inc.php of which v2.x is used for the newer versions. I have managed to get phpMyAdmin 2.5.6 installed and supposedly working with the old v1.x config file.

I have noticed what I think is a bug in DA though. When a user adds a database, it adds their DA username to the mysql users, but it doesnt add their DA password, it uses the password for the first database that they add instead. Is this a bug or is this intentional? Is there a way to set DA to create mysql user accounts with the same password as the user's DA account?


EDITED:

I have now got phpMyAdmin up and running ok (took a lot of editing of the config.inc.php script). However, the password set by DA for the user's login is not the one set for their DA account. It sets the password to whatever they set their newest database password to. I.E. user creates new database and database user, then their DA login to phpMyAdmin is changed to that new password. Is there a way to change this ?
I am going to try again with the latest release of phpMyAdmin and edit the config file to be similar to the old one and see if i can get it working.
 
Last edited:
i am having the same problum, oly mine isnt fixed but using the password from the first db made. i am really stumped also. help please.
 
John posted in another forum a day or so ago, exactly how mysql passwords work.

Possibly you should search for that post and see if your system works according to his explanation.

Jeff
 
You must log in or register to reply here.
Back
Top