I suggest you ...

← Service Improvement

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.

42 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Maekoboss shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

14 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • David commented  ·   ·  Flag as inappropriate

    I am very surprised this is unavailable. This is a line in the sand for us to use Cloudways.

  • Yasser commented  ·   ·  Flag as inappropriate

    We definitely need this feature. This is crucial to the security of the database.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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

  • Joseph Csoti commented  ·   ·  Flag as inappropriate

    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.

  • Thomas commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Please the ability to add multiple users with different privileges per database

  • Sergio commented  ·   ·  Flag as inappropriate

    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.

Service Improvement: Security

Categories

Feedback and Knowledge Base

(thinking…)