12/20/2023 0 Comments Mysql workbenchlinux![]() ![]() Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name It seems like there is only one line that has anything to do with MySQL, and that line allows connections on port 3306 only from 127.0.0.1Īctive Internet connections (only servers) The output from "netstat -tunlp" is reproduced below. What's baffling me is that, on the "MySQL Server Configuration" page of the Webmin, I have "MySQL server listening address" set to "Any". ![]() Whenever I make any changes, I simply reboot the entire appliance, just to be on the safe side. MySQL Workbench does not let me connect using "adminer" either.ģ. In the MySQL "user" table, I checked the table column entries for "garyroot" against the table column entries for "adminer", and they match, except for the "Password" column. User "garyroot" is a MySQL user I created with the "User Permissions" page of the Webmin, and it has "Any" underneath "Hosts", just like "adminer". etc/mysql/my.cnf appears to be a link to /etc/alternatives/my.cnf, which appears to be a link to /etc/mysql/mariadb.cnf, which does not contain a "bind-address" line.Ģ. In regard to the three steps you outlined:ġ. I am attempting to connect to MySQL using MySQL Workbench 6.1 which is running on my personal workstation. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |