I implement one service on a hosting and I need to give users access to some MySql database tables (different users have different tables). You can of course implement the database access interface yourself (something like a user database to interact with the main one), but I don’t want to reinvent the wheel. Maybe there are some database engines through which you can implement this.
|
1 answer
It is not clear what you are looking for, here are the options:
Bookin bookin
3,443 five 15
- I have phpMyAdmin by default. adminer also tried. I need to give users of my site to give access to the database. i.e so that they could go there and see (change) only certain tables under their logins - antonin14d
- @ antonin14d did not think about it, but did not create users with access to certain tables in mysql dev.mysql.com/doc/refman/5.7/en/grant.html - Naumov
- if it can be good. I will try - antonin14d
- @Naumov correctly wrote, it is possible to differentiate if there is access. But the task is strange of course) - Bookin
- In the same phpmyadmin, on the user edit page, you can configure access at the database and table level - Bookin
|