How to Access MySQL Database

Link: https://support.brilliantdirectories.com/support/solutions/articles/12000082920

How to Access the MySQL Database

This article explains how to access the MySQL database through the Developer Hub and identifies the primary table used to store member information.

Important

Changes made directly to the database are permanent in most cases. Before executing any SQL statement, create a complete database backup and verify that the query targets the intended records.

Access the Database

  1. Navigate to Developer Hub.

  2. Select MySQL Database Manager.

  1. Select the site_directory database from the left navigation panel.

  1. Locate the list of database tables and select the users_data table.

The users_data table stores the primary member records, including account information, profile details, and membership settings.

Once the users_data table is selected, the database is ready for browsing records or executing SQL queries using the available database management tools.

Run a Read-Only Query

To look up records without changing anything, run a SELECT query from the SQL tab:

  1. In the left navigation panel, select the database whose name ends in _directory.

  2. Open the SQL tab at the top of the page.

  3. Paste the query into the box.

  4. Click Go. phpMyAdmin then shows the matching rows.

phpMyAdmin: select the _directory database, open the SQL tab, paste the query and click Go

A query that starts with SELECT only reads data. Queries that start with UPDATE, DELETE or INSERT change records, so take a backup first, as noted above.