Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access Denied  myodbc  using ODBC on Windows XP Pro.

Posted on 2004-08-25
11
Medium Priority
?
508 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

670 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