Evolution #3533

Script BD => Supprimer l'utilisateur avant de le créer

Added by Alexandre Cases about 8 years ago. Updated about 8 years ago.

Status:FerméStart date:05/02/2016
Priority:NormalDue date:
Assignee:Alexandre Cases% Done:

100%

Category:-Spent time:-
Target version:version 2.00

Description

Dans le script de la bd il faut supprimer l'utilisateur avant de le créer :

DELETE FROM mysql.user WHERE user='<USERNAME>';

SQL_SCRIPT="CREATE DATABASE IF NOT EXISTS pyros; GRANT USAGE ON *.* TO 
'$DB_USER'; DROP USER '$DB_USER'; GRANT ALL ON pyros.* TO 
'$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASSWORD'; 

GRANT ALL ON test_pyros.* TO '$DB_USER'@'localhost'"

History

#1 Updated by Alexandre Cases about 8 years ago

  • Tracker changed from Anomalie to Evolution

#2 Updated by Etienne Pallier about 8 years ago

  • Target version changed from version 2.01 to version 2.00

#3 Updated by Alexandre Cases about 8 years ago

  • Status changed from Nouveau to Fermé
  • % Done changed from 0 to 100

Also available in: Atom PDF