Warning: mysqli_connect(): (HY000/1049): Unknown database 'winestore'

Asked Oct 16 '16 at 08:12

Active Oct 16 '16 at 08:12

Viewed 53 times

I have this problem where i already have created a database, but whenever I run using a php code, it keeps showing this error. Im using XAMPP, to run php and mysql.

Warning: mysqli_connect(): (HY000/1049): Unknown database 'winestore' in /Applications/XAMPP/xamppfiles/htdocs/phpproject/search.php on line 4 Database Connection Failed

Here's the code

  $connection = mysqli_connect('localhost', 'root', '', 'winestore');

  if (!$connection){
      die("Database Connection Failed" . mysql_error());
  } else {
    echo "Awesome";
  }

Heres the picture of my mysql database

Clearly in the picture that winestore database has been created, I have no idea what is the problem.

asked Oct 16 '16 at 08:12

sinusGob

4,053
12
46
82

Does `root` have permissions to use that database? – Bart Friederichs Oct 16 '16 at 08:14
Try to detect error by `mysqli_connect_errno()` and what is your MySQL version?? – Murad Hasan Oct 16 '16 at 08:18
try to set up a password then check – Cristofor Oct 16 '16 at 08:18
Technically root is the one who created the database, so yeah root have access to the `winestore` database – sinusGob Oct 16 '16 at 08:18
I think the connection establish successfully and the if condition `if (!$connection){` is wrong. – Murad Hasan Oct 16 '16 at 08:19
@FrayneKonok the server version is 5.6 and yeah the connection is establish successfully but it doesn't select the database – sinusGob Oct 16 '16 at 08:20

Warning: mysqli_connect(): (HY000/1049): Unknown database 'winestore'

0 Answers0