RE: Really need help ! disabled my root connection !!! - Ismaël Touama - com.mysql.lists.win32

5 messages in com.mysql.lists.win32RE: Really need help ! disabled my ro...

From	Sent On	Attachments
Ismaël Touama	19 Oct 2001 08:17
BARTLETT, RICK	19 Oct 2001 14:42
Arjen G. Lentz	21 Oct 2001 18:37
Ismaël Touama	22 Oct 2001 01:34
Ismaël Touama	22 Oct 2001 01:49

Subject:	RE: Really need help ! disabled my root connection !!!
From:	Ismaël Touama (isma...@install.fr)
Date:	10/22/2001 01:49:20 AM
List:	com.mysql.lists.win32

sorry for previous message, forgot my one !! ;op... so :

thanks a lot for all the answer... I used Guillaume method... I should heve been thonking it was an host problem... However I don't understand why my both 'root' haven't been changed..?

Thx again,

Best Regards, ism

-----Message d'origine----- De : webm...@w3space.com [mailto:webm...@w3space.com] Envoyé : vendredi 19 octobre 2001 19:47 À : Ismaël Touama Objet : Re: Really need help ! disabled my root connection !!!

Salut Ismael

t'es en localhost ou depuis un client ?

essaie

UPDATE User SET Password="tonpwd" WHERE User='root' AND Host='%';

puis

UPDATE User SET Password="tonpwd" WHERE User='root' AND Host='localhost';

reflush

Hi list,

feel kind of stupid... I intended to change my root password via mysqlfront... flushed tables logs and priviliges, diconnect and then cannot connect myself as root !!!

following queyr was taped : UPDATE User SET Password=PASSWORD('pasSlike(this)4') WHERE User='root'

Where is the problem ? Thanks for any help !!!

ism