NOTES:
By default UpdraftPlus backups are saved in the “wp-content/updraft” folder of your WP Install
– *upsells* are offers you provide after the member signs up
– *crossells* are any memberships you want to offer on the join page
Where is my WordPress database stored?
WordPress uses MySQL as its database management system, which is a software installed on your WordPress hosting server. Your WordPress database is also stored on the same server.
This location however is not accessible on most shared hosting environments. However, if you are on a VPS hosting plan or a dedicated server, then you can use command line tools to locate the database.
Most often it is located at the following path:
/var/lib/mysql/your_database_name
However, this could differ from one hosting provider to another.
It is important to keep in mind that you don’t really need to access the database file itself. You can use other tools like phpMyAdmin to manage your database.
LOCALHOST – 127.0.0.1:8889 OR 127.0.0.1
Fixing PHP Warning: mysqli_real_connect(): (HY000/2002): with WP CLI and MAMP
Fixing PHP Warning: mysqli_real_connect(): (HY000/2002): with WP CLI and MAMP
For me, the answer was changing the setting for DB_HOST to 127.0.0.1:8889 instead of localhost in wp-config.php, and also checking the box to “Allow network access to MySQL” in the MySQL settings. Getting the port set to the port that MAMP Pro is using for the database was the critical missing piece that I didn’t see in the other answers here. YMMV.