FAQ

From Hashmysql
Jump to: navigation, search

This is a list of frequently asked questions, or frequently encountered problems. Noting that almost everything is already covered by the manual, the answers here are intended to be supplements to the manual (rather than simply URLs to the relevant chapter).


  • mysqld_safe says that mysqld ended.
  • What do these error numbers mean?
  • What are some good books for MySQL?
  • Does MySQL have <insert feature here>?
  • What the heck is a storage engine?
  • How do I upgrade MySQL?
  • Does MySQL support subqueries?
  • How do I rename a database?
  • Can I store jpg/mp3/whatever in the database?
  • How can I set up users on my desktop box?

Problems

  • I've lost my root password.
  • I created a user that can log in from other computers, but cannot log in from the same computer.
  • Why is my query slow?
  • I can't log in from anywhere or any remote location.
  • Or, "Access Denied for user '@localhost'" errors.
  • Slackware 9 or 10 and I can't start mysql because it stops right away.
  • I've deleted the root user, and there's no other user with all privileges!

3rd Party

  • What is a good GUI tool for MySQL?
  • What is a good GUI Front End for MySQL?
  • MySQL Password Reset
Retrieved from "http://hashmysql.net/w/index.php?title=FAQ&oldid=2857"

Navigation menu

Views

  • Page
  • Discussion
  • View source
  • History

Personal tools

  • Log in

Channel Links

  • Using the SQL bot
  • Channel Guidelines
  • Channel Regulars

Frequently Asked Questions

  • Error Numbers
  • MySQL Books
  • Storage Engines
  • Upgrading MySQL
  • Renaming Databases
  • Setting Up Users
  • Resetting the Root Password
  • Optimizing Slow Queries
  • Setting up Remote Access
  • Recreate the root User
  • Recreate the mysql Database
  • GUI Tools
  • Find the MySQL Configuration File
  • Tuning MySQL
  • Common Misconceptions about Zerofill

Tutorials

  • Basic SQL Statements
  • Introduction to Joins
  • Advanced Joins
  • Basic Views
  • Basic Debugging
  • Introduction to Normalization
  • Using Replication
  • Trees and Hierarchical Data
  • Rows in Table A that are not in Table B
  • Manipulating NULL values
  • Using Explain
  • Non-overlapping Ranges in Sequential Data

Development Guides

  • PHP
  • C
  • Python
  • Perl
  • Java
  • C#
  • Ruby

Documentation

  • MySQL documentation

Installing MySQL

  • CentOS
  • Debian

Support

  • Technical Support

Other Information

  • Recent changes
  • Help

 

Tools

  • What links here
  • Related changes
  • Special pages
  • Printable version
  • Permanent link
  • Page information
Powered by MediaWiki
  • This page was last edited on 26 August 2007, at 08:46.
  • Privacy policy
  • About Hashmysql
  • Disclaimers