0
It is recommended that I change a user’s connection location from the table mysql.user?
For example, I create a user 'danilo'@'localhost' but then I want it to connect from any machine, there’s another way I can do it without making a update on the table mysql.user?
1
Users work differently. A user must be registered according to where they can access. Although it is the same person when he accesses from one place or another the privilege should, in theory, be different. So it is not possible to change this user information, because it is a fundamental part of it. The correct is to remove this user and create a new one with the same privileges, but now accepting the machines you want right in the user’s name. He’s like an e-mail, a [email protected] is different from [email protected]. They could have left it isolated, but they didn’t.
There is the option of changing in the table itself by changing the data in the column. Although it works is not appropriate and do not expect it to always work.
Browser other questions tagged mysql sql mariadb permissions
You are not signed in. Login or sign up in order to post.