Skip to content

Create a new MySQL user and grant permissions

If you have a server with multiple databases, you usually don’t want to access them with an account with privileges to them all from your application(s), in case of a successful hack. It’s better instead to create a new user and grant this user only privileges on the wished database. Here’s how to do that:

[sc name=”src” url=”https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql” ]

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.