[Bug 226851] Re: Users "not root" don't works correctly

2008-05-07 Thread Mathias Gug
Confirmed. TESTCASE: * Create a test user from mysql shell: CREATE USER X IDENTIFIED BY 'Y'; GRANT ALL PRIVILEGES ON *.* TO 'X'@'%' IDENTIFIED BY 'Y' WITH GRANT OPTION; FLUSH PRIVILEGES; * From the shell, try to connect to the server: mysql -uX -pY Gutsy result: access is gran

[Bug 226851] Re: Users "not root" don't works correctly

2008-05-06 Thread luca dep
The user was made by this script (where X and Y are user and password) CREATE USER X IDENTIFIED BY 'Y'; and privileges with GRANT ALL PRIVILEGES ON *.* TO 'X'@'%' IDENTIFIED BY 'Y' WITH GRANT OPTION; FLUSH PRIVILEGES; so I flushed privileges after giving them. The error was on access: [EMAIL PROTE