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!