how to reset mysql root password:

Have you ever forgotten the root password on one of your MySQL servers? No? Well maybe I’m not as perfect as you. This is a quick h00tow (how to) reset your MySQL root password. It does require root access on your server. If you have forgotten that password wait for another article. Original article posted on reset mysql root password.

First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.

mysqld_safe –skip-grant-tables

You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.

mysql –user=root mysql

update user set Password=PASSWORD(’new-password’) where user=’root’;
flush privileges;
exit;

Now kill your running mysqld, then restart it normally. You should be good to go. Try not to forget your password again.

How to remove Autorun.inf Virus:

Ever wonder why your Anti Virus detects a virus in your autorun.inf whenever you insert your removable disk (USB, flash drive,et.) but it can’t disinfect it nor delete it or if you’re having a hard time accessing drives? Tried deleting it manually but you can’t find the file?

Autorun.inf is hidden and it can’t be remove or disinfected by Anti virus. And you try finding the autorun.inf file but failed even if you select to show all files from folder option?

Here’s what you need to do…

1. Boot your system in Safemode
2. Open your flash drive via Command
   Prompt (do this via Start->Run->cmd.exe).
3. Change your logged drive to your USB Flash drive (e.g. if your flash drive is
   at drive E: then type E: on the command
   prompt then press enter)
4. Type ATTRIB -H -R -S AUTORUN.INF then press enter
5. type in “del autorun.inf” then press [Enter]

After reboot, you can now access your drive.