[Sommaire] [Imprimer]

   1  // $Id: INSTALL.mysql.txt,v 1.7 2006/09/08 16:29:35 dries 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, CREATE
  25    TEMPORARY TABLES, LOCK TABLES
  26    ON databasename.*
  27    TO 'username'@'localhost' IDENTIFIED BY 'password';
  28  
  29  where
  30  
  31   'databasename' is the name of your database
  32   'username@localhost' is the username of your MySQL account
  33   'password' is the password required for that username
  34  
  35  Note: Unless your database user has all of the privileges listed above, you will
  36  not be able to run Drupal.
  37  
  38  If successful, MySQL will reply with:
  39  
  40    Query OK, 0 rows affected
  41  
  42  To activate the new permissions, enter the following command:
  43  
  44    FLUSH PRIVILEGES;