[Summary view] [Print] [Text view]

   1  
   2  CREATE THE MySQL DATABASE
   3  --------------------------
   4  
   5  This step is only necessary if you don't already have a database set-up (e.g. by
   6  your host). In the following examples, 'username' is an example MySQL user which
   7  has the CREATE and GRANT privileges. Use the appropriate user name for your
   8  system.
   9  
  10  First, you must create a new database for your Drupal site (here, 'databasename'
  11  is the name of the new database):
  12  
  13    mysqladmin -u username -p create databasename
  14  
  15  MySQL will prompt for the 'username' database password and then create the
  16  initial database files. Next you must login and set the access database rights:
  17  
  18    mysql -u username -p
  19  
  20  Again, you will be asked for the 'username' database password. At the MySQL
  21  prompt, enter following command:
  22  
  23    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
  24    CREATE TEMPORARY TABLES ON databasename.*
  25    TO 'username'@'localhost' IDENTIFIED BY 'password';
  26  
  27  where
  28  
  29   'databasename' is the name of your database
  30   'username@localhost' is the username of your MySQL account
  31   'password' is the password required for that username
  32  
  33  Note: Unless your database user has all of the privileges listed above, you will
  34  not be able to run Drupal.
  35  
  36  If successful, MySQL will reply with:
  37  
  38    Query OK, 0 rows affected
  39