creating a bash script to create database and user automatically

Question

Hi I am trying to create a bash script, which take username and database name and password as in arguments and create a database.

mysql -u xxx -pxxxxxx  << EOF
CREATE DATABASE '$2';
CREATE USER '$2'@'localhost' IDENTIFIED BY '$3';
GRANT ALL PRIVILEGES ON '$2'.* TO '$2'@'localhost';
EOF

I am getting mysql 1064 error while executing this command.

Any help will be appreciated.

Thanks

bhrached · Accepted Answer · 2016-02-25 08:56:00Z

2

 mysql -u $user -p$pass  << EOF
CREATE DATABASE $2;
GRANT ALL PRIVILEGES ON $2.* TO $2@'localhost' IDENTIFIED BY '$3';
 EOF

answered Feb 25, 2016 at 8:56

bhrached

1371 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bozdoz · Accepted Answer · 2017-06-16 00:21:40Z

2

The answer here did not work for me (got a number of syntax errors, including the same 1064 error as the OP). Posting this in case it helps someone else:

#!/bin/bash

echo "mysql root password:"
read rootpass

if [[ $rootpass ]]; then
    # create db
    # create user
    mysql -uroot -p$rootpass <<EOF
CREATE DATABASE \`${1}\`;
CREATE USER $1@localhost IDENTIFIED BY '$1';
GRANT ALL PRIVILEGES ON \`${1}\`.* TO \`${1}\`@'localhost';
EOF

fi

Seems like some statements required quotes, some escaped, some none at all! :D

answered Jun 16, 2017 at 0:21

bozdoz

12.9k8 gold badges74 silver badges100 bronze badges

Collectives™ on Stack Overflow

creating a bash script to create database and user automatically

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related