How to run mysql command on bash

Question

The following code works on the command line  mysql --user  myusername  --password  mypassword  --database  mydatabase  --execute  DROP DATABASE myusername   CREATE DATABASE mydatabase     However  it doesnt work on bash file on excecution     bin bash user myusername password mypassword database mydatabase  mysql --user   user  --password   password  --database   database  --execute  DROP DATABASE  user  CREATE DATABASE  database     I receive the following error      ERROR 1045  28000   Access denied for user   user   localhost   using password  YES    How to make the bash file run as the command line

User · Answer

This one worked  double quotes when  user and  password are outside single quotes  Single quotes when inside a single quote statement   mysql --user   user  --password   password  --database   user  --execute  DROP DATABASE   user   CREATE DATABASE   user

User · Answer

Use double quotes while using BASH variables   mysql --user   user  --password   password  --database   database  --execute  DROP DATABASE  user  CREATE DATABASE  database     BASH doesn t expand variables in single quotes

User · Answer

I have written a shell script which will read data from properties file and then run mysql script on shell script  sharing this may help to others      bin bash     PROPERTY FILE filename properties      function getProperty          PROP KEY  1        PROP VALUE  cat  PROPERTY FILE   grep   PROP KEY    cut -d    -f2         echo  PROP VALUE            echo    Reading property from  PROPERTY FILE      DB USER   getProperty  db username       DB PASS   getProperty  db password       ROOT LOC   getProperty  root location       echo  DB USER     echo  DB PASS     echo  ROOT LOC     echo  Writing on DB           mysql -u DB USER -p DB PASS dbname lt  lt EOFMYSQL      update tablename set tablename value      ROOT LOC  where tablename name   Root directory location       EOFMYSQL     echo  Writing root location  ROOT LOC  is done           counter  mysql -u  DB USER  -p  DB PASS  dbname -e  select count    from tablename where tablename name   Root directory location  and tablename value      ROOT LOC      grep -v  count         if     counter     1        then     echo  ROOT location updated      fi

[mysql] How to run mysql command on bash?

Examples related to mysql

Examples related to bash

Examples related to unix

Examples related to terminal

Examples related to special-characters