What is the hostname of a LAN connection?

[rbsee]

I have installed MySQL in C:\mysql on computer A. When trying to connect to this MySQL database on some other computer on a LAN, such as computer B, is the hostname just the IP address of computer A, or is it some other path?

Does the computer with the database server need to be a server, or can it be a workstation? an example is an XP workstation. You can not share the entire hard drive of an XP workstation. You can only share a designated folder.

rbsee

 

[sleipnir214]

I assume you are asking about a hostname input in a MySQL client connect dialog. If so, then it's just the resolvable hostname of machine A or A's IP address.

There would in no case be a pathname involved. MySQL is a server -- you connect to that server, make queries, and recieve input in return. It's not like Access, where you open a file on a filesystem and manipulate that file using your local database engine.

MySQL should not care which of server or workstation it's running on. The only limit is that Mi¢ro$oft has deliberately limited the number of network connections that can be made to a workstation machine.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!