Lines Matching refs:link

15 if (!$link = @my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
18 if (mysqli_get_server_version($link) < 50606)
21 if (!($res = $link->query("SHOW PLUGINS"))) {
22 die(sprintf("skip [%d] %s\n", $link->errno, $link->error));
35 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
36 die(sprintf("skip [%d] %s\n", $link->errno, $link->error));
40 die(sprintf("skip Failed to check RSA pub key, [%d] %s\n", $link->errno, $link->error));
44 …"skip Server misconfiguration? RSA pub key is suspicious, [%d] %s\n", $link->errno, $link->error));
57 $link->query("SET @@session.old_passwords=2");
59 $link->query('DROP USER shatest');
60 $link->query("DROP USER shatest@localhost");
63 if (!$link->query('CREATE USER shatest@"%" IDENTIFIED WITH sha256_password') ||
64 !$link->query('CREATE USER shatest@"localhost" IDENTIFIED WITH sha256_password')) {
65 die(sprintf("skip CREATE USER failed [%d] %s", $link->errno, $link->error));
68 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') ||
69 !$link->query('SET PASSWORD FOR shatest@"localhost" = "shatest"')) {
70 die(sprintf("skip SET PASSWORD failed [%d] %s", $link->errno, $link->error));
73 if (!$link->query("DROP TABLE IF EXISTS test") ||
74 !$link->query("CREATE TABLE test (id INT)") ||
75 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
76 die(sprintf("SKIP [%d] %s\n", $link->errno, $link->error));
79 if (!$link->query(sprintf("GRANT SELECT ON TABLE %s.test TO shatest@'%%'", $db)) ||
80 !$link->query(sprintf("GRANT SELECT ON TABLE %s.test TO shatest@'localhost'", $db))) {
81 …die(sprintf("skip Cannot grant SELECT to user [%d] %s", mysqli_errno($link), mysqli_error($link)));
84 $link->close();
94 $link = mysqli_init();
95 if (!($link->options(MYSQLI_SERVER_PUBLIC_KEY, $file))) {
96 printf("[001] mysqli_options failed, [%d] %s\n", $link->errno, $link->error);
99 if (!$link->real_connect($host, 'shatest', 'shatest', $db, $port, $socket)) {
100 printf("[002] [%d] %s\n", $link->connect_errno, $link->connect_error);
103 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
104 printf("[003] [%d] %s\n", $link->errno, $link->error);
107 printf("[004] [%d] %s\n", $link->errno, $link->error);
115 $link->close();
123 $link->query('DROP USER shatest');
124 $link->query('DROP USER shatest@localhost');