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:
- Add remote IP Address to Remote MySQL
In Operating System: ODBC and MySQL Workbench
- Close MySQL Workbench
- Download and Install 32-bit or 64-bit MySQL ODBC connector from MySQL website
- Restart PC
- Configure ODBC (Windows run Win+R: %windir%\System32\odbcad32.exe )
Add source and choose: MySQL ODBC 5.3 Unicode Driver
Choose Data Source Name
- 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.
- Port: 3306
- Fill in: User and Password
Test connection
Start MySQL Workbench
- Fill in same data as ODBC connection and test connection.
- First SQL command have to be: USE [database name] ;
- show tables;