Where and how does this create Wordpress MySQL DBs?

What issue or error are you experiencing?

Can’t seem to understand the privileges that Local sets up when installing a fresh Wordpress. The database name is always “local”? If I have many WP on my localhost, will all the DBs be called “local”?

What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

None - see question

System Details

  • Local Version:
    Latest 8.3.1+6550

  • Operating System (OS) and OS version:
    Mac OSX latest with all security updates

Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)
Not needed

Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

To be more precise - I can see the “wp-config.php” file in the public directory and see what database details were set up. But I want to access this MySQL in the terminal, or in phpmyadmin or something on my localhost. The “AdminerEvo” is pretty pathetic.

Local runs a separate MySQL instance for each site. Local connects to those via a different socket file (Linux, macOS) or port number (Windows).

Each site’s database is named ‘local’, but they exist under different MySQL instances so they won’t conflict.

You have a few options to connect to your databases if you don’t want to use AdminerEvo:

1. Use mysql in the terminal

  • Start your site.
  • Click “open site shell”.
  • Type mysql.

It will open a session connected to that site’s MySQL instance.

2. Use the TablePlus app and its add-on for Local

  • Install TablePlus.
  • Install and activate the TablePlus add-on from the “add-ons” pane in Local.
  • Start your site in Local.
  • Click “Open TablePlus” in the “Database” pane for your site.

3. Use another MySQL client of your choice

  • Start your site.
  • View database connection information on the “Database” pane for your site.
  • Enter those details into your MySQL client (the socket or host and port, as well as the database name, username, and password are all available from the database tab).