MySQL Password Change From PHPMyAdmin? *Found It*

[wpearsall]

How do I change my MySQL Password in phpmyadmin?

I saw the button "Change User Password" not too long ago, but i upgraded my PHPMyAdmin, and i think its gone now :shrug:

phpMyAdmin 2.3.0-rc2

Tnx :)

[phpman]

I have 2.2.6 and it doesn't even have that. changing a mysql password is usually done on the server side. not sure if phpMyAdmin would have permisssions to that table.

[wpearsall]

Originally posted by phpman
I have 2.2.6 and it doesn't even have that. changing a mysql password is usually done on the server side. not sure if phpMyAdmin would have permisssions to that table.

Dammit, Guess im gonna have to look for my old version of PHPMyAdmin then :(

[phpman]

why do you need your old version? can't remeber your password? :P

[wpearsall]

no, i made an extra MySQL user, using Insert, and need to set a password for it,

But it isnt MD5 encryption (my other user passwords are only like14 & 15 characters long?)

so i dunno..

:shrugs:

And i have changed my "root" user password for host=% using phpMyAdmin, cant remember where it was, guess it mite be gone though :shrugs:

cuz i now have a Add feild drop down box, and didnt before :shrugs:

Lol, i'll figure it out some time ;)

[phpman]

if phpMyAdmin had rights to the users table for Mysql that could be devistating. you would beable to change all the users passwords with no problems. I really doubt you will find this function in phpmyadmin. phpmyadmin only has functions for the DB that are in it's field list, users not being one of them. so if you signed up as you login then you won't see it, I can't even see my users table when I signon as root. this is my home machine too so I have all the rights in the world.

if you find it let me know, I wanna see it :D

[wpearsall]

Well i am on root access, and have got all my databases listed?

(Well my Root user when i installed my MySQL, not looked if i can access as "root" with em all ;)) (The one which is in "my.ini" ;))

[phpman]

ahh I might have to look on mine at home and see if I have the samething. never really paid much attention to that.

[wpearsall]

Oh NM, Found it (On the front page ;))

: Changed it about i guess :D -- Gotta log in as my new user to change the password now :D

[wpearsall]

Ahhh, and "Users" too, : Gotta do it from the main page now i guess :D

[phpman]

hey cool, I might have to upgrade :)