How to Create a New user and Grant Permissions in MySQL

MySQL is an open-source relational database management software package to store organize or retrieve data. It has an extensible varieties of management options like user management with specific permissions to databases and tables.

In this guide you are going to learn how to create a new user and grant permissions in MySQL.

Choose Best Hosting for your Business.

To create a new user you need to login to your MySQL shell using the following command.

You will be prompted to enter your root password. Once you have logged in you can execute the following command yo create a new user.

Now a new user will get created but that user wont have any permissions to perform any operations in MySQL.

Here are a list of some common permissions that can be provided to the users in MySQL.


Read Full Post

News Link:
RSS Link:

Linux Chatter is a news aggregator service that curates some of the best Linux, Cloud, Technical Guides, Hardware and Security news. We display just enough content from the original post to spark your interest. If you like the topic, then click on the 'read full post' button to visit the author's website. Use Linux Chatter to find content from amazing authors!

Note: The content provided has been modified and is not displayed as intended by the author. Any trademarks, copyrights and rights remain with the source.

Disclaimer: Linux Chatter sources content from RSS feeds and personal content submissions. The views and opinions expressed in these articles are those of the authors and do not necessarily reflect those of Linux Chatter.