MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users

In DetailMySQL is the most popular open-source database and is also known for its easy set up feature. However, proper configuration beyond the default settings remains a challenge, along with day-to-day maintenance tasks such as configuration, server monitoring and managing user credentials. This MySQL Admin Cookbook LITE book provides both step-by-step recipes and relevant background information on many basic and advanced aspects of MySQL administration and configuration. Three key aspects of MySQL administration are covered in detail; monitoring and analyzing a MySQL installation, configuring MySQL, helping you, amongst other things, to regain lost administrative user credentials, and managing users by assigning privileges.All of the recipes are based on real-world experience derived from proven solutions used in an enterprise environment.To find out more about upgrading to the full edition, visit www.packtpub.com/lite-editions and log into your account for offers and help. If you don't have an account on PacktPub.com, visit today and set one up!ApproachThis cookbook presents solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easyWho this book is forThis book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will benefit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to widen their MySQL horizon.It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general.