Hello, After setting some changes to different databases with GRANT (new users, set ALL PRIVILEGES for root etc), I get the following problem: lxs5:/ # mysql -h lxs5 -u root --password=sbcdef OBJEKT69 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 to server version: 3.23.33-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> GRANT CREATE ON OBJEKT69.* TO olaf IDENTIFIED by 'xxxxxx'; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'OBJEKT69' mysql> I only can change with GRANT on the OBJEKT69 database if I start mysql as root with the mysql-database. Is that normal? What happens, if I delete the users on the user table (or using REVOKE ALL PRIVILEGES ...)? -- Manfred Rebentisch COMPARAT GmbH Prießstraße 16, 23558 Lübeck Tel: 0451/4795660 Fax: 0451/4795662 www.comparat.de --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
