Unknown database error in PHP but it exists in PHPMyAdmin

by

It’s either

  • a spelling error. Simply check the names again.
  • or the PHP code and PHPMyAdmin are connecting to different databases

The latter could happen, for example, if you have multiple database servers on your PC installed.

To get a proof, run the following query in phpmyadmin:

show databases;

And then run the same query in PHP, using either PDO:

$host="your db host";
$user="your db username";
$pass="your db password";

$pdo = new PDO("mysql:host=$host", $user, $pass, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
$databases = $pdo->query('show databases')->fetchAll(PDO::FETCH_COLUMN);
var_dump($databases);

or mysqli

$host="your db host";
$user="your db username";
$pass="your db password";

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = mysqli_connect($host, $user, $pass);
$databases = $mysqli->query('show databases')->fetch_all();
var_dump($databases);

and compare the output. It will show you that either there is a spelling error or indeed PHPMyAdmin and PHP are connected to different database servers.

Then you can check the configuration file in PHPmyAdmin to make sure it connects to the proper server

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  3. mysqli or PDO – what are the pros and cons? [closed]
  4. How to prevent duplicate usernames when people register?
  5. What is the difference between MySQL, MySQLi and PDO? [closed]
  6. PHP PDO and MySQLi [duplicate]
  7. PHP: mysql v mysqli v pdo [closed]
  8. Installing PDO driver on MySQL Linux server
  9. How to apply bindValue method in LIMIT clause?
  10. How to change mysql to mysqli?
  11. PDO get the last ID inserted
  12. How do I use password hashing with PDO to make my code more secure? [closed]
  13. MySQLi prepared statements error reporting [duplicate]
  14. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  15. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  16. PDO multiple queries
  17. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  18. Update query with PDO and MySQL
  19. Is “SET CHARACTER SET utf8” necessary?
  20. Can I blindly replace all mysql_ functions with mysqli_?
  21. How do detect that transaction has already been started?
  22. return one value from database with mysql php pdo
  23. Trying to access array offset on value of type bool
  24. return multiple response data in one response
  25. How to get a query error from prepare() in PDO PHP?
  26. How can I pass an array of PDO parameters yet still specify their types?
  27. PHP PDO how to run a multiple query request?
  28. Which is fastest in PHP- MySQL or MySQLi?
  29. PHP Laravel: No connection could be made because the target machine actively refused it
  30. prepared parameterized query with PDO

Leave a Comment