I have a HA Setup that goes like this:
I made a user for the web server:
grant all on user_db.* to 'db_user'@'10.10.10.26' identified by 'password';
But when I try to access it via this command: Haproxy runs on 3306
mysql -u db_user -p -h 10.10.10.14 --port=3306
Access denied for user firstname.lastname@example.org or 10.10.10.16
Why does it use my HAProxy IPs? Is there any way to make it use my Web Server IP instead, for security reasons. Or is there any way to prevent my HAProxy servers from receiving data from a different IP? Example: allow only 10.10.10.26 then block the others.