'Is there any way to edit Information_schema in mysql
I know information schema is read only but I ran into a problem. I've imported mysql database. Information_schema db also got copied. Its 'views' table has a definer set. I wish to change this as this is causing problems to access some tables.
It gives me access denied to root which has all the permissions and I also tried running mysql with --skip-grant-tables option but with no help.
Is there any way I can change the definer?
Note: its Innodb
Solution 1:[1]
As mentioned in the manual:
Inside INFORMATION_SCHEMA there are several read-only tables. They are actually views, not base tables, so there are no files associated with them, and you cannot set triggers on them. Also, there is no database directory with that name.
Hence they are read only and can't be manipulated.
Solution 2:[2]
I have solution to the original problem I faced of not accessing the tables: 1) Create user that was not created. 2) There was actually a view which had a definer set. I dropped the view and recreated with the definer as my own user.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Garima Dhaka |
| Solution 2 | Ankit Arora |