1--TEST-- 2mysqli_change_user(), MySQL < 5.6 3--EXTENSIONS-- 4mysqli 5--SKIPIF-- 6<?php 7require_once __DIR__ . '/test_setup/test_helpers.inc'; 8$link = mysqli_connect_or_skip(); 9if (mysqli_get_server_version($link) >= 50600 && mysqli_get_server_version($link) < 10_00_00) 10 die("SKIP For MySQL < 5.6.0"); 11?> 12--FILE-- 13<?php 14 require_once 'connect.inc'; 15 16 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 17 printf("[006] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 18 $host, $user, $db, $port, $socket); 19 20 if (false !== ($tmp = mysqli_change_user($link, $user . '_unknown_really', $passwd . 'non_empty', $db))) 21 printf("[007] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 22 23 if (false !== ($tmp = mysqli_change_user($link, $user, $passwd . '_unknown_really', $db))) 24 printf("[008] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 25 26 if (false !== ($tmp = mysqli_change_user($link, $user, $passwd, $db . '_unknown_really'))) 27 printf("[009] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 28 29 // Reconnect because Percona and MariaDB block any commands after 3 failed 30 // change_user commands 31 mysqli_close($link); 32 33 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 34 printf("[020] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 35 $host, $user, $db, $port, $socket); 36 } 37 if (!mysqli_query($link, 'SET @mysqli_change_user_test_var=1')) 38 printf("[010] Failed to set test variable: [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 39 40 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var')) 41 printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 42 $tmp = mysqli_fetch_assoc($res); 43 mysqli_free_result($res); 44 if (1 != $tmp['test_var']) 45 printf("[012] Cannot set test variable\n"); 46 47 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db))) 48 printf("[013] Expecting true, got %s/%s\n", gettype($tmp), $tmp); 49 50 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user')) 51 printf("[014] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 52 $tmp = mysqli_fetch_assoc($res); 53 mysqli_free_result($res); 54 55 if (substr($tmp['user'], 0, strlen($user)) !== $user) 56 printf("[015] Expecting user %s, got user() %s\n", $user, $tmp['user']); 57 if ($tmp['dbname'] != $db) 58 printf("[016] Expecting database %s, got database() %s\n", $db, $tmp['dbname']); 59 60 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var')) 61 printf("[017] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 62 $tmp = mysqli_fetch_assoc($res); 63 mysqli_free_result($res); 64 if (NULL !== $tmp['test_var']) 65 printf("[019] Test variable is still set!\n"); 66 67 mysqli_close($link); 68 69 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 70 printf("[020] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 71 $host, $user, $db, $port, $socket); 72 } 73 74 if (false !== ($tmp = mysqli_change_user($link, str_repeat('user', 16384), str_repeat('pass', 16384), str_repeat('dbase', 16384)))) 75 printf("[021] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 76 77 mysqli_close($link); 78 79 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 80 printf("[022] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 81 $host, $user, $db, $port, $socket); 82 } 83 84 /* silent protocol change if no db which requires workaround in mysqlnd/libmysql 85 (empty db = no db send with COM_CHANGE_USER) */ 86 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, ""))) 87 printf("[023] Expecting true, got %s/%s\n", gettype($tmp), $tmp); 88 89 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user')) 90 printf("[024] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 91 $tmp = mysqli_fetch_assoc($res); 92 mysqli_free_result($res); 93 94 if ($tmp['dbname'] != "") 95 printf("[025] Expecting database '', got database() '%s'\n", $tmp['dbname']); 96 97 mysqli_close($link); 98 99 try { 100 mysqli_change_user($link, $user, $passwd, $db); 101 } catch (Error $exception) { 102 echo $exception->getMessage() . "\n"; 103 } 104 105 print "done!"; 106?> 107--EXPECT-- 108mysqli object is already closed 109done! 110