I have a password to a database with all the databse privileges, except
reload, shutdown, process, file and with Grant options.
This is the administrator or super user password, with most of the
privileges. Someone else has created the data base. Now I'll maintain it. I
need to add a new user with select privilege. I tried with "FLUSH
PRIVILEGES", BUT THE SYSTEM GIVES THE ERROR: ACEESS DENIED. yOU NEED THE
RELOAD PRIVILEGE FOR THIS OPERATION." How can I add a new user, when I don't
have a grant option privilege?
any insights are greatly appreciated.