How do I delete a remote mysql host? Set one up accidentally and now I can't delete.
If you did this in the WHM interface, simply go to WHM -> SQL Services -> Additional MySQL Access Hosts
and delete the line containing the remote host you do not wish to have connecting to your server.
If you did this in the cPanel interface, simply go to your cPanel interface and in the "Databases" section click on "Remote MySQL." On the page that appears, click the red "x" next to the host you wish to remove.
If you meant to say you set up a remote MySQL server and now want to move that back to localhost, please let me know.