I am using Navicat to manage my databases. I can access remote mysql servers easily but have not been able to figure out how to access mysql via an XAMPP server on another computer on my local network.
The settings I am using for my connection are:
[local ip address of the computer I want to connect with, e.g. 10.0.1.7]
port: 3306 (Is this correct for XAMPP
UserNmae: as appropriate
Password: as appropriate
I am confused by the mysql documentation. It says:
"The server accepts the connection only if the Host and User columns in some user table row match the client host name and user name and the client supplies the password specified in that row."
Does this mean that on the machine I am logging onto, the user table on that machine needs to have the IP address of the machine I am logging on from, and a User and Password that match those give by the computer attempting to log on?
I have tried this and it doesn't work. I also tried other combinations of IP addresses, e.g. reversing the client & server addresses.
I also read on the Apache Friends web site that:
"Please note! Two servers cannot be started on one same port!"
What does this mean. If the computer I am logging onto has its server up and running, do I need to use a different port to log onto it? Which port?
Sorry if my questions reveal my ignorance of the issues. I have tried to educate myself on XAMPP, Navicat and MYSQL and still only have a vague grasp of the issues.
Can anyone help me?