[development] install should optionally create the database
    Kevin Bullock 
    kbullock at ringworld.org
       
    Thu Oct 12 18:12:38 UTC 2006
    
    
  
My thoughts on this thread:
1. Sending a DBA username and password over a cleartext channel is bad. 
Users would do it without reading warnings if the feature is available, 
and their passwords would get out. -1 to requiring a DBA password via 
Web form.
2. Once a user is created and given rights, MySQL will allow that user 
to create the database the user has rights to. Yes, you can grant rights 
to a non-existent database. If you GRANT ALL PRIVILEGES ON db_name.* to 
the user, those privileges include {CREATE,DROP} DATABASE on that database:
===== Session transcript =====
$ mysql -u root -p
mysql> grant all privileges on drupal_db.* to drupal at localhost 
identified by 'super-secret password';
Query OK, 0 rows affected (0.16 sec)
mysql> quit
Bye
$ mysql -u drupal -p
mysql> show databases;
Empty set (0.00 sec)
mysql> create database drupal_db;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+-----------+
| Database  |
+-----------+
| drupal_db |
+-----------+
1 row in set (0.00 sec)
=====   End transcript   =====
3. All that aside, WordPress' "Famous 5-Minute Install" involves 
manually creating a database and a user with rights to it; I however 
still think it'd be nice to give Drupal the (optional) ability to create 
its own database.
-- 
pacem in terris / mir / shanti / salaam / heiwa
Kevin R. Bullock
    
    
More information about the development
mailing list