====== How to Create a User in Mysql and Grant Permission ======


''grant select on *.* to ‘reader’@’10.5.5.%’ identified by ‘<YOUR PASSWORD>’;''

This creates a user called reader who can connect from a machine with an ip address that starts with 10.5.5.
reader's password in this case is PASSWORD

----

''grant ALL on *.* to ‘root’@’10.5.5.%’ identified by ‘<YOUR PASSWORD>’;''

This creates a user called root who can connect from a machine with an ip address that starts with 10.5.5.
root's password in this case is <YOUR PASSWORD>

----

''flush privileges; > Is used to reload the privileges''

**Note:** Do not use the root account unless you are making changes to the database. For queries etc. please use the reader account!