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. 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?! Snapd/stable,now 2.37.I can't see your screenshots unfortunately. Sudo dpkg -purge mysql-workbench-community dpkg: warning: ignoring request to remove mysql-workbench-community which isn't installed sudo dpkg -purge mysql-workbench dpkg: warning: ignoring request to remove mysql-workbench which isn't installedĪnd when I try to install with snapd I got thisĮrror: system does not fully support snapd: cannot mount squashfs image using "squashfs": mount:/tmp/sanity-mountpoint-750692798: mount failed: Operation not permitted. Here is the content /etc/apt/sources.list GNU nano 3.2 /etc/apt/sources.list Maybe it created some kind of conflict that prevents me from installing it with apt or apt-get Most solutions I found was for Ubuntu and not for DebianįYI, at first I tried to install it by downloading and installing the following file mysql-workbench-community_8.0.23-1ubuntu20.10_b and it didn't work. I searched a lot on several forum for a solution but nothing works. When I try to install these dependencies it is a never-ending story of missing dependencies like described in this post: Recommends: mysql-utilities but it is not going to be installedĮ: Unable to correct problems, you have held broken packages. Recommends: ttf-bitstream-vera but it is not going to be installed Mysql-workbench : Depends: gdal-abi-2-1-2ĭepends: libgdal20 (>= 2.0.1) but it is not going to be installedĭepends: libmysqlcppconn7v5 (>= 1.1.7) but it is not going to be installed The following packages have unmet dependencies: The following information may help to resolve the situation: Requested an impossible situation or if you are using the unstableĭistribution that some required packages have not yet been created I get this error: Some packages could not be installed. I am trying to install MySQL Workbench on my Google Pixelbook. I first asked this question on StackOverflow but someone told me there that I have a better chance of getting an answer here
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |