Getting MYSQL DB info via bash

Question

I'm using some bash code which I got off another post on here

#!/bin/sh

users=$(mysql --user=user --password=password --database=$db -h _IP ADDRESS) -s --       execute="select$ users from db limit 1;"|cut -f1)

echo "$users"

The database is DB and the table is users basically I want to be able to get a user count from the table but when I run the script I get

ERROR 1049 (42000): Unknown database 'execute=select users from db limit 1;'

any idea what i'm doing wrong or a better way of doing it? if I do

select * form users;

on the mysql server itself it returns 12 rows in set (0.00 sec) 12 being the number of users, so I just want my script to query the user table on database DB and return the number of rows ie 12.

Gilles Quénot · Accepted Answer · 2013-09-28 19:15:32Z

1

users_count=$(
    mysql --user user_name --password=password  -h x.x.x.x <<EOF | tail -n 1
    select count(1) from mysql.user;
EOF
)

edited Sep 28, 2013 at 19:15

answered Sep 28, 2013 at 19:10

Gilles Quénot

188k43 gold badges232 silver badges229 bronze badges

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

Comments

Μenelaοs · Accepted Answer · 2013-09-28 19:03:42Z

0

it seems that the order of your params is wrong...

MYSQL is telling you that 'execute=select users from db limit 1;' is in the position of the database parameter.

Try something like this:

mysql --user user_name --password=password -e 'select users from db_schema.table limit 1;'

answered Sep 28, 2013 at 19:03

Μenelaοs

24.4k20 gold badges98 silver badges166 bronze badges

Comments

Nikhil · Accepted Answer · 2013-09-28 19:14:28Z

0

Simply try this:

mysql -u username --password=password -h hostname database_name -e 'select count(1) from table limit 1;'

answered Sep 28, 2013 at 19:14

Nikhil

2,31815 silver badges15 bronze badges

Collectives™ on Stack Overflow

Getting MYSQL DB info via bash

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related