Discussion in 'PSA 2.0 Troubleshooting and Questions' started by ssteger, Feb 3, 2002.
How do I setup MySQL and Plesk to allow ODBC connections to a MySQL. Such as using MyODBC....
You dont need to do anything...
As long as the MyODBC drivers are installed on the Windows server, you should be able to connect fine (as long as you have setup the username/password)
The MySQL server is a linux server. The MyODBC is on my local machine. I use it to connect and edit my database on the remote server. I do this with another linux server that doesn't run Plesk, and am trying to figure out how to duplicate this with Plesk.
It should work fine "out of the box".
Whats the error you get ?
When I try to test the data source the error I get is
MySQL odbc 3.51 driver : 03.51.03
[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'my IP'
you'll have to insert a % into the host column in the mysql table
otherwise you won't be able to connect from a remote location.
UPDATE mysql set Host='%' WHERE Db='psa';
Sorry, small mistake:
UPDATE Db SET Host='%' WHERE Db='psa';
(be carefull with this though since your db username and password will be send over the internet unencrypted)
The Host is set to wildcard by default in PSA.
if i remember well that is true for all the databases you create using the plesk interface, not the psa database itself.
You know, you may be right about that. It has been a long time since I have looked at a clean install, and I always change all of my db's to localhost.
Dan ... are you changing those db's to localhost by yourself or do you have some sorta script for this ?
Nope, no script. My company is small enough still that I can just periodically go through and change them by hand. You could write a very simple script to do it though I suppose.
Right, well, I could try I suppose
You rember my problem when a client used his IP address instead of 'localhost'? I thought you said than that it could be solved if I changed the db's to 'localhost' only. But, I tried it but you can still use the IP address.
I thought that would do the trick. Did you reload MySQL after making the change?
Uhm ....*whissling* .... what?
So did it work or no?
yeah it worked. Thanks Dan.
Separate names with a comma.