How do I create a shell script database?

How do you create a database in UNIX shell script?

You can use SQL on the command line: echo 'CREATE DATABASE dbname;' | mysql <...> Show activity on this post. Connect to DB using base user: mysql -u base_user -pbase_user_pass And execute CREATE DATABASE, CREATE USER and GRANT PRIVILEGES Statements.

How do I create a database using MySQL shell script?

Create a MySQL Database Using CLI1SSH into your server as root.2Log into MySQL as root: Copy. mysql -u root.3Create a new database user: Copy. GRANT ALL PRIVILEGES ON *. ... 4Log out of MySQL by typing: \q .5Log in as the new database user you just created: Copy. mysql -u db_user -p. ... 6Create a new database: Copy.

How do I create a shell script?

Let us understand the steps in creating a Shell Script:1Create a file using a vi editor(or any other editor). Name script file with extension . sh.2Start the script with #! /bin/sh.3Write some code.4Save the script file as filename.sh.5For executing the script type bash filename.sh.

How do I create a shell script in terminal?

Steps to write and execute a script1Open the terminal. Go to the directory where you want to create your script.2Create a file with . sh extension.3Write the script in the file using an editor.4Make the script executable with command chmod +x <fileName>.5Run the script using ./<fileName>.