How to add User in MySQL?

To add super user in MySQL with the username "gep", put the following two commands at prompt

GRANT ALL PRIVILEGES ON *.* TO gep@localhost IDENTIFIED BY ‘password‘ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO gep@"%" IDENTIFIED BY ‘password‘ WITH GRANT OPTION;

See also http://dev.mysql.com/doc/refman/4.1/en/grant.html

Posted: July 24, 2007

Comments »

The URI to TrackBack this entry is: http://wikinote.blogsome.com/2007/07/24/how-to-add-user-in-mysql/trackback/

No comments yet.

RSS feed for comments on this post.

Leave a comment

Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>



Anti-spam measure: please retype the above text into the box provided.