You are not logged in.
Hi there everyone!
I've been reading search result one after another that explains to /etc/mysql/my.cnf to comment the bind-address but it doesn't have anything in it but pulling other files in, so I just started going through all the linked files but I just can't find it anywhere.
Where is this setting and how do I change it?
Thanks for your time!
Schw.im! A social site with an identity crisis.
Offline
Hey, I found it in "/etc/mysql/mariadb.conf.d/50-server.cnf" and commented bind-address but on mysql restart I went from a complete failure to an error message:
"Host xxx.xxx.xxx.xxx is not allowed to connect to this MariaDB server"
I'm not sure what else would be blocking the connection. Any insight would be greatly appreciated!
Schw.im! A social site with an identity crisis.
Offline
Check your grants. MySQL identifies users by a tuple (user, host), written in the form user@host. If there is no grant for read privileges to a user user@theremotehost, or written with a wildcard for any host user@%, then the connection will be denied. Naturally, you would grant the remote user all the privileges it needs, plus, you need to be bound to an IP address reachable from the remote host.
Edit: See https://dev.mysql.com/doc/refman/8.0/en/grant.html.
Im grünen Wald, dort wo die Drossel singt…
Offline
plus, you need to be bound to an IP address reachable from the remote host.
So there is no "any host" option available with this privilege system?
Schw.im! A social site with an identity crisis.
Offline
plus, you need to be bound to an IP address reachable from the remote host.
So there is no "any host" option available with this privilege system?
There is. As I said, use the % wildcard for the hostname when creating grants. The matter of the mysql server being bound to a publicly reachable IP address is a different matter entirely. In the most simple case, you would bind to 0.0.0.0 to listen on all interfaces. IDK if the default of mysql is binding to 127.0.0.1 or 0.0.0.0 though.
Im grünen Wald, dort wo die Drossel singt…
Offline