Run MySQL query on remote machine through ssh in command line

Question

I am trying to run MySQL query on remote machine with this command:

ssh [email protected] "mysql -uroot -proot -e \"use test";""

I am not able to use that database.

Please suggest a working command.

Answer 1

Try this:

mysql -h host -u root -proot -e "show databases;";