How to Create a New User and Grant Permissions in MySQL

340

10

1

Posted in TechnologyRaspberry-pi

Introduction: How to Create a New User and Grant Permissions in MySQL

Log in to your PhpMyAdmin.

Select SQL from top menu:

Step 1:

To create a new user select users from top menu:

Step 2:

From there you can select Add user:

Step 3:

Add usernames and for host select localhost. Now because I need lower level user with less permissions I will select “Create database with same name …”from Database for user and doesn’t select anything else. Now if you want to give user Global privileges you can select them form bottom Global privileges area. It’s good idea to give users only permissions they need. If you are ready press Go. This will create the user and database named as the user. You can now log in with your new user.

Step 4:

If you need user with even less permissions the log in with your administrator user. Select Users. Behind every username is option “Edit Privileges”. Click this bad boy.

Step 5:

Now if you select “Database” option from top menu you can select and see which database user have permissions over. From top screenshot you can see that “newuser” has “all privileges” over newuser database.Now we select “Edit Privileges” and now you can see which action “newuser” can perform on the database “newuser”. And this is quick overview how you canmanage users and user privileges.

For more tutorials check jakemakes.eu

Share

    Recommendations

    • Microcontroller Contest

      Microcontroller Contest
    • Casting Contest

      Casting Contest
    • Woodworking Contest

      Woodworking Contest
    user

    We have a be nice policy.
    Please be positive and constructive.

    Tips

    Questions

    I'm trying to create new User the 2018 version on a Raspberry Pi 3 screen does not have USERS Tab??? Attached JPG. How do I create new User???

    PHPMyAdmin.jpg

    Comments

    Thanks for sharing :)