Solved

Access Denied  myodbc  using ODBC on Windows XP Pro.

Posted on 2004-08-25
11
504 Views
Last Modified: 2008-02-01
I am trying to access mysql on my remote database.  I am trying set up the ODBC connection using the windows xp ODBC interface.  When I use the test connection. It tells me that Access Denied for User  password YES.

I am setting this up to access the database using msaccess xp  on this end. Is it going to be possible. And if So, How?
0
Comment
Question by:chasferr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
11 Comments
 
LVL 17

Expert Comment

by:akshah123
ID: 11896277
Seems to me that you are not entering the right password.
0
 
LVL 17

Expert Comment

by:akshah123
ID: 11896304
Access Denied for User  password YES.

above message comes up when your odbc drivers reach the database and try to log in using the information that you provided but password is not right.  THus, you are reaching your remote database. Your username is also currect. However, either you are not providing password or it is incorrect.
0
 
LVL 1

Expert Comment

by:magicMush
ID: 11911198
When you try to access a mySQL server on remote desktop it will deny connection even if you have entered your username and password correctly.  This is due to security reasons.  What you need to do is add your ip address ( or hostname) (IP address of computer that connects to the server) to the MySQL servers known hosts list.
are you using any control panel for your remote host if you do there is usually an option (textbox ) where you can add yourIP to MySQL's host(Access Hosts) lists.




0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Expert Comment

by:newday
ID: 11913158
You need to tackle this in stages, as there can be a number of reasons that it will not work.

ON the server,

First establish the users that have access to the database. This can be found in the user privilege of you mysql data server.

At a minimum the must be a user configured with access from you clients IP address. This can be done specifically i.e. 192.168.1.23 or by sub domain i.e. 192,168.1.%

Ensure that you know if that user has a password set or not. No password is valid however if one is set then you must enter it at connection time.

On the client,

Create a new system DSN for the connection entering the drive, username and password

Use the test connection option to check that you have all the info entered correctly.

If you follow these steps you should quickly spot the cause of your problem, well it tends to work for me J
0
 

Author Comment

by:chasferr
ID: 11921922
newday   Thank you for your input. However, I have tried this extensively.  The info that is returned specifies that the user specfied "fsbo_OpenRealty" does not have access "password = YES".

I've tried without passwords, and with passwords.  I've use the extention fsbo_  I've tried it without it.   I also made sure that the user is added to the proper database within phpmyadmin. I've tried it on several different computers.  I am accessing using a windows operating system, with the myodbc3.5 for windows.  The server is on unix or linix whatever.  Same problem.  Hope someone can tell me something. Or, that it just can't be done
0
 
LVL 1

Expert Comment

by:magicMush
ID: 11925236
could you tell me how you access the remote server.
such as do you have ssh access to the server
or any control panel like
cPanel or Plesk

0
 

Author Comment

by:chasferr
ID: 11928597
MagicMush,
      I use cPanel on a remote server running mysql.  Unix or linux system.
0
 
LVL 1

Expert Comment

by:magicMush
ID: 11929702
Try:

in cPanel go to Manage Mysql/MySQL Databases

at the bottom of the MySQL page you will see

Access Hosts:
add the computers IP address to the access hosts.
and dont forget the wild cars are allowed.  (if you are using static ip you wouldnt need to use wildcards)

e.g if your ip is 81.31.154.25
you can use     81.31.154.%

IP addresses should be the on you access the internet with (assigned by your ISP) not any internal netwrok address if you are using more than one NIC.

OR you can do it with dns name
e.g
if your dns name is
spr1-bagu3-6-0-cust111.manc.broadband.ntl.com
you can use
spr1-bagu%-%-%-cust%.manc.broadband.ntl.com
how ever this will allow any one using ntl broadband to access you mysql database so make sure you use password.

this will allow other computers to access to MySQL database remotely.

this is how I access to my MySQL servers remotely using Java->ODBC connection.

Hope this will help and if you need any more info let us know :)


0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 13747493
PAQed with no points refunded (of 125)

modulo
Community Support Moderator
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question