how to connect mysql workbench to hostinger database

I am working on database project, my database is on hostinger. I want to connect mysql workbench to hostinger.

can please someone guide me how to do this.


In cpanel:

  1. Add remote IP Address to Remote MySQL

In Operating System: ODBC and MySQL Workbench

  1. Close MySQL Workbench
  2. Download and Install 32-bit or 64-bit MySQL ODBC connector from MySQL website
  3. Restart PC
  4. Configure ODBC (Windows run Win+R: %windir%\System32\odbcad32.exe )
  5. Add source and choose: MySQL ODBC 5.3 Unicode Driver

  6. Choose Data Source Name

  7. TCP/IP Server: mysql.hostinger.[top-level domain] (e.g. mysql.hostinger.nl or mysql.hostinger.in) !!! or Public IP address if it's given in cpanel at Remote MySQL on top of the page.
  8. Port: 3306
  9. Fill in: User and Password
  10. Test connection

  11. Start MySQL Workbench

  12. Fill in same data as ODBC connection and test connection.
  13. First SQL command have to be: USE [database name] ;
  14. show tables;