Hello all, I need a help with extended pattern "My SQL server On Windows and Linux".
I created an application credentials for MySQL database and used them in pattern:
Then I need the following commandline to connect to MySQL:
And I got the error:
I checked that username is right in error message.
If I tried this: "mysql -u" + "$$username$$" + " -p" + "$$password$$" + "--skip-column-names -e \"SHOW DATABASES;\""
I got another error:
Database administrator checked the strings on their side and it works fine for them:
- RDP to the Midserver
- Launch a putty session and connect to the discovered server (used same ssh private key as the one entered in ServiceNow credentials)
- Execute the query from command line : mysql –u username –ppassword ….
And he got the list of database.
Can you please help me why this error can be? Maybe we need additional rights or something else.
