How to create a user with the password in MYSQL???
Scenario: create a user "admin" with the password "admin".
Regards Durga.
INSERT INTO table_name VALUES ('admin', password('admin'));
Of course, if you don't want the password encrypted, remove the password() function.
RTM: http://www.mysql.com/doc/P/r/Privileges.html http://www.mysql.com/doc/G/R/GRANT.html