Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2003
    Location
    Wolverhampton, England
    Posts
    5

    Unanswered: MyODBC 3.51 Driver problems

    Hi guys, Im new here so please bear with me!

    Okay, Im having major problems at the moment not only with myself but with my tech support I bought the server off, they keep telling me the problem is not theres.

    I have a Cobalt RAQ4 server that is currently running MySQL. Ive created a MySQL database on it and thats fine. Im using WinXP on my local machine and have installed the MyODBC driver from www.wysql.com hoping to connect to it (in the long run Im trying to install the application from www.data-asap.com and it tells me I need to configure the DSN).

    Now Im having problems connecting remotely into the server from my machine using MyODBC and I keep getting the error "Access denied for user: 'root@pc-**-***-**-**-wv.blueyonder.co.uk'(using password: YES).

    Although I test the DSN connection on the server's ASP Server Administration (as localhost) and that connects successfully.

    I just havent got a clue where Im going wrong! Ive read other posts and sites that I might need to use GRANT functions but my knowledge on this is limited. Would I need to grant a new user with my IP address as opposed to root@localhost?

    Many thanks for any future help you can give me! A virtual beer goes out to anyone who can!

    Tim King

  2. #2
    Join Date
    Mar 2003
    Posts
    47

    Re: MyODBC 3.51 Driver problems

    Now Im having problems connecting remotely into the server from my machine using MyODBC and I keep getting the error "Access denied for user: 'root@pc-**-***-**-**-wv.blueyonder.co.uk'(using password: YES).
    hello,

    I'm a belgian webmaster & computer scientist.
    I have the same problem as you, Tim.
    I have to connect a mySQL database on the net thru a VB app.
    I try all the possible solutions (libmysql.dll, MyVBQL, MyODBC (DAO, RSO, ...) ans I always get the same error (access denied ...)
    This doc from MySQL website talk about the access denied problem:

    http://www.mysql.com/doc/en/Access_denied.html

    I try to manage with the users of the DB but nothing was successfull.
    I can't find any solution.
    I try to connect to 5 different MySQL server over the web and the result is always the same. When I use mu VB app on a localhost host MySQL server it works perfectly.

    You want to create a specific user with your IP and a password but your IP is dynamic. Everytime you connect the Net, your IP change.
    So you would have to create a user "%" with a password.
    I try this solution but it doesn't work.

    After 4 days of intensive searches, I'm now desesparate. I'm writing this problem on all dev-forums waiting for a solution rapidly.

    Is it possible that the webhoster block the remote connection to the MySQL server?

    I need help from experts rapidly.
    A belgian developer.

    P.S.: Sorry for my poor english.

  3. #3
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: MyODBC 3.51 Driver problems

    Originally posted by writeln
    hello,

    I'm a belgian webmaster & computer scientist.
    I have the same problem as you, Tim.
    I have to connect a mySQL database on the net thru a VB app.
    I try all the possible solutions (libmysql.dll, MyVBQL, MyODBC (DAO, RSO, ...) ans I always get the same error (access denied ...)
    This doc from MySQL website talk about the access denied problem:

    http://www.mysql.com/doc/en/Access_denied.html

    I try to manage with the users of the DB but nothing was successfull.
    I can't find any solution.
    I try to connect to 5 different MySQL server over the web and the result is always the same. When I use mu VB app on a localhost host MySQL server it works perfectly.

    You want to create a specific user with your IP and a password but your IP is dynamic. Everytime you connect the Net, your IP change.
    So you would have to create a user "%" with a password.
    I try this solution but it doesn't work.

    After 4 days of intensive searches, I'm now desesparate. I'm writing this problem on all dev-forums waiting for a solution rapidly.

    Is it possible that the webhoster block the remote connection to the MySQL server?

    I need help from experts rapidly.
    A belgian developer.

    P.S.: Sorry for my poor english.
    A few questions.

    Do you have access and control on the server you are connecting to ?

    Have you tried connecting with the MySQL client first ?

    In any case, the procedure to add a user is described here:
    http://www.mysql.com/doc/en/Adding_users.html

  4. #4
    Join Date
    Mar 2003
    Posts
    47
    Do you have access and control on the server you are connecting to ?
    --------------------------------------------------------------------------------
    for sure yes.
    I'm the owner, I have ftp access, login, password, ...
    In some of my accounts I already have a administration section to manage with the server.

    Have you tried connecting with the MySQL client first ?
    --------------------------------------------------------------
    What do you mean by MySQL client?
    I try a lot of solution, even one with the MySQL API but nothing works.

    In any case, the procedure to add a user is described here:
    http://www.mysql.com/doc/en/Adding_users.html
    --------------------------------------------------------------------
    To add or delete a user is very easy, I can do it.
    But all the users I've created make the same error (access denied for ...)
    Only localhost works fine.


    Any other solution or informations.??? I realllyyy need help SS

  5. #5
    Join Date
    Apr 2003
    Location
    Wolverhampton, England
    Posts
    5
    After a long hard slog last night I finally managed to solve the problem.

    writeln- I dont think your problem is the same as mine, because you already tried the % wildcard and that didnt work for you, but it didnt for me (Im fortunate that my workstation is on a static ip)

    You were right to the point I hadnt allowed access for external users. I simply used the wildcard and granted all privileges to root@'%' and it has solved the problem.

    All the info I needed to solve it I found @
    http://www.mysql.com/doc/en/Connection_access.html

    Hope this will help anyone else for has the same problem!

    Best of luck in solving your problem though, if I find anything out I will come back and let you know!

  6. #6
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1
    Originally posted by writeln
    Do you have access and control on the server you are connecting to ?
    --------------------------------------------------------------------------------
    for sure yes.
    I'm the owner, I have ftp access, login, password, ...
    In some of my accounts I already have a administration section to manage with the server.

    Have you tried connecting with the MySQL client first ?
    --------------------------------------------------------------
    What do you mean by MySQL client?
    I try a lot of solution, even one with the MySQL API but nothing works.

    In any case, the procedure to add a user is described here:
    http://www.mysql.com/doc/en/Adding_users.html
    --------------------------------------------------------------------
    To add or delete a user is very easy, I can do it.
    But all the users I've created make the same error (access denied for ...)
    Only localhost works fine.


    Any other solution or informations.??? I realllyyy need help SS
    The client come with MySQL distribution. The client app is mysql (mysql.exe on Windows) and the server is mysqld (mysqld.exe on Windows). After updating the users/privileges, did you FLUSH PRIVILEGES ?

  7. #7
    Join Date
    Mar 2003
    Posts
    47
    localy, no need to do that
    remotly, I cant flush privileges (what does this mean?)
    I have the right to create, delete and modify users, thats all
    I won't have any option or control panel to flush.

    In the society in which I work, the viaverio could do that, but actully our administrator is on holiday

    So I have to wait some more day for him to help me.

    But could you explain what flush privileges means?

  8. #8
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1
    Originally posted by writeln
    localy, no need to do that
    remotly, I cant flush privileges (what does this mean?)
    I have the right to create, delete and modify users, thats all
    I won't have any option or control panel to flush.

    In the society in which I work, the viaverio could do that, but actully our administrator is on holiday

    So I have to wait some more day for him to help me.

    But could you explain what flush privileges means?
    Writes the changes to the user/permissions/grants to make them effective. At the client prompt, just issue a FLUSH PRIVILEGES .

    In any case, I found a French MySQL documentation site:

    http://dev.nexen.net/docs/mysql/annotee/manuel_toc.php

    If you need further help, just give me your email and we'll continue this off-forum.

    Can speak French and English.

    Hope this helps.

  9. #9
    Join Date
    Mar 2003
    Posts
    47
    oki big thx to you all
    I will try to manage a solutions

    Here is my e-mail bstjean : swriteln@hotmail.com
    I have MSN if you want.

    I'm always searching a solution.
    If I need further help I will continue to post on this forum, and will contact you by mail.

    Thx all, pray for me however I will be vired

  10. #10
    Join Date
    Mar 2003
    Posts
    47
    I give you the last things I've discover.
    Almost all hosters block the remote conenction to mysql or any other DB for evident security reasons.

    You can verify this by telnet the IPort of your MySQL server.
    That's my problem actually all my hosters block the remote connection so my ODBC app cannot access the server.

    Many solutions are possibles:
    - find another host which allow this operation.
    - manage to create your own database on your own computer to allow you remote connections.
    - don't use BD, use files by FTP protocol.
    - Call a local script on your server that will generate a file (XML for ex) and access the file that contain the request result .

    Thx all for your help. I really hope that this will help someothers persons cause this problem give me hours of reflection and searches.

    Bye all

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •