Create Database

Last login: Sat Jan 18 16:13:31 on ttys000
docm7155:~ co304so$ ssh co304so@igor.gold.ac.uk
co304so@igor.gold.ac.uk's password: 
Last login: Sat Jan 18 16:19:17 2014 from 158.223.57.155
---------------GOLDSMITHS COLLEGE DEPARTMENT OF COMPUTING---------------
                          (_) ___   ___  _ __
                          | |/ _ \ / _ \| '__|
                          | | (_) | (_) | |
                          |_|\__  |\___/|_|
                             |___/
    Email enquiries regarding this server to sysadmin@doc.gold.ac.uk
------------------------------------------------------------------------
*  NOTE: Host igor has a new operating system running on new hardware  *
*  Please notify sysadmin@doc.gold.ac.uk if you discover any problems  *
------------------------------------------------------------------------
[co304so@igor ~]$ mysql -h igor -u co304so -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 372981
Server version: 5.1.71 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database co304so_LondonCrime;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+---------------------+
| Database            |
+---------------------+
| information_schema  |
| co304so             |
| co304so_2           |
| co304so_LondonCrime |
| co304so_crimestats  |
| co304so_webdb       |
| test                |
+---------------------+
7 rows in set (0.18 sec)