Granting Mysql access from Azure Ubuntu server

It is assumed Mysql on the Ubuntu Vm has been installed

Set an endpoint for Mysql

Look for my.cnf and change the bind address. They should be in one of the following locations.

·         /etc/my.cnf

·         /etc/mysql/my.cnf

·         $MYSQL_HOME/my.cnf

·         [datadir]/my.cnf

·         ~/.my.cnf

#Replace 127.0.0.1 with your IP Address

bind-address        = 0.0.0.0

Now use Mysql as root and execute the command below

CREATE USER 'trustedUser'@'%' IDENTIFIED BY 'SomePassword'; GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES ON *.* TO 'trustedUser'@'%';

Afterwards, try to connect to mysql database.

mysql -h hostname.cloudapp.net -u trustedUser -p