Changing Database-user password after installation

Hi all, I would like to know if there is any way to change the Databse-user after the installation? I forgot to change it in setp 3 of http://localhost/otrs/installer.pl Thank you. Best Regards

Hi, Miguel. Try looking in Kernel/Config.pm # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{DatabasePw} = ''; Michael. Miguel Dias wrote:
Hi all, I would like to know if there is any way to change the Databse-user after the installation? I forgot to change it in setp 3 of
http://localhost/otrs/installer.pl
Thank you. Best Regards ------------------------------------------------------------------------
_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/

Hello, Michael
And if I just do that i won't lose the database connection? The database is
created and with the default password.
Thank you
2008/4/4, Michael Teo
Hi, Miguel. Try looking in Kernel/Config.pm
# (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{DatabasePw} = '';
Michael.
Miguel Dias wrote:
Hi all, I would like to know if there is any way to change the Databse-user after the installation? I forgot to change it in setp 3 of
http://localhost/otrs/installer.pl
Thank you. Best Regards ------------------------------------------------------------------------
_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/
_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/

Hi, Miguel. Yes, you need to update the new password in your mysql database as well. You can login to your mysql database and try executing the following: mysql> UPDATE mysql.user SET Password=PASSWORD('/|newpass|/') WHERE User='otrs'; mysql> FLUSH PRIVILEGES; Michael. Miguel Dias wrote:
Hello, Michael And if I just do that i won't lose the database connection? The database is created and with the default password. Thank you
2008/4/4, Michael Teo
mailto:otrs.org@miketeo.net>: Hi, Miguel. Try looking in Kernel/Config.pm
# (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{DatabasePw} = '';
Michael.
Miguel Dias wrote:
Hi all, I would like to know if there is any way to change the Databse-user after the installation? I forgot to change it in setp 3 of
http://localhost/otrs/installer.pl
Thank you. Best Regards ------------------------------------------------------------------------

Thank you,
I do it from a different way and more simple I thing so I will share with
you
go to /etc or /bin [mysql dir] and type
mysqladmin -u your_username -p password the_new_password
after that do what Michael (Great Help) told
Try looking in Kernel/Config.pm
# (The password of database user. You also can use
bin/CryptPassword.pl
# for crypted passwords.)
$Self->{DatabasePw} = '';
Best Regards
2008/4/4, Michael Teo
Hi, Miguel. Yes, you need to update the new password in your mysql database as well.
You can login to your mysql database and try executing the following:
mysql> UPDATE mysql.user SET Password=PASSWORD('/|newpass|/') WHERE User='otrs'; mysql> FLUSH PRIVILEGES;
Michael.
Miguel Dias wrote:
Hello, Michael And if I just do that i won't lose the database connection? The database is created and with the default password. Thank you
2008/4/4, Michael Teo
:
Hi, Miguel. Try looking in Kernel/Config.pm
# (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{DatabasePw} = '';
Michael.
Miguel Dias wrote:
Hi all, I would like to know if there is any way to change the Databse-user after the installation? I forgot to change it in setp 3 of
http://localhost/otrs/installer.pl
Thank you. Best Regards
------------------------------------------------------------------------
_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/
participants (2)
-
Michael Teo
-
Miguel Dias