WordPress

MaxBlogPress Black Friday Discount

Black Friday Sale offers you to grab premium and costly products at cheaper rate. I’ve already share

StudioPress Themes 25% Discount Coupon

Dreamhost $110 Black Friday Discount Coupon

Photocrati WordPress Photography Theme 33% Discount Coupon

Flexi WordPress Theme Club Black Friday Sale

SoloStream WordPress Premium Theme Club Black Friday Sale

Premise WordPress Landing Page Discount Coupon

Xtreme One Framework 30% Discount Coupon

And now in this post I will share MaxBlogpress discount offer. As a blogger you’re interested in this offer because MaxBlogPress offers free and premium plugins which includes Ninja Affiliate, Subscribers Magnet. With these premium plugins you will get 70 page eBook named as Blog Traffic Formula and they have released WordPress learning Website by videos which named as WpWizard.

On this special day MaxBlogPress running a special discount which allows you to grab 70% off while buying their products which means that you can get the stuff at $137. So hurry up and grab this offer as soon as possible because this offer is available for 24 hours only.

Sign-Up Link For MaxBlogPress Black Friday Discount Offer

[How-To Guide] Install Plugin In WordPress Blog

WordPress no doubt best and most popular blogging platform because it is easiest and offers you lots of free themes and plugins which will enhance your blogging experience. Already I’ve covered a tutorial on “How-To Add New Themes” and now in this post focus on adding plugin in your WordPress blog.

Step-By-Step Guide On Adding Plugin in your WordPress Admin Panel

Step1: Login into your wp-admin Panel by typing this URL in your browser

http://www.yourdomainname.com/wp-admin

Step2: Now click on Plugins Option as shown below:

Step3: Now click on “Add New” and it will open a new page.

Step4: On new page, you can add your favorite plugin on your WordPress Admin Panel.

Step5: Now type your plugin name and hit search button (for me its disqus comment system) and it will show you all the results as shown below:

Step6: Now click on install button and it installs the plugin in your wp-content/plugins folder.

Step7: After clicking on Install Button, it opens a new page as shown below, where you’ve to activate the plugin.

Congratulations, you’ve successfully added new plugins in WordPress dashboard.

If you face any difficulty then let us know in the comments section.

[How-To Guide] Delete MySQL Database

Already in earlier article, I have provided you a step-by-step guide in creating a new user in MySQL database. Now, this post focus on deleting MySQL database.

Step1: Click on MySQL Database.

Step2: After clicking on MySQL Database, you will find the names of all your current databases. Click on “Delete Database”, to delete the required database.

Step3: Now it will ask for permission to delete the database as shown below:

Step4: After granting the permission, you’ve successfully deleted the database.

In this way you can easily delete a database and if you face any problem then do let us know in the comments section? In the meanwhile you might be interested in reading in these articles:

Install MySQL Offline On Your PC

Configure MySQL Offline On Your PC

Checking MySQL Installation Works On PC or Not?

Repair And Optimize WordPress Database Using WordPress Hidden Feature

Optimize WordPress Database Using PHPMyAdmin

Repair WordPress Database Using PHPMyAdmin

Top WordPress Plugin To Optimize WordPress Database

Create Multiple User In MySQL Database

[How-To Guide] Create New User In MySQL Database

MySQL, most popular database which allows you to run content-driven websites. MySQL database managed by using third-party programs such as PHPMyAdmin because it offers you a quick and easy database administration process. Already I had provided you lots of guides on MYSQL Database from installation to some advanced level. Here is a quick round-up of all the posts.

Install MySQL Offline On Your PC

Configure MySQL Offline On Your PC

Checking MySQL Installation Works On PC or Not?

Repair And Optimize WordPress Database Using WordPress Hidden Feature

Optimize WordPress Database Using PHPMyAdmin

Repair WordPress Database Using PHPMyAdmin

Top WordPress Plugin To Optimize WordPress Database

All these posts help you out in getting friendlier with MYSQL database. This post focus on creating a new user in MySQL. Follow the step-by-step guide to create user.

Step1: Open your cPanel, under it click on MySQL Database option as shown below:

Step2: After clicking on MySQL database, it will open a new page. Now scroll down and you see the “MySQL Users” as shown below in screen-shot:

Step3: After clicking on “Create User” button a new user-created and it looks like this:

Step4: The new database user will be “cpanelusernmae_admin” (admin is the username of that database you’ve created).

Step5: Now click on “Add” button to “Add User to Database” as shown below:

Step6: Now select the privileges you assign to this user and after assigning privileges click on “Make Changes” button.

Step7: Congratulations, you have successfully added new user to database.

This tutorial guides you in creating more users to your database.

If you face any problems then let us know in the comments section. To get all the latest information you can follow us on Twitter

Top WordPress Plugin To Optimize Database

WordPress, no doubt most popular blogging platform among bloggers/webmasters and its plugin directory made him best among all the blogging platform. We had already provided you a step-by-step guide on Optimizing And Repairing WordPress Database by using PHPMyAdmin or by using WordPress built-in hidden feature. When you look out those articles, you’ll find that all of them requires technical stuff and if you commit a single mistake you’ll ruin all your hard work in a second. It’s a suggestion not to apply them unless and until you’re familiar with them. Especially newbie don’t apply them directly.

If you’re not familiar with PHPMyAdmin or technical stuff, then no need to worry WordPress Plugin Directory is there for your help. It offers you lots of plugins which optimize your database without even using your cPanel or PHPMyAdmin. So here comes the list of handy plugins which optimizes your WordPress Database in no time.

1) WP-Optimize

This is a database clean-up and optimization tool. It doesn’t require PHPMyAdmin to optimize your database tables. It allows you to remove post revisions, comments in the spam queue, un-approved comments within few clicks.

2) WP Database Optimizer

This plugin allows you to optimize your WordPress tables on a schedule. It uses the WordPress databases class to do the work, and you can set the number of days in between optimizations.

3) Clean Options

This plugin finds orphaned options and allows for their removal from the wp_options table. This plugin is for advanced users only, so use it with care.

4) WP-DBManager

It allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up and optimizing of database.

Although, I had provided you the list of all useful plugins which helps you to optimize your database before using any of them back-up your database first and do not DROP or EMPTY any table which you do not know.

Finally in the comments section do let us know which plugin you like the most and why?