How do I connect to MySQL via SSH?

Use the following outline to connect and begin querying the MySQL server from SSH. Remember that you cannot connect to your databases remotely due to security concerns, you can only connect from localhost .

1. Connect To The MySQL Server
servername:/> mysql -u USERNAME -p
Enter Password: PASSWORD

2. Connect To The Database
mysql> use DATABASENAME;

3. Receiving Help
mysql> help

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How do I create/edit/delete tables in my database?

All administration of your mySQL databases can be done through our convenient web based...

How do I connect to MySQL through Perl using the mySQLPerl Module?

Use the following outline to connect and begin querying the MySQL server from a Perl script....

How do I connect to MySQL through PHP?

Use the following outline to connect and begin querying the MySQL server from a Perl script....

The Official MySQL Documentation

The official MySQL documentation may be found at: http://www.mysql.com Other useful...