Linux mysql command

17.Jul.2010

Sometimes there is a need to check our MySQL database directly on our server. Usually connected via SSH, we have Linux terminal in front ourselves. Using Linux mysql command is quite an easy task. Use following code to connect to your database and then select some data.

1
2
3
mysql> USE dbname;
mysql> SELECT * FROM mysql_table;
mysql> QUIT;