[ Index ]

PHP Cross Reference of Documentation Drupal

title

Body

[close]

/ -> INSTALL.mysql.txt (source)

   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.,
   6  by your host). In the following examples, 'username' is an example MySQL user
   7  which has the CREATE and GRANT privileges. Use the appropriate user name for
   8  your 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 log in 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 the following command:
  22  
  23    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
  24    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  
  40  If the InnoDB storage engine is available, it will be used for all database
  41  tables. InnoDB provides features over MyISAM such as transaction support,
  42  row-level locks, and consistent non-locking reads.


Développeurs Drupal & Développement mobile Montréal
Generated: Thu Feb 21 17:10:26 2013 Cross-referenced by PHPXref 0.7.1