Shrinking MySQL DB – 'uptime' user grants problem

by Nov 7, 2018

Hi All,

I was following the article about DB shrinking (http://support.uptimesoftware.com/article.php?id=088) and I ran into the problem.

When I started the command: "mysqldump -uuptime -puptime -P3308 –protocol=tcp uptime > /backup/export.txt" I have got this response after some time:

"mysqldump: Couldn't execute 'show create table `element_status`': SHOW VIEW command denied to user 'uptime'@'localhost' for table 'element_status' (1142)"

Then I tried to add SHOW VIEW grant to user 'uptime' and I could not because 'uptime' user does not have enough grants to do that, when I tried to login as a 'root' I could not log in with my regular root password. So I assume I need MySQL root password for the Uptime. I tried to reset Uptime's root password, well if I succeeded, I would not be here now.

Thanks,

Mladen