phpmyadmin login failed

S

searching

Verified User
Joined
Nov 12, 2004
Messages
46
Hi there,
I've problem to login to my phpmyadmin. Earlier when I changed my hosting login details, the phpmyadmin login details also automatically changed. But today I can't login due to invalid password. I'm pretty sure that the login details is automatically changed once I've changed the hosting login details.

Please assist
 
phpMyAdmin should be using the username and passwords from the MySQL database. You should be able to login with your primary username and password that you use to login to DirectAdmin. Can you login to DA? and using the same un/pw does not work in phpMyAdmin?
Do any other MySQL accounts (if any) work?
 
That's why I'm wondering right now as I can't login using the the same un/pw in DA. It seems now if I changed any user password, the phpmyadmin password doesn't changed. Therefore I do not know how to login the phpmyadmin as I forgot the earlier password. I just know the DA login but from there I can see anywhere to edit the phpmyadmin password.

I'm pretty sure that earlier whenever I changed the user password in DA, the phpmyadmin password will also changed based on the new user pasword. But it falied right now. Maybe this is a new bugs in DA.

I hope DA staff can look into it.
 
I'm not sure what version of MySQL but it was installed by DA staff sometime in May 2004.

Of course I changed password using the DA panels. ie once login, i click the password icon on the top right which has 2 icons ie SIGN OUT - PASSWORD - HELP (The default skin).

I'll check what version of MySQL.

Thanks for the assistance.

Regards
 
From the php info page, I saw a report on Client API version : 3.23.49. I think that's the MySQL version. My phpmyadmin version is 2.5.4.

Regards
 
When I click the system / services info at the reseller panel, the MySQL version is 4.0.14 and it's running.

Regards
 
But all the while since May 2004, it works fine with this MySQL & phpmyadmin version as I never upgrade them but seems it has problem now.

Regards
 
jmstacey said:
You are not using Mysql 4.1.x
You might give this a try. If the MySQL password was changed outside of DirectAdmin it might not be able to login and make the necassary changes which is why the password isn't changing as it should.

http://help.directadmin.com/item.php?id=45
Click to expand...

I've check the link above but it's an error on MySQL: Access denied for user.....

But this case is denied by phpmyadmin due to wrong password. mySQL seems working fine for other user account.

I wonder what was wrong with it as it never been upgraded since May 2004 which was installed by DA staff. I think it's a bugs or maybe my freeBSD server is attacked by virus etc.

Regards
 
phpmyadmin login failure workaround

I too have suffered from this problem a number of times, and have found that creating three databases for the user that cant login (you may have to allow them to create 3 from reseller/admin level) i have always been able to login.

Once you have logged in once, the problem never returns and you can delete the databases again.

I have no idea why creating more databases works and can only think of 2 possible reasons why:
a. the time taken for me to create 3 databases for the user is the time needed for directadmin and phpmyadmin databases to become sycronised
b. creating an extra database has causes a bit of script to run enabling the user to logon.
Neither of these seems plausable, but its the best I can do!

Andy
 
Hi Andy,
My problem is already solved. I let someone to handle the phpmyadmin from outside DA ie using the mySQL root access and fixing the issue.

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