• About Me
  • Site Map
  • Connect
  • ✫ Resources

Michael G. Stults

Changing the world one pixel at a time

  • All Posts
  • Leadership
    • Life
      • Stress
  • How To
  • WordPress
    • Plugins
  • Social Media
  • Online Marketing
    • Affiliate Marketing
    • SEO
  • ✫ Resources
You are here: Home / Archives for Wordpress

The Most Flexible Coming Soon Plugin for WordPress 2015

April 21, 2015 By Michael G. Stults 2 Comments

Customize SeedProd Plugin

SeedProd Coming Soon Plugin

 

Have you found yourself in a situation where you're building a WordPress website on a live domain yet you don't want the whole world to see your “progression”? Maybe you have some extended maintenance to do? I'd tend to think most people have encountered a project that is going to take more than a few minutes but you just don't want to risk the world wide web seeing the disarray in the meantime. Look no further for the ultimate coming soon and maintenance plugin, SeedProd.

SeedProd offers the best coming soon plugin for WordPress on the market today. Yes, I'm bias because I've used this plugin multiple times over the past couple of years. There is no doubt that you want the Pro version if you are serious about your branding and WordPress development. It is my go to for new websites I start. It is one of my best investments I've ever made for website development work. Multi-dimensional is the best description because of how it is packed with feature rich options that can be used with any level of knowledge from a true “beginner” to an “expert”. I love this PLUGIN! [Read more…]

Michael G. Stults
Michael G. Stults

Dynamic, high-energy executive with history of performance-oriented leadership to e-commerce sales and marketing within the online marketing and advertising industry. MichaelStults.com is where I share my thoughts on different marketing methods, wordpress, leadership, and various topics that I feel inspired to write about. Please take time to learn more about Rare Disease at www.BriParDun.com

www.michaelstults.com/

Filed Under: Blog, Plugins Tagged With: Best coming soon, Client Access, Features of SeedProd, John Turner, Plugins, Review SeedProd, SeedProd, Ultimate Coming Soon Plugin, Wordpress

How to Setup MySQL Workbench Database for WordPress on Windows Server

October 9, 2014 By Michael G. Stults 5 Comments

MySQL WorkbenchSetting up a MySQL database while installing WordPress on their host has came a long ways compared to even 5 years ago. Most people experience an easy way to use cPanel, Fantastico, or Simple Scripts which provide a push button approach of installing and doing the heavy lifting for you such as your Wordpress files on your domain and creating the database. Ideally this post is for someone that is fairly new but has some experience with setting up WordPress.

Recently I came across the need to do it manually. Now, most hosting companies allow you to create an individual database manually and off to the races you are. Typically that entails a pretty control panel to make your life easier. On this current project, they were using what I refer to as a raw server. There is no easy control panel to quickly eliminate several steps to create a database for your new WordPress website. It was a Dedicated Windows Server.

This is where MySQL Workbench comes into play.

The goal I was accomplishing was to set up a WordPress blog within an existing site. That site was built on Bootstrap and was NOT currently using WordPress as it's “engine”. Essentially, a static website.

How to Get Started with MySQL Workbench For WordPress Database

If your dedicated or virtual private server does not already have MySQL Workbench installed, head on over to get it downloaded: Go HERE. This assumes it isn't already installed. I won't be going over on how to install it but the prompts are fairly straight forward to get things set up. Your default username will always be “root”. I recommend choosing a complex and strong password if you choose to leave your username the same.

Step 1: Assuming you have Workbench ready to roll…. open the program. You will come to the “home” screen where you should see something similar to this. Now, my screenshot here is showing you a couple “tiles' but that is only because I've created a few.

MySQL Workbench Home Screen

MySQL Workbench Home Screen

