Connect to server

mysql -h 127.0.0.1 -u foo -p

Create database

Use UTF-8 as the default encoding.

CREATE DATABASE foo DEFAULT CHARACTER SET utf8;

Grant access

GRANT ALL ON foo.* TO 'bar'@'202.54.10.20' IDENTIFIED BY 'PASSWORD';
FLUSH PRIVILEGES;