Mysql 5.6 and Ubuntu 15.10 Remote Connection

Asked

Viewed 77 times

1

I have a Droplet on Digitalocean with Mysql 5.6 on Ubuntu 15.10. Normally for remote connection I change the file /etc/mysql/my.cnf in the parameter bind-address = 0.0.0.0.

It turns out that in this version the file my.cnf comes only with the includes down below:

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

I couldn’t find where to change the bind-address = 0.0.0.0

I’ve already assigned permissions to the user.

In the version 5.6 of mysql the path of changed configuration file?

  • 1

    These directives point out that in these folders there are configuration files (.cnf) to be read. Probably the file you are looking for is in /etc/mysql/mysql.conf.d/mysqld.cnf.

  • @mrlew really this is the path file. I changed the parameter and get the remote connection.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.