Accessing your MySQL database via SSH Telnet

(Last modified Aug 29, 2002 )

To access your MySQL database from a SSH telnet command prompt, use the following command structure.

/usr/local/mysql/bin/mysql -u username -p database

Note: You can determine the name of your database from your domain name. If your domain name is abc.com then the name of your database is abc_com

Here is an example using a sample account. Replace the account information listed here with your own account information.

Domain name: abc.com
Database name: abc_com
Account User name: test
Account Password: test

From a shell prompt type:

/usr/local/mysql/bin/mysql -u test -p abc_com

You will then see the MySQL monitor where you can execute MySQL commands and queries on your database:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 164280 to server version: 3.23.21-beta-log

Type 'help' for help.

mysql>

Online Manual

Accessing your MySQL database via SSH Telnet