Monthly Archives: December 2010

Securing default MySQL installation

Usually a MySQL installation will also create some default databases. In case they don’t exist you can create the default databases by running this: mysql_install_db Setting a MySQL root password The most important thing is to ensure that all root … Continue reading

MySQL

MySQL commands – usually run from shell

Connecting to the server mysql -h localhost -u root The commands below asume the existance of the default databases. If this is not true take a look at securing a default MySQL installation. Selecting a specific MySQL database use database  … Continue reading

MySQL