How To Create New MySQL User In Ubuntu

Few days ago I created a tutorial on how to create new database and table in mysql, in ubuntu and using GUI tool. Now, in this tutorial, I’ll show you how to create new MySQL user using the same GUI tool.

First of all, Launch mysql administrator or if you don’t have it yet, install it with this command: sudo apt-get install mysql-admin. After logging in, choose User Administration from side panel and click on New User. Entry form is then enabled, we could fill in the needed credential. Save it by clicking on Apply Changes.

By default, new user will be able to connect from anywhere. To change how this particular user be able to login, right click on it’s name in User Accounts section.

A new pop up window should appear where we could be able to set the needed domain setting. In this window, we will be able to set whether this user will be able to connect from any domain, a selected domain, or localhost.

Next, we need to set the schema privileges. Click on our newly created domain setting for this user then move on Schema Privileges tab to set this new user’s privileges. Save it by clicking on Apply Changes

Thats it, now we have new user!

Author: Arief Bayu Purwanto

Hello, my name is Arief Bayu Purwanto, a 24 years old father of a beautiful daughter. Interested in online programming, linux, games, and reading. Currently working on kapanlagi.com as junior developer. I live in a relatively quite and cool place called Malang. I'm available for some freelance stuff as well as some consulting job. You can see my portofolio for some previous task I've finished and some other information related to my capability. Btw, I'm plurking here.

  • test comment ah

  • test comment ah

  • nice article ! great . i love it !!!

    *spammer mode*

  • nice article ! great . i love it !!!

    *spammer mode*

  • whats wrong with grant all priviles on database.table to [email protected] identified by ‘passwd’ ?

    silent:Nothing’s wrong with that. I just want to show the GUI way ;))

  • whats wrong with grant all priviles on database.table to [email protected] identified by ‘passwd’ ?

    silent:

    Nothing’s wrong with that. I just want to show the GUI way ;))