Freelancer's Playground! New knowledges every now and then

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!