Remote access

http://www.cyberciti.biz/faq/unix-linux-mysqld-server-bind-to-more-than-one-ip-address

Ubuntu.

Bind to ipaddress.

/etc//mysql/my.cnf

bind-address =

Xxx.xxx.xxx.xxx.

0.0.0.0

Any.

Restart MySQL.

verify

lsof -i -P | grep :3306

netstat -nlt | grep 3306

netstat -tulpn

Create user (user@<guest>)

Else.

Error. User not allowed to.

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';.

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;.

CREATE USER 'username'@'%' IDENTIFIED BY 'password';.

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;.

FLUSH PRIVILEGES;.