add alias for IP and encoding to mysql