O'Reilly logo

MySQL® by Paul DuBois

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 12. General MySQL Administration

This chapter discusses the responsibilities that you must carry out to keep MySQL running smoothly if you administer MySQL at your site:

  • Securing your MySQL setup after installing it

  • Making sure that the server is up and running as much of the time as possible

  • Setting up user accounts so that clients can access the server

  • Maintaining server logs

  • Modifying and monitoring the server’s operating parameters for better performance

  • Running multiple servers

  • Determining whether and when to upgrade MySQL to a newer version

Other significant administrative concerns are covered in Chapter 13, “Access Control and Security,” and Chapter 14, “Database Maintenance, Backups, and Replication.”

This chapter covers several programs ...

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