Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from MySQL 8 Administrator???s Guide Effective guide to administering high-performance MySQL 8 solutions

Product type Paperback

Published in Feb 2018

Publisher Packt

ISBN-13 9781788395199

Length 510 pages

Edition 1st Edition

Languages

SQL

Tools

MySQL

Concepts

Database Administration

Authors (3):

Chintan Mehta

Hetal Oza

Subhash Shah

View More author details

Table of Contents (17) Chapters

Preface

1. An Introduction to MYSQL 8 FREE CHAPTER

2. Installing and Upgrading MySQL 8

3. MySQL 8 – Using Programs and Utilities

4. MySQL 8 Data Types

5. MySQL 8 Database Management

6. MySQL 8 Storage Engines

7. Indexing in MySQL 8

8. Replication in MySQL 8

9. Partitioning in MySQL 8

10. MySQL 8 – Scalability and High Availability

11. MySQL 8 – Security

12. Optimizing MySQL 8

13. Extending MySQL 8

14. MySQL 8 Best Practices and Benchmarking

15. Troubleshooting MySQL 8

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

MySQL 8 – Using Programs and Utilities

In the previous chapter, we installed MySQL 8 and got to know alternative ways to install MySQL 8. We also learned how to migrate and upgrade to MySQL 8. The following are the summary topics explained in the previous chapter:

MySQL 8 Installation
Post Installation Setup
MySQL 8 Upgrading
MySQL 8 Downgrading

In this chapter, the reader will learn about various programs and utilities available in MySQL 8. The reader will also get to know how to use programs and utilities in MySQL 8. The reader will learn about using command-line programs used in MySQL 8. The reader will learn the syntax for the program and how they are being used with specific options to perform specific operations. The following is a summary of the topics covered in this chapter.

Overview of MySQL 8 programs
MySQL 8 command-line programs
MySQL 8 client programs

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (3)

Mehta

Chintan Mehta is a co-founder of KNOWARTH Technologies and heads the cloud/RIMS/DevOps team. He has rich, progressive experience in server administration of Linux, AWS Cloud, DevOps, RIMS, and on open source technologies. He is also an AWS Certified Solutions Architect. Chintan has authored MySQL 8 for Big Data, Mastering Apache Solr 7.x, MySQL 8 Administrator's Guide, and Hadoop Backup and Recovery Solutions. Also, he has reviewed Liferay Portal Performance Best Practices and Building Serverless Web Applications.

See other products by Mehta

Oza

Hetal Oza an MCA from a reputable institute of India, is working as a lead consultant at KNOWARTH Technologies. She has rich experience in Java-based systems with various databases. Her 10 years of experience covers all stages of software development. She has worked on development of web-based software solutions on various platforms. She has good exposure to integration projects with web-service-based and thread-based architecture. Her knowledge is not bound to any single field because she has worked on wide range of technologies and tools.

See other products by Oza

Subhash Shah

Subhash Shah is an experienced solution architect. With 14 years of experience in software development, he works as an independent technical consultant now. He is an advocate of open source development and its utilization in solving critical business problems. His interests include Microservices architecture, Enterprise solutions, Machine Learning, Integrations and Databases. He is an admirer of quality code and test-driven development (TDD). His technical skills include translating business requirements into scalable architecture and designing sustainable solutions. He is a co-author of Hands-On High Performance with Spring 5, Hands-On AI for Banking and MySQL 8 Administrator's Guide. He has also been a technical reviewer for other books.

See other products by Subhash Shah