MySql Problem

[jonirvine]

Hi, I've been asked to install a cgi script which uses MySql.

quote:

You may create the tables indicated by the SQL commands displayed
# below by executing the following single command on your MySQL
# database server (assuming that 'username' has access to the
# database 'databasename' on SQL server 'hostname'):

How do you execute commands on the Mysql database?

Any clues would be brilliant.

Cheers, Jon



------------------
Web Design, development and hosting.
Contact: jon@dustnet.co.uk www.yorkdesigns.co.uk (http://www.yorkdesigns.co.uk)
Newest Project: www.101tutorials.com (http://htpp://www.101tutorials.com)

[Jacob]

The following will log you into the mysql admin. Execute this in a shell:

<BLOCKQUOTE><font size="1" face="Verdana, Arial">code:</font><HR><pre>
mysql -h &lt;hostname&gt; -u &lt;username&gt; -p
[/code]

&lt;hostname&gt; = your servers IP address (localhost should work fine)

&lt;username&gt; = mysql username you specified during the install. (root usually)

For more help, I suggest checking out MySQL's website, located at: http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html

Regards,


------------------
Jacob A. Wheeler
Co-Founder / Web Engineer
Big Resources Network
jacob@bigresources.com
ICQ: 390147 (http://www.icq.com/390147)

[jonirvine]

Where do I type the code given into?

[whkoh]

You execute it in a shell

------------------
Koh Wei Han
Network Engineer
Contact: whkoh@apexmail.com , whkoh@mailandnews.com , whkoh@020.co.uk

[This message has been edited by whkoh (edited 01-19-2001).]

[This message has been edited by whkoh (edited 01-19-2001).]

[jonirvine]

Any more clues?

Whats a shell? I'm completely new to this and am trying to learn.