Apache Friends Support Forum

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

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...)

I hear what your saying, but where do I set up users?

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).

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!!

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.

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

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