MySQL create user

Step 1 - Create new MySQL user

---

MySQL create user

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

First let's see how to use the CREATE USER command. Here I have to mention that thi s command is available only in MySQL 5 (5.0.2) and newer releases. The syntax is the following: