Page 1 of 1

CHANGING MYSQL USERNAME AND PASSWORD

Posted: Wed Jun 01, 2005 6:56 am
by Parody
How do you change the MYSQL default username and password for a localhost?

All Help Appreciatted

:D :D :D :D :D :D :D :D :D

Posted: Wed Jun 01, 2005 7:45 am
by shiznatix
goto your cpanel, your host probebly gave you that, then just goto mysql and change it

Posted: Wed Jun 01, 2005 8:43 am
by Chris Corbyn
If it's on your own machine then do this in a console window or command prompt.

Code: Select all

-bash $ mysql -u username -p
mysql> Password: *******
mysql> set password=password(&quote;your new password here&quote;);
mysql> exit;
-bash $ _
and if you're talking about a database on your hosts server elsewhere do this on your own machine....

Code: Select all

-bash $ mysql -u username -h the_url_of_the_server.com -p
mysql> Password: *******
mysql> set password=password(&quote;your new password here&quote;);
mysql> exit;
-bash $ _
:wink: