vTiger's admin username can be easily changed with a simple MySQL query. The most convenient way to manage the database is through the phpMyAdmin tool. Go to your cPanel and click on phpMyAdmin in the Databases box. (If you are not using cPanel or do not have phpMyAdmin, you can run the query directly for vTiger's database.)
Once in phpMyAdmin, select the vTiger database from the drop-down menu on the left. The page will refresh and the database tables will be displayed. Open the SQL tab (look at the top navigation bar).
In the text field write the following query:
1
|
UPDATE vtiger_users SET user_password='adpexzg3FUZAk',crypt_type=''WHERE id=1;
|
This query will reset the password for the administrative username with ID 1. In most cases this is your admin user. The password will be set to admin.
Once you are ready, click on the GO button to submit the query. If everything goes fine without errors, you should be able to log into vTiger with the new password.
You need help with an application? hostlantern is specialized in hosting and supporting more than 200 scripts. Sign up for our web hosting services and let us help you with your application, 24/7!