summaryrefslogtreecommitdiff
path: root/INSTALL.mysql.txt
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2005-11-25 10:07:49 +0000
committerDries Buytaert <dries@buytaert.net>2005-11-25 10:07:49 +0000
commit924dda1fa4f227c295f5a6e28f2c6e57d7871ecc (patch)
tree4e2ad8fa9c7f896369b507af778d5770d51d7473 /INSTALL.mysql.txt
parent5cf74ccb72ae9449e892b6642c8fc363a6a18237 (diff)
downloadbrdo-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.txt73
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
+