Database

Operation with Database

As nbh.se built on top of WordPress, which used MySQL as the standard database

mysql  Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

Login MySQL with credentials, the root login has been disabled for security reasons.

mysql -u nbhse -p

Then type the command with the database

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| nbhse              |
+--------------------+
2 rows in set (0.01 sec)

mysql> show tables;
+------------------------------+
| Tables_in_nbhse              |
+------------------------------+
| wp_actionscheduler_actions   |
| wp_actionscheduler_claims    |
| wp_actionscheduler_groups    |
| wp_actionscheduler_logs      |
| wp_commentmeta               |
| wp_comments                  |
| wp_defender_lockout          |
| wp_defender_lockout_log      |
| wp_et_bloom_stats            |
| wp_et_social_stats           |
| wp_links                     |
| wp_options                   |
| wp_postmeta                  |
| wp_posts                     |
| wp_smush_dir_images          |
| wp_term_relationships        |
| wp_term_taxonomy             |
| wp_termmeta                  |
| wp_terms                     |
| wp_usermeta                  |
| wp_users                     |
| wp_wpforms_tasks_meta        |
| wp_wpmailsmtp_tasks_meta     |
| wp_yoast_indexable           |
| wp_yoast_indexable_hierarchy |
| wp_yoast_migrations          |
| wp_yoast_primary_term        |
| wp_yoast_seo_links           |
| wp_yoast_seo_meta            |
+------------------------------+
29 rows in set (0.00 sec)