its a very dirty (!) way to add a new user, but i think it should work ...
Step 1:
Code:
INSERT INTO `shinken`.`users` (`id`, `realname`, `email`, `username`, `password_algo`, `password`, `logins`, `last_login`) VALUES (NULL, 'Real Name', 'real.name@domain.tld', 'user', 'b64_sha1', 'W6ph5Mm5Pz8GgiULbPgzG37mj9g=', '0', NULL);
W6ph5Mm5Pz8GgiULbPgzG37mj9g= = password (sha1 base64)
Step 2:
Code:
INSERT INTO `shinken`.`ninja_user_authorization` (`id`, `user_id`, `system_information`, `configuration_information`, `system_commands`, `all_services`, `all_hosts`, `all_service_commands`, `all_host_commands`) VALUES (NULL, '2', '1', '1', '1', '1', '1', '1', '1');
You must insert the correct user id in step 2
Please note: All sql statements are untested ....