Creating a MySQL database for WordPress

Creating a MySQL database with cPanel, which is included in all of hosting plans(may differ with different hosting providers), can be easily accomplished.

Create a MySQL database on your hosting account, you need to log in control Panel. This can be done by either using the Go to cPanel button in the Customer Area My Accounts section or by entering one of the following URLs in your web browser:

http://yourdomainname.com/cpanel

 

create database with cpanel

Creating MySQL Database with cpanel

In order to connect a new database you need to enter the desired name of the database in the New Database field and click on the Submit button as shown below:

where to enter details to create wordpress database

enter your details to create wordpress database

Hint enter keyword into Table Prefix e.g. wp_horseriding to avoid spam emails. Spammers search the internet for newly installed wp_ databases. And make note of Username and password.

Wordpress Training Teaching full install

WordPress Login Screen

A confirmation screen will be displayed, informing that the database has been successfully created.

Next Run the install

WordPress Login Screen

Planning Your Website

The difference between a disappointing website and a website that becomes the life line of your business? Simple and it all in the planning.

Now lets start we are going to spend some time thinking about our goals and developing the plan.

This phase includes everything from planning our content to creating a budget

Learnables:
  • Defining Your Business Website
  • Content Planning what will be on it
  • Diagram Your Website
  • Have site Budget

What is the purpose of your website.

With WordPress you dont need techanical skills or know-how to use it.

But while WordPress is simple and taken the work out of making a site, the one thing that you still have to do, planning behind your site.

For your site to be an effective business tool, it must reflect the core goals and missions of your company. Whereas many of us start the planning of a site by looking at the available WordPress themes and letting those designs sway our decisions, we really need to be starting from a more strategic point of view and making decisions about themes, plugins etc, based on the bigger picture.

1) What are the values and overall mission of your company?

fundamentally your website must be a reflection of the driving force behind your business. What are you trying to convey? What is it about your business that keeps you motivated to run it every day?

What are the business goals of the company?

Website development to marketing strategy. Get clear on what the specific goals of your company are. Your goals may change over time, so it’s good to review them periodically and make sure your site is still in alignment with your business goals.

Who are your desired clients?

Provide a certain service or make a certain product and do that well. So focus on catering to the customers you really want to attract to ensure you are building a business and client base that will serve its purpose.

What do you want visitors to do at your site – your call to action?

 

Have a Clear, defined serving you and your purpose. The more clear your sense of direction, the better result you will get out of your site.

How to Install WordPress

Your web host may offers a ‘one-click install‘ or similar for WordPress, you may want to choose that.

WordPress while easy to use. Installing it is not for the faint hearted.

2nd:) If Your web host offers a ‘one-click install‘ you may choose that:

  1. Download and unzip the WordPress package if you haven’t already.
  2. Create a database for WordPress on your web server, as well as a MySQL user who has all privileges for accessing and modifying it.
  3. Upload the WordPress files to the desired location on your web server: If you want to install WordPress into the root of your domain (e.g. http://example.com/), move or upload all contents of the unzipped WordPress directory (excluding the WordPress directory itself) into the root directory of your web server.
  4. If you want to have your WordPress installation in its own subdirectory on your web site (e.g. http://example.com/blog/), create the blog directory on your server and upload the contents of the unzipped WordPress package to the directory via FTP.
    Note: If your FTP client has an option to convert file names to lower case, make sure it’s disabled.
  5. Run the WordPress installation script by accessing the URL in a web browser. This should be the URL where you uploaded the WordPress files directly to.
  6. If you installed WordPress in the root directory, you should visit: http://example.com/
  7. If you installed WordPress in its own subdirectory called blog, for example, you should visit: http://example.com/blog/

That’s it! WordPress should now be installed.

Any problems give me a call

I also provide a wordpress install service to get you started.

Understanding WordPress and SEO

WordPress Training. Pinguis Website Training, Irish WordPress Experts.

We provide Training in WordPress and seo.

WordPress was at first a blogging platform and later a good content management system but now its a great c.m.s. Ideally suited for business owners and bloggers who are looking to be able to manage and update their own wordpress website, when ever they want.

This website is an example of the level of understanding of WordPress, its a multisite wordpress install. With several sub-domains installed and separate websites on this domain. All websites are on page one in their chosen category for searches. And there is a lot of sub domains to install.

Contact 087 754-7098

How to find the right web host, How to install WordPress, Getting to know the WordPress Dashboard, Creating Content: Posts vs. Pages and when to use each, How to write a WordPress post, Using WordPress themes, How to use WordPress widgets, Using WordPress plugins, How to create custom WordPress menus
Getting Started the Install, and Planning Your Website

More than 25% of website are now designed with WordPress and its free. And more business owners are requesting that they have full access to their own website’s back-end, allowing them to update and change their website when and how they choose.

They wish to add in a new page or blog post, delete a part of a certain page or change the entire theme and look of their website.

Early Content Management Systems (CMS) were hard to use. Even adding in something simple such as a new line of text was hard work. WordPress  to the rescue, its a platform for building and updating websites.

What is WordPress?

WordPress started off as a blogging platform which allowed users to share with the world their passions, hobbies and images. Businesses quickly noticed how easy and straight forward this system was to use and quickly adopted it as their platform of choice on which to build their business website. In the spirit of WordPress we provide free WordPress Training in Kerry and Cork

Why use WordPress?

Why WordPress is a winning solution for your business website:

1) Extremely easy of use – If you can work Microsoft Word or send an email then WordPress will be a breeze to learn.

2) Millions of businesses around the world now use WordPress. With a massive community online assistance is always online with D.I.Y. enthusiasts waiting to help you. Is it the #1 choice of Content Management Systems available today.

