All storage, retrieval, management and processing of data is actually done by database software DBMS (database management system). MySQL is a DBMS, that is, it is a database software.
MySQL has been around for a long time and is widely installed and used worldwide.
Why are so many companies and developers using MySQL? The reasons are listed below. Cost – MySQL is open source and is generally free to use (and even modify). performance – MySQL executes fast (very fast). trust – some very important and prestigious companies and sites use MySQL to handle their important data. Simple – MySQL is easy to install and use.
In fact, the only real criticism of MySQL is that it doesn’t always support the capabilities and features offered by other DBMSS. However, this is getting better, with new features and functionality being added to each new version of MySQL.
Client-server software DBMSS can be divided into two categories: DBMS based on shared file system and DBMS based on client-server.
The former (which includes things like Microsoft Access and FileMaker) are intended for desktop use and are generally not used for high-end or more critical applications.
Databases such as MySQL, Oracle, and Microsoft SQL Server are client-server based databases. Client-server applications are divided into two distinct parts. The server part is the one piece of software responsible for all data access and processing. The software runs on a computer called a database server.
Only server software deals with data files. All requests for data, data addition, deletion, and data updates are made by the server software. These requests or changes come from the computer running the client software. Clients are software that interacts with users. For example, if you request an alphabetical list of products, the client software submits the request to the server software over the network. The server software processes the request, filtering, discarding, and sorting the data as needed; Then send the results back to your client software.
How many computers are there? Client and server software may be installed on two computers or one computer. Regardless of whether they are on the same computer or not, the client software communicates with the server software for all database interactions.
All of these activities are transparent to the user. The fact that the data is stored somewhere else, or that the database server does the processing for you, is hidden. You don’t need direct access to the data files. In fact, most networks are built without users having access to their data, or even to the drives that store it.
What’s the point? Because in order to use MySQL, you need to access the computer that runs MySQL server software and the computer that issues commands to MySQL client software.
The server software is MySQL DBMS. You can run on a copy installed locally, or you can connect to a copy running on a remote server that you have access to.
Clients can be tools provided by MySQL, scripting languages (such as Perl), Web application development languages (such as ASP, ColdFusion, JSP and PHP), programming languages (such as C, C++, Java), and so on.