How do I connect to mariadb from my local desktop?
New to Linode, have a linode running debian 9 and I installed mariadb.
I followed to directions from here: https://www.linode.com/docs/databases/mariadb/mariadb-setup-debian/
All worked fine, able to create a db, add a user, grant permissions and login but I want to remote access the database from my windows desktop using Mysql Workbench.
I followed these directions and it failed: https://www.linode.com/docs/databases/mariadb/mariadb-setup-debian/#remote-user-connections
The connection was refused. I'm connecting to the IP address provided on port 3306 using the user I created.
Any help or input about accessing the database on my new linode would be welcome.
Ah, right, just did that and is now working.
Hi barbedcoil i'm also trying to achieve a similar setup via an automation script i wrote in python. Basically i want to connect and get access to the database in the linode but am unable to connect due to the error mentioned below.
Can't connect to MySQL server on '22.214.171.124:3306' (10060 A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond)
I initially wrote the script for a mysql workbench as my employer mentioned that mysql was installed on the system.
And using the lish console and navigating to the .cnf files i found it was a mariadb setup.
So i want to know if there is some mistake in my script and if not then is this a connection issue.
I already commented the binding address line in /etc/my.cnf.d/server.cnf
Also can you elaborate how you changed the firewall settings.
Any help will be greatly appreciated.