IT: How to allow remote mysql access?

2018 m. vasario 21 d., trečiadienis

Edit MySQL config file:

$ sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Find line:

bind-address = 127.0.0.1

Change it to:

bind-address = 0.0.0.0

Restart MysQL Server:

$ sudo systemctl restart mysql.service

Logging to MySQL database, and create new user:

$ mysq -u username -p

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