Before you can start running the examples in this chapter, you need to have
Access to an installation of MySQL. We recommend installing a copy on your own computer for testing. Even though this sounds daunting, it isn'tMySQL installs easily on many platforms, including BSD, Linux, Mac OS X, Solaris, and Windows. For more information, refer to the online manual.
An account on the MySQL server that has full permissions on one or more databases. The root account created by default in a fresh install of MySQL has all the required permissions.
A MySQL client. We recommend using the mysql command-line client or the MySQL Query Browser. (All the examples in this chapter assume you're using the mysql command-line client.) See Chapter 7, "The mysql Command-line Client," for more details.