MySQL Workbench not inserting password

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

MySQL Workbench not inserting password

L4 Transporter

Hi Everyone,

 

I am working with the MySQL workbench 8.

I have a very strange problem where the user name is put into the login screen.

The password is not inserted. If I type the password in manually it then authenticates and works with no issues. But I have to add the password manually every time. This is just not very secure I would like to get it to add the password as well.

Any ideas on this?

1 accepted solution

Accepted Solutions

L4 Transporter

The Solution to the MySQL Workbench 8.0 CE integration.

 

The problem with the CyberArk prebuilt integration from the CyberArk MarketPlace is that it is unable to input the password in the password block. After replacing the online 72

FROM: WindowsForms10.EDIT.app.0.1a0e24_r13_ad11

TO: WindowsForms10.EDIT.app.0.34f5582_r6_ad11

 

It was now able to put the password in the password field.

To resolve the auto login part (Clicking on the "OK" box) I had to change line 73.

FROM: WindowsForms10.BUTTON.app.0.1a0e24_r13_ad13

TO: WindowsForms10.BUTTON.app.0.34f5582_r6_ad13

 

That worked to fix the issue with the PSMMySQLDispatcher.exe

 

Do not forget to run the Compile Script to .exe.

View solution in original post

11 REPLIES 11

L4 Transporter

Field_Content_versions_oct20__068Ht00000RL8ZIIA1.png

L7 Applicator

if you check the box to save the password, what happens then?

 

-Matt

Hi Matt,

That opens a new rabbit hole with other problems, it pops up with a message about the password stored in the vault(Mysql Workbench).

So, I'm mostly familiar with Windows accounts using PSM, but for Windows accounts the connection needs to be able to save the password in order for the psm to input it automatically - I'm wondering if there is a similar situation/limitation on something like this as well.

 

what specific error do you see when you save the password?

 

-Matt

I wish the log file had more details. I have the Debugging running and there is nothing in it to do with the password.

The log shows the full process from start to finish, but it will not reveal the password, if that's what you're trying to get. You can follow the PID for each action through the log. its the number in brackets.

 

for example:

2/10/2023 15:45:00 [b76ac] CACPM652I Perform validation for password Operating Policyname.

 

the PID here is [b76ac] - so I can follow this in the log to see the full details of this transaction.

 

Hope this helps!

 

-Matt

L4 Transporter

The Solution to the MySQL Workbench 8.0 CE integration.

 

The problem with the CyberArk prebuilt integration from the CyberArk MarketPlace is that it is unable to input the password in the password block. After replacing the online 72

FROM: WindowsForms10.EDIT.app.0.1a0e24_r13_ad11

TO: WindowsForms10.EDIT.app.0.34f5582_r6_ad11

 

It was now able to put the password in the password field.

To resolve the auto login part (Clicking on the "OK" box) I had to change line 73.

FROM: WindowsForms10.BUTTON.app.0.1a0e24_r13_ad13

TO: WindowsForms10.BUTTON.app.0.34f5582_r6_ad13

 

That worked to fix the issue with the PSMMySQLDispatcher.exe

 

Do not forget to run the Compile Script to .exe.

You will need to make use of the tool AutoIT Windows Info to get these details if they change again.

L2 Linker

In my case, below PSMMySQLDispatcher.au3 script is working with MySQL Workbench 8.0.42. PSMMySQLDispatcher.exe is not required in Component folder.

 

++++++++++++++++++

Local $hWnd1 = WinWaitActive("Connect to MySQL Server", "", 10)

WinActivate ($hWnd1)

Send ($TargetPassword,1)

Send ("{ENTER}")

; ControlSetText ("Connect to MySQL Server","","WindowsForms10.EDIT.app.0.1a0e24_r13_ad11",$TargetPassword)

; ControlClick ("Connect to MySQL Server","","WindowsForms10.BUTTON.app.0.1a0e24_r13_ad13")

++++++++++++++++++

L2 Linker

In my case, below PSMMySQLDispatcher.au3 script is working with MySQL Workbench 8.0.42. PSMMySQLDispatcher.exe is not required in Component folder.

 

++++++++++++++++++

Local $hWnd1 = WinWaitActive("Connect to MySQL Server", "", 10)

WinActivate ($hWnd1)

Send ($TargetPassword,1)

Send ("{ENTER}")

; ControlSetText ("Connect to MySQL Server","","WindowsForms10.EDIT.app.0.1a0e24_r13_ad11",$TargetPassword)

; ControlClick ("Connect to MySQL Server","","WindowsForms10.BUTTON.app.0.1a0e24_r13_ad13")

++++++++++++++++++

Hello Andy,

Nice to see you here. I have tried the above adjustments with the reviewed parameters using the AutoIT Windows Tool and still the password won't populate. Am I missing something?

  • 1 accepted solution
  • 818 Views
  • 11 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!