The database user name/password is not stored in the database; it is only used to access the database. Change the username (and password, too) to the new values in wp-config.php. And the problem might be access to the database via phpmyadmin; check your username/password in Cpanel or some other hosting control panel.
Use the following functionto set views manually function setPostViewsManually($postID, $viewCount) { $count_key = ‘post_views_count’; $count = get_post_meta($postID, $count_key, true); update_post_meta($postID, $count_key, $viewCount); } You can run this code by <?php setPostViewsManually(get_the_ID(), 1234); ?> The above code will set the view to ‘1234’ for the current post. Run this function carefully else your new views will … Read more
I found a post on Stack Overflow advising that converting a column from blob to text should result in no data loss. I didn’t really care about data loss since I wanted to remove the plugin data anyway, so I gave it a shot. On the Structure tab in phpMyAdmin, I edited the val column … Read more
The short answer is yes. Having a secure username and password is paramount to keeping your site secure.
You have two tasks to solve here: 1. Resolve the time-out problem. 2. Update WordPress. Resolve the time-out problem These things don’t just happen because your WP is old. There must be a concrete reason. The three most common reasons are: Not enough memory. Maybe your hosting provider has limited the memory? Try adding the … Read more
Thank you so much for your reply. It helped me figure out what’s going on. I get a far bit of spam submissions via my contact form, these spam submissions include URLs. Although they are being flagged as spam and filtered out, WordPress still creates an oembed_cache entry in the database for them. I have … Read more
Plugins and themes are no in the database, they are physical files under wp-content directory, and that is why you CAN’T find them in the database nor edit them from phpmyadmin. However WordPress has a built in editor for plugins and themes files. For themes its under appearances -> editor and for plugins its under … Read more
The join isn’t that complex, but I wouldn’t bother with it. Since you have a lot to remove a direct SQL query will run a LOT faster than WP. However, we do need to keep track of the post ID numbers and remove the descendants and metadata. Not tested / Make a backup / your … Read more
300 sites within a multisite shouldn’t be a problem by itself. Just be aware that things scale out quickly when you are operating that many sites. In particular, the number of posts will grow fast, and depending on the type of site, the traffic can grow fast. 300 empty sites with no traffic can be … Read more
This is something that has thrown me off in the past. You actually see the error that talking about the Privileges, but the actual error is that the database doesn’t exist! You are searching for database name wp_ where there is only bitnami_wordpress. $sql = “SELECT * FROM bitnami_wordpress.wp_comments WHERE comment_ID = $id”;