Allow remote to access mysql on root

allow-mysql-access.md

Tutorial

• Step 1: Run the script

 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
 FLUSH PRIVILEGES;

Note: You have to change password to your password

• Step 2: Edit /etc/mysql/mysql.conf.d/mysqld.cnf

Change line:

bind-address          = 127.0.0.1

to:

# bind-address          = 127.0.0.1