Search code examples
phpmysqlidatabase-connectionwamp

How can i solve this "Warning: mysqli_connect(): (HY000/1049): Unknown database" problem?

I downloaded an Event management software and install wamp server. Everything is fine but when I try to sign up into the website, it is showing me this

( ! ) Warning: mysqli_connect(): (HY000/1049): Unknown database 'eventmanagmnt' in C:\wamp64\www\Emsp\connection.php on line 2

Call Stack
#   Time    Memory  Function    Location
1   0.0507  403176  {main}( )   ...\Login.php:0
2   0.1265  404264  include( 'C:\wamp64\www\Emsp\connection.php' )  ...\Login.php:2
3   0.1266  404264  mysqli_connect ( )  ...\connection.php:2
Solution

  • New versions of WAMP seems to install both MySQL and MariaDB. And when I logged in through the phpMyAdmin, I saw that the MySQL is using the port 3308.

    enter image description here

    So in my PHP code, instead of using just localhost for my database hostname, I added the port to it like this: localhost:3308 and it worked.

    $db = new mysqli('localhost:3308', 'root', 'password', 'db_name');