{"id":20176,"date":"2019-08-22T20:59:47","date_gmt":"2019-08-23T01:59:47","guid":{"rendered":"https:\/\/kb.pressable.com\/?post_type=article&p=12414"},"modified":"2025-10-07T12:39:58","modified_gmt":"2025-10-07T17:39:58","slug":"access-wordpress-database-with-pressable","status":"publish","type":"knowledgebase","link":"https:\/\/pressable.com\/knowledgebase\/access-wordpress-database-with-pressable\/","title":{"rendered":"Accessing A WordPress Database with Pressable"},"content":{"rendered":"\n

How to Access a WordPress Database<\/h2>\n\n\n\n

For security reasons, we do not allow remote access to a Pressable site’s database. For more information, please see our Platform and Service Considerations<\/a>.<\/p>\n\n\n\n

However, if you wish to connect to your Pressable site’s database programmatically from within your site, such as via PHP Data Objects (PDO) or MySQLi, you may do so.<\/p>\n\n\n\n

If you’re using PDO or MySQLi within WordPress, you can use the PHP constants defined for database access:<\/p>\n\n\n\n

<?php
require 'wp-load.php';
$connection = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);<\/pre>\n\n\n\n
<\/div>\n\n\n\n
If you are not accessing the database from within WordPress (i.e. via a PHP script that functions outside of WordPress), then you can use the following script to output the database credentials necessary for a PDO or MySQLi connection.<\/p>\n\n\n\n
    \n
  • You can create a .php<\/code> file inside the site root \/htdocs <\/code>to add custom PHP scripts below<\/li>\n\n\n\n
  • You can then access the script by visiting its URL in your browser (e.g., http:\/\/yourwebsite.com\/your_script.php<\/code>).<\/li>\n<\/ul>\n\n\n\n
    <?php
    require 'wp-load.php';
    \/\/ Display WP database credentials
    echo \"DB NAME :\".DB_NAME .\"<br>\";
    echo \"DB USER :\".DB_USER .\"<br>\";
    echo \"DB HOST :\".DB_HOST .\"<br>\";
    echo \"DB PASSWORD :\".DB_PASSWORD;<\/pre>\n\n\n
    \n      
    \n\n            
    \n                  
    \n                        \n      \n       <\/circle>\n       <\/path>\n       <\/circle>\n <\/svg>                        
    \n                                                                  \n                                          Important:                                    <\/span>\n                              \n                                                                  
    \n                                          After using the database file, please remove it from the site root directory \/htdocs. Leaving the file there is a security risk.                                    <\/p>\n                                                      <\/div>\n                  <\/div>\n            <\/div>\n\n      <\/section>\n<\/div>\n\n\n
    If you have any questions, please contact support.<\/p>\n","protected":false},"excerpt":{"rendered":"
    How to Access a WordPress Database For security reasons, we do not allow remote access to a Pressable site’s database. For more information, please see our Platform and Service Considerations. However, if […]<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":60,"template":"","meta":{"content-type":"","footnotes":""},"knowledgebase-categories":[524],"kb-tags":[],"class_list":["post-20176","knowledgebase","type-knowledgebase","status-publish","hentry","knowledgebase-categories-tutorials"],"jetpack_sharing_enabled":true,"meta_box":{"kb_updater":"1"},"_links":{"self":[{"href":"https:\/\/pressable.com\/wp-json\/wp\/v2\/knowledgebase\/20176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressable.com\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/pressable.com\/wp-json\/wp\/v2\/types\/knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/pressable.com\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":3,"href":"https:\/\/pressable.com\/wp-json\/wp\/v2\/knowledgebase\/20176\/revisions"}],"predecessor-version":[{"id":47288,"href":"https:\/\/pressable.com\/wp-json\/wp\/v2\/knowledgebase\/20176\/revisions\/47288"}],"wp:attachment":[{"href":"https:\/\/pressable.com\/wp-json\/wp\/v2\/media?parent=20176"}],"wp:term":[{"taxonomy":"knowledgebase-categories","embeddable":true,"href":"https:\/\/pressable.com\/wp-json\/wp\/v2\/knowledgebase-categories?post=20176"},{"taxonomy":"kb-tags","embeddable":true,"href":"https:\/\/pressable.com\/wp-json\/wp\/v2\/kb-tags?post=20176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}