Skip to Main Content
MySQL Reference Manual
book

MySQL Reference Manual

by Michael Widenius, David Axmark, Kaj Arno
June 2002
Intermediate to advanced content levelIntermediate to advanced
816 pages
20h 46m
English
O'Reilly Media, Inc.
Content preview from MySQL Reference Manual

Appendix A. Problems and Common Errors

This appendix lists some common problems and error messages that users have run into. You will learn how to figure out what the problem is, and what to do to solve it. You will also find proper solutions to some common problems.

How to Determine What Is Causing Problems

When you run into problems, the first thing you should do is find out which program/piece of equipment is causing problems:

  • If you have one of the following symptoms, it is probably a hardware (like memory, motherboard, CPU, or hard disk) or kernel problem:

    • The keyboard doesn’t work. This can normally be checked by pressing Caps Lock. If the Caps Lock light doesn’t change you have to replace your keyboard. (Before doing this, you should try to reboot your computer and check all cables to the keyboard.)

    • The mouse pointer doesn’t move.

    • The machine doesn’t answer to a remote machine’s pings.

    • Different, unrelated programs don’t behave correctly.

    • If your system rebooted unexpectedly (a faulty user-level program should never be able to take down your system).

    In this case you should start by checking all your cables and run some diagnostic tool to check your hardware! You should also check if there are any patches, updates, or service packs for your operating system that could likely solve your problems. Check also that all your libraries (like glibc) are up to date.

    It’s always good to use a machine with ECC memory to discover memory problems early!

  • If your keyboard is locked up, you may ...

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 Cookbook

MySQL Cookbook

Paul DuBois
Advanced MySQL 8

Advanced MySQL 8

Eric Vanier, Birju Shah, Tejaswi Malepati
MySQL 8 Cookbook

MySQL 8 Cookbook

Karthik Appigatla
High Performance MySQL

High Performance MySQL

Jeremy D. Zawodny, Derek J. Balling

Publisher Resources

ISBN: 0596002653Purchase bookErrata Page