WDN Logo

home-icon Home / MySQL / MySQL database introduction

MySQL database introduction

MySQL database introduction

The MySQL database package consists of the following:

  • The MySQL server: This is the heart of MySQL. You can consider it a program that stores and manages your databases.
  • MySQL client programs: MySQL comes with many client programs. The one with which we’ll be dealing a lot is called mysql (note: smallcaps). This provides an interface through which you can issue SQL statements and have the results displayed.
  • MySQL client Library: This can help you in writing client programs in C. (We won’t be taking about this in our tutorial).

Sponsored Links

The difference between MySQL and mysql

MySQL is used to refer to the entire MySQL distribution package or the MySQL server, while mysql refers to a client program.

Why have client and server programs?

The server and client programs are different entities. Thus, you can use client programs on your system to access data on a MySQL server running on another computer. (Note: you would need appropriate permissions for this. Consult the system administrator of the remote machine.)
Dividing the package into a server and clients separates the actual data from the interface.

Sponsored Links

Search

Your comments
Star icon IMPORTANT Have a question / problem? Click here to ask an expert.

Web designer vs. web developer

Sponsored Links

Tips

How do I view a deleted web page?
Is there a way to view a deleted web page - one that is no longer available? Yes there is and the solution is quite simple. [more...]

Fact

The world's first hard disk couldn't be bought as an individual device. You had to get the computer with which it came. The computer, IBM305 RAMAC, itself was only available on lease for $3200 per month. [more...]

Share on Whats app Share on Facebook Share on Twitter Share on Google plus