ssh - Centos mysql access remote -


i before login username : username, , no password. stopped working, created account, worked while. randomly stopped.

now users ( ssh)

enter image description here

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:

enter image description here

q: how can make work? why wont work out of suddenly? , tell me more how acually works?

you need grant access outside in mysql.

  1. go mysql server , login root user.
  2. run grant on db_name.* 'user'@'81.167.51.107' identified 'password' access particular ip address or grant on db_name.* 'user'@'%' identified 'password' ip address.

Comments

Popular posts from this blog

html - Outlook 2010 Anchor (url/address/link) -

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -