|
Login to your server via ssh. Change directories to where mysql is installed and login to the mysql server.
Will be something like this:
[calmlikeabomb@reviews]# cd /usr/bin/
[calmlikeabomb@reviews]# mysql -u root -p -h your.server
Where -u is the user logging in (root in this example), -p just specifys we will be using a password, -h is the server were logging in to. Then you will be promted for the mysql password that is associated with the user.
After logging in Select a database to work with:
mysql> use databasename;
If you don't know what databases are in the system:
mysql> show databases;
Show the tables in a database once you've selected one:
mysql> show tables;
Learn more about the fields/columns that the table consists of:
mysql> describe sometable;
Hope this gets you headed in the right direction ; )
__________________
subarus.
|