mysql> SELECT * FROM ofUser WHERE username='admin'; +----------+---------------+-------------------+---------------+---------------+-----------------+------------------+ | username | plainPassword | encryptedPassword | name | email | creationDate | modificationDate | +----------+---------------+-------------------+---------------+---------------+-----------------+------------------+ | admin | NULL | df8d8aa53e956defc | Administrator | admin@com.com | 001248259155800 | 0 | +----------+---------------+-------------------+---------------+---------------+-----------------+------------------+ 1 row in set (0.00 sec) mysql> _
Мы видим, что пароль есть и он зашифрован. Меняем шифрованный пароль на открытый.
mysql> UPDATE ofUser SET plainPassword='newpass', encryptedPassword=NULL WHERE username='admin'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> SELECT * FROM ofUser WHERE username='admin'; +----------+---------------+-------------------+---------------+---------------+-----------------+------------------+ | username | plainPassword | encryptedPassword | name | email | creationDate | modificationDate | +----------+---------------+-------------------+---------------+---------------+-----------------+------------------+ | admin | newpass | NULL | Administrator | admin@com.com | 001248259155800 | 0 | +----------+---------------+-------------------+---------------+---------------+-----------------+------------------+ 1 row in set (0.00 sec) mysql> _
Теперь у нас есть доступ в админку джаббер-сервера.
Свежие комментарии