I was having trouble creating databases and their users with permission when automating with bash shell script. In this post, I will show you how to execute the mysql or mariadb command using bash shell script, as well as an alternate method.
Method 1: Using Bash shell
You need to use the following command in order to execute the mysql quiey.
mysql -h <host> -u<user> -p<password> database -e \ "SELECT * FROM table_name WHERE id='007';"
Single line command for bash shell
mysql -h <host> -u<user> -p<password> database_name_here -e "SELECT * FROM table WHERE id='007';"
Method 2: Using .sql file
.sql we can import the quiry using given command.
mysql -h "<host_ip_here>" "--user=<username_here>" "--password=<password_here>" "--database=<database_name_here>" < "filename.sql"
Or you can use the given command, “Recommend.”
mysql -h "host_ip_here" -u "username_here" -p "database_name_here" < "sqlfile.sql"
We have successfully execute the mysql quiiey in bash shell script, Kindly report in case you are facing defeculties with follwing details.
- OS name
- OS version
- Package name
- Logs – Error / Warning / failed
Get in touch with our new devops tools based website- https://www.devopstricks.in/