MySQL Forums
Forum List  »  Newbie

Re: Having One and Only User But Having Not Admin Permissions
Posted by: Barry Galbraith
Date: July 25, 2023 04:17PM

By default, root user has all privileges, including the ability to GRANT privileges to other users. Other users can only GRANT privileges if root user has GRANTed them the GRANT OPTION.

The bottom line.
Use root to run mysqldump.
Or, login as root and GRANT PROCESS privilege to 'Mike'
Be aware, PROCESS is a global privilege, so root will need to do something like this
GRANT PROCESS on *.* to 'Mike'@'%';

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Having One and Only User But Having Not Admin Permissions
July 25, 2023 04:17PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.