Create user with full privileges in mysql

Global privileges – Privileges are grouped according to the version that supports.

Privileges support by all MySQL version

[table id=5 /]

Supports 4.0.2 version
[table id=6 /]

Supports 5.0 version
[table id=7 /]

Supports 5.1 version
[table id=8 /]

First check your MySQL version,

Now we go to MySQL database

We will check all user at mysql database

Now we create one user for example.

Back end of MySQL will execute command like below,

So just update mysql.user for myee user,

Now myee user has full privileges in localhost, if you wanna connect from outside just change host with you ip address.

Leave a Reply