~~NOTOC~~


====== How to create a new MySQL database in Debian/Ubuntu ======

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


===== Install MySQL server =====
<code>
sudo apt-get install mysql-server
</code>



===== Create a new MySQL database  =====
<code>
mysqladmin -u root create <databasename>
</code>

===== Working on MySQL databases =====
<code>
mysql -u root <databasename> < sqlcommands.sql
</code>

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


===== Other =====

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

<code>
sudo apt-get install php5-mysql
</code>

{{tag>unix coding}}


~~DISCUSSION~~