Remote connection to mySQL

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

Remote connection to mySQL

Postby dec913 » 05. May 2009 15:40

I am currently attempting to set up SQL Maestro for mySQL. Having had problems connecting to the database from my laptop (the setup work fine in a test installation using localhost on the server) where I need to be able to work, their techincal support has told me that the problem is that I need to configure mySQL to allow remote connection.... how/where to I do this??? Desperatly want to be able to try out the this trial to ensure it does what I want before I have to pay for it, and the demo is time limited.

Any help please.
Thanks
Dec
dec913
 
Posts: 10
Joined: 17. April 2008 12:19

Re: Remote connection to mySQL

Postby Wiedmann » 05. May 2009 15:55

their techincal support has told me that the problem is that I need to configure mySQL to allow remote connection.... how/where to I do this???

You need a user, which is allowed to connect from remote hosts (and not only from localhost).

(BTW: If this techincal support doesn't know this about MySQL, a good idea to not use this program...)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Remote connection to mySQL

Postby dec913 » 05. May 2009 16:12

I hear what your saying, but where do I set up users?
dec913
 
Posts: 10
Joined: 17. April 2008 12:19

Re: Remote connection to mySQL

Postby Wiedmann » 05. May 2009 16:16

but where do I set up users?

In MySQL with any MySQL client you want (e.g. the MySQL command line client, SQL Maestro or phpMYAdmin).
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Remote connection to mySQL

Postby dec913 » 05. May 2009 16:29

I've added a user under phpMYadmin with host set to 'Any Host' but it won't let me log in with it. Sorry to be thick, but I think that I must be missing something really simple in the config of a new user under phpMYadmin.

I've VNC'd onto the server and attempted the login using phpMYadmin on the server directly and it still does not allow me to login!!
dec913
 
Posts: 10
Joined: 17. April 2008 12:19

Re: Remote connection to mySQL

Postby Wiedmann » 05. May 2009 16:33

I've added a user under phpMYadmin with host set to 'Any Host' but it won't let me log in with it.

Maybe a firewall is blocking the request. Setting the host part from a user to "%" is enough for remote connections.

Maybe the error message from your client give more hints.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Remote connection to mySQL

Postby dec913 » 05. May 2009 16:36

I've VNC'd onto the server and attempted the login using phpMYadmin on the server directly using the newly created user, and it still does not allow me to login!!

this what's setup?

User Host Password Global privileges 1 Grant
Any % -- USAGE No Edit Privileges
Any localhost No USAGE No Edit Privileges
dec % Yes ALL PRIVILEGES Yes Edit Privileges
pma localhost No RELOAD, SHUTDOWN, PROCESS No Edit Privileges
root 127.0.0.1 No ALL PRIVILEGES Yes Edit Privileges
root localhost Yes ALL PRIVILEGES Yes Edit Privileges
With selected: Check All / Uncheck All
dec913
 
Posts: 10
Joined: 17. April 2008 12:19

Re: Remote connection to mySQL

Postby Wiedmann » 05. May 2009 18:20

I've VNC'd onto the server and attempted the login using phpMYadmin on the server directly using the newly created user,

So you have opened a browser with "http://localhost/phpmyadmin/"?

- And then there was a login form?
- What is the "newly created user"?
- How have you created this new user?

it still does not allow me to login!!

Why? --> error message
Wiedmann
AF Moderator
 
Posts: 17106
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 24 guests