All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Newsletters

Free Learning

You're reading from Advanced MySQL 8

Product type Book

Published in Jan 2019

Publisher

ISBN-13 9781788834445

Pages 286 pages

Edition 1st Edition

Languages

SQL

Concepts

Database Administration

Authors (3):

Eric Vanier

Birju Shah

Tejaswi Malepati

View More author details

Table of Contents (13) Chapters

Preface

1. Introduction

2. MySQL 8's New Features

3. Indexing Your Data for High Performance

4. Advanced Data Techniques for Large Queries

5. MySQL Data Dictionary in MySQL 8.0

6. MySQL Server Settings

7. Group Replication in MySQL 8.0

8. InnoDB Cluster in MySQL 8.0

9. Monitoring Your Large Distributed Databases

10. Authentication and Security Management with MySQL 8.0

11. Advanced MySQL Performance Tips and Techniques

12. Other Books You May Enjoy

Leave a review - let other readers know what you think

Troubleshooting connection problems

Sometimes, you may encounter a couple of problems while trying to connect to the MySQL server. In such situations, you can try some of the following actions to rectify the situation:

Ensure that the server is working correctly. If it is not, clients cannot connect to it. Let's say that you are attempting to connect to the server, but that this operation fails. You may get an error message and, if that message is similar to one of the following messages, there is a very high chance that your server isn't running:

$ mysql
ERROR 2003: Can't connect to MySQL server on 'host_name' (111)
$ mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)

Another scenario is where the server is up and running. However, you are attempting to connect to it via a named pipe. Or perhaps...

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 €14.99/month. Cancel anytime}

Authors (3)

Eric Vanier

Eric Vanier is one of the few DBAs worldwide specializing in MySQL performance, and is an expert with large architectures such as those for Air Miles, Cogeco, McGill University, Bombardier Aerospace, and many more. As a senior DBA and instructor for 18 years, he has a track record in performance and troubleshooting on dozens of high-profile MySQL systems, including complex cluster environments.

See other products by Eric Vanier

Birju Shah

Birju Shah is the principal architect for Endurance International Group. He has a bachelor's degree in computer engineering from Gujarat University. He has the experience and expertise to build scalable products for hosting domains. He is passionate about the latest architectural patterns, tools, and technologies, and he helps organizations to follow best practices. He is also passionate about technical training and sessions.

See other products by Birju Shah

Tejaswi Malepati

Tejaswi Malepati is the Cassandra Tech Lead for Target. He has been instrumental in designing and building custom Cassandra integrations, including a web-based SQL interface and data validation frameworks between Oracle and Cassandra. Tejaswi earned a master's degree in computer science from the University of New Mexico, and a bachelor's degree in electronics and communication from Jawaharlal Nehru Technological University in India. He is passionate about identifying and analyzing data patterns in datasets using R, Python, Spark, Cassandra, and MySQL.

See other products by Tejaswi Malepati