MySQL

From ArchWiki
Revision as of 13:18, 13 May 2007 by Harlekin (Talk | contribs) (New page: {{i18n_links_start}} {{i18n_entry|English|MySQL}} {{i18n_entry|German|MySQL (Deutsch)}} {{i18n_links_end}} = Introduction = MySQL is a widely spread, multi-threaded, multi-user SQL databa...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Template:I18n links start Template:I18n entry Template:I18n entry Template:I18n links end

Introduction

MySQL is a widely spread, multi-threaded, multi-user SQL database. For more information about features, see the official homepage.

Installation

Install the mysql package:

# pacman -S mysql

After installing MySQL you should run arch's init script as root:

# /etc/rc.d/mysqld start

This will take care of the basic configuration as adding system users and creating log files. You may add mysqld to your DAEMONS array in /etc/rc.conf to start the MySQL database at system startup:

DAEMONS=(... @mysqld ...)

Configuration

Once you've started the MySQL Server, you probably want to add a root account in order to maintain your MySQL users and databases. Do so by issuing this command as root:

# mysqladmin -u root password YOUR_PASSWORD

This will add a root account using YOUR_PASSWORD. Then you'll be able to do further configuration using you favorite interface. For example you can use MySQL's command line tool to login as root into your MySQL server:

$ mysql -p -u root