Quickly Lock down MySQL
There is a fantastic little script that comes with modern distributions of MySQL., called mysqlsecureinstallation to run it just for the following:
Note: you will need to know the root password for MySQL.
sudo mysql_secure_installationIt will first ask you if you want to change your root password.
then it will ask 3 great questions that the answer will for the most part be yes to.
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Reload privilege tables now? [Y/n] yYour more secure easy wasn't it!?!?
Written by Josh Beauregard
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mysql
Authors
Did you know?
Most application security programs still stop at the repository. The page a visitor loads can run third-party scripts that read the DOM, change a checkout, or steal a session after the deploy already looks clean.
Security insights from Cside
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#