From: <[EMAIL PROTECTED]>
> i have a simple question. how can i change mysql root password? if i
> change it using winmysqladmin.exe, and changing it in my.ini, nothing
> happens. i can change passwords using phpmyadmin, but i would like to
> change it without it.
Do you have access to the MySQL default client?
If so, log in and use the following:
SET PASSWORD FOR user@host = PASSWORD('newpassword');
--
Mike Johnson . : . : . AIM: denonymous
http://www.coldcircuit.net ' : ' : ' http://65.96.177.11
"According to one of our readers, the new MacOS X contains another
Satanic holdover from the 'BSD Unix' OS mentioned above; to open up
certain locked files one has to run a program much like the DOS
prompt in Microsoft Windows and type in a secret code: 'chmod 666'."
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php