Using different MySQL server

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Using different MySQL server

Postby lewis » 14. June 2013 00:54

Hi, was hoping someone could help me...

My PHP application connects fine to the XAMPP MySQL server ('localhost', 'root', '').

However I need to connect to a hosted MySQL server, while still running the app through localhost. I'm certain my host/login details are correct but it simply won't connect.

I can connect to it when running the PHP on a production server so I'm sure it must be a XAMPP config problem.

Any help would be hugely appreciated!

Thanks, Lewis
Posts: 1
Joined: 14. June 2013 00:45
XAMPP Version: 5.6.14
Operating System: Win 8 Pro x64

Re: Using different MySQL server

Postby Altrea » 14. June 2013 04:44

Hi lewis,

MySQL User that are allowed to connect from localhost are not automatically allowed to connect from remote hosts.
In reality you can specify the same username for many different hosts and all of them are unique and can have different permissions.

Ask your database Hoster if remote connections are allowed and possible and which connection parameters you need to connect.

It is not a XAMPP issue.

Best wishes,
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
AF Moderator
Posts: 7293
Joined: 17. August 2009 13:05
XAMPP Version: 5.6.3
Operating System: Windows 10 Pro x64

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 35 guests