create_DB_User.sql 529 Bytes
Newer Older
Gerd Schachtschneider's avatar
initial  
Gerd Schachtschneider committed
1
2
3
4
5
6
7
8
-- lege user fuer die db an
 GRANT USAGE ON *.* TO 'mpg_gfk'@'localhost' IDENTIFIED BY 'password';
 DROP USER 'mpg_gfk'@'localhost';
 CREATE USER 'mpg_gfk'@'localhost' IDENTIFIED BY  '***';
 GRANT USAGE ON *.* TO  'mpg_gfk'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
 SET PASSWORD FOR  'mpg_gfk'@'localhost' = PASSWORD( 'Z8XwcFJmxepr4KL9' );
 GRANT ALL PRIVILEGES ON  `mpidb\_mpg\_gfk` . * TO  'mpg_gfk'@'localhost' WITH GRANT OPTION ;