Putty(root server� problem with whitelist

11/23/2014 20:06 MaStErIaKo#1

Evening fellow EPVPers,

one good friend of mine helped me with setting an IP Whitelist for my Navicat. But well, my IP adress changed and i can't log in to my Navicat :( and i can't reach my friend as well... Would someone help me to regain my acces into navicat? I have full controll of Putty (Root server) but cant acces the navicat... Help please :handsdown: :handsdown: :confused:

11/23/2014 20:27 #dynastie#2

PHP Code:


			
UPDATE mysql.user SET host(s) = '%' WHERE user = 'root' AND host(s) = 'your.old.i.p'

11/23/2014 20:32 MaStErIaKo#3

Quote:

Originally Posted by #dynastie

Log in with the root-localhost details to your mysql-server. You can change then the whitelist via query:

PHP Code:

UPDATE mysql.user SET host(s) = '%' WHERE user = 'root' AND host(s) = 'your.old.i.p'

Um root localhost details? It's a VPS server :/

11/24/2014 16:44 #dynastie#4

Quote:

Originally Posted by MaStErIaKo

Um root localhost details? It's a VPS server :/

Username and password to connect to the mysql-server directly via localhost, not even via a other host.