On Thu, 1 Aug 2024, Greg Wooledge wrote: > On Thu, Aug 01, 2024 at 14:47:49 +0000, fxkl4...@protonmail.com wrote: >> i have mysql on host1 >> i created a user for mysql so i could have access from 192.168.1.% >> that works fine >> on host2 i use "mysql -u user1 -p --host=host1" and it works >> if on host1 i use "mysql -u user1 -p --host=host1" it fails >> ERROR 1045 (28000): Access denied for user 'user1'@'localhost' (using >> password: YES) >> in /etc/hosts i have "127.0.1.1 host1.my-network host1" >> if i comment this line out, accessing mysql from host1 works > > Take one more step back: > > Do you have a local area network, with two or more hosts on it, and does > each of those hosts have an assigned IP address? > > I.e. is host1 *always* 192.168.1.5? > > If that's the case, then the correct fix is to change the 127.0.1.1 line, > replacing 127.0.1.1 with the assigned IP address (192.168.1.5 or whatever > it is).
all of my devices are served by dhcp but have a static address changing 127.0.1.1 to 192.168.1.5 works for me > > The 127.0.1.1 is a fallback for systems where the IP address isn't fixed. > It guarantees that your system will be able to look up its own hostname > and get *some* kind of working IP address. But if you have a fixed IP > address, you should use that instead. > > If your hosts are getting their IP addresses by DHCP, and you'd like them > to get the same address every time so that you *can* make this change to > your /etc/hosts files, then you'll want to tell your DHCP server to assign > a fixed IP address to each MAC address. >
