Unable to create/update dataabse user

Help! (Home for newbies)
1

Dear Community,

I’m stuck at kimai (time tracker) installation, which requires a new database user to complete installation (actually not, but an embedded framework doesn’t like the password I’ve set for main user, so I prefer to create a new one).

What I’ve done so far:

  • Created a new subdomain to install kimai: time.mydomain.com -> OK, database “time” created
  • Logged in on webmin as main user, selected System > Users & Groups, created “newuser”
  • Selected Servers > mySQL server > User permissions: newuser apperas to have no permission.
  • Selected “newuser”, selected all permissions in the drop-down list and clicked on Save.
  • Got the error message “Unable to update user: SQL update user set host = ?, user = ?, 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 = ?, Show_db_priv = ?, Super_priv = ?, Create_tmp_table_priv = ?, Lock_tables_priv = ?, Execute_priv = ?, Repl_slave_priv = ?, Repl_client_priv = ?, Create_view_priv = ?, Show_view_priv = ?, Create_routine_priv = ?, Alter_routine_priv = ?, Create_user_priv = ?, Event_priv = ?, Trigger_priv = ?, Create_tablespace_priv = ?, Delete_history_priv = ? where host = ? and user = ? missed: Column ‘Select_priv’ is not updatable”

I can’t understand what happens here… :cry: I just want to create a user who would have all rights on the database “time”. What’s the right way to do this?

Thanks a lot for any help!

2

Hi,

  • Logged in on webmin as main user, selected System > Users & Groups, created “newuser”
  • Selected Servers > mySQL server > User permissions: newuser apperas to have no permission.

This is impossible as creating a system user has nothing to do with db users.

Selected “newuser”, selected all permissions in the drop-down list and clicked on Save.

You could simply go to Database Permissions and assign that new user permissions to only specific dbs.

Example:

image
image1198×506 33.4 KB

Got the error message “Unable to update user: SQL update user set host …

Try using ALTER user instead in your prepared statement.

3

Hi Ilia, thanks for the quick answer!

Where can I find this option (Edit Database Permissions): Webmin or Virtualmin? I could’nt find it in any area…

Regarding the ALTER command, please note that I have no choice on the command sent by the tool, just clicked on the Save button…

Thanks again for your help!