While using SSL is highly encouraged, there are edge cases where it's not enabled, and therefore the connect-mysqlserver cmdlet fails.
Activity
cabozone commentedon Jun 29, 2018
In the file MySQL.psm1
Look for the $connectionString and add SslMode=none; in the variables.
$connectString = 'server={0};port={1};uid={2};pwd={3};database={4};SslMode=none;' -f .......
Add this to bot connection string lines and then
Remove-Module MySQL
Import-Module MySQL
Then try to connect again.
steviecoaster commentedon Jun 30, 2018
That's all well and fine. But the PR I put in to add the -UseSSL switch is much cleaner. Especially when you have systems with and without it.