Cannot make remote connection to MySQL

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

Cannot make remote connection to MySQL

Postby shsavage » 30. March 2009 22:26

Hello,

I have an xampp installation running on Windows Server 2000, with a firewall set up that allows traffic on port 3306 to come through. My web applications operate normally. But when I try to set up a remote connection from Toad for MySQL, I cannot get in to MySQL. I get "access denied" messages. Does anybody know how to connect to a MySQL database remotely?

Thanks,

-Steve
Stephen H. Savage
GAIA Lab
School of Human Evolution and Social Change
Box 872402
Arizona State University
Tempe, AZ 85287-2402
shsavage
 
Posts: 4
Joined: 18. October 2005 21:16
Location: Tepme, Arizona

Re: Cannot make remote connection to MySQL

Postby Wiedmann » 30. March 2009 22:43

But when I try to set up a remote connection ... I get "access denied" messages.

You need a user like user@% in MySQL.

The default user in XAMPP have user@localhost (only connections from localhost are allowed).
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 159 guests