![]() ![]() I am using v.15 of the LAMP Stack appliance (Version 1.881 of the Webmin). Sorry they didn't get to you, but it looks like you did not need them anyway. My three screenshots were uploaded in the "Attached" section of the form used to start a new Forum topic. TurnKey appliances on AWS (either via the Hub or AWSMP) provide default security group settings that match the default firewall rules. TurnKey ships with firewall rules configured, but the firewall itself is not enabled by default (which we will likely change at some point in the future). ![]() I can't be sure, but I suspect that if you use those instructions and swap out your "garyroot" user where that says "root", it should still work.Īssuming that you are running your server locally, the firewall should not be giving you any grief. FWIW that's why we create an additional (root like) "Adminer" MySQL user. As something of an aside (as I note you are using a separate user) in v15.x appliances, without further config changes, root can ONLY connect from localhost (uses unix socket so no password required). There is actually a doc page that explicitly notes how to do this, although it needs checking/updating to ensure that it's still relevant to v15.x. Restart MySQL (to apply config change #1).Allowing the specific user you wish to connect with to connect from a remote address (or create a new user that is allowed to connect remotely).Enable listening for remote connections (in /etc/mysql/my.cnf IIRC).Personally, I'm a commandline user and I assume from your post you are using Webmin. All other appliances that include MySQL (technically MariaDB these days) are bound to localhost. To clarify and confirm, only the standalone "MySQL" appliance itself is pre-configured to allow remote connections. But it sounds like you are on the right track, but I'm not sure why it isn't working for you?! I can't see your screenshots unfortunately.
0 Comments
Leave a Reply. |