localhost is a little confusing.
in fact it has nothing to do with mysql at all.
localhost is a reference to the ip 127.0.0.1
connections can me made to ip addresses on specific ports.
apache uses 80 so localhost:80 or 127.0.0.1:80 is what apache binds to.
mysql binds to 127.0.0.1:3306.
wamp doesnt need to be running at all because wamp is just a menu that will start and stop the apache and mysql services.
A service on windows is a way for windows to control an exe in a controlled, reliable and automatic manner.
so for example the mysqld.exe which is the exe used for services is started by telling windows to start the wampmysqld service.
if you just want to use the mysql.exe this will result in the command prompt staying open unless you start it in a cmd shell with the -c command
provided that the port is open in the firewall, on windows the ip address of the machine will be used for remote connections.
so if pc with a LAN IP of 192.168.1.2 is running mysql on port 3306 , you will access this on all pcs on the network with the host name 192.168.1.2
if the remote pc is not on the same LAN network , then you can use the WAN IP. If a router is involved, you will use your WAN IP and then have the router forward all connections on port 3306 to the internal LAN IP.
Regardless of this, mysql is usually set up very securely with just access for localhost and 127.0.0.1
To allow someone else to connect , you need to create a new user and give the ip of the pc that will want to connect. you can also use a wild card to allow anyone, but this is not recommended.
regarding ODBC, Mysql needs a specfic connector to be installed > [
dev.mysql.com]
Steven Martin
stevenmartin99@gmail.comstevenmartin99@hotmail.comPampServer.com - [
pampserver.com]