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.
4  5858 
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.
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.
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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: rb |
last post by:
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...
|
by: Ryan Stewart |
last post by:
I'm running MySQL server on a WinXP box at home. I have a cable
modem/router. I've set up port forwarding on port 3306 to the machine
running MySQL. I can connect locally just fine, but when I try...
|
by: Ian Davies |
last post by:
Hello all
The following code allows me to connect to a local MySQL database on my pc
from a VB6 project.
****************************************************************************
**
Dim...
|
by: bettervssremoting |
last post by:
To view the full article, please visit
http://www.BetterVssRemoting.com
Better VSS Remote Access Tool including SourceOffSite, SourceAnyWhere
and VSS Remoting
This article makes a detailed...
|
by: Ike |
last post by:
Let's say I have a MySQL 4.12 database, opened to the internet on
111.111.111.111 allowing all incoming and outgoing ports. I have a username
and password setup, which CAN connect to this database,...
|
by: courtney.machi |
last post by:
Hello,
I am trying to connect to a remote mysql server through php. Here's the
code:
mysql_connect("my.hostname.edu", "username", "password") or die
(mysql_error());...
|
by: mcyi2mr3 |
last post by:
hi all how do i make a command line connection to a remote mysql
server?
for local connections i know it is: mysql -u root dbname
how do i connect to a remote server with a password?
thanks...
|
by: Jerim |
last post by:
I have a script on one server, trying to access the MySQL database on
another server. The server with the script is on an outside network,
hosted with another company. The MySQL server is here in...
|
by: jmohan |
last post by:
Dear Sir/Madam,
I develop a website in asp.net with c#. And also, I develop a toolbar in the toolbar studio separately.
Aim of the Website: Enabling the visitors to become a member of our...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
