WebDevelopersNotes 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

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

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 Australian female voice on Siri is of Karen Jacobsen, an Australian-born, NY based artist. [more...]