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