How to determine if there is a user in mysql in BASH?

Question

How to determine if there is a user in mysql in BASH ?

if [ "$NAME_USER" == ???? ]; then
  echo "User exists in MySQL"
else
  echo "User no exists in MySQL"
fi

tzelleke · Accepted Answer · 2012-08-14 21:59:38Z

4

while read User; do
    if [[ "$NAME_USER" == "$User" ]]; then
        echo "$User exists in MySQL"
        break
    fi
done < <(mysql -B -N -e 'use mysql; SELECT `user` FROM `user`;')

if [[ "$NAME_USER" != "$User" ]]; then
    echo "$NAME_USER does not exists in MySQL"
fi

edited Aug 14, 2012 at 21:59

answered Aug 14, 2012 at 21:37

tzelleke

15.4k5 gold badges35 silver badges49 bronze badges

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

4 Comments

jordanm Over a year ago

Using backticks in double quotes will cause the shell to execute "user". Also, you probably want -B and -N for mysql so the table header is not included in the output.

tzelleke Over a year ago

@jordanm thanks for correcting me on the quotes. I'm not using mysql very often in scripts, but when I do (usually I pipe the output to further process) table headers are excluded...

jordanm Over a year ago

That probably depends on client version. From my experience, when used in a pipeline, it implies -B, but not -N.

Jason Smith Over a year ago

I had to use xargs to strip the carriage return at the end of each value in $User for this to work.

Conner · Accepted Answer · 2012-08-16 04:29:25Z

0

You can enclose a script to make a mysql query and then parse the output.

edited Aug 16, 2012 at 4:29

Conner

31.4k8 gold badges55 silver badges75 bronze badges

answered Aug 14, 2012 at 20:57

Adam Dymitruk

131k28 gold badges149 silver badges143 bronze badges

Collectives™ on Stack Overflow

How to determine if there is a user in mysql in BASH?

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related