I got a client who gave me the database details but no cpanel access i dunno how to connect manually can some one help me ? Is there and windows based software which allows me to connect to the database? i have the database name, database username and database password. thanks in advance.
To connect to mysql you can use several desktop softwares e.g. HeidiSQL. For other options visit the MySQL GUIs list.
MySQL user must have privileges to connect remotely. Ask your client to provide you any web based tool or grant access to mysql user to connect remotely.
bluehost.com does not allow database access without first loging into the cpanel first. You will have to get cpanel access from your client source: http://helpdesk.bluehost.com/index.php/kb/article/556
If you are denied, mostly because the host doesn't allow remote database connection before your IP is added to their "allowed ip list". For such situation, you will need to have a static IP first and then contact the host asking them to add your ip to the "allowed ip list".
hi mate Nantronix DB Connect OCX - This tool provides you with the ability to obtain a connection string to any ODBC compliant datasource or any SQL Server or Microsoft Jet 4.0 OLE DB database. When invoked, this OCX will display a Datasource Properties dialog box that will gather information from the user about the database that they want to connect to, then the OCX will pass back an ADO compliant connection string to your application. Only one line of code provides you with a valid verified connection string!