MySQL Password Change From PHPMyAdmin? *Found It*

wpearsall · Oct 21st, 2002, 06:42 PM

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 · Oct 22nd, 2002, 03:24 PM

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 · Oct 22nd, 2002, 03:40 PM

Quote:

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 · Oct 22nd, 2002, 03:47 PM

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

wpearsall · Oct 22nd, 2002, 03:54 PM

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 · Oct 22nd, 2002, 04:00 PM

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

wpearsall · Oct 22nd, 2002, 04:09 PM

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 · Oct 22nd, 2002, 04:12 PM

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 · Oct 22nd, 2002, 04:18 PM

Oh NM, Found it (On the front page

)

: Changed it about i guess

-- Gotta log in as my new user to change the password now

wpearsall · Oct 22nd, 2002, 04:21 PM

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

phpman · Oct 22nd, 2002, 04:23 PM

hey cool, I might have to upgrade

Oct 21st, 2002, 06:42 PM	#1
wpearsall Frenzied Member Join Date: Feb 02 Location: England / UK Posts: 1,052	MySQL Password Change From PHPMyAdmin? Found It 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 __________________ Wayne Last edited by wpearsall; Oct 22nd, 2002 at 04:23 PM.

Oct 22nd, 2002, 03:54 PM	#5
wpearsall Frenzied Member Join Date: Feb 02 Location: England / UK Posts: 1,052	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 __________________ Wayne

Oct 22nd, 2002, 04:09 PM	#7
wpearsall Frenzied Member Join Date: Feb 02 Location: England / UK Posts: 1,052	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" ) Attached Images __________________ Wayne

Oct 22nd, 2002, 04:18 PM	#9
wpearsall Frenzied Member Join Date: Feb 02 Location: England / UK Posts: 1,052	Oh NM, Found it (On the front page ) : Changed it about i guess -- Gotta log in as my new user to change the password now Attached Images __________________ Wayne

Oct 22nd, 2002, 04:21 PM	#10
wpearsall Frenzied Member Join Date: Feb 02 Location: England / UK Posts: 1,052	Ahhh, and "Users" too, : Gotta do it from the main page now i guess __________________ Wayne

Oct 22nd, 2002, 03:24 PM	#2
phpman Frenzied Member Join Date: Nov 99 Posts: 1,089	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.

Oct 22nd, 2002, 03:47 PM	#4
phpman Frenzied Member Join Date: Nov 99 Posts: 1,089	why do you need your old version? can't remeber your password? :P

Oct 22nd, 2002, 04:00 PM	#6
phpman Frenzied Member Join Date: Nov 99 Posts: 1,089	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

Oct 22nd, 2002, 04:12 PM	#8
phpman Frenzied Member Join Date: Nov 99 Posts: 1,089	ahh I might have to look on mine at home and see if I have the samething. never really paid much attention to that.

Oct 22nd, 2002, 04:23 PM	#11
phpman Frenzied Member Join Date: Nov 99 Posts: 1,089	hey cool, I might have to upgrade

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode