Creating New User In MySQL

posted on Nov 20th, 2016

MySQL

MySQL is an open-source relational database management system (RDBMS). It's name is a combination of "My", the name of co-founder Michael Widenius' daughter, and "SQL", the abbreviation for Structured Query Language.

The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.

Pre Requirements

1) A machine with Ubuntu 14.04 LTS operating system

2) MySQL Server installed (How to install MySQL in Ubuntu)

Creating new user in MySQL

The following steps to create a new user in MySQL Server.

Steps to follow

Step 1 - Enter into MySQL command line inteface(CLI). Open a terminal (CTRL + ALT + T) and type the following command.

$ mysql -u root -p

Enter password

Enter password :****

Step 2 - Creating new user

mysql> CREATE USER 'username'@'%' IDENTIFIED BY 'password';

Step 3 - Grant all privileges to new user

mysql> GRANT all on *.* to 'username'@localhost identified by 'password';

Step 4 - Flush privileges

mysql> flush privileges;

Creating New User In MySQL

Please share this blog post and follow me for latest updates on

facebook             google+             twitter             feedburner

Previous Post                                                                                          Next Post

Labels : MySQL Installation on Ubuntu   Connecting to MySQL with Java Program