Different MySQL users - one for managing database and one with limited permissions for usage in scripts
As many apps stores MySQL credentials in a plain text inside code. I suggest to provide us with 2 MySQL users
1) Admin user - with the most wide permissions
2) Script user - allowed only to manipulate with rows (CRUD)
This is common security practice on other hostings.
58
votes
Maekoboss
shared this idea
-
Sergio
commented
We also need this feature that is necessary let different users access the database(s). It's also important for security reasons to have more than one unique/single "master/main" database user with all privilegies to connect to database from a server outside of localhost.