diff options
author | Dries Buytaert <dries@buytaert.net> | 2005-11-25 10:07:49 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2005-11-25 10:07:49 +0000 |
commit | 924dda1fa4f227c295f5a6e28f2c6e57d7871ecc (patch) | |
tree | 4e2ad8fa9c7f896369b507af778d5770d51d7473 /INSTALL.mysql.txt | |
parent | 5cf74ccb72ae9449e892b6642c8fc363a6a18237 (diff) | |
download | brdo-924dda1fa4f227c295f5a6e28f2c6e57d7871ecc.tar.gz brdo-924dda1fa4f227c295f5a6e28f2c6e57d7871ecc.tar.bz2 |
- Patch #25792 by Cvbge and Morbus: improved the installation instructions for PostgreSQL.
Diffstat (limited to 'INSTALL.mysql.txt')
-rw-r--r-- | INSTALL.mysql.txt | 73 |
1 files changed, 73 insertions, 0 deletions
diff --git a/INSTALL.mysql.txt b/INSTALL.mysql.txt new file mode 100644 index 000000000..7402f70c9 --- /dev/null +++ b/INSTALL.mysql.txt @@ -0,0 +1,73 @@ +// $Id$ + +CONTENTS OF THIS FILE +--------------------- + + * Introduction + * Installation and configuration: + - Database and user creation + - Drupal schema loading + +INTRODUCTION +------------ + +This file describes how to create a MySQL database for Drupal. + +If you control your databases through a web-based control panel, +check its documentation, as the following instructions are for the +command line only. + +INSTALLATION AND CONFIGURATION +------------------------------ + +1. CREATE THE DRUPAL 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, 'dba_user' 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 dba_user -p create databasename + + MySQL will prompt for the 'dba_user' database password and then create + the initial database files. Next you must login and set the access + database rights: + + mysql -u dba_user -p + + Again, you will be asked for the 'dba_user' database password. + At the MySQL prompt, enter following command: + + GRANT ALL PRIVILEGES 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 + + If successful, MySQL will reply with: + + Query OK, 0 rows affected + + To activate the new permissions, enter the following command: + + FLUSH PRIVILEGES; + +2. LOAD THE DRUPAL DATABASE SCHEMA + + Once you have a database, you must load the required tables into it. + + If you use a web-based control panel, you should be able to upload + the file 'database.mysql' from Drupal's 'database' directory and + run it directly as SQL commands. + + From the command line, use (again, replacing 'username' and + 'databasename' with your MySQL username and database name): + + mysql -u username -p databasename < database/database.mysql + |