Demo Codes

Well, this post is all about resetting the lost password of sugar CRM.by the way,Sugar CRM is a great Open source software for project management,employees management and the CRM.

Well, not talking too much ,let me straightly tell you the process.

Suppose you have forgot the password for your username ‘demouser’

1.Login to PHPMyAdmin/mysql console.

2.Select the Sugar CRM ’s daabase ,in my case it was named sugarcrm so i selected sugarcrm.

to select the database in PhpMyAdmin ,simply select it from left sidebar dropdown box.

in case of mysql console use the following query

-> use sugar_db_name

where -> denotes mysql prompt(i am assuming) and the sugar_db_name is the name of the database where you have installed the sugar crm.

3.Now you are almost half done.Just one more step.

suppose you have to reset password for the user having username “demouser”

so execute the following query.

update users set user_hash=md5(’password’) where user_name=’demouser’;

this will reset the demouser’s password to “password”

Now suppose i forgot the password of admin account,so what i need to do.Well i am showing you to reset the password of admin to the text “testadminpassword”

use the following query

update users set user_hash=md5(’testadminpassword’) where user_name=’admin’;

Process analysis in detail

As sugar CRM stores its password as md5 32 character hash,we have simply updated that value.The field user_hash in the user’s table signifies the password of user.

Wow,Congratulations, you have successfully reset your password.[:)]

For the last one year we have been doing development of templates,plugins for wordpress.I Love the features/api provided by the wordpress for the developers.It is really very easy to develop skins for the wordpress.It is like a breeze that touches you and makes you smile.You may look at the wordpress codex pages for the help. There are still too many hopes from the wordpress community about the features regarding the spamming and others,let us see how much they can do for us [:)]

Hi,it’s a nice experience to be here and talking with the world.Blogging is it self a great thing ,a great experience,and now i will be also delving into the experience.I have been a regular blogger on wordpress and google’s e-blogger.For the last one year ,i have been developing the themes and plug ins for wordpress.I always find it very interesting to develop the themes for wordpress.Now the template tags have become a part of my tech vocabulary [:D].

Uff, i am trying to blog on my own site now.Don’t know whether i will be able to fetch the traffic or not.Anyway, i am an optimist,and so hope to enjoy this journey as ever.

brajesh