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

 

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:

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 Login Screen

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

Next Run the install

WordPress Login Screen

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.

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.
The 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’.

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

htaccess index.html added by Plugin wordpress

This works for any wordpress directory.

If you have a WordPress website and have noticed that some thing has added index.html or a plugin has added it.

Example would be http://pinguisweb.com/about/index.html.

The code below will redirect to http://pinguisweb.com/about/ and drop index.html

try adding

RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteRule ^index\.html$ / [R=301,L]
RewriteRule ^(.*)/index\.html$ /$1/ [R=301,L]

to your .htaccess file

How to redirect subdirectory to url with htaccess file

 

This will redirect all references to Car-Sales directory to 
the car-sales file. 

RedirectMatch 301 ^/Car-Sales/.*$ http://pinguisweb.com/car-sales/

Improve Page Speed

Some tips on how to Improve Page Speed.

Use one of the below suggestions to improve your website speed.

CSS Optimization Test

Analyze the CSS delivery of your web page (ultimately your website).

CSS Compressor

Minimize CSS scripts for page speed.

Javascript Optimization Test

Analyze the Javascript delivery of your web pages.

Javascript Compressor

Minify your JS scripts to maximize performance.

GZIP Compression Test

Test whether your web pages have Gzip compression enabled.

Image Optimization Test

Test the image delivery of your website so you can improve it.

PNG Compressor

Reduce the file size of PNG images while keeping quality.

JPEG Compressor

Play with the quality and size of JPEG images to reduce file size.

CSS Sprites Generator

Save multiple images to a single image to make fewer requests.

Caching Test

Check whether and how your website files are cached.

Broken Links/Requests Test

Test your web pages for broken links and requests.

HTTP Requests Checker

How many HTTP requests do your web pages produce?

Base64 Encoder

Encode web files into a Base64 string to reduce HTTP requests.

Keep-Alive Checker

Check whether your website has keep-alive enabled.

Line Breaks Remover

Remove line breaks from your scripts to reduce file size.

HTTP Header Checker

Check the HTTP server header of a web page.

Taking these actions while not a big influence on page speed individually, do accumulate to that faster speeds.

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.

Ultimately, 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.

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.

WordPress Reading Settings

WordPress Reading Settings Control your frontpage Settings

Front Page Display Setting choose what content appears on your website’s front page. Choose to have your latest blog posts or a static page. Created in the Pages tab (black bar left hand sidebar) of your site.

Your front page is set to display your latest blog posts by default, this can change it to a static front page. Using a static front page is handy if you want to use your front page as a landing page.

Blog pages show at most – Controls the number of Posts to display on your blog page. If frontpage display is set to display Your Latest Posts this value is controlled here also.

Syndication feeds show the most recent – These feeds show the most recent items and lets you set how many blog posts will be sent out at via RSS feed (mine is located at http://pinguisweb.com/feed/). Add /feed/ to your wordpress domain name to get your feed address.

For each article in a feed, show – choose whether to show all post content or the first 55 words, you can select Full text or Summary. Full text means that the entire contents of a post are included in the feed. Summary means that only the first 55 words are included in the feed, along with the option to continue reading the rest of the post. Best change to Summary because of pagespeed and bandwidth factors.

Search Engine Visibility – If you want to setup your website before indexig check the Discourage search engines from indexing this site box to ask search engines not to index this site. When the option is checked, this changes robots.txt to send back noindex(Disallow) commands to search engines.