Lines Matching refs:query
23 if (!($res = $link->query("SHOW PLUGINS"))) {
37 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
62 if (!$link->query("SET @@session.old_passwords=2")) {
66 $link->query('DROP USER shatest');
67 $link->query("DROP USER shatest@localhost");
70 if (!$link->query('CREATE USER shatest@"%" IDENTIFIED WITH sha256_password') ||
71 !$link->query('CREATE USER shatest@"localhost" IDENTIFIED WITH sha256_password')) {
75 if (!$link->query('SET PASSWORD FOR shatest@"%" = PASSWORD("shatest")') ||
76 !$link->query('SET PASSWORD FOR shatest@"localhost" = PASSWORD("shatest")')) {
80 if (!$link->query("DROP TABLE IF EXISTS test") ||
81 !$link->query("CREATE TABLE test (id INT)") ||
82 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
86 if (!$link->query(sprintf("GRANT SELECT ON TABLE %s.test TO shatest@'%%'", $db)) ||
87 !$link->query(sprintf("GRANT SELECT ON TABLE %s.test TO shatest@'localhost'", $db))) {
104 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
120 $link->query('DROP USER shatest');
121 $link->query('DROP USER shatest@localhost');
