1

My hosting site provided me phpMyAdmin on server's localhost. How to connect remotely to MySql using remote tool as Session Manager or MySql Workbench. When i work database in my website i use hostname as localhost. So question is what to fill in hostname in workbench. I already tried hosting site ip address, but couldnt connect with database. A screenshot

GingerHead
  • 8,130
  • 15
  • 59
  • 93
cybersuvidha
  • 11
  • 1
  • 2
    Does this answer your question? [How to access remote server with local phpMyAdmin client?](https://stackoverflow.com/questions/16801573/how-to-access-remote-server-with-local-phpmyadmin-client) – Jsowa May 19 '20 at 04:49
  • Did you check that your server is allowing this way to connect DB? – Sanjay May 19 '20 at 05:32
  • where to look for it. I am new in programming – cybersuvidha May 19 '20 at 14:46

1 Answers1

0

From the figure, you shared I can see you are using HeidiSQL software to connect with a remote MySQL server. Hostname/IP should be your hosting IP address provided by your hosting provider. You need to verify the port where your MySQL is running. Here you have set 3306 which is the default port. It could run on a different port. In the User and Password fields, you should use your username and password to login into your hosting server.

Raihanul Alam Hridoy
  • 441
  • 1
  • 7
  • 15