Using the mysql monitor

The most common way to interface with the MySQL server—aside from a PHP script—is to use the mysql client (or mysql monitor, as it is also called). This application can be used to connect to mysqld (the actual application controlling the databases) running on the same machine or even on another. All of the examples throughout this chapter will be demonstrated via mysql (the lowercase word mysql will refer to the client, as opposed to MySQL, which refers to the software as a whole). In Chapter 9, “Web Application Development,” I’ll come back to the mysql monitor as a debugging tool.

The mysql client is accessed from a command-line interface, be it the Terminal application in Linux or Mac OS X, or a DOS prompt in Windows. ...

Get PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.