wordpressのバックエンドでは、mysqlが動いてる。
中身ののぞき方的な感じの備忘録的な。
mysqlへのログイン
root@HYPERION:~# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 632 Server version: 5.5.55-0ubuntu0.14.04.1 (Ubuntu) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
データベース一覧
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | wordpressdb | +--------------------+ 4 rows in set (0.00 sec)
データベース選択
mysql> use wordpressdb; 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> show tables; +---------------------------+ | Tables_in_wordpressdb | +---------------------------+ | wp_ahm_download_stats | | wp_ahm_emails | | wp_commentmeta | | wp_comments | | wp_cpd_counter | | wp_links | | wp_media_file_manager_log | | wp_options | | wp_postmeta | | wp_posts | | wp_term_relationships | | wp_term_taxonomy | | wp_termmeta | | wp_terms | | wp_usermeta | | wp_users | | wp_wfu_dbxqueue | | wp_wfu_log | | wp_wfu_userdata | | wp_wpbackitup_job_control | | wp_wpbackitup_job_items | | wp_wpbackitup_job_tasks | +---------------------------+ 22 rows in set (0.00 sec)
カラム一覧
mysql> show columns from wp_terms; +------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------------+------+-----+---------+----------------+ | term_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(200) | NO | MUL | | | | slug | varchar(200) | NO | MUL | | | | term_group | bigint(10) | NO | | 0 | | +------------+---------------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec)
テーマ一覧
mysql> select * from wp_terms; +---------+---------------------------+--------------------------------------------------------------------------+------------+ | term_id | name | slug | term_group | +---------+---------------------------+--------------------------------------------------------------------------+------------+ | 1 | 未分類 | %e6%9c%aa%e5%88%86%e9%a1%9e | 0 | | 2 | Windows | windows | 0 | | 3 | コマンド | %e3%82%b3%e3%83%9e%e3%83%b3%e3%83%89 | 0 | | 4 | Active Directory | active-directory | 0 | | 5 | Windows 10 | windows-10 | 0 | | 6 | VMware | vmware | 0 | | 7 | 資格 | %e8%b3%87%e6%a0%bc | 0 | | 8 | Linux | linux | 0 | | 9 | バッチファイル | %e3%83%90%e3%83%83%e3%83%81%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab | 0 | | 10 | バッチファイル | %e3%83%90%e3%83%83%e3%83%81%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab-windows | 0 | | 11 | post-format-image | post-format-image | 0 | | 12 | 正規表現 | %e6%ad%a3%e8%a6%8f%e8%a1%a8%e7%8f%be | 0 | | 13 | 正規表現 | %e6%ad%a3%e8%a6%8f%e8%a1%a8%e7%8f%be | 0 | | 14 | Hyper-V | hyper-v | 0 | | 15 | zabbix | zabbix | 0 | | 16 | フリーツール | %e3%83%95%e3%83%aa%e3%83%bc%e3%83%84%e3%83%bc%e3%83%ab | 0 | | 17 | Powershell | powershell | 0 | | 18 | Powershell | powershell-windows | 0 | | 19 | EXCEL | excel | 0 | | 20 | VBA | vba | 0 | | 21 | Firefox | firefox | 0 | | 22 | グループポリシー | %e3%82%b0%e3%83%ab%e3%83%bc%e3%83%97%e3%83%9d%e3%83%aa%e3%82%b7%e3%83%bc | 0 | | 23 | グループポリシー | %e3%82%b0%e3%83%ab%e3%83%bc%e3%83%97%e3%83%9d%e3%83%aa%e3%82%b7%e3%83%bc | 0 | | 24 | WordPress | wordpress | 0 | | 25 | Internet Explorer | internet-explorer | 0 | | 26 | レジストリ | %e3%83%ac%e3%82%b8%e3%82%b9%e3%83%88%e3%83%aa | 0 | | 27 | PS3 | ps3 | 0 | | 28 | OwnCloud | owncloud | 0 | | 29 | Apache | apache | 0 | | 30 | vim | vim | 0 | | 31 | vi | vi | 0 | | 32 | Teraterm | teraterm | 0 | | 33 | ESXi | esxi | 0 | | 34 | Ubuntu | ubuntu | 0 | | 35 | Vyos | vyos | 0 | | 36 | WinShot | winshot | 0 | | 37 | Skype for Business Server | skype-for-business-server | 0 | | 38 | GPD Pocket | gpd-pocket | 0 | | 39 | プリンタ | %e3%83%97%e3%83%aa%e3%83%b3%e3%82%bf | 0 | | 40 | SQL | sql | 0 | +---------+---------------------------+--------------------------------------------------------------------------+------------+ 40 rows in set (0.00 sec)