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

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">