<!-- wp:paragraph --> <p><code>show databases;</code></p> <!-- /wp:paragraph -->

<!-- wp:paragraph --> <p><code>use database_name;</code></p> <!-- /wp:paragraph -->

<!-- wp:paragraph --> <p><code>show tables;</code></p> <!-- /wp:paragraph -->

<!-- wp:paragraph --> <p>to view table fields</p> <!-- /wp:paragraph -->

<!-- wp:paragraph --> <p><code>desc wp_users;</code></p> <!-- /wp:paragraph -->

<!-- wp:paragraph --> <p>to get data from user_login field</p> <!-- /wp:paragraph -->

<!-- wp:paragraph --> <p><code>mysql&gt; select user_login<br>-&gt; from wp_users;</code></p> <!-- /wp:paragraph -->