MySQL Forums
Forum List  »  Newbie

Can't seem to create a new user account
Posted by: David Schwartz
Date: February 24, 2009 12:07AM

I'm trying to create a new user account. I've tried several ways but they don't seem to work.

1) CREATE USER 'mensch' IDENTIFIED BY 'justice';
>>ERROR 1396 (HY000): Operation CREATE USER failed for 'mensch'@'%'

2) CREATE USER 'mensch'@'localhost' IDENTIFIED BY 'justice';
>> ERROR 1396 (HY000): Operation CREATE USER failed for 'mensch'@'localhost'

3) INSERT INTO user (Host,User,Password) VALUES('localhost','mensch',PASSWORD('justice'));
>>ERROR 1146 (42S02): Table 'jcc.user' doesn't exist

It appears that there is no user table but there is a users table so I tried the following:

4) INSERT INTO users (Host,User,Password) VALUES('localhost','mensch',PASSWORD('justice'));
>>ERROR 1054 (42S22): Unknown column 'Host' in 'field list'

Here's what the users table looks like:

mysql> describe jcc.users;
+-----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+----------------+
| uid | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(60) | NO | UNI | | |
| pass | varchar(32) | NO | | | |
| mail | varchar(64) | YES | MUL | | |
| mode | tinyint(4) | NO | | 0 | |
| sort | tinyint(4) | YES | | 0 | |
| threshold | tinyint(4) | YES | | 0 | |
| theme | varchar(255) | NO | | | |
| signature | varchar(255) | NO | | | |
| created | int(11) | NO | MUL | 0 | |
| access | int(11) | NO | MUL | 0 | |
| login | int(11) | NO | | 0 | |
| status | tinyint(4) | NO | | 0 | |
| timezone | varchar(8) | YES | | NULL | |
| language | varchar(12) | NO | | | |
| picture | varchar(255) | NO | | | |
| init | varchar(64) | YES | | | |
| data | longtext | YES | | NULL | |
+-----------+------------------+------+-----+---------+----------------+

Any ideas about what might be going on would be greatly appreciated!

TIA,
David

Options: ReplyQuote


Subject
Written By
Posted
Can't seem to create a new user account
February 24, 2009 12:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.