Project

General

Profile

Paste
Download (1.68 KB) Statistics
| Branch: | Revision:

root / drupal7 / INSTALL.mysql.txt @ 6d8023f2

1 85ad3d82 Assos Assos
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 4444412d Julien Enselme
  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
24
  CREATE TEMPORARY TABLES ON databasename.*
25 85ad3d82 Assos Assos
  TO 'username'@'localhost' IDENTIFIED BY 'password';
26
27 4444412d Julien Enselme
where:
28 85ad3d82 Assos Assos
29
 'databasename' is the name of your database
30 4444412d Julien Enselme
 'username' is the username of your MySQL account
31
 'localhost' is the web server host where Drupal is installed
32 85ad3d82 Assos Assos
 'password' is the password required for that username
33
34 4444412d Julien Enselme
Note: Unless the database user/host combination for your Drupal installation
35
has all of the privileges listed above (except possibly CREATE TEMPORARY TABLES,
36
which is currently only used by Drupal core automated tests and some
37
contributed modules), you will not be able to install or run Drupal.
38 85ad3d82 Assos Assos
39
If successful, MySQL will reply with:
40
41
  Query OK, 0 rows affected
42
43
If the InnoDB storage engine is available, it will be used for all database
44
tables. InnoDB provides features over MyISAM such as transaction support,
45
row-level locks, and consistent non-locking reads.