Error on views after restore a backup
I am getting backups in the following way:
mysqldump --user=$user --password=$password --skip-lock-tables --single-transaction --quick $database > $copia
The problem occurs after restore a backup and with some views for example:
select * from view_ac LIMIT 10;
Error 1449 (HY000): The user specifed as definer ('root'@'%') does not exist.
To solve the problem I execute the following instructions:
update user set host = '%' where user = 'root' and host='localhost';
flush privileges;
But the problem is that instructions enable the remote connections and that is a problem for the the security of my database server.
I have to tell that I have to restore 20 databases and I have a script that automatizes that task, so that is difficult to fix the problem in manual way.
Subject
Views
Written By
Posted
Error on views after restore a backup
647
September 16, 2022 05:56PM
Sorry, you can't reply to this topic. It has been closed.
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.