Lines Matching refs:link

15 	if (!$link = mysql_connect($host, $user, $passwd, true))
18 if (!mysql_select_db($db, $link))
19 die(sprintf("skip [%d] %s", mysql_errno($link), mysql_error($link)));
21 if (!$res = mysql_query('SHOW VARIABLES LIKE "old_passwords"', $link)) {
22 die(sprintf("skip [%d] %s", mysql_errno($link), mysql_error($link)));
34 if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link))
35 die(sprintf("skip [%d] %s", mysql_errno($link), mysql_error($link)));
41 mysql_query('DROP USER pcontest', $link);
42 mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
43 …TE USER pcontest@"%s" IDENTIFIED BY "pcontest"', mysql_real_escape_string($host, $link)), $link)) {
44 printf("skip Cannot create second DB user [%d] %s", mysql_errno($link), mysql_error($link));
45 mysql_close($link);
50 … SELECT ON TABLE %s.test TO pcontest@"%s"', $db, mysql_real_escape_string($host, $link)), $link)) {
51 …intf("skip Cannot GRANT SELECT to second DB user [%d] %s", mysql_errno($link), mysql_error($link));
52 … ALL PRIVILEGES, GRANT OPTION FROM pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
53 mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
54 mysql_close($link);
58 mysql_close($link);
101 if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link))
102 printf("[006] [%d] %s", mysql_errno($link), mysql_error($link));
108 …tf('SET PASSWORD FOR pcontest@"%s" = PASSWORD("newpass")', mysql_real_escape_string($host, $link));
109 if (!mysql_query($sql, $link))
110 …ntf("[007] Cannot change PW of second DB user, [%d] %s\n", mysql_errno($link), mysql_error($link));
114 if (!mysql_query(sprintf('KILL %d', $pthread_id), $link))
115 … KILL persistent connection of second DB user, [%d] %s\n", mysql_errno($link), mysql_error($link));
119 if (!$res = mysql_query("SHOW FULL PROCESSLIST", $link))
120 printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link));
167 … ALL PRIVILEGES, GRANT OPTION FROM pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
168 mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
169 mysql_close($link);
176 if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) {
181 if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link))
182 printf("[c002] [%d] %s", mysql_errno($link), mysql_error($link));
188 … ALL PRIVILEGES, GRANT OPTION FROM pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
189 @mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
191 mysql_close($link);