How to give access to the server by MAC address?

Question

MySQL

Task: There is a server on linux. How can I configure it so that only certain MAC addresses can connect to it, and the rest are immediately forwarded.
If you can somehow organize access from a specific list of devices - write, I will be glad.
PS I know that the MAC address can be changed, I don't need to talk about it.

Answer 1

#1227 - Access denied. You need SUPER privileges for this operation

delegate privileges to the SUPER user to the user who has the right to do so

Answer 2

Through iptables:

iptables -t nat -A PREROUTING -m mac --mac-source xx-xx-xx-xx-xx-xx -j ACCEPT (Host A)
iptables -t nat -A PREROUTING -m mac --mac-source xx-xx-xx-xx-xx-xx -j ACCEPT (Host B)
iptables -t nat -A PREROUTING -p tcp --dport 80  -j DNAT --to 127.0.0.1:8080

Via PHP:
https://stackoverflow.com/questions/1420381/how-ca...

If you can somehow organize access from a specific list of devices

Keys, VPN or VLAN (on the switch)

Answer 3

the easiest way - on a switch

Answer 4

I know that the MAC address can be changed, I don’t need to talk about it.

but about the level of the model, where does mac appear?
and yes, 802.1X