webmaster@1: // $Id: INSTALL.mysql.txt,v 1.10 2007/11/19 19:53:51 goba Exp $
webmaster@1: 
webmaster@1: CREATE THE MySQL DATABASE
webmaster@1: --------------------------
webmaster@1: 
webmaster@1: This step is only necessary if you don't already have a database set-up (e.g. by
webmaster@1: your host). In the following examples, 'username' is an example MySQL user which
webmaster@1: has the CREATE and GRANT privileges. Use the appropriate user name for your
webmaster@1: system.
webmaster@1: 
webmaster@1: First, you must create a new database for your Drupal site (here, 'databasename'
webmaster@1: is the name of the new database):
webmaster@1: 
webmaster@1:   mysqladmin -u username -p create databasename
webmaster@1: 
webmaster@1: MySQL will prompt for the 'username' database password and then create the
webmaster@1: initial database files. Next you must login and set the access database rights:
webmaster@1: 
webmaster@1:   mysql -u username -p
webmaster@1: 
webmaster@1: Again, you will be asked for the 'username' database password. At the MySQL
webmaster@1: prompt, enter following command:
webmaster@1: 
webmaster@1:   GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
webmaster@1:   ON databasename.*
webmaster@1:   TO 'username'@'localhost' IDENTIFIED BY 'password';
webmaster@1: 
webmaster@1: where
webmaster@1: 
webmaster@1:  'databasename' is the name of your database
webmaster@1:  'username@localhost' is the username of your MySQL account
webmaster@1:  'password' is the password required for that username
webmaster@1: 
webmaster@1: Note: Unless your database user has all of the privileges listed above, you will
webmaster@1: not be able to run Drupal.
webmaster@1: 
webmaster@1: If successful, MySQL will reply with:
webmaster@1: 
webmaster@1:   Query OK, 0 rows affected
webmaster@1: