MySQL Forums :: Newbie :: Can't seem to create a new user account


Advanced Search

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 David Schwartz 02/24/2009 12:07AM
Re: Can't seem to create a new user account Vinod Sugur 02/24/2009 01:25AM
Re: Can't seem to create a new user account David Schwartz 02/25/2009 12:12AM
Re: Can't seem to create a new user account Rick James 02/25/2009 09:59PM


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.