MAGENTO: Updating Base URLs

update core_config_data set value = 'http://domainname/'
where path = 'web/unsecure/base_url';

update core_config_data set value = 'http://domainname/'
where path = 'web/secure/base_url';

MAGENTO: Disabling All Email Communications

• Login to Magento backend
• Go to the System->Configuration menu.
• On the left hand menu under the Advanced tab (at the bottom) select the System menu item.
• Select ‘Mail Sending Settings’ from the selection on the right hand side.
• Set Disable email communications to ‘Yes’, then no email will send through Magento.

MAGENTO: Creating an Admin User

ADMIN USER:
insert into admin_user
select
(select max(user_id) + 1 from admin_user) user_id,
'FIRSTNAME' first_name,
'LASTNAME' last_name,
'TEST@EMAIL.COM' email,
'USERNAME' username,
MD5('PASSWORD') password,
now() created,
NULL modified,
NULL logdate,
0 lognum,
0 reload_acl_flag,
1 is_active,
(select max(extra) from admin_user where extra is not null) extra,
NULL,
NULL;

ADMIN ROLE:
insert into admin_role
select
(select max(role_id) + 1 from admin_role) role_id,
(select role_id from admin_role where role_name = 'Administrators') 
parent_id, 2 tree_level, 0 sort_order, 'U' role_type,
(select user_id from admin_user where username = 'USERNAME') user_id,
'USERNAME' role_name;