Re: Having One and Only User But Having Not Admin Permissions
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.
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.