I can't remotely access our database in Excel

Avatar
  • Answered
I have added our IP in the allowed hosts and can remotely access through HeidiSQL, but not through Excel using MySQL Connector/ODBC. What could be the possible cause?
Avatar
johnpaulb-imhs1
Hello, Thank you for your question. We are happy to help, but need some additional information such as the version of Excel you are using. What happens when you attempt to connect? Do you get any errors? What are the full error messages? Are following a tutorial such as this: Connect to a MySQL database? If not can you provide a link to the tutorial you are following? Feel free to post any additional questions below. Thank you, John-Paul