1 | |
---|
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. by |
---|
6 | your host). In the following examples, 'username' is an example MySQL user which |
---|
7 | has the CREATE and GRANT privileges. Use the appropriate user name for your |
---|
8 | 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 login 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 following command: |
---|
22 | |
---|
23 | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, |
---|
24 | CREATE TEMPORARY TABLES ON databasename.* |
---|
25 | TO 'username'@'localhost' IDENTIFIED BY 'password'; |
---|
26 | |
---|
27 | where |
---|
28 | |
---|
29 | 'databasename' is the name of your database |
---|
30 | 'username@localhost' is the username of your MySQL account |
---|
31 | 'password' is the password required for that username |
---|
32 | |
---|
33 | Note: Unless your database user has all of the privileges listed above, you will |
---|
34 | not be able to run Drupal. |
---|
35 | |
---|
36 | If successful, MySQL will reply with: |
---|
37 | |
---|
38 | Query OK, 0 rows affected |
---|
39 | |
---|