how to use mysql workbench connection component provided by market place to conect to a my sql database using mysql workbench via PSM?

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

how to use mysql workbench connection component provided by market place to conect to a my sql database using mysql workbench via PSM?

L0 Member

im using mysql workbench and the mysql workbench connection component to connect to a mysql database through PSM. when i click on the connect button in pvwa psm window opens and the mysql workbench software starts. then a popup window comes asking the password for the database and i have to manually enter it😶. how to fix this issue? also what are the ways to connect to a mysql database through PSM?

1 accepted solution

Accepted Solutions

L3 Networker

Hello everyone who reads this!

In reference of link https://community.cyberark.com/s/feed/0D550000062mfJNCAY , for me, the script stopped at the authentication window, not entering the password. So, I managed to run the script .au3 correctly inserting between the lines WinWait ("Connect to MySQL Server") and Send ($TargetPassword) new commands. So, that was it:

 

.

.

.

WinWait ("Connect to MySQL Server")

WinActivate("Connect to MySQL Server")

Send ("{TAB}")

Send ($TargetPassword)

Send ("{ENTER}")

.

.

.

for me, worked fine!!!

View solution in original post

12 REPLIES 12

L6 Presenter

Can you post screenshot of the account settings along with screenshot of Connection component you are using?

L4 Transporter

Can you post screenshot of the account settings along with screenshot of Connection component you are using?

L4 Transporter

check the version of Mysql if it supported

L4 Transporter

@Gayan Perera​ Any luck on this? I am facing the similar issue.

 

L3 Networker

@Gayan Perera​  were you able to fix this ? facing same issue

 

L3 Networker

Hello everyone who reads this!

In reference of link https://community.cyberark.com/s/feed/0D550000062mfJNCAY , for me, the script stopped at the authentication window, not entering the password. So, I managed to run the script .au3 correctly inserting between the lines WinWait ("Connect to MySQL Server") and Send ($TargetPassword) new commands. So, that was it:

 

.

.

.

WinWait ("Connect to MySQL Server")

WinActivate("Connect to MySQL Server")

Send ("{TAB}")

Send ($TargetPassword)

Send ("{ENTER}")

.

.

.

for me, worked fine!!!

Thanks @João Carlos de Ximenes​ 

It worked for me too thanks a lot

 

Regards,

Yogesh

Thanks @João Carlos de Ximenes​ 

It worked for me too thanks a lot

 

Regards,

Yogesh

Thanks @João Carlos de Ximenes​ 

It worked for me too thanks a lot

 

Regards,

Yogesh

L0 Member

Hi all,

 

A similar solution from my side was modifying the .au3 with the following where $hWnd1 is declared:

 

Local $hWnd1 = WinWait ("Connect to MySQL Server")

WinActivate ($hWnd1)

ControlSetText ("Connect to MySQL Server","","WindowsForms10.EDIT.app.0.34f5582_r6_ad11",$TargetPassword)

ControlClick ("Connect to MySQL Server","","WindowsForms10.BUTTON.app.0.34f5582_r6_ad13")

 

To detect the field to insert the password and "OK" button, I used the value of the parameter "ClassnameNN" which can be obtained with AutoIt v3 Window Info.

 

Then compiled the .au3 to .exe, added to psm\components folder, added to applocker and test.

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")

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

  • 1 accepted solution
  • 2916 Views
  • 12 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!