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

Here is Solutions:

We have many solutions to this problem, But we recommend you to use the first solution because it is tested & true solution that will 100% work for you.

Solution 1

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.

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


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');

Solution 2

How can I solve this “Warning: mysqli_connect(): (HY000/1049): Unknown
database” problem?

If you are very sure you have created the database, then go to your connect file and add the port (3308) to your host variable [private $host = "localhost:3308";].
It’s worked for me.

Solution 3

In your connection.php line 2 verify your credentials if they’re correct for your localhost.

mysqli_connect("localhost","your_username","your_password","your_database_name");

When we download such a project we first have to check the connection for the database. If you could provide me with your php version and a snippet from your connection.php file.

Solution 4

For me this worked:

If you are using wamp 3.1.9 the problem is you created the database using MariaDB. Try to create or import the database using Mysql selection as the server choice it will connect.

Solution 5

For passing localhost–> use "localhost:3308" instead of just localhost or 127.0.0.1

see this code- $con = new mysqli("localhost:3308","root","","database_name");

Solution 6

The solution is using

$db = mysqli_connect('localhost', 'root', '', 'turbo_logistics','3308'); 

or

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

Note: Use and implement solution 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply