Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
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.
The point is, you keep using localhost: but your problems are not with localhost, but external. You need to try connecting to the EXTERNAL ip of the machine, not 127.0.0.1.
But mysql is apparently not listening for external connections. Make sure there is no "skip-networking" entry in my.cnf. Also check for a bind-address = 127.0.0.1: there is one by default on most installs.
Distribution: Ubunto and slowly switching to debian
Posts: 308
Rep:
make sure your router is forwarding the mysql port to the local ip address on which the sql server is hosted and set my sql to lisen on the local ip address as from your router it will be accessing the loacal ip
also can you access it localy? and does your isp block port 3306?
and just out of curiosity how come you want to access your sql data base externaly? if its on a web site the same server i hosting set the PHP script to use the local ip and not external as with apache sql and php it reads the sql serverside and not client side so ther is no point in having the port open if thats what you are doing
It does work locally telnet localhost 3306 but not externally telnet ext_ip 3306, My ISP is not blocking that port, cuz i checked.
I have several customers that need enternal access (just temporarily) so I would like to know how to set this up. THey are using phpmaker and need to connect to the mysql server so they can work with phpmaker and there db.
the router is forwarding the port to the local IP of the server now how to I set mysql to listen to the local IP? do i add the following in the my.cnf file?
Have you considered using phpMyAdmin? That will give you an easy to use web access to your mysql databases, if all they need to do is edit, browse or backup their databases.
Yep, they and myself are using it right now, but the program that they are using phpmaker doesnt manage the db its connects to it and generates php code.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.