Magento Cheat Sheet, how to add a magento admin user, directly thorugh SQL Thanks to Atwix, i found the SQL which is needed to create a magento admin user. Cheat sheet for me: SET @fistname = 'Fabian'; SET @lastname = 'Blechschmidt'; SET @email = 'mailaddress@example.com'; SET @username = 'fabian'; SET @password = 'password';