SQL Connection error: Connection failed: Unknown MySQL server host 'localhost:3306' (0)

Question

I am not sure why I am getting this connection failed error. I am sure that the sever where the database is located is "localhost:3306". I'm currently using cPanel to access myAdmin.

My php code is

<?php

$server = "localhost:3306";
$username="root";
$password="";
$dbname ="mommyinfo";

$conn = new mysqli($server, $username, $password, $dbname);

if ($conn-> connect_error){
    die("Connection failed:  " . $conn->connect_error);
}

$sql = "SELECT title, dateposted FROM post";
$result = $conn->query($sql);

if($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo $row["title"] . $row["dateposted"] . "<br>";
    }
}else {
    echo "More posts coming soon!";
}

$conn->close();
?>

At the top of PHP My Admin it says: Server: localhost:3306 »Database: mommyinfo »Table: post

My goal is to get the five most recent posts to display in a div on my website. I've looked it up and I can't seem to find an answer that fixes it. Thanks in advance!

Possible duplicate: stackoverflow.com/questions/27328733/… — user3444714
– user3444714, Commented Apr 16, 2017 at 20:22
Possible duplicate of SQLSTATE[HY000] [2005] Unknown MySQL server host 'localhost:3306' (2) — gmc
– gmc, Commented Apr 16, 2017 at 20:40

Redswitches.com · Accepted Answer · 2017-04-17 02:40:08Z

13

Remove the port number from the configuration file , just keep the mysql server as localhost and then try.

answered Apr 17, 2017 at 2:40

Redswitches.com

5321 gold badge4 silver badges8 bronze badges

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

Comments

Pang · Accepted Answer · 2017-05-19 05:08:35Z

0

The tasks are:

restart your server.
You review if the service the mysql is starting
you quit the port
Or verify with ip address without any port or verify your port
If in services don't restarting else you stop the mysql server

edited May 19, 2017 at 5:08

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Apr 17, 2017 at 4:59

Mike Hurtado A

262 bronze badges

Collectives™ on Stack Overflow

SQL Connection error: Connection failed: Unknown MySQL server host 'localhost:3306' (0)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related