I use the new MYSQL. What I found is that you have to specifiy the account that you actually use to connect to the MYSQL databases in the Grant Option Command.
I used the '%' and it didn't work but when I entered 'mysql' which is the account I use it worked fine.
I hope this helps anyone trying the Grant command with new MYSQL
|