Skip to Content
Advanced MySQL 8
book

Advanced MySQL 8

by Eric Vanier, Birju Shah, Tejaswi Malepati
January 2019
Intermediate to advanced
286 pages
7h 41m
English
Packt Publishing
Content preview from Advanced MySQL 8

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:
$ mysqlERROR 2003: Can't connect to MySQL server on 'host_name' (111)$ mysqlERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (111)
  • Another scenario is where the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

MySQL 8 Cookbook

MySQL 8 Cookbook

Karthik Appigatla
High Performance MySQL, 3rd Edition

High Performance MySQL, 3rd Edition

Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
High Performance MySQL, 2nd Edition

High Performance MySQL, 2nd Edition

Jeremy D. Zawodny, Derek J. Balling, Baron Schwartz, Peter Zaitsev, Arjen Lentz, Vadim Tkachenko

Publisher Resources

ISBN: 9781788834445Other