24/7 U.S. Support – 877-595-4482
If you have employed a developer to help create your website, you may often want to present a solution to accessin the database without actually giving Cpanel access to the developer. One of the free MySQL clients that can be used for this purpose is Heidi SQL. The following article shows how download Heidi SQL and configure to access a MySQL database setup on your server.
Before you begin, you can download HeidiSQL from here. Click on the link that says INSTALLER. Install HeidiSQL by double-clicking on the HeidiSQL_7.0_Setup.exe file that you download. When the installation completes, you will have the option to run the program and read the readme file. Go ahead and run the program and then go to the next part in accessing the database.
Before you can connect to the database using HeidiSQL, you will need to create an entry in Remote MYSQL. This allows the MySQL client to connect to the database. You will need to obtain the internet IP address for the individual using HeidiSQL to access the database. For more information using Remote MySQL, please go to How to use Remote MySQL. If you are unsure of your IP address, use this link: Find my IP address. Once you have the IP address, then you can add the IP address to the Remote MYSQL section as per below:
In order to configure this section, you will need to obtain the user name and password that you used when you created the database. The user name and the password do not need to be the original user name and password. You can also create a new user and assign that user to the database. In either case, the user should have complete access to the database.
|Email:||support@WebHostingHub.com||Ticket:||Submit a Support Ticket|
|Chat:||Click To Chat Now|