Grant access permissions on MySQL

by mtecheasy on December 21, 2010

mysql> GRANT ALL ON <database>.* TO <user>@<host> IDENTIFIED BY ‘<password>’;

*** Note that if the specified user account does not exist, it will be created. ***

<database>: The name of the database, for example “my_new_database”.
<user>: The username that will be used to access the database.
<host>: The hostname of the server on which the database will be running.
<password>: The password you wish to set in order to limit access to the database.

Leave a Reply