Using PowerShell 3 to connect to MySQL DB

Question

I've been scouring the internet for guides on how to do this, and most seem to tell me to do exactly what I'm doing already. All I'm trying to do is connect to a MySQL database and retrieve a name from the database based on a parameter I pass. The problem is that I've been unable to connect to the database based on all the guides I've seen so far.

Here's one of the ways I've tried:

$connectionstring = "server=mysql.collegename.edu;uid=sconsdoc;pwd=password;database=namedatabase;"

try {
    $connection = New-Object MySql.Data.MySqlClient.MySqlConnection
    $connection.ConnectionString = $connectionString
    $connection.Open()
} catch {
    Write-Host "ERROR : Unable to run query : $query 'n$Error[0]"
} finally {
    $connection.Close()
}

I get the following error:

ERROR : Unable to run query : 'nException calling "Open" with "0" argument(s): "Unable to connect to any of the specified MySQL hosts." Exception calling "Open" with "0" argument(s): "Unable to connect to any of the specified MySQL hosts." Exception calling "Open" with "0" argument(s): "Unable to connect to any of the specified MySQL hosts."[0]

I'm pretty sure I've specified the correct host, and I know I have the correct login credentials (I can at least log in through phpmyadmin), so I'm not sure what's wrong. I've followed the format I've seen in several guides so I don't understand what's wrong here. If I'm supposed to pass arguments to open, what are they? Like I said this is the only format I've been able to find to use.

Ansgar Wiechers · Accepted Answer · 2013-05-15 09:43:53Z

2

"Unable to connect" sounds like a blocked connection attempt due to a closed/filtered port. Check if you can actually access the port on the remote server:

telnet mysql.collegename.edu 3306

If the database is listening on a non-default port you need to add the port to the connection string:

server=mysql.collegename.edu;port=12345;uid=user;pwd=password;database=dbname;

edited May 15, 2013 at 9:43

answered May 14, 2013 at 22:49

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

SRansom Over a year ago

I could not create a connection using the following command. could that also be because I didn't specify login credentials, or does that definitely mean that the port is closed?

Ansgar Wiechers Over a year ago

The command should have produced some output. What was that output?

SRansom Over a year ago

Connecting To mysql.collegename.edu...Could not open connection to the host, on port 3306: connection failed

Ansgar Wiechers Over a year ago

As suspected, either the port is blocked by some firewall, or the database server is listening on a non-default port. In case it's the latter (ask the server/DB administrator) add the port to the connection string (Port=12345;). Credentials can't be the issue here, because they can only be passed to the server after the connection was already established.

vbhosale Over a year ago

Same problem , did you got solution. please tell me

Collectives™ on Stack Overflow

Using PowerShell 3 to connect to MySQL DB

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related