Create a MySQL user account

Posted October 12, 2003 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

The Conversation

Follow the reactions below and share your own thoughts.

  • Murali

    Hi friend. thank u very much. your sample code working good.

  • Anonymous

    i want to join with this

  • gavin

    How would I prevent this new user from accessing database `information_schema` after creation?

  • Ashishvig 88

    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

    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