-1

I want enable external connections in MySql , i added in my.cnf file :

bind-address with my specific ip

I Granted all the privileges to root

when i try to connect from mysqlworkbench i have this message

Can you help me ? Thanks

user2462353
  • 57
  • 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 Answers1

0

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
  • 42,670
  • 15
  • 104
  • 155