ÀÛ¼ºÀÚ :
Á¶¼ºÈ¯ [ 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 ·Î º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù.......)
¸¶Áö¸·À¸·Î À¥ °ü¸®ÀÚ ÆäÀÌÁö·Î Á¢¼ÓÇÏ¿© ÆÐ½º¿öµå º¯°æÈÄ »ç¿ëÇÏ½Ã¸é µË´Ï´Ù.......
|
|
|
|