DrupalManage の編集

** Database の設定 [#u12d2bcc]
*** MySQL に DRUPAL 用のアカウント (dba_user) を作成する [#v41a2ddd]
-- USER : dba_user
-- PASSWORD : drupalpassword
 [root@power htdocs]# mysql
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 9 to server version: 3.23.58
  
 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  
 mysql> GRANT USAGE ON *.* TO dba_user@localhost IDENTIFIED BY 'drupalpassword';
 Query OK, 0 rows affected (0.00 sec)
*** dba_user の drupal.* のアクセスに対して CREATE と GRANT 権限を与える [#je09b35d]
 mysql> GRANT CREATE ON drupal.* TO dba_user@localhost;
 Query OK, 0 rows affected (0.00 sec)
 
 mysql> GRANT GRANT OPTION ON drupal.* TO dba_user@localhost;
 Query OK, 0 rows affected (0.00 sec)
  
 mysql> SHOW GRANTS FOR dba_user@localhost;
  +----------------------------------------------------------------------------------------+
 | Grants for dba_user@localhost                                                           |
 +----------------------------------------------------------------------------------------+
 | GRANT USAGE ON *.* TO 'dba_user'@'localhost' IDENTIFIED BY PASSWORD '461f9fa12c5f22ee' |
 | GRANT CREATE ON `drupal`.* TO 'dba_user'@'localhost' WITH GRANT OPTION                  |
 +----------------------------------------------------------------------------------------+
 2 rows in set (0.00 sec)
 
 mysql> QUIT
*** MySQL に DRUPAL のデータベースを作成する [#m184d743]
 [root@power htdocs]# mysqladmin -u dba_user -p create drupal
 Enter password:  <---- drupalpassword
 [root@power htdocs]# mysql -u dba_user -p
 Enter password:
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 11 to server version: 3.23.58
  
 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

[root@power htdocs]# mysql
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 13 to server version: 3.23.58
  
 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  
 mysql> GRANT ALL ON drupal.* TO dba_user@localhost;
 Query OK, 0 rows affected (0.00 sec)
  
 mysql> SHOW GRANTS FOR dba_user@localhost;
 +----------------------------------------------------------------------------------------+
 | Grants for dba_user@localhost                                                           |
 +----------------------------------------------------------------------------------------+
 | GRANT USAGE ON *.* TO 'dba_user'@'localhost' IDENTIFIED BY PASSWORD '461f9fa12c5f22ee' |
 | GRANT ALL PRIVILEGES ON `drupal`.* TO 'dba_user'@'localhost' WITH GRANT OPTION          |
 +----------------------------------------------------------------------------------------+
 2 rows in set (0.00 sec)
  
 mysql> FLUSH PRIVILEGES;
 Query OK, 0 rows affected (0.00 sec)
  
 mysql> SHOW GRANTS FOR dba_user@localhost;
 +----------------------------------------------------------------------------------------+
 | Grants for dba_user@localhost                                                           |
 +----------------------------------------------------------------------------------------+
 | GRANT USAGE ON *.* TO 'dba_user'@'localhost' IDENTIFIED BY PASSWORD '461f9fa12c5f22ee' |
 | GRANT ALL PRIVILEGES ON `drupal`.* TO 'dba_user'@'localhost' WITH GRANT OPTION          |
 +----------------------------------------------------------------------------------------+
 2 rows in set (0.00 sec)
  
 mysql> QUIT
 Bye
 [root@power htdocs]#

タイムスタンプを変更しない

テキスト整形のルールを表示する