Thread: MySQL
View Single Post
Old 01-24-2005, 01:11 AM  
fris
Too lazy to set a custom title
 
fris's Avatar
 
Industry Role:
Join Date: Aug 2002
Posts: 55,479
Quote:
Originally Posted by calmlikeabomb
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 ; )
please tell her in english

she will need to use to database with the software.

tiffany if the software you are using needs say "database1" and the user and pass thats what you put when you install the software, the actual software accesss it.

phpmyadmin is web based software used to edit your database that your host will setup.

what software are you trying to install?
__________________
Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.


My Cam Feeds Script
fris is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote