I am just starting with mySQL. I downloaded. I am not very clear
about the mySQL client and server components. In other databases,
usually client has a UI (e.g oracle, ms access,.. have forms, .. soon
GUI development tools).

When I download, mySQL, what are the server and client components? do
they come in one package or I need to download and configure them
seperately? I am not sure If my questions are making sense or I am
too much confused.

Thanks in advance

shelly (sk06032003 (AT) yahoo (DOT) com) wrote:
: I am just starting with mySQL. I downloaded. I am not very clear
: about the mySQL client and server components. In other databases,
: usually client has a UI (e.g oracle, ms access,.. have forms, .. soon
: GUI development tools).

: When I download, mySQL, what are the server and client components? do

The simplist client is the program `mysql'. It displays a command line
prompt at which you can type sql statements, and a few control commands.
The client needs to connect to a running mysql server.

The server is one of the other programs. One way to run the server
program is by running it from a command line prompt. On the command line
you also indicate some arguments that tell it where to put the database
files, and etc. I think there are various shell scripts provided to
start/stop the database server program, and to help do some of the basic
administration tasks.

Most "real" programs do not the mysql client program. That is really just
for developers, and experimentors.

Web applications typically use something like perl, (using DBI) or PHP,.
I.e., mysql provides libraries that allow perl to connect to the mysql
server. This is not really a "client" in the sense you probably mean.
The programmer making the perl script has to program everything from
scratch, so to speak.

Another client option is to run any windows program that uses odbc and
connect that program to the mysql server using the mysql odbc drivers. In
this case the "windows program" is something like access or excel, or
etc., again, it is not something provided by mysql.

"shelly" <sk06032003 (AT) yahoo (DOT) com> wrote


MySQL Control Centre is a client with a GUI, similar to Access, and can be
used to administer the database. It's downloadable from the MySQL web site.

MySQL doesn't have an included GUI client, but it does include a command
line client. If you would like a GUI client, take a look at mycc. It is
available from mysql.com

Greg

shelly wrote: