Create Database If not Exists – phpMyAdmin – Learn to Fix it

CREATE DATABASE IF NOT EXISTS `ss` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: #1044 – Access denied for user ‘secwebs’@’%’ to database ‘ss’

Create Database If not Exists

If you are having a wordpress website, it just means that you have made the best choice for your business. However, having a wordpress cms demands lots of knowledge when you run into some problems. You may contact your programmer or website designer or you may want to fix it yourself.

One of the problem that many people has is an issue which is similar to this :

CREATE DATABASE IF NOT EXISTS `ss` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci





 When does this happen?

This issue often happens when a person wants to migrate a wordpress website from one server to another.

The person usually make a backup of his WP Website and Export the SQL.

He then goes to the new server, upload his WP Website and Import the SQL from the phpMyAdmin. The issue happens at the Import of the SQL to the New Host.

Top 25 WordPress Portfolio Themes – Awesome Designs

The reasons can be:

  1. Bad Naming of the databases
  2. Bad Naming of the Users

While this issue can be solved by Expert Programmers directly from the phpMyAdmin, beginner wp users can easily fix this by what i will show below.


How to fix this?

The way to fix the issue of ” CREATE DATABASE IF NOT EXISTS `ss` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ” is to actually fix it at the root.

What i mean by the root, is when you do your SQL Export from your old server itself.

Let’s go for it.

(A) From your Old Server, go to phpMyAdmin

(B) Click on the Database Associated with your WP Website

(C) You will see a list of Tables like in the Picture below.

(D) Tick “Check all” (number 1 in the picture below)

(E) You will see the Drop Down, “With Selected” (number 2 in the picture below), click and you will see Export. Click Export.

Create Database If not Exists

(F) Another window will open up, Select “Custom” (number 3 in the picture below)

(G) Select SQL (number 4 in the picture below)

(H) All Tables should be selected (number 5 in the picture below)

Create Database If not Exists

(I) Click “Go” (number 6 in the picture below)

Create Database If not Exists


Now What?

Now, go to your New Server and import the SQL you just did above. This issue ” CREATE DATABASE IF NOT EXISTS `ss` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ” will not appear.

If you are having any problems, leave a comment below.

Top 25 WordPress Portfolio Themes – Awesome Designs

WordPress Portfolio Themes are mostly used by companies or freelancers who want to showcase their works online.

Top 25 WordPress Portfolio Themes Awesome Designs

We all know that wordpress is the choice of majority webmasters since 2014. We all remember the days of joomla and magento. Even the latters are still being used today, but many webmasters have swapped to WordPress CMS. WordPress Portfolio Themes Awesome Designs are widely used by designers, artists, photographers and others. Below are the top 25 WordPress Portfolio Themes :



WP Themes 1 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 2 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 3 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 4 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 5 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 6 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 7 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 8 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 9 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 10 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 11 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 12 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 13 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 14 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 15 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 16 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 17 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 18 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 19 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 20 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 21 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 22 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 23 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 24 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

WP Themes 25 : VIEW  |  DOWNLOAD

Wordpress Portfolio Themes

 


INTERESTING LINKS:

Restaurant Marketing Ideas – 5 Elegant Restaurants WordPress Templates

5 Incredible Gym WordPress Themes – Gym Trainer Marketing Ideas


Why use Wordpress Portfolio Themes Awesome Designs

If you have a company, portfolio themes should be your best choice. When you have a portfolio section, your customers are able to view your previous works before they make their choice. It is always harassing when your customers ares you for your portfolio and you have to send them a PDF by email. So, porfolio themes Awesome Designs are the best choice for you to use. It also brings more traffic to your website. Your porfolio items, i.e the pictures are catched by search engines (if you insert the title, alt tags and description).

 

Who use Wordpress Portfolio Themes Awesome Designs

Let’s say you are a wedding photographer and you want to have a website. The ideal choice would ofcourse be to have a WordPress CMS for your backend. The themes you need to have should be those which offer a portfolio section. You can list your pictures in different categories such as indian wedding photography, pre wedding photos, family photography, bridal photos and others.

 

Other professionals also use WordPress Portfolio Themes :

Fashion Designer – A fashion designer with Awesome Designs can upload their fashion dresses which they have just designed. It could be categorised by women’s trousers, cotton trousers, wedding dresses, bridal gowns, mens shoes or more.

Architecture Firms – It can be amazing to have a gallery of pictures showing your latest contemporary architecture, architecture office or architectural house plans. This will help your potential customers to make up their mind in hiring you.

Interior Designer – Interior decorating is a fabulous work but it is always complex to give satisfaction to your clients. You can offer packages and upload your pictures in the portfolio section such as interior design bedroom, office interior design or kitchen interior design.

