I want to enable external connections in MySQL. I added to my my.cnf file: bind-address with my specific IP. I also granted all the privileges to root.
when I try to connect from MySQL Workbench, I get this message
Asked
Active
Viewed 277 times
-1
TRiG
- 10,148
- 7
- 57
- 107
user2462353
- 57
- 1
- 10
-
Possible duplicate of [Your password does not satisfy the current policy requirements](https://stackoverflow.com/questions/43094726/your-password-does-not-satisfy-the-current-policy-requirements) – raina77ow May 29 '18 at 08:27
-
Ok i grant all privileges to root but I can not log in from MysqlWorkbench – user2462353 May 29 '18 at 09:01
1 Answers
1
This is not a privileges problem. The error message says a connection to the MySQL server could not be made. Hence it makes no sense to play with grants here. First check if you can "physically" reach the server. For instance ping the target machine and run a telnet command in a terminal to see if the server process is accessible. Firewall settings, other network related problems etc. may block access. Only when you have solved this you can continue with figuring out how to log in (which will give you a different error message, like Access denied for user blah@foo using password: YES or similar).
Mike Lischke
- 48,925
- 16
- 119
- 181
-
-
Ah, glad you found it! Please accept my answer then and if you think it's worth it you can even upvote. Thanks. – Mike Lischke May 30 '18 at 13:43