mysql 제로보드 패스워드 초기화

* DB 로 접속합니다.

#   mysql -uroot -proot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1885 to server version: 5.0.26

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

mysql>



* databases 확인

mysql> show databases ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| db_zb4             |
| db_zb5             |
| mysql              |
| test               |
+--------------------+
5 rows in set (0.07 sec)

mysql>



* 제로보드5 설치 database 접속

mysql> use db_zb5 ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql>



* 테이블 확인

mysql> show tables ;
+--------------------------+
| Tables_in_db_bbs2        |
+--------------------------+
| zb_analytics             |
| zb_articles              |
| zb_comment               |
| zb_file                  |
| zb_layout_manager        |
| zb_member_level          |
| zb_member_level_manager  |
| zb_member_list           |
| zb_member_mail           |
| zb_member_signup_manager |
| zb_menu_manager          |
| zb_menu_tree             |
| zb_message               |
| zb_module_category       |
| zb_module_manager        |
| zb_page_category         |
| zb_page_manager          |
| zb_page_plugin           |
| zb_plugin_category       |
| zb_plugin_manager        |
| zb_referer_query         |
| zb_report_log            |
| zb_search_keyword        |
| zb_sequence              |
| zb_serial                |
| zb_server_manager        |
| zb_session               |
| zb_session_autologin     |
| zb_site_manager          |
| zb_site_message          |
| zb_survey                |
| zb_survey_item           |
| zb_survey_log            |
| zb_tag                   |
| zb_trackback             |
+--------------------------+
35 rows in set (0.00 sec)

mysql>



*  패스워드를 갖고 있는 zb_member_list 테이블 구조 확인 (Describe)

mysql> desc zb_member_list ;
+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| member_srl      | int(11)      | NO   | PRI |         |       |
| listorder       | int(11)      | NO   | MUL |         |       |
| user_id         | varchar(20)  | NO   | UNI |         |       |
| passwd          | varchar(60)  | NO   |     |         |       |
| user_name       | varchar(20)  | NO   |     |         |       |
| nick_name       | varchar(20)  | NO   | UNI |         |       |
| email_address   | varchar(255) | NO   | UNI |         |       |
| email           | varchar(255) | NO   |     |         |       |
| email_host      | varchar(255) | NO   | MUL |         |       |
| extend_val      | text         | YES  |     | NULL    |       |
| new_message     | int(11)      | NO   |     |         |       |
| point           | int(11)      | NO   |     |         |       |
| allowed         | varchar(2)   | NO   |     | N       |       |
| denied          | varchar(2)   | NO   |     | N       |       |
| mailing         | varchar(2)   | NO   | MUL | N       |       |
| manager_message | text         | NO   |     |         |       |
| regdate         | varchar(14)  | NO   | MUL |         |       |
| last_signin     | varchar(14)  | NO   |     |         |       |
| image_nick      | varchar(255) | NO   |     |         |       |
| image_mark      | varchar(255) | NO   |     |         |       |
| profile_image   | varchar(255) | NO   |     |         |       |
| sign            | text         | NO   |     |         |       |
+-----------------+--------------+------+-----+---------+-------+
22 rows in set (0.02 sec)

mysql>



* admin 계정 관련 기본 정보 확인 (select)

mysql> select user_id, passwd, user_name from zb_member_list ;
+---------+----------------------------------+-----------+
| user_id | passwd                           | user_name |
+---------+----------------------------------+-----------+
| admin   | 890sdfsdfd78fsdfsd89sdf1234mmcaq | admin     |
+---------+----------------------------------+-----------+
1 row in set (0.00 sec)



* admin 계정 패스워드 변경 (초기화) 하기

mysql> update zb_member_list set passwd='21232f297a57a5a743894a0e4a801fc3' where user_id='admin' ;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0


위와 같이 패스워드 값을 변경 (초기화) 하면 admin / admin 으로 로그인 할수 있습니다.


(참고로 패스워드 값을 '81dc9bdb52d04dc20036dbd8313ed055' 로 update 하면  admin 패스워드를 1234 로 변경할 수 있습니다.......)




마지막으로 웹 관리자 페이지로 접속하여 패스워드 변경후 사용하시면 됩니다....... 

http://www.wowunix.com/cgi-bin/CrazyWWWBoard.cgi?mode=read&num=22&db=zeroboard&backdepth=1