Comments - Connector-C error
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I have more information on this problem.
If I set the options so that only IPv4 addresses are used, then I get the same error for the IPv4 address of the localhost machine.
Here's the new information: I don't get this error if I statically assign IP addresses. The error occurs only when the IP addresses are assigned using DHCP.
So MySQL returns error 1130 when the IP address of the local machine was assigned via DHCP. How odd!
So MySQL and DHCP appear to be a toxic mix...
Given that the internet is filled with people experiencing the 1130 error over DECADES, I am a bit surprised that no one has made this connection between the 1130 error and DHCP being enabled!
I am not saying that all 1130 errors are caused by DHCP, but given most networking environments use DHCP, I think it's a good bet that a high percentage of the 1130 error instances are due to the DHCP and MySQL toxicith.
As there is no reason why such a problem with DCPH and MySQL should exist after decades of users experiencing error 1130, it seems that someone (everyone) is asleep at the switch!
MySQL should work the same in both static address assignment and DHCP environments, OBVIOUSLY!!!!!