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
lewis
 
Posts: 1
Joined: 14. June 2013 00:45
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,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

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


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 176 guests