1
// $Id: INSTALL.mysql.txt,v 1.10 2007/11/19 19:53:51 goba Exp $
3
CREATE THE MySQL DATABASE
4
--------------------------
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
11
First, you must create a new database for your Drupal site (here, 'databasename'
12
is the name of the new database):
14
mysqladmin -u username -p create databasename
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:
21
Again, you will be asked for the 'username' database password. At the MySQL
22
prompt, enter following command:
24
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
26
TO 'username'@'localhost' IDENTIFIED BY 'password';
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
34
Note: Unless your database user has all of the privileges listed above, you will
35
not be able to run Drupal.
37
If successful, MySQL will reply with:
39
Query OK, 0 rows affected