MariaDB create database via CLI

Question

How do I issue commands to MariaDB via the CLI without actually jumping into the interactive use mode?

I know I can type mysql which will then jump me into the interactive mode where I can write SQL commands like CREATE DATABASE dbname; and then exit to go back to the regular terminal.

However I'd like to skip that and do something like mysql 'CREATE DATABASE dbname;' all in one line.

Only trivially -- You would not need to go in and out of mariadb. — Rick James, Aug 25 '20 at 14:45
The canonical question (MariaDB's and MySQL's should be sufficiently compatible): *[How do I import an SQL file using the command line in MySQL?](https://stackoverflow.com/questions/17666249/)* (62 answers (incl. deleted)) — Peter Mortensen, Sep 19 '21 at 15:49
Does this answer your question? [How do I import an SQL file using the command line in MySQL?](https://stackoverflow.com/questions/17666249/how-do-i-import-an-sql-file-using-the-command-line-in-mysql) — Peter Mortensen, Sep 19 '21 at 15:51

score 4 · Accepted Answer · edited Oct 05 '21 at 19:18

4

mysql --help | grep "\-execute"

Output:

-e, --execute=name Execute command and quit

So to create a database with command line client, you just need to execute

mysql -uuser -p -e"CREATE DATABASE dbname"

You can also concatenate several SQL statements, e.g.

mysql -uuser -p -e"CREATE DATABASE dbname;SHOW DATABASES"

edited Oct 05 '21 at 19:18

Peter Mortensen

30,738
21
105
131

answered Aug 24 '20 at 14:26

Georg Richter

5,970
2
9
15

score 0 · Answer 2 · answered Aug 24 '20 at 10:52

0

Put the commands that you want executed into a text file (optionally with a file extension of .sql) then, from the command line, do mysql -uuser -p < yourtextfile.sql to have all of the commands in the file executed.

answered Aug 24 '20 at 10:52

Dave

5,108
16
30
40

Is it possible to swap the text file for a quoted string like `mysql -user -p < 'create database dbname;'` ? – Royal Wares Aug 24 '20 at 13:30
Have you tried it? It doesn't work for me and you would still need to interact with it to supply the password. – Dave Aug 24 '20 at 14:07

MariaDB create database via CLI

2 Answers2