drupal/drupal/INSTALL.mysql.txt

// $Id: INSTALL.mysql.txt,v 1.10 2007/11/19 19:53:51 goba Exp $

CREATE THE MySQL DATABASE
--------------------------

This step is only necessary if you don't already have a database set-up (e.g. by
your host). In the following examples, 'username' is an example MySQL user which
has the CREATE and GRANT privileges. Use the appropriate user name for your
system.

First, you must create a new database for your Drupal site (here, 'databasename'
is the name of the new database):

  mysqladmin -u username -p create databasename

MySQL will prompt for the 'username' database password and then create the
initial database files. Next you must login and set the access database rights:

  mysql -u username -p

Again, you will be asked for the 'username' database password. At the MySQL
prompt, enter following command:

  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
  ON databasename.*
  TO 'username'@'localhost' IDENTIFIED BY 'password';

where

 'databasename' is the name of your database
 'username@localhost' is the username of your MySQL account
 'password' is the password required for that username

Note: Unless your database user has all of the privileges listed above, you will
not be able to run Drupal.

If successful, MySQL will reply with:

  Query OK, 0 rows affected

If the InnoDB storage engine is available, it will be used for all database
tables. InnoDB provides features over MyISAM such as transaction support,
row-level locks, and consistent non-locking reads.
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
41	If the InnoDB storage engine is available, it will be used for all database
42	tables. InnoDB provides features over MyISAM such as transaction support,
43	row-level locks, and consistent non-locking reads.