Can't connect to (non localhost) mysql server from laptop or desktop.
Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Can't connect to (non localhost) mysql server from laptop or desktop.
I have set-up mysql on my home server machine which has a static ip address of 192.168.0.1. This is a command-line only version of Mandriva.
I then set-up the root sql password and created a database.
I have been running a program called Knoda on a couple of machines and that works just fine connecting to localhost as root, but I just cannot get it to connect to the mysql server running on my 192.168.0.1 home server.
I should say here that I am no expert on sql of any flavour and and learning as I go along. I have got databases up and running on a couple of machines running Knoda, but always connected to the mysql engine running on
that local machine.
Is it most likely to be a firewall issue? (Although I have tried switching it off to no avail.) Do I need to open up the relevant IP port for incoming traffic or should mysql have done that? Could it be a separate issue altogether?
Thanks for the suggestion, Dave. I can log in on the server itself as the user, but not from a remote machine, which makes me think it's something to do with the networking set-up rather than permissions.
on the DB host to punch a hole in the iptables firewall (assuming iptables is running). If there's still no joy, post the output from:
# netstat -pantu | grep LISTEN
So, looks like it's actually listening on 2273? Or is that a different package which is purely for management? If I change the frontend package (Knoda) to use port 2273 on 192.168.0.1 then I get bad username/password pairing error. Which suggests it's not what I should be logging on to as those credentials work if I ssh in to the machine and log on directly.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.