This is the definitive, best-selling guide to using, programming, and administering MySQL 5.5, the newest version of the world's #1 open source database. Authored by Paul DuBois, the open source community leader who now leads MySQL's own English language documentation team, this guide is perfect for MySQL users at all levels of experience, in roles ranging from web developer to database administrator. Fully updated to reflect the final stable version of MySQL 5.5, MySQL, Fifth Editionhas been meticulously revised and updated to cover important new features that extend MySQL's power and make it even more valuable in large-scale enterprise environments. Throughout, DuBois focuses on the productive and effective use of MySQL in real-world environments. DuBois covers all this: efficiently capturing information in a MySQL database, and formulating queries to retrieve it; using MySQL with PHP or Perl to generate dynamic web pages; writing programs that access MySQL databases; administering MySQL servers; controlling database access and enforcing security; maintaining, backing up, and replicating MySQL databases, and much more. This Fifth Edition incorporates extensive feedback from both readers and top developers throughout the MySQL global community, and also includes significantly expanded coverage of stored procedures, functions, triggers, and events.