i resolved the issue myself. installed the wp-cli. used the wp-search-replace command to replace the old IP with the new IP.
also, I am unable to access phpmyadmin. so no luck there. i need to know what i can change from the ftp because that is the only access i have to the server and wordpress.