My views are getting access denied for all users

[MsCardoso77]

Describe the bug

I have created some views from the existing tables in my database. It turns out that after a few days, only these views are being denied access, even for me who created them. All other database tables are available.

To Reproduce

Steps to reproduce the behavior:

1. Create a view.
2. Use it as a query source in a nodejs api.
3. After a few days it will be denied access.

Expected behavior

The view should remain accessible, since all other tables in the database are available and only the view has access denied for all users in the database.

Screenshots

Server configuration

• Operating system: Percona Server
• Web server: Localhost via UNIX socket
• Database version: libmysql - mysqlnd 7.4.30
• PHP version: 7.4.30
• phpMyAdmin version: 4.9.7

Client configuration

• Browser: chrome
• Operating system: windows 10

Additional context

Add any other context about the bug here.

[williamdes]

Hi @MsCardoso77
I think stackoverflow.com would be a better help here as I think this has nothing to do with phpMyAdmin

When you export the view what is the definer?

---

By the way you should try the latest 5.2 version in development (phpMyAdmin 5.2+snapshot) also available as a non official docker image

It has a lot of fixes and is better appropriate than the version you currently use :)