💡 WordPress uses MySQL as its database management system. WordPress database is where all of the necessary website data is stored. Not just the basic information like usernames and passwords but posts, pages and comments, even the website theme and WordPress configuration settings.
Here you can find various SQL snippets and PHPMyAdmin tips.
1. log in to the MySQL: mysql -u root -p; 2. Select the database: use database_name; 3. List all users: select * from wp_users\G 4. Change the password for the user you require: UPDATE wp_users SET user_pass=MD5(‘new_password_here’) where ID=user_id_here;
In this example, I’m using ID 14988 Using Media Library If you are logged in as admin, add the media ID in the website URL: then copy the file URL: Using SQL Using WPCLI or
DO_NOT_UPGRADE_GLOBAL_TABLES is a WordPress constant that can be added to the wp-config.php file in order to avoid the upgrade functions from doing expensive queries against global tables. To enable it, simply add the following to your wp-config.php file: WordPress websites that use bbPress have large users and usermeta tables. When upgrades are running, ALTER, DELETE … Read full article →
wp_postmeta table should be the biggest table in your database, if not, there is a problem. Read wp_actionscheduler_actions & wp_actionscheduler_logs tables When you install WordPress for the first time, tables are created in the database, for example for the wp_postmeta table: the problem? solution: On an existing tables, We can add high-performance keys that match … Read full article →
![WordPress database error Table .dbwp options is marked as crashed and should be repaired - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]](https://wpxss.com/application/wp-content/webp-express/webp-images/uploads/2022/10/WordPress-database-error-Table-.dbwp_options-is-marked-as-crashed-and-should-be-repaired.png.webp "WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]")
Here are 4 different methods to fix the scary-looking error: “WordPress database error Table ‘./db/wp_options’ is marked as crashed and should be repaired”. NOTE: It is critically important that you backup your database before performing any of the following suggestions. You’re fully responsible for undertaking this yourself, I can’t be held responsible if you break … Read full article →
According to publicwww about 5000 websites are known to be infected with this type of WordPress malware. It is similar to legendarytable.com malware and adds js code into every post and page so that visitors are redirected to third-party websites. Check if infected To check if your website is infected, open PHPMyAdmin, select your database, … Read full article →
The SAVEQUERIES wp-config constant saves database queries to an array and We can use that array to display queries. The information saves each query, what function called it, and how long that query took to execute. To enable SAVEQUERIES add this to the wp-config.php file: Then in the footer of your theme put this: <?php … Read full article →
In this post I discussed an example where wp_options table had 900k rows of plugin-based data in it, causing the wp-admin dashboard to load slowly. As noted there, good coding practice is for each plugin to create its own database tables and use those instead of default WP tables. While the WordPress community actively improves … Read full article →
WooCommerce plugin uses the wp_actionsscheduler_actions table in the database to log scheduled actions such as cron’s running, product synchronization, upgrade, etc. These actions should be deleted once they are executed but this doesn’t always happen, in most cases, this table uses an InnoDB database engine with a row-level locking feature meaning that multiple queries can … Read full article →
WordPress uses the wp_commentmeta and wp_comments tables to store comments and their data. To delete all comments in WordPress simply empty those tables in the database: To delete all spam comments use: To delete all unapproved comments use: NOTE: In the above commands change wp_ prefix with the table prefix that you are using *(view … Read full article →