Create a MySQL user account
Contributed by qmchenry 
Tagged: MySQL It is a good security policy to allow least privileges. Allowing all access to a system through a single account with all abilities is typically dangerous. Creating MySQL user accounts allows privileges to be granted as appropriate.
To create a user jsmith with password Secret15 and allow them to do anything with the database named accounts, connect to the database with mysql and issue the command:
grant all on accounts.* to jsmith@localhost identified by 'Secret15';
You may also like -
Connect to a MySQL server using the mysql command
Rename or change name of MySQL table
Vista: Making Only Administrators UAC Free
Leopard: How to Install Wordpress
Vista: Disable Secure Desktop When Prompting for Elevation
Create a MySQL database
Display a list of databases on a MySQL server
XP: Password and Account management
Murali said on November 11, 2008
Hi friend. thank u very much. your sample code working good.
Anonymous said on July 25, 2009
i want to join with this
gavin said on April 13, 2010
How would I prevent this new user from accessing database `information_schema` after creation?
Ashishvig 88 said on June 14, 2010
grant all on accounts.* to jsmith@% identified by ‘Secret15′;
i enter this command in mysql and also enter a flsuh priviliage but it not work is show error #1045 – Access denied for user ‘varun’@'localhost’ (using password: YES)
Karon_44 said on August 1, 2010
grant all on accounts.* to jsmith@localhost identified by ‘Secret15′;
where to excute this command I Just installed mysql-mysql-connector-odbc-3.51.22-win32 I am not able to login with localhost itself