SQLite format 3@ MM. (  / :r))tablesessiondetailssessiondetailsCREATE TABLE sessiondetails (Id INTEGER, filename TEXT, isedited INTEGER)N!!gtabletabdetailstabdetailsCREATE TABLE tabdetails (Id INTEGER , Tabid INTEGER, Tabtype INTEGER DEFAULT 0, isedited INTEGER DEFAULT 0,position INTEGER, leftortoppercent INTEGER, title TEXT,tooltip TEXT,isfile INTEGER, isfocussed INTEGER, content TEXT, FOREIGN KEY(Id) REFERENCES conndetails(Id) ON DELETE CASCADE )!tableobdetailsobdetailsCREATE TABLE obdetails (Id INTEGER PRIMARY KEY NOT NULL, obdb TEXT,FOREIGN KEY(Id) REFERENCES conndetails(Id) ON DELETE CASCADE )7)))tablehistorydetailshistorydetailsCREATE TABLE historydetails (Id INTEGER PRIMARY KEY NOT NULL, historydata TEXT,FOREIGN KEY(Id) REFERENCES conndetails(Id) ON DELETE CASCADE )##mtableconndetailsconndetailsCREATE TABLE conndetails (Id INTEGER PRIMARY KEY NOT NULL, position INTEGER, ObjectbrowserBkcolor TEXT, ObjectbrowserFgcolor TEXT, isfocussed INTEGER, Name TEXT , Host TEXT , User TEXT ,Password TEXT ,Port TEXT, StorePassword TEXT,keep_alive TEXT,Database TEXT ,compressedprotocol TEXT,defaulttimeout TEXT, waittimeoutvalue TEXT,Tunnel TEXT,Http TEXT ,HTTPTime TEXT,HTTPuds TEXT,HTTPudsPath TEXT , Is401 TEXT,IsProxy TEXT,Proxy TEXT , ProxyUser TEXT, ProxyPwd TEXT , ProxyPort TEXT , User401 TEXT , Pwd401 TEXT , ContentType TEXT , HttpEncode TEXT,SSH TEXT,SshUser TEXT,SshPwd TEXT,SshHost TEXT,SshPort TEXT,SshForHost TEXT,SshPasswordRadio TEXT,SSHPrivateKeyPath TEXT,SshSavePassword TEXT,SslChecked TEXT,SshAuth TEXT,Client_Key TEXT,Client_Cert TEXT,CA TEXT,Cipher TEXT,sqlmode_global TEXT,sqlmode_value TEXT,init_command TEXT,readonly TEXT,isencrypted INTEGER)))9tableschema_versionschema_versionCREATE TABLE schema_version (description TEXT, major_version TEXT, minor_version TEXT)  13.131313 4z4 =   167772150localhostlocalhostrootDhvJB1A2s/NXGkMq9Mwogw==330600112880010 vo/*[16-Jan 15:01:19][52 ms]*/ show databases; /*[16-Jan 15:01:41][0 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[16-Jan 15:01:41][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[16-Jan 15:01:41][38 ms]*/ SHOW COLUMNS FROM `mysql`.`user`; /*[16-Jan 15:01:41][6 ms]*/ SHOW COLUMNS FROM `mysql`.`db`; /*[16-Jan 15:01:41][6 ms]*/ SHOW COLUMNS FROM `mysql`.`tables_priv`; /*[16-Jan 15:01:41][3 ms]*/ SHOW COLUMNS FROM `mysql`.`procs_priv`; /*[16-Jan 15:01:41][0 ms]*/ SHOW DATABASES; /*[16-Jan 15:01:41][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = '' AND Host = 'localhost'; /*[16-Jan 15:01:41][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = '' AND Host = 'localhost'; /*[16-Jan 15:01:41][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = '' AND Host = 'localhost'; /*[16-Jan 15:01:41][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = '' AND Host = 'localhost'; /*[16-Jan 15:01:41][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = '' AND Host = 'localhost'; /*[16-Jan 15:01:41][0 ms]*/ select database(); /*[16-Jan 15:01:41][0 ms]*/ use `mysql`; /*[16-Jan 15:02:28][29 ms]*/ RENAME USER ''@'localhost' TO 'landing'@'localhost'; /*[16-Jan 15:02:28][0 ms]*/ FLUSH PRIVILEGES; /*[16-Jan 15:02:28][0 ms]*/ ALTER USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'; /*[Error Code 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'' at line 1]*/ /*[16-Jan 15:02:58][0 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[16-Jan 15:02:58][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[16-Jan 15:02:58][iW/*[21-May 16:44:46][1 ms]*/ show databases; /*[21-May 16:44:48][0 ms]*/ use `kptv_site2`; /*[21-May 16:44:54][4 ms]*/ UPDATE pages SET ContentRO = REPLACE( REPLACE( REPLACE( REPLACE( ContentRO, 'https://images.reverb.com/image/upload/s--bkuut3bK--/a_exif,c_limit,e_unsharp_mask:80,f_auto,fl_progressive,g_south,h_620,q_90,w_620/v1522201126/i1powpscipsnqvn23mz1.jpg', '/images/uploads/cdj-400.jpg'), 'https://www.interseckt.com/wp-content/uploads/2017/12/sl1210gr-inspire-3.png', '/images/uploads/technics-sl1200gr.jpg'), 'https://upload.wikimedia.org/wikipedia/commons/thumb/7/7e/Enrico_Caruso_1873_-_1921.jpg/170px-Enrico_Caruso_1873_-_1921.jpg', '/images/uploads/enrico-caruso.jpg'), 'https://upload.wikimedia.org/wikipedia/commons/thumb/5/5c/Nellie_Melba_with_the_Metropolitan_Opera.jpg/170px-Nellie_Melba_with_the_Metropolitan_Opera.jpg', '/images/uploads/nellie-melba.jpg') WHERE ID = 52; /*[21-May 16:44:54][2 ms]*/ SELECT (CHAR_LENGTH(ContentRO) - CHAR_LENGTH(REPLACE(ContentRO, 'reverb.com', ''))) / CHAR_LENGTH('reverb.com') AS reverb, (CHAR_LENGTH(ContentRO) - CHAR_LENGTH(REPLACE(ContentRO, 'interseckt.com', ''))) / CHAR_LENGTH('interseckt.com') AS interseckt, (CHAR_LENGTH(ContentRO) - CHAR_LENGTH(REPLACE(ContentRO, '170px-Enrico_Caruso', ''))) / CHAR_LENGTH('170px-Enrico_Caruso') AS caruso_thumb, (CHAR_LENGTH(ContentRO) - CHAR_LENGTH(REPLACE(ContentRO, '170px-Nellie_Melba', ''))) / CHAR_LENGTH('170px-Nellie_Melba') AS melba_thumb FROM pages WHERE ID = 52 LIMIT 0, 1000; /*[22-May 12:20:49][0 ms]*/ use `kptv_site2`; /*[22-May 12:20:49][0 ms]*/ show databases; /*[22-May 12:21:04][22 ms]*/ ALTER TABLE stiri MODIFY Datas DATETIME NOT NULL; /*[22-May 12:21:04][1 ms]*/ SELECT ID, Datas FROM stiri ORDER BY Datas DESC LIMIT 5; /*[22-May 12:21:14][9 ms]*/ show full tables from `kptv_site2` where table_type = 'BASE TABLE'; /*[22-May 12:21:21][0 ms]*/ select * from `kptv_site2`.`stiri` limit 0, 1000; /*[22-May 12:21:21][0 ms]*/ show create table `kptv_site2`.`stiri`; /*[22-May 12:21:21][25 ms]*/ show full fields from `kptv_site2`.`stiri`; /*[22-May 12:21:21][1 ms]*/ show keys from `kptv_site2`.`stiri`;  !kptv_site2  uG   _}2Query 1Query 1-- Page 52 (DE LA PATEFON LA PICK-UP / PATEFON): replace 4 broken images. -- Pioneer CDJ-400 (reverb.com dead), Technics SL-1210GR (interseckt.com 404), -- Enrico Caruso + Nellie Melba (Wikimedia thumb URLs return 400). UPDATE pages SET ContentRO = REPLACE( REPLACE( REPLACE( REPLACE( ContentRO, 'https://images.reverb.com/image/upload/s--bkuut3bK--/a_exif,c_limit,e_unsharp_mask:80,f_auto,fl_progressive,g_south,h_620,q_90,w_620/v1522201126/i1powpscipsnqvn23mz1.jpg', '/images/uploads/cdj-400.jpg'), 'https://www.interseckt.com/wp-content/uploads/2017/12/sl1210gr-inspire-3.png', '/images/uploads/technics-sl1200gr.jpg'), 'https://upload.wikimedia.org/wikipedia/commons/thumb/7/7e/Enrico_Caruso_1873_-_1921.jpg/170px-Enrico_Caruso_1873_-_1921.jpg', '/images/uploads/enrico-caruso.jpg'), 'https://upload.wikimedia.org/wikipedia/commons/thumb/5/5c/Nellie_Melba_with_the_Metropolitan_Opera.jpg/170px-Nellie_Melba_with_the_Metropolitan_Opera.jpg', '/images/up   a}2Query 1Query 1-- Widen stiri.Datas from DATE to DATETIME so the column can hold HH:MM:SS. -- Existing dates are preserved; they get 00:00:00 appended automatically. ALTER TABLE stiri MODIFY Datas DATETIME NOT NULL; -- Optional: backfill existing rows with deterministic per-ID seconds within -- their date, so that legacy same-day items keep a stable ordering when sorted -- by Datas (not just by ID). Skip this if you want all old times to stay 00:00. -- UPDATE stiri SET Datas = DATE_ADD(DATE(Datas), INTERVAL (ID MOD 86400) SECOND); -- Verify a few rows SELECT ID, Datas FROM stiri ORDER BY Datas DESC LIMIT 5;`stiri` tion_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:35][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:35][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:35][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:35][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TAB / SELECT * FROM `mysql`.`db` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:44:34][0 ms]*/ use `kptv_site`; /*[23-Jan 12:57:47][0 ms]*/ echo md5('123'); /*[Error Code 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'echo md5('123')' at line 1]*/ /*[23-Jan 12:57:55][0 ms]*/ select md5('123'); /*[23-Jan 12:58:26][0 ms]*/ select md5('_kptv147#'); /*[23-Jan 12:58:49][1 ms]*/ select count(*) from `kptv_site`.`accounts` where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '$1$lT2qbHpp$9/TpiBXqTFKweLcWagyKA/' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[23-Jan 12:58:49][0 ms]*/ update `kptv_site`.`accounts` set `Password` = '829db74e519e62a2bd3136308f1efc33' where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '$1$lT2qbHpp$9/TpiBXqTFKweLcWagyKA/' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[23-Jan 12:59:56][0 ms]*/ select SHA1('_kptv147#'); /*[23-Jan 13:00:11][0 ms]*/ select count(*) from `kptv_site`.`accounts` where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '829db74e519e62a2bd3136308f1efc33' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[23-Jan 13:00:11][0 ms]*/ update `kptv_site`.`accounts` set `Password` = '3f4ab254fa6c25e60b0d225058615659869872e6' where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '829db74e519e62a2bd3136308f1efc33' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[23-Jan 13:01:31][0 ms]*/ select * from `kptv_site`.`accounts` ; /*[23-Jan 13:01:31][0 ms]*/ show create table `kptv_site`.`accounts`; /*[23-Jan 13:01:31][27 ms]*/ show full fields from `kptv_site`.`accounts`; /*[23-Jan 13:01:31][0 ms]*/ show keys from `kptv_site`.`accounts`; /*[23-Jan 13:01:32][0 ms]*/ select * from `kptv_site`.`accounts` limit 0, 1000; /*[23-Jan 13:01:32][0 ms]*/ show create table `kptv_site`.`accounts`; /*[23-Jan 13:01:32][11 ms]*/ show full fields from `kptv_site`.`accounts`; /*[23-Jan 13:01:32][0 ms]*/ show keys from `kptv_site`.`accounts`; /*[23-Jan 13:08:46][19 ms]*/ select CRYPT('_kptv147#'); /*[Error Code 1305: FUNCTION kptv_site.CRYPT does not exist]*/ /*[23-Jan 13:09:57][0 ms]*/ select MD5('_kptv147#'); /*[23-Jan 13:10:15][1 ms]*/ select count(*) from `kptv_site`.`accounts` where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '3f4ab254fa6c25e60b0d225058615659869872e6' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[23-Jan 13:10:15][2 ms]*/ update `kptv_site`.`accounts` set `Password` = '829db74e519e62a2bd3136308f1efc33' where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '3f4ab254fa6c25e60b0d225058615659869872e6' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[20-May 07:44:56][0 ms]*/ use `kptv_site`; /*[20-May 07:44:56][39 ms]*/ show databases; /*[20-May 07:48:06][2 ms]*/ show charset; /*[20-May 07:48:07][4 ms]*/ show collation; /*[20-May 07:48:13][1 ms]*/ create database `kptv_site2`; /*[20-May 07:48:13][22 ms]*/ show databases; /*[20-May 07:48:13][0 ms]*/ use `kptv_site2`; /*[20-May 07:48:15][0 ms]*/ use `kptv_site`; /*[20-May 07:48:29][33 ms]*/ show full tables from `kptv_site` where table_type = 'BASE TABLE'; /*[20-May 07:48:31][14 ms]*/ SHOW TRIGGERS FROM `kptv_site`; 5('123'); /*[Error Code 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'echo md5('123')' at line 1]*/ /*[23-Jan 12:57:55][0 ms]*/ select md5('123'); /*[23-Jan 12:58:26][0 ms]*/ select md5('_kptv147#'); /*[23-Jan 12:58:49][1 ms]*/ select count(*) from `kptv_site`.`accounts` where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '$1$lT2qbHpp$9/TpiBXqTFKweLcWagyKA/' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[23-Jan 12:58:49][0 ms]*/ update `kptv_site`.`accounts` set `Password` = '829db74e519e62a2bd3136308f1efc33' where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '$1$lT2qbHpp$9/TpiBXqTFKweLcWagyKA/' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[23-Jan 12:59:56][0 ms]*/ select SHA1('_kptv147#'); /*[23-Jan 13:00:11][0 ms]*/ select count(*) from `kptv_site`.`accounts` where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '829db74e519e62a2bd3136308f1efc33' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[23-Jan 13:00:11][0 ms]*/ update `kptv_site`.`accounts` set `Password` = '3f4ab254fa6c25e60b0d225058615659869872e6' where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '829db74e519e62a2bd3136308f1efc33' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[23-Jan 13:01:31][0 ms]*/ select * from `kptv_site`.`accounts` ; /*[23-Jan 13:01:31][0 ms]*/ show create table `kptv_site`.`accounts`; /*[23-Jan 13:01:31][27 ms]*/ show full fields from `kptv_site`.`accounts`; /*[23-Jan 13:01:31][0 ms]*/ show keys from `kptv_site`.`accounts`; /*[23-Jan 13:01:32][0 ms]*/ select * from `kptv_site`.`accounts` limit 0, 1000; /*[23-Jan 13:01:32][0 ms]*/ show create table `kptv_site`.`accounts`; /*[23-Jan 13:01:32][11 ms]*/ show full fields from `kptv_site`.`accounts`; /*[23-Jan 13:01:32][0 ms]*/ show keys from `kptv_site`.`accounts`; /*[23-Jan 13:08:46][19 ms]*/ select CRYPT('_kptv147#'); /*[Error Code 1305: FUNCTION kptv_site.CRYPT does not exist]*/ /*[23-Jan 13:09:57][0 ms]*/ select MD5('_kptv147#'); /*[23-Jan 13:10:15][1 ms]*/ select count(*) from `kptv_site`.`accounts` where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '3f4ab254fa6c25e60b0d225058615659869872e6' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[23-Jan 13:10:15][2 ms]*/ update `kptv_site`.`accounts` set `Password` = '829db74e519e62a2bd3136308f1efc33' where `ID` = '33' and `UserName` = 'zsolt' and `Password` = '3f4ab254fa6c25e60b0d225058615659869872e6' and `AccountType` = 'ABCDEFGHIJ' and `Enabled` = '1' and `CustID` = '0' and `Name` = '' and `EmailAddress` = ''; /*[20-May 07:44:56][0 ms]*/ use `kptv_site`; /*[20-May 07:44:56][39 ms]*/ show databases; /*[20-May 07:48:06][2 ms]*/ show charset; /*[20-May 07:48:07][4 ms]*/ show collation; /*[20-May 07:48:13][1 ms]*/ create database `kptv_site2`; /*[20-May 07:48:13][22 ms]*/ show databases; /*[20-May 07:48:13][0 ms]*/ use `kptv_site2`; /*[20-May 07:48:15][0 ms]*/ use `kptv_site`; /*[20-May 07:48:29][33 ms]*/ show full tables from `kptv_site` where table_type = 'BASE TABLE'; /*[20-May 07:48:31][14 ms]*/ SHOW TRIGGERS FROM `kptv_site`; /*[20-May 07:48:31][11 ms]*/ select `EVENT_NAME` from `INFORMATION_SCHEMA`.`EVENTS` where `EVENT_SCHEMA` = 'kptv_site'; /*[20-May 07:48:31][11 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site' and ROUTINE_TYPE = 'FUNCTION'; /*[20-May 07:48:31][4 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site' and ROUTINE_TYPE = 'PROCEDURE'; /*[20-May 07:48:31][0 ms]*/ show full tables from `kptv_site` where Table_type = 'view'; /*[20-May 07:48:34][0 ms]*/ use `kptv_site2`; /*[20-May ]*/ SHOW DATABASES; /*[16-Jan 15:01:41][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = '' AND Host = 'localhost'; /*[16-Jan 15:01:41][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = '' AND Host = 'localhost'; /*[16-Jan 15:01:41][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = '' AND Host = 'localhost'; /*[16-Jan 15:01:41][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = '' AND Host = 'localhost'; /*[16-Jan 15:01:41][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = '' AND Host = 'localhost'; /*[16-Jan 15:01:41][0 ms]*/ select database(); /*[16-Jan 15:01:41][0 ms]*/ use `mysql`; /*[16-Jan 15:02:28][29 ms]*/ RENAME USER ''@'localhost' TO 'landing'@'localhost'; /*[16-Jan 15:02:28][0 ms]*/ FLUSH PRIVILEGES; /*[16-Jan 15:02:28][0 ms]*/ ALTER USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'; /*[Error Code 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'' at line 1]*/ /*[16-Jan 15:02:58][0 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[16-Jan 15:02:58][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[16-Jan 15:02:58][11 ms]*/ SHOW COLUMNS FROM `mysql`.`user`; /*[16-Jan 15:02:58][6 ms]*/ SHOW COLUMNS FROM `mysql`.`db`; /*[16-Jan 15:02:58][6 ms]*/ SHOW COLUMNS FROM `mysql`.`tables_priv`; /*[16-Jan 15:02:58][3 ms]*/ SHOW COLUMNS FROM `mysql`.`procs_priv`; /*[16-Jan 15:02:58][0 ms]*/ SHOW DATABASES; /*[16-Jan 15:02:58][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:02:58][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:02:58][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:02:58][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:02:58][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:02:58][0 ms]*/ select database(); /*[16-Jan 15:02:58][0 ms]*/ use `mysql`; /*[16-Jan 15:03:00][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:00][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:00][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:00][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:00][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:07][0 ms]*/ ALTER USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'; /*[Error Code 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'' at line 1]*/ /*[16-Jan 15:03:27][0 ms]*/ ALTER USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'; /*[Error Code 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'' at line 1]*/ /*[16-Jan 15:03:31][0 ms]*/ use `mysql`; /*[16-Jan 15:03:34][0 ms]*/ show charset; /*[16-Jan 15:03:34][0 ms]*/ show collation; /*[16-Jan 15:03:38][1 ms]*/ create database `landing`; /*[16-Jan 15:03:38][0 ms]*/ show databases; /*[16-Jan 15:03:39][0 ms]*/ use `landing`; /*[16-Jan 15:03:44][0 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[16-Jan 15:03:44][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[16-Jan 15:03:44][11 ms]*/ SHOW COLUMNS FROM `mysql`.`user`; /*[16-Jan 15:03:44][6 ms]*/ SHOW COLUMNS FROM `mysql`.`db`; /*[16-Jan 15:03:44][6 ms]*/ SHOW COLUMNS FROM `mysql`.`tables_priv`; /*[16-Jan 15:03:44][3 ms]*/ SHOW COLUMNS FROM `mysql`.`procs_priv`; /*[16-Jan 15:03:44][0 ms]*/ SHOW DATABASES; /*[16-Jan 15:03:44][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:44][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:44][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:44][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:44][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:44][0 ms]*/ select database(); /*[16-Jan 15:03:44][0 ms]*/ use `mysql`; /*[16-Jan 15:03:53][32 ms]*/ GRANT ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, EXECUTE, INDEX, INSERT, LOCK TABLES, REFERENCES, SELECT, SHOW VIEW, TRIGGER, UPDATE ON `landing`.* TO 'landing'@'localhost'; /*[16-Jan 15:04:00][0 ms]*/ use `landing`; /*[16-Jan 15:04:20][0 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[16-Jan 15:04:20][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[16-Jan 15:04:20][12 ms]*/ SHOW COLUMNS FROM `mysql`.`user`; /*[16-Jan 15:04:20][6 ms]*/ SHOW COLUMNS FROM `mysql`.`db`; /*[16-Jan 15:04:20][6 ms]*/ SHOW COLUMNS FROM `mysql`.`tables_priv`; /*[16-Jan 15:04:20][3 ms]*/ SHOW COLUMNS FROM `mysql`.`procs_priv`; /*[16-Jan 15:04:20][0 ms]*/ SHOW DATABASES; /*[16-Jan 15:04:20][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:04:20][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:04:20][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:04:20][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:04:20][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:04:20][0 ms]*/ select database(); /*[16-Jan 15:04:20][0 ms]*/ use `mysql`; /*[16-Jan 15:04:31][0 ms]*/ DROP USER 'landing'@'localhost'; /*[16-Jan 15:04:31][0 ms]*/ FLUSH PRIVILEGES; /*[16-Jan 15:04:31][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:31][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:31][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:31][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:31][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM informa /*[20-May 07:48:31][11 ms]*/ select `EVENT_NAME` from `INFORMATION_SCHEMA`.`EVENTS` where `EVENT_SCHEMA` = 'kptv_site'; /*[20-May 07:48:31][11 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site' and ROUTINE_TYPE = 'FUNCTION'; /*[20-May 07:48:31][4 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site' and ROUTINE_TYPE = 'PROCEDURE'; /*[20-May 07:48:31][0 ms]*/ show full tables from `kptv_site` where Table_type = 'view'; /*[20-May 07:48:34][0 ms]*/ use `kptv_site2`; /*[20-May 07:48:34][3 ms]*/ show full tables from `kptv_site2` where table_type = 'BASE TABLE'; /*[20-May 08:36:23][0 ms]*/ use `kptv_site2`; /*[20-May 08:36:23][2 ms]*/ show databases; /*[20-May 08:36:48][5 ms]*/ show full tables from `kptv_site2` where table_type = 'BASE TABLE'; /*[20-May 08:36:48][4 ms]*/ select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'kptv_site2' and `TABLE_TYPE` = 'VIEW'; /*[20-May 08:36:48][16 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site2' and ROUTINE_TYPE = 'PROCEDURE'; /*[20-May 08:36:48][4 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site2'and ROUTINE_TYPE = 'FUNCTION'; /*[20-May 08:36:48][9 ms]*/ SHOW TRIGGERS from `kptv_site2`; /*[20-May 08:36:48][8 ms]*/ select `EVENT_NAME` from `INFORMATION_SCHEMA`.`EVENTS` where `EVENT_SCHEMA` = 'kptv_site2' order by EVENT_NAME; /*[20-May 11:13:49][0 ms]*/ use `kptv_site2`; /*[20-May 11:13:49][30 ms]*/ show databases; /*[20-May 11:14:50][2 ms]*/ UPDATE banners SET Banner = REPLACE(Banner, 'http://radio.kptv.ro/', 'https://testsite2.kptv.ro/') WHERE ID = 8; /*[20-May 11:14:50][0 ms]*/ SELECT (CHAR_LENGTH(Banner) - CHAR_LENGTH(REPLACE(Banner, 'testsite2.kptv.ro', ''))) / CHAR_LENGTH('testsite2.kptv.ro') AS testsite2_hits, (CHAR_LENGTH(Banner) - CHAR_LENGTH(REPLACE(Banner, 'radio.kptv.ro', ''))) / CHAR_LENGTH('radio.kptv.ro') AS radio_hits FROM banners WHERE ID = 8 LIMIT 0, 1000; /*[20-May 11:28:56][2 ms]*/ UPDATE banners SET Banner = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( Banner, 'pg=page&id=46', 'pg=page&id=__PAT__'), 'pg=page&id=52', 'pg=page&id=__MAG__'), 'pg=page&id=47', 'pg=page&id=__MIC__'), 'pg=page&id=51', 'pg=page&id=__KAR__'), 'pg=page&id=48', 'pg=page&id=__TON__'), 'pg=page&id=__PAT__', 'pg=page&id=52'), 'pg=page&id=__MAG__', 'pg=page&id=56'), 'pg=page&id=__MIC__', 'pg=page&id=53'), 'pg=page&id=__KAR__', 'pg=page&id=55'), 'pg=page&id=__TON__', 'pg=page&id=54') WHERE ID = 8; /*[20-May 11:28:56][0 ms]*/ SELECT b.Banner REGEXP 'pg=page&id=46' AS still_broken_46, b.Banner REGEXP 'pg=page&id=47' AS still_broken_47, b.Banner REGEXP 'pg=page&id=48' AS still_broken_48, b.Banner REGEXP 'pg=page&id=51' AS still_broken_51 FROM banners b WHERE ID = 8 LIMIT 0, 1000; /*[20-May 11:56:40][3 ms]*/ UPDATE pages SET ContentRO = REPLACE( REPLACE( REPLACE( ContentRO, 'https://lh3.googleusercontent.com/proxy/7akwVO8h6Wq8a0MDvc5ITL_OmtEujawukRQ5sRXz7B9gTslzAL2Y05O0K9eTYVWGTYwBZ3fd17fWkXaQh4gxC5czcrcMcvGGGbwHR0Nz3hHDGpR6oB_nPUyTJ2TLYzZX29ZBDUr7kjv6r4P5OeAh-Q', '/images/uploads/telegrafon-poulsen.jpg'), 'https://www.musictech.net/wp-content/uploads/2014/05/studer-j37.jpg', '/images/uploads/studer-j37.jpg'), 'https://images.reverb.com/image/upload/s--qL2B_hrF--/a_exif,c_limit,e_unsharp_mask:80,f_auto,fl_progressive,g_south,h_620,q_90,w_620/v1480371018/p9tsayngsyyqtsvnmelp.jpg', '/images/uploads/dat-recorder.jpg') WHERE ID = 56; /*[20-May 11:56:40][1 ms]*/ SELECT (CHAR_LENGTH(ContentRO) - CHAR_LENGTH(REPLACE(ContentRO, 'lh3.googleusercontent.com', '')))/CHAR_LENGTH('lh3.googleusercontent.com') AS lh3, (CHAR_LENGTH(ContentRO) - CHAR_LENGTH(REPLACE(ContentRO, 'musictech.net', ''))) /CHAR_LENGTH('musictech.net') AS musictech, (CHAR_LENGTH(ContentRO) - CHAR_LENGTH(REPLACE(ContentRO, 'images.reverb.com', ''))) /CHAR_LENGTH('images.reverb.com') AS reverb FROM pages WHERE ID = 56 LIMIT 0, 1000;  SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:35][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:35][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:35][0 ms  rsion for the right syntax to use near 'USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'' at line 1]*/ /*[16-Jan 15:03:31][0 ms]*/ use `mysql`; /*[16-Jan 15:03:34][0 ms]*/ show charset; /*[16-Jan 15:03:34][0 ms]*/ show collation; /*[16-Jan 15:03:38][1 ms]*/ create database `landing`; /*[16-Jan 15:03:38][0 ms]*/ show databases; /*[16-Jan 15:03:39][0 ms]*/ use `landing`; /*[16-Jan 15:03:44][0 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[16-Jan 15:03:44][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[16-Jan 15:03:44][11 ms]*/ SHOW COLUMNS FROM `mysql`.`user`; /*[16-Jan 15:03:44][6 ms]*/ SHOW COLUMNS FROM `mysql`.`db`; /*[16-Jan 15:03:44][6 ms]*/ SHOW COLUMNS FROM `mysql`.`tables_priv`; /*[16-Jan 15:03:44][3 ms]*/ SHOW COLUMNS FROM `mysql`.`procs_priv`; /*[16-Jan 15:03:44][0 ms]*/ SHOW DATABASES; /*[16-Jan 15:03:44][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:44][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:44][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:44][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:44][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:03:44][0 ms]*/ select database(); /*[16-Jan 15:03:44][0 ms]*/ use `mysql`; /*[16-Jan 15:03:53][32 ms]*/ GRANT ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, EXECUTE, INDEX, INSERT, LOCK TABLES, REFERENCES, SELECT, SHOW VIEW, TRIGGER, UPDATE ON `landing`.* TO 'landing'@'localhost'; /*[16-Jan 15:04:00][0 ms]*/ use `landing`; /*[16-Jan 15:04:20][0 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[16-Jan 15:04:20][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[16-Jan 15:04:20][12 ms]*/ SHOW COLUMNS FROM `mysql`.`user`; /*[16-Jan 15:04:20][6 ms]*/ SHOW COLUMNS FROM `mysql`.`db`; /*[16-Jan 15:04:20][6 ms]*/ SHOW COLUMNS FROM `mysql`.`tables_priv`; /*[16-Jan 15:04:20][3 ms]*/ SHOW COLUMNS FROM `mysql`.`procs_priv`; /*[16-Jan 15:04:20][0 ms]*/ SHOW DATABASES; /*[16-Jan 15:04:20][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:04:20][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:04:20][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:04:20][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:04:20][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[16-Jan 15:04:20][0 ms]*/ select database(); /*[16-Jan 15:04:20][0 ms]*/ use `mysql`; /*[16-Jan 15:04:31][0 ms]*/ DROP USER 'landing'@'localhost'; /*[16-Jan 15:04:31][0 ms]*/ FLUSH PRIVILEGES; /*[16-Jan 15:04:31][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:31][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:31][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:31][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:31][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:31][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:31][0 ms]*/]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:35][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM inLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:35][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:42][0 ms]*/ use `landing`; /*[16-Jan 15:04:44][0 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[16-Jan 15:04:44][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[16-Jan 15:04:44][11 ms]*/ SHOW COLUMNS FROM `mysql`.`user`; /*[16-Jan 15:04:44][6 ms]*/ SHOW COLUMNS FROM `mysql`.`db`; /*[16-Jan 15:04:44][6 ms]*/ SHOW COLUMNS FROM `mysql`.`tables_priv`; /*[16-Jan 15:04:44][3 ms]*/ SHOW COLUMNS FROM `mysql`.`procs_priv`; /*[16-Jan 15:04:44][0 ms]*/ SHOW DATABASES; /*[16-Jan 15:04:44][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:44][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:44][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:44][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:44][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'formation_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:42][0 ms]*/ use `landing`; /*[16-Jan 15:04:44][0 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[16-Jan 15:04:44][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[16-Jan 15:04:44][11 ms]*/ SHOW COLUMNS FROM `mysql`.`user`; /*[16-Jan 15:04:44][6 ms]*/ SHOW COLUMNS FROM `mysql`.`db`; /*[16-Jan 15:04:44][6 ms]*/ SHOW COLUMNS FROM `mysql`.`tables_priv`; /*[16-Jan 15:04:44][3 ms]*/ SHOW COLUMNS FROM `mysql`.`procs_priv`; /*[16-Jan 15:04:44][0 ms]*/ SHOW DATABASES; /*[16-Jan 15:04:44][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:44][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:44][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:44][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:44][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'pma' AND Host = 'localhost'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'tables_priv'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLEmysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ select database(); /*[16-Jan 15:04:44][0 ms]*/ use `mysql`; /*[16-Jan 15:05:07][0 ms]*/ CREATE USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'; /*[16-Jan 15:05:07][0 ms]*/ FLUSH PRIVILEGES; /*[16-Jan 15:05:13][0 ms]*/ GRANT ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, EXECUTE, INDEX, INSERT, LOCK TABLES, REFERENCES, SELECT, SHOW VIEW, TRIGGER, UPDATE ON `landing`.* TO 'landing'@'localhost'; /*[16-Jan 15:05:17][0 ms]*/ use `landing`; /*[10-Mar 09:22:54][0 ms]*/ use `landing`; /*[10-Mar 09:22:59][89 ms]*/ show databases; /*[10-Mar 09:23:49][2 ms]*/ show full tables from `landing` where table_type = 'BASE TABLE'; /*[10-Mar 09:23:49][2 ms]*/ select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'landing' and `TABLE_TYPE` = 'VIEW'; /*[10-Mar 09:23:49][9 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'landing' and ROUTINE_TYPE = 'PROCEDURE'; /*[10-Mar 09:23:49][3 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'landing'and ROUTINE_TYPE = 'FUNCTION'; /*[10-Mar 09:23:49][10 ms]*/ SHOW TRIGGERS from `landing`; /*[10-Mar 09:23:49][7 ms]*/ select `EVENT_NAME` from `INFORMATION_SCHEMA`.`EVENTS` where `EVENT_SCHEMA` = 'landing' order by EVENT_NAME; /*[22-Nov 11:42:54][0 ms]*/ use `landing`; /*[22-Nov 11:42:54][161 ms]*/ show databases; /*[22-Nov 11:42:58][0 ms]*/ use `kptv_site`; /*[22-Nov 11:43:00][0 ms]*/ use `landing`; /*[22-Nov 11:43:01][0 ms]*/ use `kptv_site`; /*[22-Nov 11:43:03][0 ms]*/ use `landing`; /*[22-Nov 11:43:07][0 ms]*/ use `kptv_site`; /*[22-Nov 11:43:33][324 ms]*/ show full tables from `kptv_site` where table_type = 'BASE TABLE'; /*[22-Nov 11:43:33][13 ms]*/ select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'kptv_site' and `TABLE_TYPE` = 'VIEW'; /*[22-Nov 11:43:33][77 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site' and ROUTINE_TYPE = 'PROCEDURE'; /*[22-Nov 11:43:33][3 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site'and ROUTINE_TYPE = 'FUNCTION'; /*[22-Nov 11:43:33][6 ms]*/ SHOW TRIGGERS from `kptv_site`; /*[22-Nov 11:43:33][6 ms]*/ select `EVENT_NAME` from `INFORMATION_SCHEMA`.`EVENTS` where `EVENT_SCHEMA` = 'kptv_site' order by EVENT_NAME; /*[22-Nov 11:46:10][0 ms]*/ use `kptv_site`; /*[22-Nov 11:46:10][5 ms]*/ show databases; /*[22-Nov 11:46:13][0 ms]*/ use `landing`; /*[22-Nov 11:46:28][1620 ms]*/ show full tables from `landing` where table_type = 'BASE TABLE'; /*[22-Nov 11:46:28][11 ms]*/ select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'landing' and `TABLE_TYPE` = 'VIEW'; /*[22-Nov 11:46:28][6 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'landing' and ROUTINE_TYPE = 'PROCEDURE'; /*[22-Nov 11:46:28][3 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'landing'and ROUTINE_TYPE = 'FUNCTION'; /*[22-Nov 11:46:28][9 ms]*/ SHOW TRIGGERS from `landing`; /*[22-Nov 11:46:28][6 ms]*/ select `EVENT_NAME` from `INFORMATION_SCHEMA`.`EVENTS` where `EVENT_SCHEMA` = 'landing' order by EVENT_NAME; /*[23-Jan 12:37:29][0 ms]*/ use `landing`; /*[23-Jan 12:37:31][28 ms]*/ show databases; /*[23-Jan 12:37:37][0 ms]*/ use `kptv_site`; /*[23-Jan 12:37:38][43 ms]*/ show full tables from `kptv_site` where table_type = 'BASE TABLE'; /*[23-Jan 12:37:41][0 ms]*/ select * from `kptv_s_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ SELECT TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'user'; /*[16-Jan 15:04:44][0 ms]*/ select database(); /*[16-Jan 15:04:44][0 ms]*/ use `mysql`; /*[16-Jan 15:05:07][0 ms]*/ CREATE USER 'landing'@'localhost' IDENTIFIED BY 'upS4szMOzwvc'; /*[16-Jan 15:05:07][0 ms]*/ FLUSH PRIVILEGES; /*[16-Jan 15:05:13][0 ms]*/ GRANT ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, EXECUTE, INDEX, INSERT, LOCK TABLES, REFERENCES, SELECT, SHOW VIEW, TRIGGER, UPDATE ON `landing`.* TO 'landing'@'localhost'; /*[16-Jan 15:05:17][0 ms]*/ use `landing`; /*[10-Mar 09:22:54][0 ms]*/ use `landing`; /*[10-Mar 09:22:59][89 ms]*/ show databases; /*[10-Mar 09:23:49][2 ms]*/ show full tables from `landing` where table_type = 'BASE TABLE'; /*[10-Mar 09:23:49][2 ms]*/ select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'landing' and `TABLE_TYPE` = 'VIEW'; /*[10-Mar 09:23:49][9 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'landing' and ROUTINE_TYPE = 'PROCEDURE'; /*[10-Mar 09:23:49][3 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'landing'and ROUTINE_TYPE = 'FUNCTION'; /*[10-Mar 09:23:49][10 ms]*/ SHOW TRIGGERS from `landing`; /*[10-Mar 09:23:49][7 ms]*/ select `EVENT_NAME` from `INFORMATION_SCHEMA`.`EVENTS` where `EVENT_SCHEMA` = 'landing' order by EVENT_NAME; /*[22-Nov 11:42:54][0 ms]*/ use `landing`; /*[22-Nov 11:42:54][161 ms]*/ show databases; /*[22-Nov 11:42:58][0 ms]*/ use `kptv_site`; /*[22-Nov 11:43:00][0 ms]*/ use `landing`; /*[22-Nov 11:43:01][0 ms]*/ use `kptv_site`; /*[22-Nov 11:43:03][0 ms]*/ use `landing`; /*[22-Nov 11:43:07][0 ms]*/ use `kptv_site`; /*[22-Nov 11:43:33][324 ms]*/ show full tables from `kptv_site` where table_type = 'BASE TABLE'; /*[22-Nov 11:43:33][13 ms]*/ select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'kptv_site' and `TABLE_TYPE` = 'VIEW'; /*[22-Nov 11:43:33][77 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site' and ROUTINE_TYPE = 'PROCEDURE'; /*[22-Nov 11:43:33][3 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site'and ROUTINE_TYPE = 'FUNCTION'; /*[22-Nov 11:43:33][6 ms]*/ SHOW TRIGGERS from `kptv_site`; /*[22-Nov 11:43:33][6 ms]*/ select `EVENT_NAME` from `INFORMATION_SCHEMA`.`EVENTS` where `EVENT_SCHEMA` = 'kptv_site' order by EVENT_NAME; /*[22-Nov 11:46:10][0 ms]*/ use `kptv_site`; /*[22-Nov 11:46:10][5 ms]*/ show databases; /*[22-Nov 11:46:13][0 ms]*/ use `landing`; /*[22-Nov 11:46:28][1620 ms]*/ show full tables from `landing` where table_type = 'BASE TABLE'; /*[22-Nov 11:46:28][11 ms]*/ select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'landing' and `TABLE_TYPE` = 'VIEW'; /*[22-Nov 11:46:28][6 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'landing' and ROUTINE_TYPE = 'PROCEDURE'; /*[22-Nov 11:46:28][3 ms]*/ select `SPECIFIC_NAME ` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'landing'and ROUTINE_TYPE = 'FUNCTION'; /*[22-Nov 11:46:28][9 ms]*/ SHOW TRIGGERS from `landing`; /*[22-Nov 11:46:28][6 ms]*/ select `EVENT_NAME` from `INFORMATION_SCHEMA`.`EVENTS` where `EVENT_SCHEMA` = 'landing' order by EVENT_NAME; /*[23-Jan 12:37:29][0 ms]*/ use `landing`; /*[23-Jan 12:37:31][28 ms]*/ show databases; /*[23-Jan 12:37:37][0 ms]*/ use `kptv_site`; /*[23-Jan 12:37:38][43 ms]*/ show full tables from `kptv_site` where table_type = 'BASE TABLE'; /*[23-Jan 12:37:41][0 ms]*/ select * from `kptv_site`.`accounts` limit 0, 1000; /*[23-Jan 12:37:41][0 ms]*/ show create table `kptv_site`.`accounts`; /*[23-Jan 12:37:41][13 ms]*/ show full fields from `kptv_site`.`accounts`; /*[23-Jan 12:37:41][0 ms]*/ show keys from `kptv_site`.`accounts`; /*[23-Jan 12:42:49][4 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[23-Jan 12:42:49][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[23-Jan 12:42:49][19 ms]*/ SHOW COLUMNS FROM `mysql`.`user`; /*[23-Jan 12:42:49][19 ms]*/ SHOW COLUMNS FROM `mysql`.`db`; /*[23-Jan 12:42:49][24 ms]*/ SHOW COLUMNS FROM `mysql`.`tables_priv`; /*[23-Jan 12:42:49][17 ms]*/ SHOW COLUMNS FROM `mysql`.`procs_priv`; /*[23-Jan 12:42:49][0 ms]*/ SHOW DATABASES; /*[23-Jan 12:42:49][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'landing' AND Host = 'localhost'; /*[23-Jan 12:42:49][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'landing' AND Host = 'localhost'; /*[23-Jan 12:42:49][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[23-Jan 12:42:49][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[23-Jan 12:42:49][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[23-Jan 12:42:49][0 ms]*/ select database(); /*[23-Jan 12:42:49][0 ms]*/ use `mysql`; /*[23-Jan 12:42:55][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]* ite`.`accounts` limit 0, 1000; /*[23-Jan 12:37:41][0 ms]*/ show create table `kptv_site`.`accounts`; /*[23-Jan 12:37:41][13 ms]*/ show full fields from `kptv_site`.`accounts`; /*[23-Jan 12:37:41][0 ms]*/ show keys from `kptv_site`.`accounts`; /*[23-Jan 12:42:49][4 ms]*/ SELECT COUNT(`Host`) FROM `mysql`.`user`; /*[23-Jan 12:42:49][0 ms]*/ SELECT `Host`, `User` FROM `mysql`.`user`; /*[23-Jan 12:42:49][19 ms]*/ SHOW COLUMNS FROM `mysql`.`user`; /*[23-Jan 12:42:49][19 ms]*/ SHOW COLUMNS FROM `mysql`.`db`; /*[23-Jan 12:42:49][24 ms]*/ SHOW COLUMNS FROM `mysql`.`tables_priv`; /*[23-Jan 12:42:49][17 ms]*/ SHOW COLUMNS FROM `mysql`.`procs_priv`; /*[23-Jan 12:42:49][0 ms]*/ SHOW DATABASES; /*[23-Jan 12:42:49][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'landing' AND Host = 'localhost'; /*[23-Jan 12:42:49][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'landing' AND Host = 'localhost'; /*[23-Jan 12:42:49][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[23-Jan 12:42:49][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[23-Jan 12:42:49][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'landing' AND Host = 'localhost'; /*[23-Jan 12:42:49][0 ms]*/ select database(); /*[23-Jan 12:42:49][0 ms]*/ use `mysql`; /*[23-Jan 12:42:55][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:42:55][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT * FROM `mysql`.`user` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT * FROM `mysql`.`db` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Table_name, Table_priv FROM `mysql`.`tables_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Table_name, Column_name, Column_priv FROM `mysql`.`columns_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:43:10][0 ms]*/ SELECT Db, Routine_name, Routine_type, Proc_priv FROM `mysql`.`procs_priv` WHERE User = 'root' AND Host = 'localhost'; /*[23-Jan 12:44:34][0 ms]*/ use `kptv_site`; /*[23-Jan 12:57:47][0 ms]*/ echo md07:48:34][3 ms]*/ show full tables from `kptv_site2` where table_type = 'BASE TABLE'; /*[20-May 08:36:23][0 ms]*/ use `kptv_site2`; /*[20-May 08:36:23][2 ms]*/ show databases; /*[20-May 08:36:48][5 ms]*/ show full tables from `kptv_site2` where table_type = 'BASE TABLE'; /*[20-May 08:36:48][4 ms]*/ select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'kptv_site2' and `TABLE_TYPE` = 'VIEW'; /*[20-May 08:36:48][16 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site2' and ROUTINE_TYPE = 'PROCEDURE'; /*[20-May 08:36:48][4 ms]*/ select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'kptv_site2'and ROUTINE_TYPE = 'FUNCTION'; /*[20-May 08:36:48][9 ms]*/ SHOW TRIGGERS from `kptv_site2`; /*[20-May 08:36:48][8 ms]*/ select `EVENT_NAME` from `INFORMATION_SCHEMA`.`EVENTS` where `EVENT_SCHEMA` = 'kptv_site2' order by EVENT_NAME; /*[20-May 11:13:49][0 ms]*/ use `kptv_site2`; /*[20-May 11:13:49][30 ms]*/ show databases; /*[20-May 11:14:50][2 ms]*/ UPDATE banners SET Banner = REPLACE(Banner, 'http://radio.kptv.ro/', 'https://testsite2.kptv.ro/') WHERE ID = 8; /*[20-May 11:14:50][0 ms]*/ SELECT (CHAR_LENGTH(Banner) - CHAR_LENGTH(REPLACE(Banner, 'testsite2.kptv.ro', ''))) / CHAR_LENGTH('testsite2.kptv.ro') AS testsite2_hits, (CHAR_LENGTH(Banner) - CHAR_LENGTH(REPLACE(Banner, 'radio.kptv.ro', ''))) / CHAR_LENGTH('radio.kptv.ro') AS radio_hits FROM banners WHERE ID = 8 LIMIT 0, 1000; /*[20-May 11:28:56][2 ms]*/ UPDATE banners SET Banner = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( Banner, 'pg=page&id=46', 'pg=page&id=__PAT__'), 'pg=page&id=52', 'pg=page&id=__MAG__'), 'pg=page&id=47', 'pg=page&id=__MIC__'), 'pg=page&id=51', 'pg=page&id=__KAR__'), 'pg=page&id=48', 'pg=page&id=__TON__'), 'pg=page&id=__PAT__', 'pg=page&id=52'), 'pg=page&id=__MAG__', 'pg=page&id=56'), 'pg=page&id=__MIC__', 'pg=page&id=53'), 'pg=page&id=__KAR__', 'pg=page&id=55'), 'pg=page&id=__TON__', 'pg=page&id=54') WHERE ID = 8; /*[20-May 11:28:56][0 ms]*/ SELECT b.Banner REGEXP 'pg=page&id=46' AS still_broken_46, b.Banner REGEXP 'pg=page&id=47' AS still_broken_47, b.Banner REGEXP 'pg=page&id=48' AS still_broken_48, b.Banner REGEXP 'pg=page&id=51' AS still_broken_51 FROM banners b WHERE ID = 8 LIMIT 0, 1000; /*[20-May 11:56:40][3 ms]*/ UPDATE pages SET ContentRO = REPLACE( REPLACE( REPLACE( ContentRO, 'https://lh3.googleusercontent.com/proxy/7akwVO8h6Wq8a0MDvc5ITL_OmtEujawukRQ5sRXz7B9gTslzAL2Y05O0K9eTYVWGTYwBZ3fd17fWkXaQh4gxC5czcrcMcvGGGbwHR0Nz3hHDGpR6oB_nPUyTJ2TLYzZX29ZBDUr7kjv6r4P5OeAh-Q', '/images/uploads/telegrafon-poulsen.jpg'), 'https://www.musictech.net/wp-content/uploads/2014/05/studer-j37.jpg', '/images/uploads/studer-j37.jpg'), 'https://images.reverb.com/image/upload/s--qL2B_hrF--/a_exif,c_limit,e_unsharp_mask:80,f_auto,fl_progressive,g_south,h_620,q_90,w_620/v1480371018/p9tsayngsyyqtsvnmelp.jpg', '/images/uploads/dat-recorder.jpg') WHERE ID = 56; /*[20-May 11:56:40][1 ms]*/ SELECT (CHAR_LENGTH(ContentRO) - CHAR_LENGTH(REPLACE(ContentRO, 'lh3.googleusercontent.com', '')))/CHAR_LENGTH('lh3.googleusercontent.com') AS lh3, (CHAR_LENGTH(ContentRO) - CHAR_LENGTH(REPLACE(ContentRO, 'musictech.net', ''))) /CHAR_LENGTH('musictech.net') AS musictech, (CHAR_LENGTH(ContentRO) - CHAR_LENGTH(REPLACE(ContentRO, 'images.reverb.com', ''))) /CHAR_LENGTH('images.reverb.com') AS reverb FROM pages WHERE ID = 56 LIMIT 0, 1000; /*[20-May 12:12:57][3 ms]*/ UPDATE pages SET ContentRO = REPLACE( REPLACE( REPLACE( ContentRO, 'https://images.mid-day.com/images/2015/jan/20david-edward-hughes-l.jpg', '/images/uploads/microfon-hughes.jpg'), 'https://images.reverb.com/image/upload/s--A71kXTXf--/f_auto,t_large/v1570121587/xmdlvb9nrjgaiffx5pj3.jpg', '/images/uploads/microfon-rca44.png'), 'https://static-neumann.s3.amazonaws.com/img/3703/x2_desktop_019_bearbeitet_1500px_.jpg', '/images/uploads/microfon-neumann.jpg') WHERE ID = 53; x

Windows NT KPTV 6.2 build 9200 (Windows Server 2012 Datacenter Edition) i586