Free Ten MySQL Best Practices Tutorial

1. Set a password for the “root” user and then rename the user.The first thing you should do with a clean MySQL install is set a password for the root user:[01:19:00] george@firenze$ mysqladmin -u root password’somepassword’Once you’ve set the password, change the name of the “root” user to something else. A hack attempt on a MySQL server might target the one user that exists on most systems, “root”, both because it has superuser powers and because it is a known user. By changing the  
continue >>