Learning Mysql
MySQL Software Covered in This Book
Download 4.24 Mb. View original pdf
|
- Navigate this page:
- MySQL Software Covered in This Book | 7
- The Book’s Web Site
| MySQL Software Covered in This Book You can be very productive with MySQL without dedicating a lot of time to configuration and administration. In Chapter 2, we’ll look at several common ways of setting up the software you’ll need for this book. While you can skip most of the instructions if you already have a working MySQL installation, we recommend you at least skim through the material for your operating system we’ll frequently refer to parts of this chapter later on. As part of this chapter, we explain how you can configure your MySQL server for good security. MySQL provides many other tools for administration, including compile-time options, a large configuration file, and standalone utilities developed by both MySQL AB and MySQL Software Covered in This Book | 7 external developers. We’ll give you the basics that will keep you up and running inmost environments, and will briefly describe even some relatively advanced topics. We won’t coverall the programs that come with the MySQL distribution, and we won’t spend too long on each one the MySQL reference manual does a good job of covering all the options. We’ll instead look at the programs and options that you’re most likely to use in practice these are the ones we’ve used ourselves a reasonable number of times over several years of working with MySQL. The Book’s Web Site We’ve setup the website, http://www.learningmysql.com, which contains the sample databases, datafiles, and program code. We recommend you make good use of the website while you read this book. 8 | Chapter 1: Introduction CHAPTER 2 Installing MySQL Learning MySQL is easiest if you have a database server installed on your computer. By administering your own server, you can go beyond querying and learn how to manage users and privileges, configure the server, and make the best use of its features. Importantly, you also learn the steps required to install and configure MySQL, which is useful when you need to deploy your applications elsewhere. This chapter explains how to choose and configure a suitable environment for learning MySQL. We cover the following topics What to install how to decide between precompiled packages, an integrated web development environment, and compiling from the source code Whereto install Linux, Microsoft Windows, or Mac OS X Why, when, and how to upgrade MySQL • How MySQL has changed and how to migrate between versions How to configure the Apache web server and support for the PHP and Perl scripting languages. MySQL is available in several forms and for many operating systems. In the next section, we examine the choices available and how you can decide what suits you. Download 4.24 Mb. Share with your friends:
|