The information stored in a WordPress database includes posts, pages, comments, categories, tags, custom fields, users, and other WordPress settings. There are some rare cases you may want to edit the database yourself. For example, if you migrated a site on your own and need to edit the wp_options table; or import a backup of a database manually.
CAUTION:
Whatever the reason may be, when editing the database, do it with the utmost care. One wrong change can cause fatal errors on your site and for it to stop working. Only recommend users who are experienced with databases and SQL to access the database. Also, always remember to make a backup of your site before making changes.
- Log into your Convesio dashboard and go to the site dashboard to access the database.
- Once logged in, go to the SETTINGS tab on the dashboard.
- Under the Settings tab, you will see another list of options to the right of the dashboard. Click on the option Database Settings.
- The dashboard will then show you the database information for the site, including the username and password. First, you can click on the link which says Launch phpMyAdmin.
- That will take you to the phpMyAdmin login page.
- From the Convesio dashboard, copy the username and password and paste them into their respective fields on the phpMyAdmin login page.
- Hit the Go button to login and then click the database name on the left. You can now edit the WordPress database.