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.
Maekoboss
shared this idea
14 comments
-
DudeMan
commented
How is this not possible?
-
David
commented
I am very surprised this is unavailable. This is a line in the sand for us to use Cloudways.
-
Yasser
commented
We definitely need this feature. This is crucial to the security of the database.
-
Anonymous
commented
I've signed up to trial - all looks good apart from when I went to setup sql users. like everyone here i have a user for front end and user for admin with different privileges - was taken aback to find i can only have one sql user. Not good.
-
Marco
commented
I'd really need to be able to create DB users and manage privileges to connect MySQL to external services without using the main user
-
Federico
commented
+1, I also need this
-
Ada Maria Lorenc
commented
I would need read-only user for example, so different privileges
-
banarsiamin
commented
Please the ability to add multiple users with different privileges per database
-
Joseph Csoti
commented
I would like to see this implemented as well for security reasons. The policy of "least permissions possible"
This way a user can access the without admin credentials.
-
Anonymous
commented
Please the ability to add multiple users with different privileges per database
-
Thomas
commented
This will be great if it could allow to accept connections from external servers as well. So the ability to create custom users tied to a database per application with the ability to assign connection from/user/pass.
-
Den
commented
Please the ability to add multiple users with different privileges per database
-
Meisam
commented
The ability to add multiple users with different privileges per database
-
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.