vendredi 12 janvier 2007
2 minutes db+ user creation
Par Nicolas, vendredi 12 janvier 2007 à 10:24 :: geek stuff
Where is this damn script supposed to create a database and a user with all the rights on it? Well here, it should work with almost all the db you use for dev purposes (Oracle, MySQL, HSQL...) :
create database myDB;
grant all on myDB.* to 'myUser'@'localhost' identified by 'myUser' with grant option;
grant all on myDB.* to 'myUser'@'localhost.localdomain' identified by 'myUser' with grant option;