Ubuntu 10.10 Pentax K-5

Sunday, September 18, 2011

MySQL UDF Execution - strong password

For mysql 5.5.8 or earlier on Windows, there is such danger about "User-defined-functions" execution.

So help, there is a need to 
1. Ensure the password is strong
2. Delete the "root" account for hostname "%" (i.e. others cannot use "root" account at other host)

A good habit:
1. Create new user privilege only on specific database it belongs to.
2. Have a strong password for the user account

What is a strong password:
Hint:
  • It needs to contain special characters such as @#$%^&
  • It must be at least 8 characters long.
  • It must not have any common words such as 123, password, your birth date, your login name and any words that can be found in the dictionary.
  • a variation of capitalization and small letters

Todo:
1. A password manager is needed to remember for you.

No comments: