Creating database user in MySQL

Tutorials Shared by the Internet Community


  Top Tutorials     New Tutorials     Submit     Login     Register  

Creating database user in MySQL

In this MySQL create user article I try to summarize how you can add a new user to your MySQL database.
  • Total Hits: 22358

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating


  • Total Votes: 154 votes

  • Category: MySQL/MySQL Misc

  • Submitted on: 2008-04-15 01:22:12

  • Submitted By: Shekhar

  • Set as Favorite


Nowadays security is more and more important even in case of smaller websites. As a lot of site uses some database so this is one point where we can make some improvements.

In this article we will work with MySQL on our goal is to create a new user in the database.

There are more ways how you can do this.

Using CREATE USER and/or GRANT commands

Inserting a new record into the mysql.user table    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 37.01%  57
 Two starsTwo star  Vote LeftVote MiddleVote Right 11.04%  17
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 12.34%  19
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.69%  18
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 27.92%  43

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.