ANTI-LEY CISPA

Script started on Fri 17 Feb 2012 03:28:43 PM MST
#

root@georgemichael> ~mysql -u root -p

Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
#

[1] root@georgemichael> ~

#

[1] root@georgemichael> ~mmysql -h m navytan
k
k.np-  o-ip.org -P 33706 -u products_user -p

 products

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 87
Server version: 5.1.54-1ubuntu4 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> mysql> CSHOW TABLES;
Empty set (0.06 sec)

mysql> CREATE TABLE `user` (
    ->    `usetrrname` VARCHAR (50),
    ->    `password` ARVARCHAR( (50),
    ->    `email`    VARCHAR( R (50),
    ->     PRIMARY KEY (`username`)
    -> );
Query OK, 0 rows affected (0.05 sec)

mysql> SHOPW W TABLES;
+--------------------+
| Tables_in_products |
+--------------------+
| user               |
+--------------------+
1 row in set (0.05 sec)

mysql> DESCRIBE `user`;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(50) | NO   | PRI |         |       |
| password | varchar(50) | YES  |     | NULL    |       |
| email    | varchar(50) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.04 sec)

mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql> DESCRIBE `user`;
SHOW TABLES;
CREATE TABLE `user` (    `username` VARCHAR (50),    `passw
word` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`u
username`) );

 `user` (    `username` VARCHAR (50),    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`us `user` (    `username` VARCHAR (50),    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`use `user` (    `username` VARCHAR (50),    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`user `user` (    `username` VARCHAR (50),    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`usern `user` (    `username` VARCHAR (50),    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`userna`user` (    `username` VARCHAR (50),    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`usernam



ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`user` (    `username` VARCHAR (50),    `password` VARCHAR (50),    `email`    V' at line 1
mysql> CREATE `user` (    `username` VARCHAR (50),    `password` V
VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`usernam
me`) );DESCRIBE `user`;




SHOW TABLES;
CREATE TABLE `user` (    `username` VARCHAR (50),    `passw
word` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`u
username`) );,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`us,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`use,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`user,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`usern,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`userna,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`usernam,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`username,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`username`,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`username`) );,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`username`) );,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`username`) );,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`username`) );,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`username`) );




ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`userna' at line 1
mysql> sdescribDESCRBIIBE `users`;
ERROR 1146 (42S02): Table 'products.users' doesn't exist
mysql> DESCRIBE `users`;`;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(50) | NO   | PRI |         |       |
| password | varchar(50) | YES  |     | NULL    |       |
| email    | varchar(50) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.04 sec)

mysql> DROP TABLE `users`;
Query OK, 0 rows affected (0.04 sec)

mysql> sSHOW TABLES;
Empty set (0.04 sec)

mysql> SHOW TABLES;
DROP TABLE `user`;
ESCRIBs`;
CREATE TABLE `user` (    `username`,    `password` VARCHAR
 (50),    `email`    VARCHAR (50),    PRIMARY KEY (`username`) );
`user` (    `username` VARCHAR (50),    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`usernam
me`) );TABLE `user` (    `username`,    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`username`) );
`user` (    `username` VARCHAR (50),    `password` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`usernam
me`) );DESCRIBE `user`;




SHOW TABLES;
CREATE TABLE `user` (    `username` VARCHAR (50),    `passw
word` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`u
username`) ););



CREATE TABLE `user` (    `username` VARCHAR (50),    `passw
word` VARCHAR (50),    `email`    VARCHAR (50),    PRIMARY KEY (`u
username`) );
Query OK, 0 rows affected (0.04 sec)

