How does mysql determine the hostname of its clients?
I’m trying to create a MySQL user which will only be allowed to connect to the MySQL database from a specific hostname. grant all on db_name.* to ‘user_name’@’appserver-lan.mydomain.com’ identified by ‘some_passwd’ By checking the user table on the mysql db, I can see that the user was created successfully: use mysql; select * from user … Read more