All pastes #247445 Raw Edit

Mine

public text v1 · immutable
#247445 ·published 2006-11-13 15:00 UTC
rendered paste body
mysql> insert into `NMS`.`graph_to_servers` (graph_id, server_id) values (25042,53);
ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation
mysql> show create table NMS.graph_to_servers;
+------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table            | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
+------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| graph_to_servers | CREATE TABLE `graph_to_servers` (
  `graph_id` int(10) unsigned NOT NULL,
  `server_id` int(11) NOT NULL,
  PRIMARY KEY  (`graph_id`,`server_id`),
  KEY `graph_id` (`graph_id`),
  KEY `server_id` (`server_id`),
  CONSTRAINT `graph_to_servers_ibfk_1` FOREIGN KEY (`graph_id`) REFERENCES `graph` (`graph_id`) ON DELETE CASCADE,
  CONSTRAINT `graph_to_servers_ibfk_2` FOREIGN KEY (`server_id`) REFERENCES `mynatnet`.`servers` (`asset_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>