Re: [webmin-l] MySQL add user problem

[Obantec S. <su...@ob...>]

----- Original Message ----- 
From: "Jamie Cameron" <jca...@we...>
To: "Webmin users list" <web...@li...>
Sent: Sunday, December 17, 2006 5:25 PM
Subject: Re: [webmin-l] MySQL add user problem


> On 17/Dec/2006 01:59 Obantec Support wrote ..
>> Hi
>>
>> webmin 1.310 on FC3
>>
>> i tried to add a user today using the same method i have for the last 100
>> DB's
>> now i cannot see the username so i tried to add same again and webmin 
>> said
>>
>> Failed to save user : SQL insert into user
>> (Host,User,Password,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Reload_priv,Shutdown_priv,Process_priv,File_priv,Grant_priv,References_priv,Index_priv,Alter_priv)
>> values ('', '', '', 
>> 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
>> failed : Duplicate entry '' for key 1
>>
>> from the insert string the Host User & Password seem empty. Yes i did put
>> values in the form.
>>
>> i cannot see the username looking at the mysql db direct or via 
>> phpMyadmin.
>
> Were you adding this user using the MySQL module, or the Virtualmin 
> module?
> I tried the MySQL module in Webmin 1.310 just now, and it added a user 
> with no problems.
>
> - Jamie
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> -
> Forwarded by the Webmin mailing list at 
> web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
>
>
MySQL module. i do have Vitualmin module installed but i don't use it.

found it! you are right i did not select the username option correctly.

Panic over on both posts.

Mark