If you want to enable remote connections from all interfaces (i.e 0.0.0.0), your file would look something like below, however be sure you set up your firewall correctly if you do. If you need to check what the groups are for the other commands, there's an example my.cnf file here. To add bind-address you will need to add above it. You need to add the correct group above the command you're trying to put in otherwise the service wont start. It doesn't contain any configuration that I can edit. # The files must end with '.cnf', otherwise they'll be ignored.
# * IMPORTANT: Additional settings that can override those from this file!
# -print-defaults to see which it would actually understand and use. # Run program with -help to get a list of available options and with Here you can select The MySQL version, Tools, Connectors (like MySQL Workbench), and preview packages. When you attempt to install the package, it will ask you what product and version you want to install. # One can use all long options that the program supports. deb: sudo dpkg -i mysql-apt-configx.x.b where x.x.x-x is the MySQL version. # - "~/.my.cnf" to set user-specific options. # - "/etc/mysql/my.cnf" to set global options, # The MySQL database server configuration file. However, the /etc/mysql/my.cnf file on my Ubuntu has only: # I am trying to edit the my.cnf file to allow remote access and ultimately using software from my Windows Server to configure scheduled backup for MySQL Server.
0 kommentar(er)