The list goes on and on because just anyone and any business should have a portfolio section in their website and should use WordPress Portfolio Themes Awesome Designs.

5 Incredible Gym WordPress Themes – Gym Trainer Marketing Ideas

Gym WordPress Themes

gym wordpress themes

5 Incredible Gym WordPress Themes

Gym Trainer 2017 Marketing Ideas – These are the world best gym wordpress themes used by the professional gym trainers. Don’t you think you should be among the best fitness trainers?

Ofcourse you want it. Get one of these incredible Gym WordPress Themes to rockfire your sales.




 

1 GYM EDGE – Gym WordPress Themes

Gym Edge wordpress theme is one of the best template available for wordpress. This theme is suitable for a gym trainer or gym wishing to have a website. GymEdge has many features and pages like Classes, Schedules, Trainers, Blog, image gallery. It also has a shop to sell fitness products.

RATING : 10/10

DOWNLOAD   DEMO

 

gym wordpress themes

gym wordpress themes

 

 

2 GYM X – Gym WordPress Themes

Gym X is a responsive Fitness, gym and sport club theme for wordpress. This is a must have for a personal trainer to market his/her fitness classes. The wordpress template has features like trainer overview, trainer details, classes overview, classes details, schedule / timetables.

RATING : 10/10

DOWNLOAD   DEMO

gym wordpress theme

gym wordpress theme

 

3 GYM & FIT – Gym WordPress Themes

Gym X is a responsive Fitness, gym and sport club theme for wordpress. This is a must have for a personal trainer to market his/her fitness classes. The wordpress template has features like trainer overview, trainer details, classes overview, classes details, schedule / timetables.

RATING : 10/10

DOWNLOAD   DEMO

gym wordpress theme

gym wordpress theme

 

4 GYM & FITNESS – Gym WordPress Templates

This is a multi sports, gym and fitness website template – wordpress theme. This theme was created to support the fitness industry. We built it for Gym, Fitness Clubs, Personal Trainers, Health Centers and other sport and health related business and it is suitable for any kind of sport activity like Marathon event, Dance school, Boxing classes, Crossfit and Martial arts. The design is focused on quality, usability and functional features like events, classes, schedule / timetable, opening hours, accessible from shortcodes and widgets.

RATING : 10/10

DOWNLOAD   DEMO

gym wordpress themes

gym wordpress themes

 

5 FITNESS ZONE – Gym WordPress Themes

Fitness Zone WordPress theme is a must have for modern trend gyms, sport club or fitness centre and personal trainers. The heat needs to be felt. Gym trainers need to get this template for their awesome website. Easy to edit with a drag and drop option.

RATING : 10/10

DOWNLOAD   DEMO

gym wordpress themes

gym wordpress themes

 

Gym Trainers – Gym WordPress Themes

WordPress CMS is the best to use. Many entrepreneurs, startups, companies and personal trainers prefer to use wordpress as their website backend. I advise you to use these gym wordpress themes if you are a Fitness Coach.

 

I installed SSL but NO Padlock – WordPress Fix

SSL Installed but NO Padlock

No padlock can be seen on your SSL https website? Your SSL padlock disappears after some time? Fix the it to get High Google Rankings.

Scroll below to know how to fix this.

  • Q1 : I have installed an SSL certificate on my website, but no padlock can be seen. why?
  • Q2 : The padlock on my https website disappears a few seconds later. why?
  • Q3 : The padlock on my SSL website was working fine, but disappeared suddenly today. Why?




 

When SSL is installed, no padlock can be seen in the address bad. Here is the fix for it.

 

One of my clients (Johnson) who have his website running on WordPress CMS contacted me and said ” I installed SSL on my website but NO Padlock can be seen, Help me Yognel. ”

There are so many information available on the internet about this SLL Certificate & No Padlock problems.

 

At this stage, i assume that you have bought the correct SSL Certificate with the correct provider. And that you have installed it correctly as it should be. But still No Green Padlock.

SSL No Padlock

 

SSL Installed but NO Padlock. How to Fix?

[ 1 ] Go to this Website : https://www.whynopadlock.com/

 

[ 2 ] Place your Website URL in the Secure URL, then click Check. ( As shown below )

SSL Padlock

 

[ 3 ] If it tells you something is wrong with the links on your website, Download this HTTPS Plugin for WordPress. Install it in your WordPress Admin and Activate it.

 

[ 4 ] Select the options you see below and click Save Changes.

SSL No Padlock

 

[ 5 ] Now download the .htaccess file from your website root. Add the following codes and re-upload your .htaccess to the root of your website.

THE CODE: Header set Content-Security-Policy: upgrade-insecure-requests

SSL no padlock

 

[ 6 ] It’s done! You can now see your Green Padlock.

 

Get HTTPS Now & Increase your Google Rankings