Shinnara's Blog
Talking with Shinnara :: NaraTalk.com

[shinnara /home/httpd/drupal]$ ls
CHANGELOG.txt      MAINTAINERS.txt    install.php        scripts/
INSTALL.mysql.txt  UPGRADE.txt        misc/              sites/
INSTALL.pgsql.txt  cron.php           modules/           themes/
INSTALL.txt        includes/          profiles/          update.php
LICENSE.txt        index.php          robots.txt         xmlrpc.php
[shinnara /home/httpd/drupal]$

  1 // $Id: INSTALL.mysql.txt,v 1.7 2006/09/08 16:29:35 dries Exp $
  2
  3 CREATE THE MySQL DATABASE
  4 --------------------------
  5
  6 This step is only necessary if you don't already have a database set-up (e.g. by
  7 your host). In the following examples, 'username' is an example MySQL user which
  8 has the CREATE and GRANT privileges. Use the appropriate user name for your
  9 system.
 10
 11 First, you must create a new database for your Drupal site (here, 'databasename'
 12 is the name of the new database):
 13
 14   mysqladmin -u username -p create databasename
 15
 16 MySQL will prompt for the 'username' database password and then create the
 17 initial database files. Next you must login and set the access database rights:
 18
 19   mysql -u username -p
 20
 21 Again, you will be asked for the 'username' database password. At the MySQL
 22 prompt, enter following command:
 23
 24   GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE
 25   TEMPORARY TABLES, LOCK TABLES
 26   ON databasename.*
 27   TO 'username'@'localhost' IDENTIFIED BY 'password';
 28
 29 where
 30
 31  'databasename' is the name of your database
 32  'username@localhost' is the username of your MySQL account
 33  'password' is the password required for that username
 34
 35 Note: Unless your database user has all of the privileges listed above, you will
 36 not be able to run Drupal.
 37
 38 If successful, MySQL will reply with:
 39
 40   Query OK, 0 rows affected
 41
 42 To activate the new permissions, enter the following command:
 43
 44   FLUSH PRIVILEGES;

[shinnara /home/httpd/drupal]$ mysql -u root -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 73
Server version: 5.1.21-beta FreeBSD port: mysql-server-5.1.21

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> insert into user (host,user,password) values ('localhost','drupal',password('xxxxxxxxxxxxx'));
Query OK, 1 row affected, 3 warnings (0.00 sec)

mysql> insert into db values ('localhost','drupal','drupal','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
Query OK, 1 row affected (0.00 sec)

mysql> exit
Bye
[shinnara /home/httpd/drupal]$ mysqladmin -u root -p create drupal
Enter password:
[shinnara /home/httpd/drupal]$ mysqladmin -u root -p reload
Enter password:
[shinnara /home/httpd/drupal]$ mysql -u drupal -p drupal
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 76
Server version: 5.1.21-beta FreeBSD port: mysql-server-5.1.21

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

The Drupal installer requires write permissions to ./sites/default/settings.php during the installation process.

All necessary changes to ./sites/default/settings.php have been made, so you should now remove write permissions to this file. Failure to remove write permissions to this file is a security risk.

!!중요!!

이때 settings.php 에 대한 write권한을 삭제하면 이후 첫번째 계정(관리자 계정)을 만드는 과정에서 문제가 생깁니다. 관리자 계정 설정후에 해당 권한을 삭제하시기바랍니다.