Changing da_admin password via phpMyAdmin

S

Strator

Verified User
Joined
Jan 19, 2011
Messages
250
Hi all,

I have tried to change the password for da_admin via phpMyAdmin, with the strange result that I can't log into phpMyAdmin with da_admin at all anymore. Not an immediate problem, because I still have the root login, but does anyone know why this isn't working as I expected?

Thanks!
 
Hi,

- I visit mysite.com/phpMyAdmin
- I log in as root (not sure if this is relevant, but that's what I do)
- I click on the "users" tab
- Beside the user da_admin, I click on "change rights" (or whatever it says in English)
- At the top, I click on "change password"
- I specify a new password (letters and numbers only) - I leave everything else unchanged, i.e. MySQL 4.1+ encryption
- phpMyAdmin confirms that the password for da_admin@localhost has been changed
- I log out and try logging in again as da_admin using the new password, but it doesn't work

This is phpMyAdmin 4.3.8 and mySQL 5.5.
 
I've followed your steps on

MySQL 5.5.43
PHP version: 5.3.29
phpMyAdmin 4.4.5

and I haven't run into the issue you are writing about.

Try to update phpMyAdmin to the latest and follow the steps once more.
And make sure you've got only one user da_admin. Though you may have several users there with the same name but different host (or empty host at all).
 
As it turns out, updating phpMyAdmin 4.3.8 -> 4.3.9 did the trick - I was able to log in again without further action (didn't even have to touch the password).

Thanks for the assistance and advice!
 
You must log in or register to reply here.
Back
Top