-- 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 ;