Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

Trying to connect online mysql database from local computer

Home
Forums
Learn iOS Programming

Trying to connect online mysql database from local computer

mayur pandit

7yAsked May 9, 2019, 3:54 AM868Learn iOS Programming

I have use google cloud for hosting. I have use linux system for hosting. I have set up mysql

database there. My server name is localhost . But I have tring to access mysql database in my local computer using IP address. it's showing "Unable to connect to any of the specified MySQL hosts." Please suggest. Kidly help.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Mario Scheeren7y ago
Usually no one is allowed to connect to a mysql server who is not on localhost ( the computer mysql is installed on ). So you will have to GRANT permission to a user connecting from the outside world. If you are connectiong from a specific host / ip then grand rights for 'user'@'myHost' or 'user'@'myStaticIP' so that the user is allowed to connect FROM that host.

SHOW GRANTS FOR 'joe'@'office.example.com';
Piyush Pansuriya7y ago
Hi Mayur,
May be somthing is missing in connection string.
Please share your connection string once.