I am on the desktop now a mysql database, want to open for access to the rest of the local area network (LAN), but our side is dial-up Internet, dynamic IP, in order to let be people access my database, I can only give all people have access within the local area network (LAN) - grant all privileges on the. To 'root' @ '%' identified by '123456789' with grant option;
But it is not safe, I want to get the MAC address of the interviewer, to record and determine the visitor information, so that even if the IP has been changed, but the MAC is the same
Is encountering the question is: can access the network, by means of dial-up PPP adapter address is the same network segment, but Ethernet address is not the same network segment, although can PING, but there is no record ARP table MAC address, how to break?
If the idea is feasible and how to obtain the MAC address?
If there are other solutions?

CodePudding user response:

Your client in the local area network (LAN), they just use your LAN address access, has nothing to do with your Internet connection, and your IP networks outside also have no relation,
Control strategy is generally only for three layers, the IP address do,
Open database access to others, especially the root account, is a very unsafe practices,