This is a short memo on how to install and work on MySQL databases under a Debian Linux compatible OS.

sudo apt-get install mysql-server

mysqladmin -u root create <databasename>

mysql -u root <databasename> < sqlcommands.sql

Where mysqlcommands.sql is a file that contains sql queries for modifying the database.

If you are running PHP you will also need to install the php module for mysql :

sudo apt-get install php5-mysql

Labels: unix, coding