Gostaria apenas de informar o que me ajudou a resolver esse problema.
eu ja tinha o mySql community instalado entao eu tive que reconfigura-lo, mudando o modo de autenticacao para legacy. solução encontrada no stackoverflow.
1) Open mysql installer. // busquei mysql comunity nos programas instalados
2) Click on Reconfigure (to the left mysql server)
3) Go to Authentication method tab (by clicking on Next twice.)
4) Then select the radio button Use Legacy Authentication Method. Click Next.
5) Enter your password. Click on Check. Go to Apply Configuration (by clicking on Next twice).
6) Click on Execute. Then Finish.
