Category Archives: MySQL

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

Installing MySQL

In order to install MySQL you need to install these: mysql mysql-server mysql-lib mysql-devel yum install mysql mysql-lib mysql-server mysql-devel After php and php-mysql are installed you may start MySQL: /etc/init.d/mysqld start And you should get this: PLEASE REMEMBER TO … Continue reading

MySQL