Save my password in the Connection dialog box needs to be changed first

Applies to

ApexSQL Search for MySQL

Symptoms

The message “Save my password in the Connection dialog box needs to be changed first” appears when the Object search feature is used.

Problem

When selecting a MySQL database in Server Explorer and using the Object search command either from the Server Explorer context menu or ApexSQL Search for MySQL main menu, the “Save my password in the Connection dialog box needs to be changed first. Modify the connection and try again” message appears as shown below:

The "Save my password in the Connection dialog box needs to be changed first. Modify the connection and try again" message

Solution

To avoid the occurrence of the warning message and enable smooth operation of ApexSQL Search for MySQL in Visual Studio, under the Server Explorer pane, right-click on the MySQL Server database, and from the context menu, choose the Modify Connection command:

Modify Connection command in the context menu of Server Explorer

In the Modify Connection window, check the Save my password checkbox and click the OK button:

Save my password check box under the Modify Connection window

Now, when trying the same thing as before, the Object search pane will appear instead of the warning message:

MySQL object search pane