Richard Petty wrote:
<snip>
I reset the 'otrs' database password:
1. Used bin/CryptPassword.pl with a password of 'otrs'
2. Pasted the result, '09b8d8c8, into the otrs password field in MySQL
3. Setup entry in Config.pm to: $Self->{DatabasePw} = 'otrs';
Not sure what the CryptPassword.pl script is for, but that is not how
you change a password in mysql. At least not how I have always done it.
You can change the password using the command line mysql client like this:
Log in to mysql:
mysql -u root -p
Enter the root password when prompted.
Now issue the commands:
mysql> SET PASSWORD FOR 'otrs'@'localhost' = PASSWORD('otrs');
You can also edit the password field directly like you said you did
above. In that case, you still use the mysql PASSWORD() function to set
the password. After manually editing the password field like that, you
should issue a 'flush privileges' command to mysql.
S/
Matt M.
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
