Why mysql GRANT does not work?
I'm trying to create a database 'x' for user 'y' with password 'z'. The user does not exist also.
So, I did:
GRANT ALL PRIVILEGES ON x TO y@"%" IDENTIFIED
BY 'z' WITH GRANT OPTION;
(this line was directly from the mysql manual)
and I got:
Query OK, 0 rows affected (0.00 sec)
But nothing happens! I believe that "o rows affected" isn't good, right?
The user exists, but only can see the test and mysql databases.
The database was created also.
Does anyone know what is going on?