Creating an administrator Account in OpenX from MySQL

Creating an admin from the admin panel isn’t a hard task. But what do you do if you don’t have access to the admin panel, but you do have access to the mysql database?

OpenX has several kinds of users:

1. ADMIN
2. MANAGER
3. ADVERTISER
4. TRAFFICKER

The id values in the accounts table correspond to the number in the list.

Users are stored in the users table. Also keep in mind that the password is hashed with md5

Based on all of the above, the mysql query for creating a user looks like this:

insert into users (contact_name,email_address,username,password,language,default_account_id,active)
values ('User Name', '[email protected]', 'userlogin', md5('password'), 'en', 1, 1);

Don’t forget that the mysql database might use a prefix for its tables.