mysqli_expire_password.phpt - OpenGrok cross reference for /PHP-7.2/ext/mysqli/tests/mysqli_expire

Lines Matching refs:link
9 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
14 if ($link->server_version < 50610)
15 	die(sprintf("SKIP Needs MySQL 5.6.10 or newer, found MySQL %s\n", $link->server_info));
21 mysqli_query($link, 'DROP USER expiretest');
22 mysqli_query($link, 'DROP USER expiretest@localhost');
24 if (!mysqli_query($link, 'CREATE USER expiretest@"%"') ||
25 	!mysqli_query($link, 'CREATE USER expiretest@"localhost"')) {
26 	printf("skip Cannot create second DB user [%d] %s", mysqli_errno($link), mysqli_error($link));
27 	mysqli_close($link);
31 if (!mysqli_query($link, 'ALTER USER expiretest@"%" PASSWORD EXPIRE') ||
32 	!mysqli_query($link, 'ALTER USER expiretest@"localhost" PASSWORD EXPIRE')) {
33 	printf("skip Cannot modify second DB user [%d] %s", mysqli_errno($link), mysqli_error($link));
34 	mysqli_close($link);
38 if (!$link->query("DROP TABLE IF EXISTS test") ||
39 	!$link->query("CREATE TABLE test (id INT)") || !$link->query("INSERT INTO test(id) VALUES (1)"))
40 	die(sprintf("SKIP [%d] %s\n", $link->errno, $link->error));
44 if (!mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO expiretest@'%%'", $db)) ||
45 	!mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO expiretest@'localhost'", $db))) {
46 	printf("skip Cannot grant SELECT to user [%d] %s", mysqli_errno($link), mysqli_error($link));
47 	mysqli_close($link);
57 	if (!$link = my_mysqli_connect($host, 'expiretest', "", $db, $port, $socket)) {
61 		$link->query("SELECT id FROM test WHERE id = 1");
62 		printf("[002] Connect should fail, [%d] %s\n", $link->errno, $link->error);
66 	$link = mysqli_init();
67 	$link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 0);
68 	if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) {
72 		$link->query("SELECT id FROM test WHERE id = 1");
73 		printf("[004] Connect should fail, [%d] %s\n", $link->errno, $link->error);
77 	$link = mysqli_init();
78 	$link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 1);
79 	if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) {
83 		$link->query("SELECT id FROM test WHERE id = 1");
84 		printf("[006] Connect allowed, query fail, [%d] %s\n", $link->errno, $link->error);
85 		$link->close();
89 	$link = mysqli_init();
90 	$link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 1);
91 	if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) {
95 		$link->query("SET PASSWORD=PASSWORD('expiretest')");
96 		printf("[008] Connect allowed, pw set, [%d] %s\n", $link->errno, $link->error);
97 		if ($res = $link->query("SELECT id FROM test WHERE id = 1"))
99 		$link->close();
104 	if (!$link = my_mysqli_connect($host, 'expiretest', "expiretest", $db, $port, $socket)) {
108 		$link->query("SELECT id FROM test WHERE id = 1");
109 		if ($res = $link->query("SELECT id FROM test WHERE id = 1"))
111 		$link->close();
121 	mysqli_query($link, 'DROP USER expiretest');
122 	mysqli_query($link, 'DROP USER expiretest@localhost');