I have just installed Joomla as a Web App on Azure by selecting it from the gallery. When I tried to log in to the back end I was told the user didn't exist, despite having given the username and password as part of the set-up process. To double-check I logged into the ClearDB MySQL database using MySQL Workbench and checked the
database.jos_users table where I assumed (I'm a total Joomla newbie if you hadn't guessed) the user data would be. There are no rows in the table. Can I add an admin user by directly adding data into this table? If I can, what would the SQL for that be?
Or should I just delete the entire installation and try again making the admin username "admin" instead of trying to be clever and putting something non-obvious as the username as I did this time?