How to create a read only user for a managed DB

Hey there!

You should be able to do that by following the official DigitalOcean documentation here:

• How to Modify User Privileges in MySQL Databases
• How to Manage MySQL Users and Databases in a Database Cluster

For the read-only user, you would need to make sure that you only grant read-only privileges:

First, you’ll need to create the user in your MySQL database:

• How to Manage MySQL Users and Databases in a Database Cluster

After that revoke all of the default privileges for that new readonly user:

REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'readonly'@'%';

Next, grant the necessary privileges for read-only access. The SELECT privilege is all you need to give them the ability to read from the database.

GRANT SELECT ON your_database.* TO 'read_only_user'@'%';

Replace 'read_only_user' with the username that you used in the previous step and also replace your_database with the name of the database you want the user to access.

To ensure that the new privileges take effect, run the following command:

FLUSH PRIVILEGES;

Happy coding! 🚀

- Bobby

Heya,

I think you can follow these articles to achieve what you are looking for:

• How to Modify User Privileges in MySQL Databases
• How to Manage MySQL Users and Databases in a Database Cluster