O'Reilly logo

Fedora® 9 and Red Hat® Enterprise Linux® Bible by Christopher Negus

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 24. Setting Up a MySQLDatabase Server

In This Chapter

  • Finding MySQL packages

  • Configuring the MySQL server

  • Working with MySQL databases

  • Displaying MySQL databases

  • Making changes to tables and records

  • Adding and removing user access

  • Checking and fixing databases

MySQL is a popular structured query language (SQL) database server. Like other SQL servers, MySQL provides the means of accessing and managing SQL databases. However, MySQL also provides tools for creating database structures, as well as for adding, modifying, and removing data from those structures. Because MySQL is a relational database, data can be stored and controlled in small, manageable tables. Those tables can be used in combination to create flexible yet complex data structures.

A Swedish company called MySQL AB was responsible for developing MySQL (www.mysql.com). MySQL AB released MySQL as an open-source product several years ago, gaining revenue by offering a variety of MySQL support packages, commercial licenses, and MySQL brand franchise products. In February, 2008, Sun Microsystems Inc. acquired MySQL AB for about $1 billion dollars. (Who says you can't make money with open source software?)

Although all the ramifications of Sun's acquisition of MySQL have not all played out yet, for now MySQL software is still available as open-source software. According to stories on the Web, however, Sun is expected to begin close sourcing parts of the MySQL code base. Some predict that, in time, this could cause a migration ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required