Hi! I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS to that database. When logon with that new user and want to create a new user with some privileges a get an error.
How I do it: mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by 'haslo' with grant option; Query OK, 0 rows affected (0.00 sec) Now, I logon as user temp and create database temp: mysql> create database temp; Query OK, 1 row affected (0.01 sec) And finally I try to give some of my privileges to user temp2: mysql> grant insert on temp.* to [EMAIL PROTECTED] identified by 'haslo'; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' And I get an access denied error. What's wrong? I know that it should work but it doesn't. It works with MySQL 4.0.12 compiled by me from sources on RedHat. It doesn't work with 3.23.49 installed from deb on Debian. It doesn't work with 4.0.12 installed from binary distribution on Windows 2000. I think it is because of a configuration of MySQL. But what I have to change? Maybe it is something else? Please help me. Thanks, Blazo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
