How to allow ip connect mysql server code example
Example: mysql allow remote connections
#open /etc/mysql/mysql.conf.d/mysqld.cnf
#and change
#bind-address = 127.0.0.1
#to
#bind-address = 0.0.0.0
#then grant root all privaleges to root
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
#If you ran above command and accidently
#did not change password for root you can run this:
ALTER USER 'root'@'%' IDENTIFIED BY 'MyNewPass';