How to: change WordPress user password with MySQL

Did ever happened to you that you are unable to login in a wordpress blog because you have not access to the email account?

There’s a way to recover your account without knowing the last password. The only thing you need is access to PhpMyAdmin and five minutes.

First step: access to PhpMyAdmin and go to the users table.

Second step: locate the row which needs the change, click the ‘Edit’ link.

Third step: The link will lead you to a form, locate in the form the value for the column ‘user_pass’. After that, you need to fill in the input your new password enconded in md5. Finally don’t forget to press the update button to save the row changes.
2016-07-23 15_20_39-Settings

Tip: You can use services like to encode a string to md5.
Shortcut: On second step, intead of use the ‘Edit’ link you can execute de following query:

UPDATE `wp_users` 
SET `user_pass`= MD5('yourpassword') 
WHERE `user_login`='yourusername';

Simple DB maintenance for your wordpress blog without any plug-in

Hello everyone!

Sure it happened you more than once. Your lightweight wordpress blog database has turned with some time and a lot of articles in a heavy, big and unoptimized information core for your site.
But what happened? Could this get reversed? Fortunately yes. Your wordpress site can run smooth again.

If you are not up to install some plugins in order to get the optimizations that you need for a faster blog then you can run the following queries.

Please, before do anything else, backup your database.

The following query get rid off all the revision posts:

DELETE FROM `wp_posts` WHERE post_type = 'revision';

This one deletes the autodraft posts:

DELETE FROM `wp_posts` WHERE post_status = 'auto-draft';

And this sends them to the place to its only place to be:

DELETE FROM `wp_comments` WHERE comment_approved = 'spam';

Finally, this one deletes the unapproved comments:

DELETE FROM `wp_comments` WHERE comment_approved = '0';

Just to finish, comes this bonus that will delete some data from the wp_options table.

DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient_%');

If you do this optimizations with a regular basis, you’ll get an efficient wordpress site.

Why MySQL data source is not appearing on Visual Studio 2010?

Hello everyone!

Today I’ll show you how to make work the MySQL data source for MySQL in Visual Studio. The thing is that the MySQL ADO connector is linked in some kind of way with the Visual Studio version. This is some kind of obvious but you do not expect this from big community such a MySQL (and Oracle).

Let’s start with the info! A moment ago when I opened my Visual Studio 2010 and tried to begin a configuration to connect MySQL I noted that the connector suddenly dissapeared.

2015-03-09 11_01_42-choose_datasource

Why did my connector dissapear? The answer is very simple: I’ve updated it. So don’t do that if you want to keep it. I installed the 6.9.6 ADO .NET connector. If you did that too I have some news you gotta to…

2015-03-09 11_08_23-uninstall

After that just install the old (outdated but still functional) MySQL ADO .NET connector and you ready to go!
The version 6.6.7 is the last that seems to work with the Visual Studio 2010 but If you have news from any newer please let me know to update this post.

2015-03-09 11_16_46-MySQL_download

When you open again your Visual Studio 2010 and try to make a MySQL connection via data source the world will be spinning again.

2015-03-09 11_23_07-peaceOfMind

Hope this article solves your problem. Happy coding!