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

Code Files

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

Daniel Schneller, Udo Schwedt

eBook
$7.00
RRP $9.99
Save 29%
Print + eBook
$19.99
RRP $19.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$7.00
$19.99
RRP $9.99
RRP $19.99
eBook
Print + eBook

Frequently bought together


MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users Book Cover
MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users
$ 9.99
$ 7.00
MySQL Admin Cookbook LITE: Replication and Indexing Book Cover
MySQL Admin Cookbook LITE: Replication and Indexing
$ 9.99
$ 7.00
Buy 2 for $14.00
Save $5.98
Add to Cart

Book Details

ISBN 139781849516129
Paperback120 pages

Book Description

MySQL 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!

Table of Contents

What You Will Learn

  • Use the InnoDB storage engine to store data in different files and thus improve efficiency
  • Establish alert mechanisms to let you know when table space is running low
  • Identify and change MySQL variables
  • Enable and configure binary logging
  • Understand and configure MySQL and InnoDB timeout options
  • Run multiple MySQL Server Instances in parallel on a Linux server
  • Manage MySQL user accounts and assign appropriate privileges
  • Configure MySQL Administrator to display global privileges and hosts
  • Restrict access sensibly and regain access to your database in case of loss of administrative user credentials

Authors

Table of Contents

Book Details

ISBN 139781849516129
Paperback120 pages
Read More

Read More Reviews

These popular $10 titles might interest you

MySQL Admin Cookbook LITE: Replication and Indexing Book Cover
MySQL Admin Cookbook LITE: Replication and Indexing
$ 9.99
$ 7.00
Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
MySQL Management and Administration with Navicat Book Cover
MySQL Management and Administration with Navicat
$ 17.99
$ 10.00
OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 ) Book Cover
OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 )
$ 29.99
$ 10.00
Mastering phpMyAdmin 3.4 for Effective MySQL Management Book Cover
Mastering phpMyAdmin 3.4 for Effective MySQL Management
$ 23.99
$ 10.00
Getting Started with NoSQL Book Cover
Getting Started with NoSQL
$ 14.99
$ 10.00