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.
4 Replies
Ah, right, just did that and is now working.
Thanks
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 '198.58.104.113: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.