I have read in many places that using mysql command line tools over SSH with Godaddy shared hosting is impossible. As of December, 2011, that is incorrect. Below are a few examples of VERY helpful functions that can be done on a Godaddy shared hosting account with SSH access (I use Putty & WinSCP for Windows).
To access the mysql command line tool:
mysql -h DatabaseHost –user=DBName –password=DBPassword
mysql -h mydatabase.db.4738635.hostedresource.com –user=mydatabase –password=yourpassword
Once connected, you will have a new prompt “>”
Type “show databases;” to show all databases. Which there should only be two.
Type “use mydatabase;” to select the database to use.
Type “show tables;” to show all the tables in the selected database
From here, the posibilities are endless. Just read up on how to use the mysql command line tool.