DrupalManage
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
]
開始行:
** Database の設定 [#u12d2bcc]
*** MySQL に DRUPAL 用のアカウント (dba_user) を作成する ...
-- 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 bu...
mysql> GRANT USAGE ON *.* TO dba_user@localhost IDENTIFI...
Query OK, 0 rows affected (0.00 sec)
*** dba_user の drupal.* のアクセスに対して CREATE と GRA...
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@localh...
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' IDENTIFIE...
| GRANT CREATE ON `drupal`.* TO 'dba_user'@'localhost' W...
+-------------------------------------------------------...
2 rows in set (0.00 sec)
mysql> QUIT
*** MySQL に DRUPAL のデータベースを作成する [#m184d743]
[root@power htdocs]# mysqladmin -u dba_user -p create dr...
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 bu...
[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 bu...
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' IDENTIFIE...
| GRANT ALL PRIVILEGES ON `drupal`.* TO 'dba_user'@'loca...
+-------------------------------------------------------...
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' IDENTIFIE...
| GRANT ALL PRIVILEGES ON `drupal`.* TO 'dba_user'@'loca...
+-------------------------------------------------------...
2 rows in set (0.00 sec)
mysql> QUIT
Bye
[root@power htdocs]#
終了行:
** Database の設定 [#u12d2bcc]
*** MySQL に DRUPAL 用のアカウント (dba_user) を作成する ...
-- 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 bu...
mysql> GRANT USAGE ON *.* TO dba_user@localhost IDENTIFI...
Query OK, 0 rows affected (0.00 sec)
*** dba_user の drupal.* のアクセスに対して CREATE と GRA...
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@localh...
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' IDENTIFIE...
| GRANT CREATE ON `drupal`.* TO 'dba_user'@'localhost' W...
+-------------------------------------------------------...
2 rows in set (0.00 sec)
mysql> QUIT
*** MySQL に DRUPAL のデータベースを作成する [#m184d743]
[root@power htdocs]# mysqladmin -u dba_user -p create dr...
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 bu...
[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 bu...
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' IDENTIFIE...
| GRANT ALL PRIVILEGES ON `drupal`.* TO 'dba_user'@'loca...
+-------------------------------------------------------...
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' IDENTIFIE...
| GRANT ALL PRIVILEGES ON `drupal`.* TO 'dba_user'@'loca...
+-------------------------------------------------------...
2 rows in set (0.00 sec)
mysql> QUIT
Bye
[root@power htdocs]#
ページ名:
![[PukiWiki]](image/taikyoku.gif "[PukiWiki]")
