Putty(root serverú problem with whitelist

[MaStErIaKo]

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

[#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' 


[MaStErIaKo]

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 :/

[#dynastie]

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.