I'm trying to figure out how to enable database connection to the database on one of our droplets from the remote application. I believe the IP is the same as the droplet, but is the port also 3306 or any other?
Anything else that needs to be done to make it happen?
I tried by just using the default port (above), the ip address and right credentials for the given database, but no luck.
This tutorial includes a section on enabling remote connections in MySQL. By default the MySQL service only allows connections from localhost so some configuration changes and a user with permissions to access your databases from a remote host are required.
Tried this tutorial for adding IPs but my file at /etc/mysql/my.cnf does not have a section with [mysqld]
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
where do I add
bind-address = your_database_IP
and how do I add several IPs?
Thx
Mike
my.cnf includes conf.d and mysql.conf.d. So check the file ./mysql.conf.d/mysql.cnf you'll find bind-address there. :)