Dear. I need to provide an end user, who does not know SQL syntax, a simple way to update and filter data from a MySQL database. Do you know any tool that facilitates this? Or something that can be integrated with the base to make simple queries, apply filters and modify data? The main objective is that the user does not have to consult and extract information through sql code. Thank you very much!
Through PHP you can create a program through which you can access the BD and create, read, update, delete (CRUD) ... whatever you want. The client would access this PHP program and you would schedule all queries in a completely transparent manner.
If the BD is hosted on a server you can perfectly create access privileges to your application and to the folder where the PHP program will be hosted, protect it by password through .htaccess, etc.