Re: [webmin-l] MySQL add user problem

[Jamie C. <jca...@we...>]

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