| by Scott Kilroy

Basic MySQL Security

After installing MySQL Set the root passwoord using mysqladmin -u root password new-password login as root and run the following comands drop database test; use mysql; delete from db; delete from user where not (host=”localhost” and user=”root”); flush privileges;

Share Button
Read More
| by Scott Kilroy

Optimize and repair all mysql tables

mysqlcheck -o -u root -p –all-databases

Share Button
Read More
| by Scott Kilroy

Reset the mysql root password

Stop the mysql daemon Restart mysql using the command mysqld_safe –skip-grant-tables Now you should be able to connect as root Once connected run the following: update user set Password=PASSWORD(‘new-password’) where user=’root’; then flush privileges exit mysql restart mysql and you should be able to login with the new password

Share Button
Read More