3
Working with MySQL
In this chapter, you’ll learn how to connect and log in to MySQL, how to issue MySQL statements, and how to obtain information about databases and tables.
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 other client/server DBMSs, requires that you log in to the DBMS before you can issue commands. Your login name 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 user.
When you first installed MySQL, you were probably prompted for an administrative login (often root) and a password. If you are using your ...
Get MySQL Crash Course, 2nd Edition 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.
