Wordpress and phpMyAdmin - Best Blogs Asia
Wordpress suffers from a few bugs, which you’ll notice if you’re writing non-English content or have lost your password etc.,
There’s a few tips you can use to update your WP database. Wordpress is great, but suffers from a few bugs, which you’ll notice if you’re writing non-English content or have lost your password etc.,
Optimise Database Tables
Database tables should be periodically optimized (and repaired if necessary) for optimum performance, an example would be manually optimizing and repairing your table through a tool like phpmyadmin.
Reset a WordPress Password from phpMyAdmin
If you’ve managed to lose or want to change your Wordpress Password in a hurry, then the tips below will help greatly.
- Open up PhpMyAdmin, a simple application that controls your database’s.
- Locate your Database, then look for a table called wp_users.
- Select Browse, then click the pencil icon on the left side within the wp_users line.
- Go to the field called users_pass.
- Select MD5 in the Function column and type the password in plain text, then click Go.
When you save the record the password will be stored after the MD5 hash algorythm was applied. You can do this not only for Wordpress passwords but for other CMS applications, forums and other software.
UTF Databases
Your database might not actually be set up to use UTF8 and instead may be using the server default, which in many cases is Latin1.
- Make a copy of your Database first.
- Find a table with garbled characters, choose a column to edit – example I’m converting the Wordpress category name to unicode.
- Make a note of the current datatype (usually varchar / text / longtext) and length.
- Set the datatype to blob.
- Choose to edit the same column. Now flip it back to the datatype and length that it was set to originally AND set the collation as unicode.
No related posts.