In testing the restore of database, if I delete user then run restore, user is added but no privileges. I have to reset them. The script includes this line:
GRANT USAGE ON *.* TO 'Vintage_Write'@'%' IDENTIFIED BY PASSWORD '*5DF2379450DE1FE82225FC5E38BEE0D9FC952776';
Not sure if it should be *.* since this user only has rights to 1 database (mariavintage).
Thanks for any help
Gary
TMyDump not restoring privileges
Re: TMyDump not restoring privileges
When dumping with the doUsers option enabled, the following actions are executed:
- the list of all users is retrieved
- the SHOW GRANTS FOR query is executed for each user, and the result of the query is then added to the dump.
- the list of all users is retrieved
- the SHOW GRANTS FOR query is executed for each user, and the result of the query is then added to the dump.