This article series discusses installing MySQL and getting it running with some basic configuration.
What is MySQL?
MySQL is a database server, software that stores and retrieves data for other applications. You might need a database that will work with an application you're developing, or you may just want a database so you can run web applications like WordPress or Drupal. MySQL should serve you well in either instance.
These articles are intended to help a MySQL novice get a server up and running, with just enough information for basic operation. If you're going to use MySQL in a busy production environment you'd do better to get a database administrator to help you run it - someone who specializes in running and tuning database software.
If you just want to get started with a minimum of fuss, the first article covers:
- - Installing MySQL
- - Launching MySQL
- - Using the MySQL client
- - Setting a root password
- - Basic MySQL user concepts
- - Creating databases
- - Creating users
- - Granting user permissions
The second article walks through the server's configuration options, including:
- - Finding the config files
- - Reading my.cnf
- - Network settings
- - Backups and mysqldump
And the third article is a list of common tasks you might need to perform on a MySQL server, primarily discussing the creation and manipulation of databases, users, and tables. It also mentions how to reset MySQL's root password.
The first two articles, covering installing and configuring MySQL, have separate versions for each of the distributions we support.
The best place to start learning more about MySQL server than what we cover wuld be the official MySQL documentation site. They have reference manuals written for each different major version of MySQL server there.
These three articles should get you up and running with a minimum of fuss, and will hopefully put you in a good position to learn more about running and tuning your MySQL server.