Mercurial > defr > drupal > core

comparison INSTALL.mysql.txt @ 1:c1f4ac30525a 6.0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Drupal 6.0
author Franck Deroche <webmaster@defr.org>
date Tue, 23 Dec 2008 14:28:28 +0100
parents
children
comparison
equal deleted inserted replaced
0:5a113a1c4740 1:c1f4ac30525a
1 // $Id: INSTALL.mysql.txt,v 1.10 2007/11/19 19:53:51 goba Exp $
2
3 CREATE THE MySQL DATABASE
4 --------------------------
5
6 This step is only necessary if you don't already have a database set-up (e.g. by
7 your host). In the following examples, 'username' is an example MySQL user which
8 has the CREATE and GRANT privileges. Use the appropriate user name for your
9 system.
10
11 First, you must create a new database for your Drupal site (here, 'databasename'
12 is the name of the new database):
13
14 mysqladmin -u username -p create databasename
15
16 MySQL will prompt for the 'username' database password and then create the
17 initial database files. Next you must login and set the access database rights:
18
19 mysql -u username -p
20
21 Again, you will be asked for the 'username' database password. At the MySQL
22 prompt, enter following command:
23
24 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
25 ON databasename.*
26 TO 'username'@'localhost' IDENTIFIED BY 'password';
27
28 where
29
30 'databasename' is the name of your database
31 'username@localhost' is the username of your MySQL account
32 'password' is the password required for that username
33
34 Note: Unless your database user has all of the privileges listed above, you will
35 not be able to run Drupal.
36
37 If successful, MySQL will reply with:
38
39 Query OK, 0 rows affected
40