Page 1 of 1

Remote Connections to MySql

PostPosted: 14. October 2009 21:22
by jcsnider
Overall, what I want to do is make it so MySql will allow connections remotely.

What I have found is that I have to put a # by Skip-Networking in the my.cnf File.
But, i cannot find the file anywhere. I have searched the whole computer. What do I do?

Re: Remote Connections to MySql

PostPosted: 14. October 2009 22:40
by denebgarza
I haven't really every dealt with remote MySQL connections... but IF you're editing everything correctly in your files, the only problem I could think of is your MySQL ports aren't open.

Re: Remote Connections to MySql

PostPosted: 15. October 2009 00:19
by Izzy
jcsnider wrote:...my.cnf File.
But, i cannot find the file anywhere. I have searched the whole computer. What do I do?
Go to xampp\mysql\bin folder and look for a file my which looks like a shortcut or in newer XAMPP versions look for my.ini file.

Open your text editor, notepad for example, and drag that my file into the opened notepad window for editing.

Continue to edit then save the file and restart MySQL.

It helps if we know what XAMPP version you are using as in the latest versions the file is named my.ini and in older versions it was named simply my.