Difference between revisions of "MySQL"

From ArchWiki
Jump to: navigation, search
(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...)
 
Line 1: Line 1:
 +
[[Category:Daemons and system services]]
 +
 
{{i18n_links_start}}
 
{{i18n_links_start}}
 
{{i18n_entry|English|MySQL}}
 
{{i18n_entry|English|MySQL}}
Line 4: Line 6:
 
{{i18n_links_end}}
 
{{i18n_links_end}}
  
= Introduction =
 
 
MySQL is a widely spread, multi-threaded, multi-user SQL database. For more information about features, see the [http://www.mysql.com/ official homepage].
 
MySQL is a widely spread, multi-threaded, multi-user SQL database. For more information about features, see the [http://www.mysql.com/ official homepage].
= Installation =
+
=Installation=
 
Install the mysql package:
 
Install the mysql package:
<pre># pacman -S mysql</pre>
+
# pacman -S mysql
 
After installing MySQL you should run arch's init script as root:
 
After installing MySQL you should run arch's init script as root:
<pre># /etc/rc.d/mysqld start</pre>
+
# /etc/rc.d/mysqld start
 
This will take care of the basic configuration as adding system users and creating log files.
 
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:
 
You may add mysqld to your DAEMONS array in /etc/rc.conf to start the MySQL database at system startup:
<pre>DAEMONS=(... @mysqld ...)</pre>
+
DAEMONS=(... @mysqld ...)
= Configuration =
+
=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:
 
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:
<pre># mysqladmin -u root password YOUR_PASSWORD</pre>
+
# mysqladmin -u root password YOUR_PASSWORD
 
This will add a root account using YOUR_PASSWORD.
 
This will add a root account using YOUR_PASSWORD.
 
Then you'll be able to do further configuration using you favorite interface.
 
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:
 
For example you can use MySQL's command line tool to login as root into your MySQL server:
<pre>$ mysql -p -u root</pre>
+
$ mysql -p -u root

Revision as of 13:23, 13 May 2007

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

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