Friday, June 6, 2008

Changing Mysql Password

Last day i lost my mysql password , so i had to uninstall the whole database server and reinstall, then going mysql site i found a way to change my pass word , hope this may help u

Let’s look at all the ways to change MySQL password, for root and other users:

In MySQL the default password is empty. This is inherently unsafe and should be immediately changed. Here is how you can change MySQL default root password:

mysqladmin -u root password NEWPASSWORD

Here is how you can change OLDPASSWORD to NEWPASSWORD


Replace LOGIN with your login name, OLDPASSWORD with your current password and NEWPASSWORD with the new password.


Varun Rathore

1 comment:

vrathore said...

Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

mysqlcheck is available in MySQL 3.23.38 and later.

About Me