|
We learnt that entering database connection settings again and again on "Upload MYSql data" panel was the pain point so we added an option to user where he can save connection settings and use saved connection profiles to connect on "Upload MYSql Data" panel.
|
|
Follow the steps below to "ADD/Manage Database connection" using SDB Explorer :
-
Run
SDB Explorer
as usual.
-
Go to Tools menu and select "Add/Manage Database Connection" sub menu.
-
It will open a new window to configure an Database Connection profile.
-
Click on New button to create new Profile.
-
Enter Profile Name. You can enter any name of your choice for profile to save the configuration.
-
You will find MySql as "Database Server Type".
-
Enter Host Address. Default local host IP 127.0.0.1.
-
Enter Port Number. Default port is 3306.
-
Enter User Name and Password.
-
You can test your connection before saving profile. Click on "Test Connection" button.
-
After successfully connection, you can save your profile by clicking on "Save" button.
-
It will ask you to save profile "With Password" or "Without Password" to protect your "Database Password" from malicious access.
-
After saving, this configuration gets added in left tree by its profile name.
-
You can edit your profile by selecting profile name from left tree and Click on "Edit" button.
-
Similarly if you would like to delete a profile then select profile name from left tree and click on "Delete" button.
|
Related Topics
|
|