3) Safe and secure  WordPress is updated regularly which makes it harder and harder for hackers and bad guys to break into your website.

4) It’s free  and governed by GPL a body, responsible for free open source software – free to download and use with no monthly or yearly costs.

5) It’s highly customisable – With thousands of free templates or Premium WordPress Themes, the choice is yours. With 100’s of thousands of themes to choose from there is the perfect layout and look for you – available free or to buy today.

WordPress Design, Training and SEO

 

Publish button changed to Submit For Review

How to Fix wordpress Publish button in  from Submit For Review

One of the latest problems i have the (pain) pleasure to come across to during a local business wordpress themes design. It really started off as a bit of a nightmare, when i of realised I could no longer add new pages to my WordPress site or even save the customiser settings for our theme either, faced this problem when working on a custom wordpress roofing theme but found the answer after 6ish hours.

The problem was, there was no “Publish” button. The ‘Publish’ button had be replaced by a “Submit For Review” button. Plus when saving the custom preview seemed to work, but after reloading the page were back to the old settings.

I hope my wordpress tips will help you fix your WordPress website fast and get your website working for you, and not you working for your website.

  1. Changing themes can cause this problem. I recommend you switch back to a default theme (i.e. twenty eleven, twenty twelve etc.) and test if the problem still occurs.
  2. Plugins can also cause this problem. To verify if this is the problem, I recommend deactivating or moving your plugins to a directory outside of the folder and see if the problem still happens.

Login to your phpMyAdmin, repairing the database tables. This can solve the problem.
Fix Publish button changed to Submit For ReviewThe WordPress “Publish” button is a “Submit For Review” button problem can also be caused my not having a ‘Primary Key’ and ‘Auto Increment’ in the wp-post table in your database
You can hire me to do this for you. Basically login to your phpMyAdmin and go to the table wp-post. You will see the following error, suggesting that there is no ‘Primary Key’ nor ‘Auto Increment’.

How to Fix Publish button changed to Submit For Review

Go to ‘Structure’ and on the ‘ID’ row, click on ‘Primary Key’ to make this this primary row. Once the ‘ID’ row is the ‘Primary Key’ you can then edit the ‘ID’ row and set it to Auto Increment.

 

Pinguis Web dealing with WordPress Errors and custom WordPress Website Designers

� Character Error in WordPress

Different (special) characters showing on all pages and posts even navigation. Lately i have noticed some character showing in my WordPress website design blog. These characters are appearing when the ” , ‘ and space character is used

I have installed some plugins in the hope of speeding up the website. But to my dismay it has not worked and left all these little guys(basically everywhere).

After reading up on solutions i realised that the plugin has changed my wp-config page see below for a sample
In my wp-config there was characters at the start of every line an upside down question mark ¿
This was then translated to � on the front end or my live website.

 
¿// ** MySQL settings - You can get this info from your web host ** //

¿/** The name of the database for WordPress */
¿define('DB_NAME', 'database_name_here');

¿/** MySQL database username */
¿define('DB_USER', 'username_here');

¿/** MySQL database password */
¿define('DB_PASSWORD', 'password_here');

Upon reading further i realised it was a character miscoding error.
How to fix character miscoding errors.

Fixing the Character Encoding Mismatch Problem in WordPress

Step 1) Open the ‘wp-config.php’ file in a text editor such as textwrangler or BBEdit even notepad (the wp-config.php file can be found on the directory where you installed WordPress).

