[Spip-maintainers] Bug#651158: spip: Package should prepare a MySql DB for spip

[Olivier Berger]

On Tue, Dec 06, 2011 at 11:18:47AM +0100, Olivier Berger wrote:
> 
> Hi.
> 
> AFAICT, there's nothing ready after installation, DB wise.
> 
> The package depends on MySQL, and the /spip/ecrire process requires connection to a DB with appropriate login/pass... still, the admin has to manage the creation of such a user and so on.
> 
> So at least one would expect directives in README.Debian on how to do so, or even better, a use of db-config to prepare the necessary steps WRT to the MySQL server.
> 

Btw, the mysql instructions could be :
# mysqladmin -u root -p create spip
Enter password: 
# mysql -u root -p  spip
Enter password: 

mysql> GRANT ALL ON spip.* TO spip at localhost IDENTIFIED BY 'yourownsecretpass';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

But YMMV...

Best regards,
-- 
Olivier BERGER 
http://www-public.it-sudparis.eu/~berger_o/ - OpenPGP-Id: 2048R/5819D7E8
Ingenieur Recherche - Dept INF
Institut TELECOM, SudParis (http://www.it-sudparis.eu/), Evry (France)