TechieDan

I’ve been using mysql for quite some time, and ever then after I shifted to a work place which uses msSQL, I felt that I’ve neglected mySQL for awhile. Basically one main question I had previously and just recently asked by my colleague is to how to change the root user password?

Here I will teach you what I usually use which is the mysql command line.

Login to mysql server using the following command prompt

$ mysqladmin -u root -p

In mysql prompt, select database mysql

mysql> use mysql;

Now update your root password by putting a new password in the NEWPASSWORD part

mysql> update user set password=PASSWORD(”NEWPASSWORD”) where User=’root’;

Finally you’ve completed the step. Oh one more final step.

mysql> flush privileges;

Now try quit the mysql command line, and relogin again using the new password. Congrats, your root has a new password

I’ve been paged by relatives and even friends as to help them clean their viruses and advertisements that pop up while they’re surfing the internet. Some even have problem deleting a certain file which actually seem malicious. Why do all these things happen? Well, they happen so that people like me can earn money through it?? Hahaha.. not really.

I’m going to give some pointers as to what one should do!

1. Do not simply click links that may deem unnecessary which have tag lines like “I love my body, come take a look” - MSN virus
2. For doing transaction online, make sure that connection is from a secured connection. Look for the url with https://
3. Never click redirection links from an email to the login page of transaction site. They might be phsing the current site to get your information.
4. Always Always install an antivirus, if you need a free one get either AVG or Avast or the many other choices out there.
5. If you have an antivirus, please update your virus definition file so it keeps up to date to the latest attack and viruses.
6. Use Firefox if you need to for better security. Well, if you want to avoid the target of many hackers who tried to find a loophole in Microsoft Products, ie : Internet Explorer.

Ok then, maybe this points might not be enough, but at least it’ll help in a certain way. So whatever, think wisely.