ssh - Centos mysql access remote -
i before login username : username, , no password. stopped working, created account, worked while. randomly stopped.
now users ( ssh)
i tired login user root, omg, username ( host %), , tried on root , testacc on ip adresses. nothing works. ( 100% sure using right passwords)
i while trying connect 1 of users:
q: how can make work? why wont work out of suddenly? , tell me more how acually works?
you need grant access outside in mysql.
- go mysql server , login
root
user. - run
grant on db_name.* 'user'@'81.167.51.107' identified 'password'
access particular ip address orgrant on db_name.* 'user'@'%' identified 'password'
ip address.
Comments
Post a Comment