Create a MySQL user account
Posted by Quinn McHenry in 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';
About Quinn McHenry
Quinn was one of the original co-founders of Tech-Recipes. He is currently crafting iOS applications as a senior developer at Small Planet Digital in Brooklyn, New York.
View more articles by Quinn McHenry
View more articles by Quinn McHenry
The Conversation
Follow the reactions below and share your own thoughts.
November 11, 2008 at 1:21 pm, Murali said:
Hi friend. thank u very much. your sample code working good.
July 25, 2009 at 8:24 am, Anonymous said:
i want to join with this
April 13, 2010 at 11:31 pm, gavin said:
How would I prevent this new user from accessing database `information_schema` after creation?
June 14, 2010 at 5:15 am, Ashishvig 88 said:
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)
August 01, 2010 at 1:26 pm, Karon_44 said:
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