This is all within a MySQL console. This is going to assume you have a database server that is separate from your web server. I'll note where that matters.
First, we're going to make a database and default the character set and collation to good old fashioned UTF8. We first "show character sets" in order to get a list of supported character sets in your installed version of MySQL. Assuming UTF8 is available, we're going to use it. If it's not, pick another character set and collation.
show character set; create database `shootlocal` character set = utf8 collate = utf8_general_ci;
Next, we're going to create a user to connect to. Note the IP address, which tells MySQL to ONLY allow connections for that user from that IP address. You can also use 'localhost' if your web and database is on the same server. Optionally, use '%' to allow that user from any host (Least secure option).
create user 'some_user'@'123.45.678.910' IDENTIFIED BY 'some_password';
Lastly, we're going to set that user to have permissions on a particular database. We aren't going to GRANT ALL ON . because we like security. Instead, we specify some specific priviledges. Allow "LOCK TABLES" so your later mysqldump commands work properly.
grant LOCK TABLES, SELECT, CREATE, DELETE, INSERT, UPDATE on *.* TO 'some_user'@'123.45.678.910'