Drupal example source code file (INSTALL.mysql.txt)
The INSTALL.mysql.txt Drupal example source code
// $Id: INSTALL.mysql.txt,v 1.12 2010/01/11 16:25:15 webchick Exp $ CREATE THE MySQL DATABASE -------------------------- This step is only necessary if you don't already have a database set-up (e.g. by your host). In the following examples, 'username' is an example MySQL user which has the CREATE and GRANT privileges. Use the appropriate user name for your system. First, you must create a new database for your Drupal site (here, 'databasename' is the name of the new database): mysqladmin -u username -p create databasename MySQL will prompt for the 'username' database password and then create the initial database files. Next you must log in and set the access database rights: mysql -u username -p Again, you will be asked for the 'username' database password. At the MySQL prompt, enter following command: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password'; where 'databasename' is the name of your database 'username@localhost' is the username of your MySQL account 'password' is the password required for that username Note: Unless your database user has all of the privileges listed above, you will not be able to run Drupal. If successful, MySQL will reply with: Query OK, 0 rows affected If the InnoDB storage engine is available, it will be used for all database tables. InnoDB provides features over MyISAM such as transaction support, row-level locks, and consistent non-locking reads.
Other Drupal examples (source code examples)
Here is a short list of links related to this Drupal INSTALL.mysql.txt source code file:
"Drupal" is a registered trademark of Dries Buytaert.
1998-2016 Alvin Alexander, alvinalexander.com
All Rights Reserved.
Beginning in 2016, a portion of the proceeds from pages under the '/drupal-code-examples/' URI will be donated to charity.