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
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.
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).