DATAGRIP MYSQL CONNECTION ERROR

Completed

Hello,

I'm having trouble connecting to mysql remote. I have mysql 8.0.16 version and trying to connect as root user.It says access denied for user 'root'@' ip of my server' 

2 comments
Comment actions Permalink

@oto D,

Do you have access rights for your <ip>?

0
Comment actions Permalink

thanks vasily for reply. That was the issue. I added the user with username@'%',   % for any ip address. I could give it a my ip addr but I would be unavailable to connect with the server from another computer(another ip addr). I was wondering how safe it is to add user with %

1

Please sign in to leave a comment.