470,849 Members | 1,137 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

remote MySQL connection fails

rb
I have two XP computers, with the same version of MySQL on each. I
have the same database structure and data on each. Each computer has
the same user name, and each MySQL database has the same user names.
Locally on each, I can connect and work with the data. I can ping
each computer from the other computer. My problem is that when I try
to connect from one computer to the other I get the following error:
Host 'XXX.XXX.XX.XX' is not allowed to connect to this MySQL server.
This happens on both computers. I can not find the reason for the
error.
Jul 19 '05 #1
4 5752
The Answer is in: Host 'XXX.XXX.XX.XX' is not allowed to connect to this
MySQL server.
This means (allmost everytime) that the MySQL server is configured to handle
only local connections.
You have to configure the MySQL server to handle all (or at least your IP's)
connections.

"rb" <rb***@yahoo.com> schreef in bericht
news:2a**************************@posting.google.c om...
I have two XP computers, with the same version of MySQL on each. I
have the same database structure and data on each. Each computer has
the same user name, and each MySQL database has the same user names.
Locally on each, I can connect and work with the data. I can ping
each computer from the other computer. My problem is that when I try
to connect from one computer to the other I get the following error:
Host 'XXX.XXX.XX.XX' is not allowed to connect to this MySQL server.
This happens on both computers. I can not find the reason for the
error.

Jul 19 '05 #2
The Answer is in: Host 'XXX.XXX.XX.XX' is not allowed to connect to this
MySQL server.
This means (allmost everytime) that the MySQL server is configured to handle
only local connections.
You have to configure the MySQL server to handle all (or at least your IP's)
connections.

"rb" <rb***@yahoo.com> schreef in bericht
news:2a**************************@posting.google.c om...
I have two XP computers, with the same version of MySQL on each. I
have the same database structure and data on each. Each computer has
the same user name, and each MySQL database has the same user names.
Locally on each, I can connect and work with the data. I can ping
each computer from the other computer. My problem is that when I try
to connect from one computer to the other I get the following error:
Host 'XXX.XXX.XX.XX' is not allowed to connect to this MySQL server.
This happens on both computers. I can not find the reason for the
error.

Jul 19 '05 #3
rb
Where is that configuration setting?

"Too Sexy" <so*****@nobody.com> wrote in message news:<bp**********@news1.tilbu1.nb.home.nl>...
The Answer is in: Host 'XXX.XXX.XX.XX' is not allowed to connect to this
MySQL server.
This means (allmost everytime) that the MySQL server is configured to handle
only local connections.
You have to configure the MySQL server to handle all (or at least your IP's)
connections.

"rb" <rb***@yahoo.com> schreef in bericht
news:2a**************************@posting.google.c om...
I have two XP computers, with the same version of MySQL on each. I
have the same database structure and data on each. Each computer has
the same user name, and each MySQL database has the same user names.
Locally on each, I can connect and work with the data. I can ping
each computer from the other computer. My problem is that when I try
to connect from one computer to the other I get the following error:
Host 'XXX.XXX.XX.XX' is not allowed to connect to this MySQL server.
This happens on both computers. I can not find the reason for the
error.

Jul 19 '05 #4
rb
Where is that configuration setting?

"Too Sexy" <so*****@nobody.com> wrote in message news:<bp**********@news1.tilbu1.nb.home.nl>...
The Answer is in: Host 'XXX.XXX.XX.XX' is not allowed to connect to this
MySQL server.
This means (allmost everytime) that the MySQL server is configured to handle
only local connections.
You have to configure the MySQL server to handle all (or at least your IP's)
connections.

"rb" <rb***@yahoo.com> schreef in bericht
news:2a**************************@posting.google.c om...
I have two XP computers, with the same version of MySQL on each. I
have the same database structure and data on each. Each computer has
the same user name, and each MySQL database has the same user names.
Locally on each, I can connect and work with the data. I can ping
each computer from the other computer. My problem is that when I try
to connect from one computer to the other I get the following error:
Host 'XXX.XXX.XX.XX' is not allowed to connect to this MySQL server.
This happens on both computers. I can not find the reason for the
error.

Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by rb | last post: by
reply views Thread by Ryan Stewart | last post: by
4 posts views Thread by courtney.machi | last post: by
4 posts views Thread by Jerim | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.