Shahed's Blog

Being a full time .net developer, I do most of my database related development in SQL Server. I recently moved to WordPress which use MySql as database. When I was setting up my new blog, I found that MySQL is already installed there but the password is not mentioned anywhere in the hosting docs. Now, in SQL Server by default the windows authentication is enabled. So you can easily login and change the password for sa.

But, for MySQL I found this interesting way:

1. Go to Administrative tools -> Services and stop the ‘MySql’ service
2. From command prompt, run Mysql\bin\mysqld-nt.exe” -P3306 –skip-grant-tables
3. Open another command prompt and run mysql(\Mysql\bin\mysql.exe” -P3306 mysql)
4. Now you can update mysql.user table to change the password for admin.
   For ex: update mysql.user set password=password(’new_password’) where user=’admin’
5. Finally, you can close the prompts and kill the mysqld-nt.exe process from task manager and restart the service.