mysqli_report_new.phpt 1.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. --TEST--
  2. mysqli_report(), change user, MySQL 5.6+
  3. --SKIPIF--
  4. <?php
  5. require_once('skipif.inc');
  6. require_once('skipifemb.inc');
  7. require_once('skipifconnectfailure.inc');
  8. if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
  9. die(sprintf("SKIP Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
  10. $host, $user, $db, $port, $socket));
  11. if (mysqli_get_server_version($link) < 50600)
  12. die("SKIP For MySQL >= 5.6.0");
  13. ?>
  14. --FILE--
  15. <?php
  16. require_once("connect.inc");
  17. $tmp = NULL;
  18. $link = NULL;
  19. require('table.inc');
  20. /*
  21. Internal macro MYSQL_REPORT_ERROR
  22. */
  23. mysqli_report(MYSQLI_REPORT_ERROR);
  24. mysqli_change_user($link, "0123456789-10-456789-20-456789-30-456789-40-456789-50-456789-60-456789-70-456789-80-456789-90-456789", "password", $db);
  25. mysqli_report(MYSQLI_REPORT_OFF);
  26. if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
  27. printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
  28. $host, $user, $db, $port, $socket);
  29. mysqli_change_user($link, "This might work if you accept anonymous users in your setup", "password", $db);
  30. print "done!";
  31. ?>
  32. --CLEAN--
  33. <?php
  34. require_once("clean_table.inc");
  35. ?>
  36. --EXPECTF--
  37. Warning: mysqli_change_user(): (%d/%d): Access denied for user '%s'@'%s' (using password: %s) in %s on line %d
  38. done!