[b354002] | 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 | |
---|
[d7a822e] | 23 | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, |
---|
| 24 | CREATE TEMPORARY TABLES ON databasename.* |
---|
[b354002] | 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 | |
---|