mlapl1
Posts: 66
|
| Posted: 12/05/2004, 6:00 AM |
|
I am running a MySQL database on a remote Linux machine.
I need to connect to that database for the design phase of my project.
When configuring the ODBC connection on my XP Pro PC, I enter the appropriate username (e.g. root) and password. When I test the connection, I receive the message: Access denied: root@CPE-139-168-153-181.nsw.bigpond.net.au (Using password: YES).
It looks very much as though the login name of root has had my IP etc address added to it and presented to mysql - and of course it is rejected.
How can I fix that, especially as my IP address gets periodically changed by my ISP? (i.e. I do not have a fixed address).
I have not played with CCS for a while but seem to remember having had the problem before (in the US) and having fixed it somehow. Back in Australia I cannot seem to get rid of it.
MySQL runs as localhost on the Linux box.
Thanks very much for your help
Andrew
|
 |
 |
mrachow
Posts: 509
|
| Posted: 12/06/2004, 2:40 AM |
|
On MySQL the access is not only restricted by a login but to the IP's the login is tried from too.
So a login can be configured to be allowed from localhost only, certain IP addresses, or all hosts.
Maybe that's your problem when tring over ODBC from your PC?
_________________
Best regards,
Michael |
|
|
|
gds
Posts: 1
|
| Posted: 12/07/2004, 6:03 AM |
|
Hello
Connections Setup:
1. MySQL: I have a clone database in my PC for test. (equal versions with the server database)
2: ODBC: I use this connector for a local clonebase. (Design side)
3: MySQL: I use a MySQL Library to connect a remote database. (Server side). You must put database name, localhost, user a password.
4: In local side you can use phpMyAdmin to modify users a passwords.
GDS
from Chile
_________________
all of them... |
|
|
|
nottheusual1
|
| Posted: 12/07/2004, 8:04 AM |
|
Try using the info you get from the rejection to set-up a remote host on your server. The rejection string is just info - it is telling you the rejection condition - CC wasn't adding that info to your login, mysql gleans that from your connection attempt. Also, if the database was just added, you need to restart mysql to be able to use the database.
Use the rejection string to set-up a correct "remote host" IP in your mysql server. Just remove the dashes and replace with periods. When you have an IP address that changes (I do, too, but it only changes about once every 3 months or so) you figure out your IP ahead of time and adjust the server accordingly. Don't forget to remove the unusable remote host info - even though obscure, security is security. I've never found a "better way", so if you do, please share it with us.
|
|
|
|
nottheusual1
|
| Posted: 12/07/2004, 9:19 AM |
|
My bad - you are adding "access hosts" not "remote hosts". Don't want to confuse anyone.
Let me know how it works out.
:not_the_usual1
|
|
|
|
mlapl1
Posts: 66
|
| Posted: 12/09/2004, 1:42 PM |
|
Thanks to everyone for your suggestions..
I will take on board everything that has been suggested and see if I can work on a solution that works for me.
I appreciate everyone's help
Andrew
|
|
|
|
|