locate the wp-config file with wordpress

Where to locate the wp-config file with wordpress

Step 2) Find the following two lines and comment them out:

define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');

They should look like the following after you comment them out:

//define('DB_CHARSET', 'utf8');
//define('DB_COLLATE', '');

Step 3) Now upload the updated ‘wp-config.php’ file to your web server.

WordPress Update Services

WordPress Update Services are tools which are used to let other people know you’ve updated your blog.

WordPress automatically updates popular Update Services when you have updated your blog by sending pings each time you create or update a post.

Listed below are Ping Services WordPress uses:

http://rpc.pingomatic.com
http://rpc.twingly.com
http://api.feedster.com/ping
http://api.moreover.com/RPC2
http://api.moreover.com/ping
http://www.blogdigger.com/RPC2
http://www.blogshares.com/rpc.php
http://www.blogsnow.com/ping
http://www.blogstreet.com/xrbin/xmlrpc.cgi
http://bulkfeeds.net/rpc
http://www.newsisfree.com/xmlrpctest.php
http://ping.blo.gs/
http://ping.feedburner.com
http://ping.syndic8.com/xmlrpc.php
http://ping.weblogalot.com/rpc.php
http://rpc.blogrolling.com/pinger/
http://rpc.technorati.com/rpc/ping
http://rpc.weblogs.com/RPC2
http://www.feedsubmitter.com
http://blo.gs/ping.php
http://www.pingerati.net
http://www.pingmyblog.com
http://geourl.org/ping
http://ipings.com
http://www.weblogalot.com/ping

Update service URL’s are listed under “Update Services” under Settings-> Writing Settings

WordPress Address None www. or with www.

WordPress Address www. or none www.

How to get www. before your domain name on your WordPress Website.

WordPress Address none www. or with wwwUltimately, it doesn’t really matter which one you choose. The success of your website will not be determined by a www or non-www URL. The important thing is that whichever one you choose be accurate and consistent.

If visitors type to www.pinguisweb.com or chose to type pinguisweb.com they will still find the Number 1 “Website Design Kerry” website.

In fact when you visit www.pinguisweb.com, the www will not be displayed in the browser’s address bar.

Its assumed when you are searching the world wide web that www. is there.

As long as the domain name is identical there will be no problem with WordPress. Its written into the .htaccess file WordPress has Rewrite Rules to correct this.

To change to either on the left hand black bar go to settings and general. Basically its a matter of choice.

Just be consistent throughout.

Of course, WordPress changes everything when you go installing it in a sub domain and linking it back to you main domain.

WordPress Media Settings

WordPress Media Settings

Media Settings are controlled by the various settings related to images and other media that are used in writing posts and pages.

Wordpress Media Settings Ireland

The image sizes listed determine the maximum dimensions in pixels to use when inserting an image into the body of a post.

  • Thumbnail size – Specify the Width and Height of your Thumbnail
    Crop thumbnail to exact dimensions (normally thumbnails are proportional)
  • Medium size – Specify the the Max Width and Max Height
  • Large size –  Specify the the Max Width and Max Height

Uploading Files

Default settings used for during the media upload process when writing a post.

  • Organize my uploads into month- and year-based folders – Check this box if you wish to organize your uploads into folders based on the year and the month of the upload. WordPress will automatically create the folders, such as wp-content/uploads/2010, these folders are well organised and easy to browse, if you need.

Save Changes Button

Click the Save Changes button to ensure your changes are saved(committed) to your database. Your settings have been saved.
Remember that some plugins require additional image sizes and will create them based on their specifications. One of the main reasons for WordPress site being bloated or taking up to much room.

WordPress Discussion Settings

How to setup WordPress Discussion Settings or Comments.

Default article settings WordPress will send out a pings to a site or article you have linked to in your post automatically.

Trackbacks allows you to communicate to another blog or blog owner using your WordPress

Pingbacks are sent automatically when you link to someone’s site or they link to you.


Other comment settings

I dont allow comments on my websites as a rule.

My settings are: Comment author must fill out name and email.

Users must be registered and logged in to comment.

set to 0 days

Email me whenever

A comment is held for moderation

Before a comment appears

Comment must be manually approved.

Comment author must have a previously approved comment

 

I hate spam so hold a comment in the queue if it contains or more links. (A common characteristic of comment spam is a large number of hyperlinks.)

Below are avatar settings

Avatar Display
Avatar Display

Maximum Rating
Maximum Rating




Default Avatar
Default Avatar

For users without a custom avatar of their own, you can either display a generic logo or a generated one based on their email address.