Step 2: You will want to select the “+” sign next to “MySQL Connections” at the top left hand side (main screen). Just give that ol' plus sign a click and up pops a window over your screen as shown below.

  • Name: Enter a “Connection Name”. It can be whatever your heart desires.
  • Connection Method: It defaults to “Standard (TCP/IP). I would just leave it alone. You have the option to change that though. It depends on a few other variables.
  • Hostname: Will be auto populated by default (write that down!!!!)
  • Port: Auto populated as well. (As Van Wilder said, “Write that down.”)
  • Username: If you have chosen it to be “root”… it will be sitting there for you.
  • Password: I would go ahead for good measure and click on “Store in Vault”. A new box will pop up. Enter your password and hit save. If all is well… you'll be aware.
  • Default Schema: I would say just leave blank for now because we will cover that shortly below.

Test Connection button: Click this and it will tell you if you are good. Generally you will be fine but worth doing.

Hit “OK” button to finish.

Overall, you don't really have to touch much here to move on in the process. I am sure you are relieved at this point.

Create New Connection MySQL Workbench

Create New Connection MySQL Workbench

Step 3: You are back on the “Home” screen. Next you will select your Connection “Insert what you called it here” box. In my example, I called it “test”.

Select Connection MySQL Workbench

Select Your Connection from MySQL Workbench

Step 4: A new type of window has now popped up for you to look at. This area is where you could write a Query by selecting multiple databases or “Schemas” to pull data up to export, view, or correct. No worries, you won't have to mess with that during this process. 🙂

  • Lower left hand side, you will see a box menu called “SCHEMAS”.
  • You will see some existing ones that Workbench includes to give you some ideas.
  • Right below it, right click your mouse and a box will pop up.
  • Select “New Schema”.
Create New Schema

Create New Schema, right click

Step 5: Give your new Schema a name and hit “Apply” to move on. Make sure you pay close attention on the instructions on the right on the nomenclature. They want alpha-numeric. Spaces should be avoided and use the “_” (underscore) to separate. I would avoid calling it “wordpress” or “wp”. You could go with something like “mycoolblog_2014111”. Just mix it up some.

Remember what Van said? Yes, right this name down!

Give Schema Name

Give Your Schema (database) a Name

Step 6: After you hit “Apply” from the last step, you will receive another pop up box. Nothing has to be down here except hit “Apply” button again. This is creating the basic framework for the database set up. It is creating this by a “Script”.

Apply New Schema

Apply the New Schema

Step 7: You will see another screen after the above action and simply just hit “Finish”. The pop up will close and you are a step closer to greatness.

Finish New Schema

Press “Finish” Button for New Schema

Step 8: Looking back at the “SCHEMA” section on the lower left… I called mine “new_schema” but don't be so cool like me and use a better name like something in Step 5.

Database Created

Shows your Database was Created

Completing Manual WordPress Installation

This part is assuming you have unzipped the zip file from WordPress.com and have moved the unzipped folders and files to your folder where you want them. You have a few fields here to fill out.

  • Database Name: This was Step 5 above. Enter your name exactly.
  • Username: If you have left name as “root”, then this is what you use.
  • Password: Input your crafty mile long password you created once you installed MySQL Workbench in the beginning if you had to. Otherwise, you will know it. If not… you will have to go back and create a new user assigned to this database (SCHEMA). Creating Username & Privileges
  • Database Host: For our example here… you will need to remember what you wrote down from Step 2. WordPress will default it to “localhost” but that usually is left like that if you are on a managed server. It is an IP address along with the port. You will conjoin the two by a semicolon. It probably will look like this: 100.0.0.10:3309
  • Table Prefix: I would just leave as “wp_”.

Hit Submit button. Carry on completing the next steps for your WordPress websites. When you move on after entering your database information…. WordPress will do the heavy lifting in creating the “tables” and such needed inside of the database. That is a question a lot of people don't understand or realize. ******You may be prompted to create a “wp-config.php” file after inputting all your DB info. WordPress comes with a “sample config file” (found in root folder of installation) that you can open up and input these above credentials in if need be. After you do that, just simply rename that file to “wp-config.php” and move forward.

Manual Install WordPress Database

image credit: http://www.siteground.com/

Final Thoughts on Your WordPress Database in MySQL Workbench