mysql> CREATE TABLE `orders` (
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum`
    ->    `ordernum` INT (2010)
    ->    `ordernum` INT (10)
    ->    `ordernum` INT (10)
    ->    `ordernum` INT (10)
    ->    `ordernum` INT (10)
    ->    `ordernum` INT (10)
    ->    `ordernum` INT (10)
    ->    `ordernum` INT (10) AUTO_INCREMENT,,
    ->    `username` VARCHAR (50),
    ->    `dcreditcard` VARCHAR(  (16),
    ->    `date` DATE,
    ->    PRIMARY KEY (`ordernum`)
    -> );
Query OK, 0 rows affected (0.06 sec)

mysql> describDESCRIBE `order`s`;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| ordernum   | int(10)     | NO   | PRI | NULL    | auto_increment |
| username   | varchar(50) | YES  |     | NULL    |                |
| creditcard | varchar(16) | YES  |     | NULL    |                |
| date       | date        | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
4 rows in set (0.05 sec)

mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql> CREATe
mysql> CREATe
mysql> CREATe
mysql> CREATe
mysql> CREATe
mysql> CREATe E TABLE `products` (
    ->     `name `` VARCHAR (50),
    ->     `description` TEXT,
    ->     `price` DECIMAL(5,2),2)7,2),
    ->     `picture ` VARCHAR ( (255) DEFAULT "nopic
ture.jpg"
    ->     `picture` VARCHAR (255) DEFAULT "nopictu
ure.jpg"
    ->     `picture` VARCHAR (255) DEFAULT "nopictur
re.jpg"
    ->     `picture` VARCHAR (255) DEFAULT "nopicture
e.jpg"
    ->     `picture` VARCHAR (255) DEFAULT "nopicture.
.jpg"
    ->     `picture` VARCHAR (255) DEFAULT "nopicture.j
jpg"
    ->     `picture` VARCHAR (255) DEFAULT "nopicture.jp
pg"
    ->     `picture` VARCHAR (255) DEFAULT "nopicture.jpg
g"
    ->     `picture` VARCHAR (255) DEFAULT "nopicture.jpg"
"
    ->     `picture` VARCHAR (255) DEFAULT "nopicture.jpg"

    ->     `picture` VARCHAR (255) DEFAULT "nopicture.jpg"
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->
    ->     `productid` INT (510) AUTO_INCREME
NT,
    ->     PRIMARY KEY(`productid`);
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`productid` INT (10) AUTO_INCREMENT,
    PRIMARY KEY(`productid`)
)' at line 6
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql> CREATE TABLE `products` (     `name` VARCHAR(50),     `des
scription` TEXT,     `price` DECIMAL(7,2),     `picture` VARCHAR
 (255) DEFAULT "nopicture.jpg"     `productid` INT (10) AUTO_INCR
REMENT,     PRIMARY KEY(`productid`) );
,     `productid` INT (10) AUTO_INC[1@R


Query OK, 0 rows affected (0.04 sec)

mysql> shoSHOW TABLES:;
+--------------------+
| Tables_in_products |
+--------------------+
| orders             |
| products           |
| user               |
+--------------------+
3 rows in set (0.05 sec)

mysql> DESCRIBE products;
+-------------+--------------+------+-----+---------------+----------------+
| Field       | Type         | Null | Key | Default       | Extra          |
+-------------+--------------+------+-----+---------------+----------------+
| name        | varchar(50)  | YES  |     | NULL          |                |
| description | text         | YES  |     | NULL          |                |
| price       | decimal(7,2) | YES  |     | NULL          |                |
| picture     | varchar(255) | YES  |     | nopicture.jpg |                |
| productid   | int(10)      | NO   | PRI | NULL          | auto_increment |
+-------------+--------------+------+-----+---------------+----------------+
5 rows in set (0.04 sec)

mysql> CREATE TABLE `products_in_orders` (
    ->     `orderidnum` INT (10),
    ->     ` productid` INT (10),
    ->       `quantity` INT(5),
    ->     `address~` MTEXT, 
    ->      PRIMARY KEY(`ordernum`, `productid`)
    -> );
Query OK, 0 rows affected (0.05 sec)

mysql> DESCRIBE `products_in_orders`;
+-----------+---------+------+-----+---------+-------+
| Field     | Type    | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| ordernum  | int(10) | NO   | PRI | 0       |       |
| productid | int(10) | NO   | PRI | 0       |       |
| quantity  | int(5)  | YES  |     | NULL    |       |
| address   | text    | YES  |     | NULL    |       |
+-----------+---------+------+-----+---------+-------+
4 rows in set (0.04 sec)

mysql> INSERT INTO `users` (
    ->    ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> selectDESCRIBE `users``;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(50) | NO   | PRI |         |       |
| password | varchar(50) | YES  |     | NULL    |       |
| email    | varchar(50) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.05 sec)

mysql> INSERT INTO `user` (
    ->     (`username`, `password`, `email`)
    -> VLUAALUES
    ->     ("Jesse",  "a"abd", "cd", "jesse@nwowhere"),
    ->     ("Eric", "a1234", "eric@arionzona"),
    ->     ("Tyson", "edftft", "tyson@gmail")
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`username`, `password`, `email`)
VALUES
    ("Jesse", "abcd", "jesse@nowhere"),' at line 2
mysql> INSERT INTO `user` (     (`username`, `password`, `email`)
) VALUES     ("Jesse", "abcd", "jesse@nowhere"),     ("Eric", "12
234", "eric@arizona"),     ("Tyson", "eft", "tyson@gmail");
     (`username`, `password`, `email`) VALUES     ("Jesse", "abcd", "jesse@nowhere"),     ("Eric", "123(`username`, `password`, `email`) VALUES     ("Jesse", "abcd", "jesse@nowhere"),     ("Eric", "1234



Query OK, 3 rows affected (0.05 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> SELECT `username` FROM `user`;
+----------+
| username |
+----------+
| Eric     |
| Jesse    |
| Tyson    |
+----------+
3 rows in set (0.04 sec)

mysql> SELECT `username` FROM `user`;[1@,[1@ [1@`[1@e[1@m[1@a[1@i[1@l[1@`
+----------+---------------+
| username | email         |
+----------+---------------+
| Jesse    | jesse@nowhere |
| Eric     | eric@arizona  |
| Tyson    | tyson@gmail   |
+----------+---------------+
3 rows in set (0.04 sec)

mysql> SELECT `username`, `email` FROM `user`;[1@*
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Jesse    | abcd     | jesse@nowhere |
| Eric     | 1234     | eric@arizona  |
| Tyson    | eft      | tyson@gmail   |
+----------+----------+---------------+
3 rows in set (0.04 sec)

mysql> SELECT * FROM `users`` WHERE `username` = "Jesse";
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Jesse    | abcd     | jesse@nowhere |
+----------+----------+---------------+
1 row in set (0.04 sec)

mysql> SELECT * FROM `user` WHERE `username` = "Jesse";inIN ("Jesse", "Eric"
);
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Eric     | 1234     | eric@arizona  |
| Jesse    | abcd     | jesse@nowhere |
+----------+----------+---------------+
2 rows in set (0.07 sec)

mysql> SELECT * FROM `user` WHERE `username` IN ("Jesse", "Eric")
);



SELECT * FROM `user` WHERE `username` IN ("Jesse", "Eric")
);


LIKE "J%"
    -> ;
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Jesse    | abcd     | jesse@nowhere |
+----------+----------+---------------+
1 row in set (0.04 sec)

mysql> ;SELECT * FROM `user` WHERE `username` LIKE "J%";`;
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Jesse    | abcd     | jesse@nowhere |
| Eric     | 1234     | eric@arizona  |
| Tyson    | eft      | tyson@gmail   |
+----------+----------+---------------+
3 rows in set (0.04 sec)

mysql> SELECT * FROM `user`; ;O;F;;R;D;E;R; ;B;Y; ;`;u;s;e;r;n;a;m;e;`; ;A;S;C;
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Eric     | 1234     | eric@arizona  |
| Jesse    | abcd     | jesse@nowhere |
| Tyson    | eft      | tyson@gmail   |
+----------+----------+---------------+
3 rows in set (0.05 sec)

mysql> SELECT * FROM `user` ORDER BY `username` ASC;;;;D;E;S;C;
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Tyson    | eft      | tyson@gmail   |
| Jesse    | abcd     | jesse@nowhere |
| Eric     | 1234     | eric@arizona  |
+----------+----------+---------------+
3 rows in set (0.05 sec)

mysql> SELECT * FROM `user` ORDER BY `username` DESC;ORDER BY `username` DESC LIMIT 0,1;
+----------+----------+-------------+
| username | password | email       |
+----------+----------+-------------+
| Tyson    | eft      | tyson@gmail |
+----------+----------+-------------+
1 row in set (0.04 sec)

mysql> SELECT * FROM `user` ORDER BY `username` DESC LIMIT 0,1;;2;
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Tyson    | eft      | tyson@gmail   |
| Jesse    | abcd     | jesse@nowhere |
+----------+----------+---------------+
2 rows in set (0.05 sec)

mysql> SELECT * FROM `user` ORDER BY `username` DESC LIMIT 0,2;,2;1,2;
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Jesse    | abcd     | jesse@nowhere |
| Eric     | 1234     | eric@arizona  |
+----------+----------+---------------+
2 rows in set (0.05 sec)

mysql> SELECT * FROM `user` ORDER BY `username` DESC LIMIT 1,2;,2;2,2;
+----------+----------+--------------+
| username | password | email        |
+----------+----------+--------------+
| Eric     | 1234     | eric@arizona |
+----------+----------+--------------+
1 row in set (0.05 sec)

mysql> SELECT * FROM `user` ORDER BY `username` DESC LIMIT 2,2;;
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Jesse    | abcd     | jesse@nowhere |
| Eric     | 1234     | eric@arizona  |
| Tyson    | eft      | tyson@gmail   |
+----------+----------+---------------+
3 rows in set (0.06 sec)

mysql> SELECT * FROM `user`; ;L;I;M;I;T; ;0;,; ;2;
+----------+----------+---------------+
| username | password | email         |
+----------+----------+---------------+
| Jesse    | abcd     | jesse@nowhere |
| Eric     | 1234     | eric@arizona  |
+----------+----------+---------------+
2 rows in set (0.05 sec)

mysql> SELECT * FROM `user` LIMIT 0, 2;[1@2
+----------+----------+-------------+
| username | password | email       |
+----------+----------+-------------+
| Tyson    | eft      | tyson@gmail |
+----------+----------+-------------+
1 row in set (0.06 sec)