Description:
sorry but I am quite new to all of this, i am a student and need sql to submit my coursework which it is not allowing me to do.
I have a problem with both the sql 5.2 workbench as well as the sql 5.1server- command line.
The server stopped working and everytime I tried to input data it would bring up an error -> ON DELETE NO ACTION
-> ON UPDATE NO ACTION)
-> ENGINE = InnoDB;
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql>
mysql>
mysql> -- -----------------------------------------------------
mysql> -- Table `mydb`.`Products`
mysql> -- -----------------------------------------------------
mysql> CREATE TABLE IF NOT EXISTS `mydb`.`Products` (
-> `item_barcode` CHAR(10) NOT NULL ,
-> `item_desc` TEXT NULL ,
-> `item_on_shelves` CHAR(10) NOT NULL ,
-> `selling_price` DECIMAL(8,2) NOT NULL ,
-> `min_stock_level` CHAR(10) NOT NULL ,
-> `Cartons_carton_barcode` CHAR(10) NOT NULL ,
-> PRIMARY KEY (`item_barcode`) ,
-> INDEX `fk_Products_Cartons1` (`Cartons_carton_barcode` ASC) ,
-> CONSTRAINT `fk_Products_Cartons1`
-> FOREIGN KEY (`Cartons_carton_barcode` )
-> REFERENCES `mydb`.`Cartons` (`carton_barcode` )
-> ON DELETE NO ACTION
-> ON UPDATE NO ACTION)
-> ENGINE = InnoDB;
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql>
mysql>
mysql>
mysql> SET SQL_MODE=@OLD_SQL_MODE;
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr
ice, min_stock_level)
-> VALUES('11111','200 x packet straw flavoured choc chip', '10', '0.50', '1
00');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr
ice, min_stock_level)
-> VALUES('22223', '100 x packet Choc flavoured Bears', '50', '1.00', '50');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr
ice, min_stock_level)
-> VALUES('11113', '50 x bars Choc Mint flavoured Iceberg', '20', '2.00', '2
5');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr
ice, min_stock_level)
-> VALUES('33333', '200 x Minature Chocolate Eggs', '20', '0.50', '100')
-> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr
ice, min_stock_level)
-> VALUES('44445', '100 x bars of Chocolate flavoured orange', '20', '0.70',
'50');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr
ice, min_stock_level)
-> VALUES('33335', '50 x Chocolate covered Rice Snack bars', '15', '1.00', '
25');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr
ice, min_stock_level)
-> VALUES('66666', '200 x Strawberry filled Wagon Wheels', '10', '0.50', '10
0');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr
ice, min_stock_level)
-> VALUES('55556', '100 x Caramel filled Choc Bars', '15', '0.60', '50');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr
ice, min_stock_level)
-> VALUES('26375', '50 x Packets Assorted Chocolate sweets', '10', '1.00', '
25');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price)
-> VALUES('23456', 'Large box Strawberry Choc chips', 'CU123', '15.00');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price)
-> VALUES('12345', 'Standard box Chocolate Bears', 'CU122', '10.00' );
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price)
-> VALUES('39765', 'Small box Chocolate Mint Icebergs', 'CU121', '5.00');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price)
-> VALUES('20909', 'Large box Chocolate Eggs', 'CC234', '20.00');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price)
-> VALUES('26667', 'Standard box Chocolate Orange', 'CC232', '15.00');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price)
-> VALUES('88664','Small box Rice Snacks', 'CC222', '10.00');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price)
-> VALUES('22331', 'Large box Wagon Wheels', 'CD456', '15.00');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price)
-> VALUES('00778', 'Standard box Caramel Bars', 'CD455', '10.00');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price)
-> VALUES('55121', 'Small box Assorted Chocolates', 'CD466', '5.00');
No connection. Trying to reconnect...
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2)
ERROR:
Can't connect to the server
mysql> INSERT INTO PurchaseOrders(order_id, order_No, order_delivery_date, order
_date, quantity, cost_price, supp_id)
-> VALUES('CU123', '1212', '2010-10-15', '2010-10-10', '15', '8.00', '123220
2' );
No connection. Trying to reconnect...
->
The server will not allow me to input my password either, it just shuts down everytime I enter my password.
And now my sql workbench has thrown a bug/exception- "object reference not set to an instance of an object.
Please, please help!!!
How to repeat:
I DONT KNOW!!!!!
Description: sorry but I am quite new to all of this, i am a student and need sql to submit my coursework which it is not allowing me to do. I have a problem with both the sql 5.2 workbench as well as the sql 5.1server- command line. The server stopped working and everytime I tried to input data it would bring up an error -> ON DELETE NO ACTION -> ON UPDATE NO ACTION) -> ENGINE = InnoDB; No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> mysql> mysql> -- ----------------------------------------------------- mysql> -- Table `mydb`.`Products` mysql> -- ----------------------------------------------------- mysql> CREATE TABLE IF NOT EXISTS `mydb`.`Products` ( -> `item_barcode` CHAR(10) NOT NULL , -> `item_desc` TEXT NULL , -> `item_on_shelves` CHAR(10) NOT NULL , -> `selling_price` DECIMAL(8,2) NOT NULL , -> `min_stock_level` CHAR(10) NOT NULL , -> `Cartons_carton_barcode` CHAR(10) NOT NULL , -> PRIMARY KEY (`item_barcode`) , -> INDEX `fk_Products_Cartons1` (`Cartons_carton_barcode` ASC) , -> CONSTRAINT `fk_Products_Cartons1` -> FOREIGN KEY (`Cartons_carton_barcode` ) -> REFERENCES `mydb`.`Cartons` (`carton_barcode` ) -> ON DELETE NO ACTION -> ON UPDATE NO ACTION) -> ENGINE = InnoDB; No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> mysql> mysql> mysql> SET SQL_MODE=@OLD_SQL_MODE; No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr ice, min_stock_level) -> VALUES('11111','200 x packet straw flavoured choc chip', '10', '0.50', '1 00'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr ice, min_stock_level) -> VALUES('22223', '100 x packet Choc flavoured Bears', '50', '1.00', '50'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr ice, min_stock_level) -> VALUES('11113', '50 x bars Choc Mint flavoured Iceberg', '20', '2.00', '2 5'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr ice, min_stock_level) -> VALUES('33333', '200 x Minature Chocolate Eggs', '20', '0.50', '100') -> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr ice, min_stock_level) -> VALUES('44445', '100 x bars of Chocolate flavoured orange', '20', '0.70', '50'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr ice, min_stock_level) -> VALUES('33335', '50 x Chocolate covered Rice Snack bars', '15', '1.00', ' 25'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr ice, min_stock_level) -> VALUES('66666', '200 x Strawberry filled Wagon Wheels', '10', '0.50', '10 0'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr ice, min_stock_level) -> VALUES('55556', '100 x Caramel filled Choc Bars', '15', '0.60', '50'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Products(item_barcode, item_desc, item_on_shelves, selling_pr ice, min_stock_level) -> VALUES('26375', '50 x Packets Assorted Chocolate sweets', '10', '1.00', ' 25'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price) -> VALUES('23456', 'Large box Strawberry Choc chips', 'CU123', '15.00'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price) -> VALUES('12345', 'Standard box Chocolate Bears', 'CU122', '10.00' ); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price) -> VALUES('39765', 'Small box Chocolate Mint Icebergs', 'CU121', '5.00'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price) -> VALUES('20909', 'Large box Chocolate Eggs', 'CC234', '20.00'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price) -> VALUES('26667', 'Standard box Chocolate Orange', 'CC232', '15.00'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price) -> VALUES('88664','Small box Rice Snacks', 'CC222', '10.00'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price) -> VALUES('22331', 'Large box Wagon Wheels', 'CD456', '15.00'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price) -> VALUES('00778', 'Standard box Caramel Bars', 'CD455', '10.00'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO Cartons(carton_barcode, carton_desc, order_id, cost_price) -> VALUES('55121', 'Small box Assorted Chocolates', 'CD466', '5.00'); No connection. Trying to reconnect... ERROR 2017 (HY000): Can't open named pipe to host: . pipe: mysql (2) ERROR: Can't connect to the server mysql> INSERT INTO PurchaseOrders(order_id, order_No, order_delivery_date, order _date, quantity, cost_price, supp_id) -> VALUES('CU123', '1212', '2010-10-15', '2010-10-10', '15', '8.00', '123220 2' ); No connection. Trying to reconnect... -> The server will not allow me to input my password either, it just shuts down everytime I enter my password. And now my sql workbench has thrown a bug/exception- "object reference not set to an instance of an object. Please, please help!!! How to repeat: I DONT KNOW!!!!!