I sincerely hope this has helped you in some way. The above steps helped accomplish my task. If you were like me, you probably searched through a lot of pages to find something close to accomplish this. You should experience a working WordPress blog with minimal issues. Of course, a lot of outside variables come into play but this should get you on the right track.

 

Michael G. Stults

Michael G. Stults
Michael G. Stults

Dynamic, high-energy executive with history of performance-oriented leadership to e-commerce sales and marketing within the online marketing and advertising industry. MichaelStults.com is where I share my thoughts on different marketing methods, wordpress, leadership, and various topics that I feel inspired to write about. Please take time to learn more about Rare Disease at www.BriParDun.com

www.michaelstults.com/

Filed Under: Blog, How To, Wordpress Tagged With: Database, dedicated server, how to create database for wordpress, Installation, MySQL Workbench, windows server, Wordpress

Backup WordPress using Backup Creator

March 10, 2012 By Michael G. Stults 5 Comments

Have you had a situation where you needed to restore WordPress or clone WordPress for any reason? Those reasons could be that you made an update and it messed up your site, your site was infected with a virus, or you simply wanted to duplicate your site to another domain. Guilty as charged? You may be more than aware of the various options out there. Backup Creator is one of the newest plugin's on the market that gives you the ability and security knowing you have all those files. Sure, there is BackupBuddy, which I also use. I mean… who said you just had to have one option to backup your sites? [Read more…]

Michael G. Stults
Michael G. Stults

Dynamic, high-energy executive with history of performance-oriented leadership to e-commerce sales and marketing within the online marketing and advertising industry. MichaelStults.com is where I share my thoughts on different marketing methods, wordpress, leadership, and various topics that I feel inspired to write about. Please take time to learn more about Rare Disease at www.BriParDun.com

www.michaelstults.com/

Filed Under: Blog, Plugins, Wordpress Tagged With: Backup Buddy, backup creator, backup WordPress, Clone WordPress site, Few Clicks, Plugins, Protect, restore WordPress site, Sites, Wordpress, WordPress Blogs

8 Simple Steps to Search Engine Optimization (SEO)

December 22, 2011 By Michael G. Stults Leave a Comment

Search Engine Optimization (SEO) and search ranking can be a beast to tackle. I typically tell clients that there is no magic pill you can take to just mysteriously show up on the first page of Google.

I hear stories all the time of the local business owner, who are good at their craft receiving a call with someone promising the first page of Google in no time. A few weeks later they wasted a few thousand dollars leaving them in a state of frustration! They are better off reading Search Engine Optimization for Dummies using its SEO checklist to make the changes. This is why WordPress is recommended to give the average Joe the chance to do some of the work themselves. [Read more…]

Michael G. Stults
Michael G. Stults

Dynamic, high-energy executive with history of performance-oriented leadership to e-commerce sales and marketing within the online marketing and advertising industry. MichaelStults.com is where I share my thoughts on different marketing methods, wordpress, leadership, and various topics that I feel inspired to write about. Please take time to learn more about Rare Disease at www.BriParDun.com

www.michaelstults.com/

Filed Under: Affiliate Marketing, Blog, How To, SEO, Wordpress Tagged With: 8 Simple Steps to Search Engine Optimization (SEO), backlinks, Internet Marketing SEO, keyword research tools, Keyword rich domain, permalinks, permalinks SEO, quality content, Search Engine Optimization for Dummies, Search engine traffic, SEO, SEO plugin, site optimization, Social Media, Wordpress

Setting up WordPress using DreamHost

September 21, 2010 By Michael G. Stults 7 Comments

DreamHost in my opinion is no dream. Recently I had a referral contact me for helping setting up a WordPress site for their client. DreamHost taunts a “One-Click Install” for WordPress as demonstrated below. I do agree this is probably accurate but when you give the user of a DreamHost account little information to which option to select…things get pretty messed up. Yes, there is a “wiki” but if you've never done this before it could get confusing. They even charge for calling technical support. That is insane!

