Unknown MySQL server host

Hi maxbenk26, 

I can't recreate that issue locally, or rather I can connect with ports such as 3305 when specified after the hostname, but on my WAMP stack doesn't seem to support 3311.

Can you try to connect from PHP directly and see if it works for you?

<?php
header("Content-type: text/plain");

$host     = 'localhost';
$user     = 'username';
$password = 'password';
$port     = 3311; // default 3306

$mysqli = new mysqli();
$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 1);
if (!$mysqli->real_connect($host, $user, $password, null, $port)) {
    die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
}

echo 'MySQL successfully connected to: ' . $mysqli->host_info . "\n";

Or put through a second level support request and we can take a look: https://www.interactivetools.com/support/request/

Thanks!

Thanks Dave for the answer.

What you wrote worked to connect:
MySQL successfully connected to: 18.9.14.3 via TCP/IP

But CMSB is not connected during installation

Hi Maxbenk26, 

Okay, try this code.  It replicates the code in CMSB: 

<?php
header("Content-type: text/plain");

$host     = 'localhost:3311'; // default 3306
$user     = 'username';
$password = 'password';

$mysqli = new mysqli();
$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 1);
$result = $mysqli->real_connect(
    hostname: $host, // can also contain :port
    username: $user,
    password: $password,
    flags   : 0,
);

// on connect error
if (!$result) {
    die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
}

// on success
echo 'MySQL successfully connected to: ' . $mysqli->host_info . "\n";

Mysqli should be able to take a hostname:port string as the 'hostname' argument.

Let me know if this works for you.  

Thanks Dave. Your script helped me find the problem. Now everything works!

Hi Maxbenk26,

Okay, great to hear.  Thanks for the update.