Á¦·Îº¸µå(XE : XpressEngine) ÀÚ·á½Ç



Vote Reply Modify Delete Forward Prev Next List

  ÀÛ¼ºÀÚ   : Á¶¼ºÈ¯ [ gadmin ] Ãßõ: 2340, Á¶È¸: 8396, ÁÙ¼ö: 158, ºÐ·ù: Etc.
Á¦·Îº¸µå5(zb5) °ü¸®ÀÚ °èÁ¤ÀÎ admin ÆÐ½º¿öµå º¯°æ ¹× ÃʱâÈ­ Çϱâ(°­Ãß)

* 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 ·Î º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù.......)




¸¶Áö¸·À¸·Î À¥ °ü¸®ÀÚ ÆäÀÌÁö·Î Á¢¼ÓÇÏ¿© ÆÐ½º¿öµå º¯°æÈÄ »ç¿ëÇÏ½Ã¸é µË´Ï´Ù.......


ÀÌÀü: ȨÆäÀÌÁö ·Î°í À§Ä¡ ¼öÁ¤ÇÏ´Â ¹æ¹ý(layoutÀÇ css ÆÄÀÏ º¯°æ)
´ÙÀ½: Á¦·Îº¸µå default Á¢¼Ó ·Î±×ÀÎ ½Ã°£(30ºÐ) º¯°æÇϱâ
2009/06/06(04:33) from 59.30.129.71
CrazyWWWBoard 2000

Vote Reply Modify Delete Forward Prev Next List

(c) Nobreak Technologies, Inc.