The very first main reason why they could never install WordPress after 3-4 tries is the domain they were using was on www.1and1.com but they were hosting the new site on DreamHost. I had to change the name servers on 1and1.com to point towards DreamHost. This solved the first big challenge. Now behind the scenes I didn't know they had email running through 1and1.com so that broke their email as well. Thankfully this happened on a Friday evening :). On my next post I'll talk about that fun circus!

Typically when you register a domain name you probably will be using that company to also host your website. I would highly recommend doing this to keep your investment cost down and things organized. WordPress isn't for every website or every person/ business. It helps provide a feasible back end administration panel that can help them easily change things out as needed. [Read more…]

Michael G. Stults
Michael G. Stults

Michael G. Stults is a leader, manager, and most importantly a team builder. He has realized that his success in his personal and business life has been contributed to the professionalism of others.

Along with his creative mindset, natural relationship building ability, and charisma, Michael has shown that he can succeed in business whether that be in the financial or online marketing sectors.

www.michaelstults.com

Filed Under: Blog, Wordpress Tagged With: DreamHost, How to set up wordpress on DreamHost, Michael G. Stults, Wordpress

How to upgrade from PHP4.0 to PHP5.0 in wordpress using 1and1.com hosting

July 26, 2010 By Michael G. Stults 21 Comments

I've been so frustrated with this whole PHP5.0 verse PHP4.0 versions in my 1and1.com hosting account regarding my wordpress sites. I had to write a quick post about this issue because I discovered that when my automatic upgrades were “hanging up” or not upgrading through the cpanel….that I wasn't the only one with this frustration. It was nearly impossible to update any plugin or install one. I just thought it was “the way it was going to be”.

Last week I read a post about WordPress PHP 4 and MySQL 4 End of Life Announcement that stated they will eventually stop supporting PHP4.0 version and ummm well you better get your stuff upgraded soon. So I started to dive in to look at the problem. The funny thing is MySQL in my 1and1 cpanel said this:

mysql view in cpanel for 1and1

[Read more…]

Michael G. Stults
Michael G. Stults

Michael G. Stults is a leader, manager, and most importantly a team builder. He has realized that his success in his personal and business life has been contributed to the professionalism of others.

Along with his creative mindset, natural relationship building ability, and charisma, Michael has shown that he can succeed in business whether that be in the financial or online marketing sectors.

www.michaelstults.com

Filed Under: Blog, Wordpress Tagged With: 1and1.com, fix, hosting, How to upgrade your PHP version on 1and1.com, PHP5.0, plugin updates, update, upgrade from PHP4.0, Wordpress

About Michael Stults

Michael G. Stults

Hi, my name is Michael Stults. I appreciate you stopping by my site. I work in the online marketing industry and when time permits coupled with my two oldest sons' having (now had) a rare neurological disease called Niemann-Pick Type C, I like to write about topics that interest me. I hope at the same time that I can provide something valuable to you in return. ...Read more

Please connect with me if you would like to talk about internet marketing of any kind, non profit work, technology or business development.

FacebookInstagramTwitter

Find Your Purpose

IdeasToFortune.com

Find Me Here

Follow @MGStults Follow @MichaelStults Follow @MichaelGStults Follow @NPCFund

Top Posts & Pages

How to Setup MySQL Workbench Database for Wordpress on Windows Server
How To Find SMTP Server Address GoDaddy For Outgoing Gmail (alternative)
Connect
How To: Basics of Google Apps and Gmail
Marketing Resources

Tags In The Cloud

1and1.com Affiliate Marketing Browser Charity chrome cpanel Daily Bread facebook Free Gmail God Google Apps hosting How to How to create an email signature HTML Infograph Inspiration Jim Kukral Kansas Kansas City Leadership Life Michael G. Stults Michael Stults Mike Stults Missouri Niemann-Pick Children's Fund Niemann-Pick Type C online tool Outlook Panda Penguin plugin Plugins product SEO Small Business Social Media Struggles Thelonious twitter Video Wordpress Wordpress 3.0

Customize Your Website

WordPress Theme Editor

[footer_backtotop]

Copyright © 2025 · Designed by Michael G. Stults · Site Map