I installed WAMP server few hours ago into my Windows 10 64-bit computer. I used phymyadmin to create a database named 'testdb' and tried to connect to it with a php file. I am sure that I created the database, but it returns this error:
"Warning: mysqli_connect(): (HY000/1049): Unknown database 'testdb' in C:\wamp64\www\projects\index.php on line 7"
Here is the php file.
<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_NAME', 'testdb');
$link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);
?>
My problem is kind of similar (but not exactly same) to the following question.:
Database is created but return error as unknown database
(However in that case, the database was not created by the original poster. In this case, I am pretty sure I have created the database.)
This type of error occurs if you select any database that does not exist in MySQL. Let us first display the error of unknown database in JDBC. To remove this type of error, just go to MySQL command line and show all database names and use the chosen one from there i.e. the database which really exist.
Generally, This error indicates that the related database exists in a cPanel user's database map, but the database does not exist in MySQL.
Generally, This error indicates that the related database exists in a cPanel user’s database map, but the database does not exist in MySQL. The first thing that our Support Engineers perform on seeing this error is to check whether the database exists within MySQL. They does this by running the following command as the root user via SSH:
When connecting to MySQL, I get an "Unknown Database" error. You connect to the wrong cluster. You connect to a database that doesn’t exist in your specified cluster. Verify that you are using the correct hostname to connect.
This type of error occurs if you select any database that does not exist in MySQL. Let us first display the error of unknown database in JDBC. The Java code is as follows.
Unknown database status in Exchange Server is a sign of an unhealthy or damaged database. Sometimes, you also notice that even though the database is mounted, the Content Index State is ‘ Unknown ’ or ‘ Not Available ’. Although users can access their mailboxes from mailbox databases with ‘ Unknown ’ status, it affects the email delivery.
In the newer versions of Wampserver, the port for MySQL has changed from 3306
to 3308
(you can see it in your first screenshot). You will need to update your connection to specify that port. Otherwise you will be hitting the MariaDB installed with WAMP which does not have that database within it.
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_NAME', 'testdb');
define('DB_PORT', 3308);
$link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, DB_PORT);
As pointed out in the comments, it is also possible to make MySQL your default database which would also solve your problem. You can get the instructions from the DBA Stack Exchange site.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With