Chapter 3. Working with MySQL

In this chapter, you’ll learn how to connect and login to MySQL, how to issue MySQL statements, and how to obtain information about databases and tables.

Making the Connection

Now that you have a MySQL DBMS and client software to use with it, it would be worthwhile to briefly discuss connecting to the database.

MySQL, like all client-server DBMSs, requires that you log in to the DBMS before being able to issue commands. Login names might not be the same as your network login name (assuming that you are using a network); MySQL maintains its own list of users internally, and associates rights with each.

When you first installed MySQL, you were probably prompted for an administrative login (often named root) and a password. ...

Get MySQL® Crash Course now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.