Is it recommended for me to change a user's connection location from the mysql.user table?
For example, I create a user 'danilo'@'localhost' but then I want it to connect from any machine, is there another way I can do this without doing a update in the mysql.user table?
Users work in a different way. A user must be registered according to the place where he can access. Although it is the same person when he accesses from one place or another the privilege should be, in theory, different. So it is not possible to change this user information because it is a fundamental part of it. The correct thing is to remove this user and create a new one with the same privileges, but now accepting the machines that you want directly in the user name. It's like an email, [email protected] is different from [email protected] . They could have left it isolated, but they did not.
There is the possibility of changing in the table itself by changing the data in the column. Although it works is not the suitable one and does not expect that it always works.
