All Help Appreciatted
CHANGING MYSQL USERNAME AND PASSWORD
Moderator: General Moderators
CHANGING MYSQL USERNAME AND PASSWORD
How do you change the MYSQL default username and password for a localhost?
All Help Appreciatted
All Help Appreciatted
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
If it's on your own machine then do this in a console window or command prompt.
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 -p
mysql> Password: *******
mysql> set password=password("e;your new password here"e;);
mysql> exit;
-bash $ _Code: Select all
-bash $ mysql -u username -h the_url_of_the_server.com -p
mysql> Password: *******
mysql> set password=password("e;your new password here"e;);
mysql> exit;
-bash $ _