i'm having problem when add a new user... this were the error show when i try to create a new user...

mysql> use mysql
Database changed
mysql> INSERT INTO user
-> (host, user, password,
-> select_priv, insert_priv, update_priv )
-> VALUES
-> ('localhost', 'someone', PASSWORD('123'),
-> 'Y','Y','Y');
ERROR 1064 (HY000): Field 'ssl_cipher' doesn't have a default value

pls help me... thanx...

Did you copy that error correctly?

Error 1064 is a syntax error.
Error 1230 is the error that produces the message you printed (Field 'ssl_cipher' doesn't have a default value)

Is there a 'ssl_cipher' field in your user table that is set NOT NULL?

this is what i have typed in the mySQL... the output that i gave when creating a user is correct... exactly the same output as shown... plz help me...

DROP DATABASE inventory;
CREATE DATABASE inventory;
CONNECT inventory;

CREATE TABLE `equipment` (
`equipment_id` int(10) unsigned NOT NULL auto_increment,
`create_date` datetime default NULL,
`edit_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`user_id` int(10) unsigned default NULL,
`asset_tag` varchar(15) NOT NULL default '',
`make` varchar(50) NOT NULL default '',
`model` varchar(50) NOT NULL default '',
`type` smallint(5) unsigned default NULL,
`description` varchar(50) default NULL,
`serial_number` varchar(50) NOT NULL default '',
`mac1` varchar(17) default NULL,
`mac2` varchar(17) default NULL,
`mac3` varchar(17) default NULL,
`mac4` varchar(17) default NULL,
`ip_address` varchar(16) default NULL,
`os` varchar(50) default NULL,
PRIMARY KEY (`equipment_id`),
KEY `user_id` (`user_id`),
KEY `asset_tag` (`asset_tag`),
KEY `serial_number` (`serial_number`)
) ENGINE=InnoDB;

CREATE TABLE `login` (
`login_id` int(10) unsigned NOT NULL auto_increment,
`login_name` varchar(20) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`permission` smallint(5) unsigned default NULL,
`change_passwd` enum('','on') NOT NULL default '',
`disable` enum('','on') NOT NULL default '',
`lastlogin` datetime default NULL,
PRIMARY KEY (`login_id`),
KEY `login_name` (`login_name`)
) ENGINE=InnoDB;

CREATE TABLE `permission` (
`permission_id` int(10) unsigned NOT NULL auto_increment,
`display` varchar(50) NOT NULL default '',
`url` varchar(75) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`2` enum('','on') NOT NULL default '',
`1` enum('','on') NOT NULL default '',
`0` enum('','on') NOT NULL default '',
PRIMARY KEY (`permission_id`)
) ENGINE=InnoDB;

CREATE TABLE `sessid` (
`sessid_id` bigint(20) unsigned NOT NULL auto_increment,
`sessid` varchar(32) NOT NULL default '',
`userid` varchar(20) NOT NULL default '',
`permission` smallint(5) unsigned default NULL,
`timel` int(10) unsigned default NULL,
`timeu` int(10) unsigned default NULL,
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`sessid_id`),
KEY `sessid` (`sessid`)
) ENGINE=InnoDB;

CREATE TABLE `software` (
`software_id` int(10) unsigned NOT NULL auto_increment,
`software_list_id` int(10) unsigned default NULL,
`license` varchar(60) NOT NULL default '',
PRIMARY KEY (`software_id`),
KEY `software_list_id` (`software_list_id`)
) ENGINE=InnoDB;

CREATE TABLE `software_assigned` (
`software_assigned_id` int(10) unsigned NOT NULL auto_increment,
`software_list_id` int(10) unsigned default NULL,
`equipment_id` int(10) unsigned default NULL,
PRIMARY KEY (`software_assigned_id`),
KEY `software_list_id` (`software_list_id`),
KEY `equipment_id` (`equipment_id`)
) ENGINE=InnoDB;

CREATE TABLE `software_list` (
`software_list_id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`version` varchar(20) NOT NULL default '',
PRIMARY KEY (`software_list_id`)
) ENGINE=InnoDB;

CREATE TABLE `support` (
`support_id` int(10) unsigned NOT NULL auto_increment,
`support_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`equipment_id` int(10) unsigned default NULL,
`login_id` int(10) unsigned default NULL,
`support_text` text NOT NULL,
PRIMARY KEY (`support_id`),
KEY `equipment_id` (`equipment_id`)
) ENGINE=InnoDB;

CREATE TABLE `type` (
`type_id` smallint(5) unsigned NOT NULL auto_increment,
`type` varchar(30) NOT NULL default '',
`list` enum('','on') NOT NULL default '',
PRIMARY KEY (`type_id`)
) ENGINE=InnoDB;

CREATE TABLE `user` (
`user_id` int(10) unsigned NOT NULL auto_increment,
`first_name` varchar(50) NOT NULL default '',
`last_name` varchar(50) NOT NULL default '',
`title` varchar(50) default NULL,
`department` varchar(50) default NULL,
`street` varchar(50) default NULL,
`city` varchar(50) default NULL,
`state` char(2) default NULL,
`zip` varchar(5) default NULL,
`phone` varchar(13) NOT NULL default '',
`cell` varchar(13) default NULL,
`pager` varchar(13) default NULL,
`terminate` enum('','on') NOT NULL default '',
PRIMARY KEY (`user_id`),
KEY `first_name` (`first_name`),
KEY `last_name` (`last_name`)
) ENGINE=InnoDB;

INSERT INTO `permission` VALUES (1, 'Administration', 'administrator.php', 'administration', 'on', '', '');
INSERT INTO `permission` VALUES (2, 'Add an Asset', 'add.php', 'addasset', 'on', 'on', '');
INSERT INTO `permission` VALUES (3, 'Software', 'software.php', 'software', 'on', 'on', '');
INSERT INTO `permission` VALUES (4, 'Add Employee', 'user.php', 'user', 'on', 'on', '');
INSERT INTO `permission` VALUES (5, 'Search Assets', 'search.php', 'search', 'on', 'on', 'on');
INSERT INTO `permission` VALUES (6, 'Logout', 'logout.php', 'logout', 'on', 'on', 'on');
INSERT INTO `login` VALUES (NULL, 'root', '5f4dcc3b5aa765d61d8327deb882cf99', 'root', 2, 'on', '', NULL);