ODBC connection to MySQL

Discussion in 'PSA 2.0 Troubleshooting and Questions' started by ssteger, Feb 3, 2002.

  1. ssteger

    ssteger Guest

    How do I setup MySQL and Plesk to allow ODBC connections to a MySQL. Such as using MyODBC....
     
  2. PaulC

    PaulC Guru

    Messages:
    1,479
    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)

    Paul
     
  3. ssteger

    ssteger Guest

    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.
     
  4. PaulC

    PaulC Guru

    Messages:
    1,479
    It should work fine "out of the box".

    Whats the error you get ?

    Paul
     
  5. ssteger

    ssteger Guest

    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'
    (10060)
     
  6. iskander

    iskander Guest

    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.

    eg

    UPDATE mysql set Host='%' WHERE Db='psa';

    hth Iskander
     
  7. iskander

    iskander Guest

    Sorry, small mistake:
    should be

    use mysql;
    UPDATE Db SET Host='%' WHERE Db='psa';

    iskander

    (be carefull with this though since your db username and password will be send over the internet unencrypted)
     
  8. serve-you.net

    serve-you.net Guru

    Messages:
    1,896
    The Host is set to wildcard by default in PSA.
     
  9. iskander

    iskander Guest

    if i remember well that is true for all the databases you create using the plesk interface, not the psa database itself.

    hth

    iskander
     
  10. serve-you.net

    serve-you.net Guru

    Messages:
    1,896
    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.
     
  11. kark

    kark Guest

    Dan ... are you changing those db's to localhost by yourself or do you have some sorta script for this ?

    Kark
     
  12. serve-you.net

    serve-you.net Guru

    Messages:
    1,896
    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.
     
  13. kark

    kark Guest

    Right, well, I could try I suppose :D

    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. :(

    Kark
     
  14. serve-you.net

    serve-you.net Guru

    Messages:
    1,896
    I thought that would do the trick. Did you reload MySQL after making the change?
     
  15. kark

    kark Guest

    Uhm ....*whissling* .... what?

    Kark :eek:
     
  16. serve-you.net

    serve-you.net Guru

    Messages:
    1,896
    So did it work or no?
     
  17. kark

    kark Guest

    yeah it worked. Thanks Dan. :)

    Kark
     

Share This Page