mysql error msg

fxpepper

Hello,

I am getting the following error:

mysql_connect() [function.mysql-connect]: Access denied for user 'password'@'1.111.22.211' (using password: YES)

can anyone tell me - is this trying to use the DB server IP or is this for the site server IP?
I am logging in thru the site server IP (for example (1.111.2222.211) but it should be using (1.111.22.222). Do you know how it gets this info to use the 1.111.22.211 for example??

does this make sense?? i am little new to this, can someone please assist?

thanks

bradgrafelman

fxpepper;10994335 wrote:
can anyone tell me - is this trying to use the DB server IP or is this for the site server IP?

Not sure what you're asking; it's going to connect to whatever hostname you give. The IP address shown in the error message refers to how PHP attempted to log into the DB server, thus the DB server is echo'ing back the IP of the server where PHP is being executed since that is the IP from which the access is being denied.

I'm also confused about the username being cited by the error message; are you really attempting to access the DB server with an account named "password", or were you instead obfuscating your actual DB password in the error message text?

fxpepper;10994335 wrote:
I am logging in thru the site server IP (for example (1.111.2222.211) but it should be using (1.111.22.222). Do you know how it gets this info to use the 1.111.22.211 for example??

As stated above, the IP in the error message is the IP from which the access request was made to the DB server.

fxpepper

thanks for your response.

yes, I used 'password' instead of place of actual password.

hopefully this clarifies:
When i log into to my ftp it shows the server ip (under host name) as 1.111.222.211 so I wasn't sure where it was getting the 1.111.222.222 from in the error message...
I am thinking if i can see where that info is coming from maybe i can update it. is this updateable from the config file?

any idea/direction?

thanks!

bradgrafelman

fxpepper;10994338 wrote:
yes, I used 'password' instead of place of actual password.

Well then that's a problem; the error message is showing what username you used to connect - it never shows a password. Thus, if it's displaying your password at that point, then I'd say you aren't calling [man]mysql_connect/man with the proper order of parameters.

fxpepper;10994338 wrote:
When i log into to my ftp it shows the server ip (under host name) as 1.111.222.211

Okay, but were you connecting to the same server where MySQL is running, or were you connecting to a different server (such as a webserver)? If it's the latter, then I don't see how this has anything to do with the problem at hand.

fxpepper;10994338 wrote:
so I wasn't sure where it was getting the 1.111.222.222 from in the error message...

It's doing exactly what you told it to do when you called [man]mysql_connect/man.

fxpepper

bradgrafelman;10994339 wrote:
Well then that's a problem; the error message is showing what username you used to connect - it never shows a password. Thus, if it's displaying your password at that point, then I'd say you aren't calling [man]mysql_connect/man with the proper order of parameters.

sorry, i checked and it is the username here - not the password. you are right

bradgrafelman;10994339 wrote:
Okay, but were you connecting to the same server where MySQL is running, or were you connecting to a different server (such as a webserver)? If it's the latter, then I don't see how this has anything to do with the problem at hand.

It's doing exactly what you told it to do when you called [man]mysql_connect/man.

this is where i get confused...on the server part...

I am trying to connect to the DB server (to set up a wordpress connection) i believe thru the config file (from the web server where the site is). does that sound right?

bradgrafelman

There's no need to guess where the connection occurs... the PHP error message will contain the file name and line number where mysql_connect() was called.

fxpepper

okay just to get a better understanding for myself on this:

mysql_connect() [function.mysql-connect]: Access denied for user 'username'@'1.111.22.211' (using password: YES)

is this 211 number for the DB server?? And is that the same as the DB host??
In config file i have the following:
define('DB_HOST', 'MySQL.brinkster.com'); Is the same as 1.111.22.211 ??

thanks!

bradgrafelman

fxpepper;10994342 wrote:
is this 211 number for the DB server??

As I have already explained in my first post above, no, this has nothing to do with the IP address of the DB server itself.

bradgrafelman wrote:
the DB server is echo'ing back the IP of the server where PHP is being executed since that is the IP from which the access is being denied.

bradgrafelman

Forgot to answer the second part...

fxpepper;10994342 wrote:
In config file i have the following:
define('DB_HOST', 'MySQL.brinkster.com'); Is the same as 1.111.22.211 ??

It could be, and it could be different. I am not your local DNS server, so I can't tell you what IP address(es) that hostname will resolve to.

fxpepper

So it sounds like it may be pointing to the wrong ip then...
since it's not coming up like I expect

okay, if that's right then talking about this was a lot of help : )

thanks again!

fxpepper

As I have already explained in my first post above, no, this has nothing to do with the IP address of the DB server itself.

just saw this...

still confused so will try to work thru it some more..
thanks tho.,

bradgrafelman

fxpepper;10994345 wrote:
So it sounds like it may be pointing to the wrong ip then...
since it's not coming up like I expect

Huh? How do you know it may be pointing to the wrong IP?

I'll say this again, since I don't think you've understood it yet: The IP address in the error message has NO RELATION WHATSOEVER to the IP address of the DB server.

There would be no need to include that information in the error message since it would be redundant; you already know the IP address used to reach the DB server since you already connected to it in the first place to get that message.

fxpepper

yeh, as i mentioned this server stuff is confusing to me.

but thanks so much

johanafm

You can consider the above as involving 3 ip addresses. Your ip (that is, the machine on which the browser runs), the web server ip and the database server ip. Do note that all of these might be the exact same ip address, since one single computer is capable of running a db server, a web server and a browser which can connect to the web server on the same computer (i.e. localhost or 127.0.0.1) which in turn connects to the database on the same computer. Also note that the connection from webserver to database server on the same maching doesn't have to connect via TCP/IP since it can use sockets or names pipes instead.

Now back to the part which brad referred to when he said that it has nothing to do with the db server's ip address

fxpepper;10994335 wrote:
mysql_connect() [function.mysql-connect]: Access denied for user 'password'@'1.111.22.211' (using password: YES)

To access the db server, you need to meet specific criteria, which are stored in the db. The criteria having to be met includes: username, password and ip address. YOUR ip address, not the database server's address.

Once again, if you manage to send your username and password to the db server, you obviously know how to reach it! The db server doesn't need to tell you this.

However, if you are connecting from an ip address which isn't allowed, the server has to inform you that you are not allowed to login just as if the username you are trying to login with isn't allowed. Thus, it tells you which ip you are connecting from, just like it tells you what username you were trying to connect with.

If you havn't allready understood it from the above, do note that the same combination of username and password might be allowed to connect from one or more ip addresses while being disallowed from one or more other ip addresses.

If you only use one single db user for your web stuff, that user should only ever be allowed to connect from the ip address(es) of your web server(s). Well, optionally you might just as well allow it locally (to the db server) as well.

fxpepper

johanafm;10994354 wrote:
You can consider the above as involving 3 ip addresses. Your ip (that is, the machine on which the browser runs), the web server ip and the database server ip. Do note that all of these might be the exact same ip address, since one single computer is capable of running a db server, a web server and a browser which can connect to the web server on the same computer (i.e. localhost or 127.0.0.1) which in turn connects to the database on the same computer. Also note that the connection from webserver to database server on the same maching doesn't have to connect via TCP/IP since it can use sockets or names pipes instead.

Now back to the part which brad referred to when he said that it has nothing to do with the db server's ip address

To access the db server, you need to meet specific criteria, which are stored in the db. The criteria having to be met includes: username, password and ip address. YOUR ip address, not the database server's address.

Once again, if you manage to send your username and password to the db server, you obviously know how to reach it! The db server doesn't need to tell you this.

However, if you are connecting from an ip address which isn't allowed, the server has to inform you that you are not allowed to login just as if the username you are trying to login with isn't allowed. Thus, it tells you which ip you are connecting from, just like it tells you what username you were trying to connect with.

If you havn't allready understood it from the above, do note that the same combination of username and password might be allowed to connect from one or more ip addresses while being disallowed from one or more other ip addresses.

If you only use one single db user for your web stuff, that user should only ever be allowed to connect from the ip address(es) of your web server(s). Well, optionally you might just as well allow it locally (to the db server) as well.

Johanafm - thanks so much for breaking it down. Although, i am still trying to get a handle on this, this definitely helps (if i am understanding correctly).
I think i was confused too b/c i had 2 different sites on the same server trying to connect to the same db server..
so i guess it would have been the username or password for this site that was giving me a problem...if we know the ip was okay...

anyway, thanks again : )