How to create a database from shell command

Question

I m looking for something like createdb in PostgreSQL or any other solution that would allow me to create database with a help of a shell command  Any hints

User · Answer

You mean while the mysql environment   create database testdb    Or directly from command line   mysql -u root -e  create database testdb

User · Answer

Use    mysqladmin -u  lt db user name gt  -p create  lt db name gt    You will be prompted for password  Also make sure the mysql user you use has privileges to create database

User · Answer

mysqladmin -u USER -p PASSWORD create  DB NAME   Replace above variables and you are good to go with this oneliner   USER is the username   PASSWORD is the password and  DB NAME is the name of the database

User · Answer

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  database-name     mysql -u username -p   If you really only want to create a database

User · Answer

Connect to DB using base user     mysql -u base user -pbase user pass  And execute CREATE DATABASE  CREATE USER and GRANT PRIVILEGES Statements   Here s handy web wizard to help you with statements www bugaco com helpers create database html

User · Answer

You can use SQL on the command line   echo  CREATE DATABASE dbname     mysql  lt     gt    Or you can use mysqladmin   mysqladmin create dbname

User · Answer

The ist and 2nd answer are good but if anybody is looking for having  a script or  If you want dynamic i e  db username password in variable  then here      bin bash    DB  mydb  USER  user1  PASS  pass bla   mysql -uroot -prootpassword -e  CREATE DATABASE  DB CHARACTER SET utf8 COLLATE utf8 general ci   mysql -uroot -prootpassword -e  CREATE USER  USER  127 0 0 1  IDENTIFIED BY   PASS    mysql -uroot -prootpassword -e  GRANT SELECT  INSERT  UPDATE ON  DB   TO   USER   127 0 0 1

User · Answer

If you create a new database it s good to create user with permissions only for this database  if anything goes wrong you won t compromise root user login and password   So everything together will look like this   mysql -u base user -pbase user pass -e  create database new db  GRANT ALL PRIVILEGES ON new db   TO new db user localhost IDENTIFIED BY  new db user pass     Where  base user is the name for user with all privileges  probably the root  base user pass it s the password for base user  lack of space between -p and base user pass is important  new db is name for newly created database new db user is name for the new user with access only for new db new db user pass it s the password for new db user

[mysql] How to create a database from shell command?

Examples related to mysql

Examples related to shell

Examples related to command-line