Login to SSH and then MySQL (mysql -u root -p).
Execute following after replacing DATABASE, USERNAME and PASSWORD
For IPv4 (required)
GRANT ALL PRIVILEGES ON DATABASE.* TO 'USERNAME'@'126.96.36.199' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
You may also need to comment out following line in mysql config file.
/etc/mysql/my.cnf or /etc/mysql/mysql.conf.d/mysqld.cnf
Comment out following line from
bind-address = 127.0.0.1
#bind-address = 127.0.0.1
Once it's done you need to restart MySQL server by:
service mysql restart