Create a database: (Creates directory /var/lib/mysql/databasename)
[prompt]$ mysqladmin -h localhost -u root -ppassword create databasename
(or use SQL command: CREATE DATABASE bedrock;)
Add tables, data, etc:
Connect to database and issue the following SQL commands:
[prompt]$ mysql -h localhost -u root -ppassword
…
mysql> use databasename; - [...]