1--TEST-- 2mysqli->change_user() 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifemb.inc'); 7require_once('skipifconnectfailure.inc'); 8 9require_once('table.inc'); 10if (!$IS_MYSQLND && (mysqli_get_server_version($link) < 50118 && mysqli_get_server_version($link) > 50100)) { 11 die("skip Your MySQL Server version has a known bug that will cause a crash"); 12} 13?> 14--FILE-- 15<?php 16 include_once("connect.inc"); 17 18 $link = NULL; 19 $tmp = NULL; 20 21 if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket)) 22 printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 23 $host, $user, $db, $port, $socket); 24 25 if (!is_null($tmp = @$mysqli->change_user())) 26 printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 27 28 if (!is_null($tmp = @$mysqli->change_user($link))) 29 printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 30 31 if (!is_null($tmp = @$mysqli->change_user($link, $link))) 32 printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 33 34 if (!is_null($tmp = @$mysqli->change_user($link, $link, $link, $link))) 35 printf("[005] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 36 37 if (false !== ($tmp = $mysqli->change_user($user . '_unknown_really', $passwd . 'non_empty', $db))) 38 printf("[006] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 39 40 if (false !== ($tmp = $mysqli->change_user($user, $passwd . '_unknown_really', $db))) 41 printf("[007] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 42 43 if (false !== ($tmp = $mysqli->change_user($user, $passwd, $db . '_unknown_really'))) 44 printf("[008] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 45 46 // Reconnect because after 3 failed change_user attempts, the server blocks you off. 47 if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket)) 48 printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 49 $host, $user, $db, $port, $socket); 50 51 if (!$mysqli->query('SET @mysqli_change_user_test_var=1')) 52 printf("[009] Failed to set test variable: [%d] %s\n", $mysqli->errno, $mysqli->error); 53 54 if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var')) 55 printf("[010] [%d] %s\n", $mysqli->errno, $mysqli->error); 56 $tmp = $res->fetch_assoc(); 57 $res->free_result(); 58 if (1 != $tmp['test_var']) 59 printf("[011] Cannot set test variable\n"); 60 61 if (true !== ($tmp = $mysqli->change_user($user, $passwd, $db))) 62 printf("[012] Expecting true, got %s/%s\n", gettype($tmp), $tmp); 63 64 if (!$res = $mysqli->query('SELECT database() AS dbname, user() AS user')) 65 printf("[013] [%d] %s\n", $mysqli->errno, $mysqli->error); 66 $tmp = $res->fetch_assoc(); 67 $res->free_result(); 68 69 if (substr($tmp['user'], 0, strlen($user)) !== $user) 70 printf("[014] Expecting user %s, got user() %s\n", $user, $tmp['user']); 71 if ($tmp['dbname'] != $db) 72 printf("[015] Expecting database %s, got database() %s\n", $db, $tmp['dbname']); 73 74 if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var')) 75 printf("[016] [%d] %s\n", $mysqli->errno, $mysqli->error); 76 $tmp = $res->fetch_assoc(); 77 $res->free_result(); 78 if (NULL !== $tmp['test_var']) 79 printf("[017] Test variable is still set!\n"); 80 81 $mysqli->close(); 82 83 if (NULL !== ($tmp = @$mysqli->change_user($user, $passwd, $db))) 84 printf("[018] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 85 86 print "done!"; 87?> 88--EXPECTF-- 89done! 90