Inicio > MySQL, OTRS > Lost root password of OTRS

Lost root password of OTRS

Check the password for the database user in Kernel/Config.pm. If you don’t know the database password for the database otrs user (any more), set it new:

shell> mysql -u root -p
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 3.23.48-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON otrs.* TO otrs@localhost IDENTIFIED BY "yourpw" WITH GRANT OPTION;
mysql>

Reset of the OTRS root password:

mysql> UPDATE system_user SET pw='roK20XGbWEsSM' where login='root@localhost';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql>

And the password of user ‘root@localhost’ will be ‘root’. The password is crypted like ‘man 3 crypt’ with crypt().

Fuente: http://doc.otrs.org/1.3/en/html/problems-with-mysql.html

Categorías:MySQL, OTRS Etiquetas: ,
  1. anonymous
    21 junio 2010 a las 3:36 PM

    shell:~ # mysql -u root -p otrs
    mysql> UPDATE users SET pw=’roK20XGbWEsSM’ where login=’root@localhost’;

    Another option for to modify root password to default one.

  2. 22 junio 2010 a las 7:12 AM

    Nice, but what do you think of:

    mike@rainbows:/opt/otrs$ bin/otrs.setPassword root@localhost root


    Mike.

  3. anonymous
    25 junio 2010 a las 1:38 AM

    Mike

    It could be a solution, is very possible, but personally i wasn’t try from that way. If you try do it and you have a success result, tell us your experience.

    Thanks for comment!

    Regards

  1. No trackbacks yet.

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s

A %d blogueros les gusta esto: