SQL Setup

[ielliott]

Hi, I'm a new user still evaluating the software. I'm having trouble with errors while setting up a SQL connection.

It's a MySQL database on a remote server. I'm assuming that I should be able to do this, instead of setting up a local database. I've also downloaded and installed the correct database driver, per the instructions. (Tried MySQL 4.0+ and 4.1+ - my version is 4.1.9)

The error I'm getting is:
SQL Error: Can't conncet to MySQL server on 'domain.com' (10061)

In the hostname, I simply have mydomain.com - I'm not sure what else it would be...

Thanks in advance for any help.

-Elliott

[Karlis]

Make sure:

1) You have permissions to access the database remotely (usually on MySQL only localhost connections are allowed)

2) There is now firewall that would block connection.

[ielliott]

Karlis,

Thanks for the quick reply.

The user I'm using to connect to MySQL can access the database using any host. I am at work right now, so a firewall may be preventing the connection through the specific port. I'll try from home tonight where I have control over my firewall and report back what I find.

Thanks again,
Elliott

[Karlis]

We have tested this feature and it does work, so it must be a connection problem.

[ielliott]

I've got this setup on a computer with all firewalls disabled, and I'm still getting the same error. I've double checked to be sure the user I'm attempting to connect with is allowed to access through any host.

Does anyone else have any ideas on this one?

-Elliott

[Karlis]

ielliott, can you connect using some other MySQL client software? Are you sure the rights are granted to yourusername@youripaddress ?

By the way what error message do you receive (full text with any codes included)?

[ielliott]

Hi Karlis,

I hadn't tried this before, but I tried connecting using MySQL GUI and could not connect. So, I did a bunch of hunting arround and found the following:

In your my.cnf file (typically in /etc) - you need to comment out the line that reads "skip-networking"

After doing this, I was allowed to connect using MySQL GUI with no problems.

However, now within Rapid, the error I recieve is:
SQL Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client

My current MySQL version is 4.1.9 and I'm using the driver for 4.1+ (I also tried the 4.0 driver just in case)


Thanks again for your help.
-Elliott

[HyrumR]

Hi,
I was also getting the same authentication error you are getting. What you need to do is set mysql to use the older method of password encryption.

mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');

Of course, the best solution would be to update the sql explorer so it understands the new password encryption routines, etc. but this works for me.

[ielliott]

Thanks HyrumR -

Yeah, I'd rather not use an older method of encryption.
It sounds like a newer MySql driver is needed.

[Karlis]

MySQL connectivity is provided using MySQL driver dll file, so we can't help there. Hopefully, MySQL vendors will release updated drivers.

[phper]

I was able to connect to a remote mysql database from RPHP. Didn't do anything special.. I had been using MySQL Query Browser to access it remotely.

[Doctor49152]

I use the free MySQL GUI available at http://www.webyog.com/sqlyog/

I just typed in my settings and was able to connect and do a whole whack of MySQL stuff. I use the exact same settings in WeBuilder and I get the Error.

I'd love to have the type of MySQL options that sqlyog gives me in WeBuilder .