If you only want a user to have select permission; i.e., the user can see but not change any information, you can grant that with
to username@localhost identified by 'userpassword';
with the name of the data base, username
with the user's name, etc.
You must do this as the administrative user; i.e., mysql,
using the password you set for user mysql
-- save the above in a file, grant.sql
or something and execute
mysql --user=mysql --password=mysqlpassword < grant.sql
If you want to grant all permissions to a user, do this:
grant all privileges
on dbname.* to user@localhost
identified by 'userpassword';
Again, save that in a file and execute as above.