How to create mysql database from shell command?

Question

I'm looking for something like createdb in psql or any other solution that would allow me to create databse with a help of a shell command. Any hints?

Answer 1

You can use SQL on the command line:

echo 'CREATE DATABASE dbname;' | mysql <...>

Or you can use mysqladmin:

mysqladmin create dbname

Answer 2

You mean while the mysql environment?

create database testdb;

Or directly from command line:

mysql -u root -e "create database testdb"; 

Answer 3

cat filename.sql | mysql -u username -p (type mysql password when asked for it.)

Where filename.sql holds all the sql to create your database. Or...

echo "create database databasename" | mysql -u -u username -p

if you really only want to create a database.