Menu

Menu

Our Blog

The latest post from us

What is SSL?

SSL stands for Secure Sockets Layer. It’s an internet protocol for securing data transfer between a user’s browser and the website they are visiting.

Every internet user transfers information when they visit websites. This information can often be sensitive like payment details, credit card information or login credentials. SSL allows encrypted data transmission and prevents it access to an outsider. For creating an SSL connection, a server needs an SSL certificate.

Websites using SSL need a SSL certificate issued by one of the recognized certificate issuing authority. This certificate is verified and highlighted in user’s browser address bar with a padlock sign and HTTPS instead of HTTP.

Do you want to get a free SSL certificate for your WordPress website? You need a SSL certificate to accept online payments and secure your website. In this article, we will show you how to easily get a free SSL certificate for your WordPress website.

Why do you need a SSL Certificate for your WordPress website?

The only website which is 100% secure is the one which does not exist. All sites are prone to attacks by hackers, but as a webmaster, your job is to minimize the possibility of attacks. You must take neccessary measures to keep your website secure.

SSL / HTTPS is recommended for all websites on the internet. However it is absolutely required for all websites that collect user information like login information, payment details, credit card information and more. Most online payment service also require your website to use SSL/HTTPs before you can receive payments.

If you are running an online store, a membership website, or require users to log in, then you need to get an SSL certificate right away.

Last, if your website is not using a SSL certificate, then Google Chorme will show your users that your website is not secure.

SSL Certificate

click here to continue >>

Adding Custom Fonts to WordPress via Plugin

In this article, we will go over how to use Easy Google Fonts. Which is one of the most popular plugins in this area.

1. Install the Plugin

The first step is installing the plugin. To do that, head on over to Plugins > Install New. Then, search for the plugin’s name. In the search results, click on Install Now and activate the plugin once it’s on your site.

Adding Custom Fonts via Plugin

2. Add/Change Fonts on Your Site

When the plugin is active, you find a new menu called Typography under Appearance > Customize.

When you click on it and choose Default  Typography, you find a list of controls to change the font of your paragraphs and headings.

Using them is really simple. Just click on the drop-down menu where it says Edit Font for the part of your site you want to change it for. This gives you access to this menu:

Here, the most important part is the one under Font Family. Here, you can choose a new font type from the entire Google Font library.

The fonts are ordered by standard, serif, sans-serif, display, handwriting and monospace fonts. However, you can also simply search them by name.

When you click on a font, you can preview the changes on the right.

3. Configure the Font

Once you have chosen a font, there are many options to further customize your typography.

First of all, you can change the Font Weight/Style under the menu of the same name. This controls the thickness of the letters.

Furthermore, under Text Decoration, you are able to add underline, line-through and overline. Text Transform also allows you to set it to uppercase, lowercase or capitalize every first letter. Under the Appearance tab on top, you may also control font color, background color, font size, line height

Finally, Positioning lets you change other settings such as margin, padding, border, border radius and display.

In short, you should be able to customize the fonts on your site completely to your liking. Easy, isn’t it? Don’t forget to hit Save & Publish at the top when you are satisfied with your changes.

Other Custom Fonts WordPress Plugins

There are also other WordPress plugins available for adding custom fonts:

By now, you are able to customize your WordPress site’s typography at will. This is not only great for the design but also a big leap in your WordPress skills.

Do you have additional thoughts and tips on how to add custom fonts to WordPress? If so, please share in the comment section below.

So far, we have only talked about how to use custom fonts in WordPress that are hosted somewhere else, namely the servers of Google. However, it’s also possible to host fonts on your own site and offer them to visitors’ browsers from there.

3. Using @font-face

To do this, you first need to download the font in question. When you do, make sure you get it in a web font format. That means TTF, OTF or WOFF. You will find more information about it here.

Once you have your font files ready, you need to upload them to your WordPress site via FTP. A good place to store them is in a subdirectory of your child theme named fonts.

After that, you need to load the font in your style sheet via @font-face. Here’s what it looks like:

@font-face {
font-family: Roboto;
src: url(https://localhost/wordpress/wp-content/themes/twentyseventeen-  child/fonts/Roboto-Regular.ttf);
font-weight: normal;
}

Remember to replace the name of the font and address for its location on your own site. After that, your new custom font will be usable.

4. Enqueueing Fonts – The “WordPress Way”

If you truly want to add custom fonts to WordPress in the correct way, you will use your function.php file and the fuction wp_enqueue_script or wp_enqueue_style.

With their help, we can take the code snippets provided by the font sites. However, instead of copying theme into a file, we will add them to the header via a function.

What’s the difference between wp_enqueue_script and wp_enqueue_style? As their names suggest, one is for adding scripts, one for style sheets. Which one is right to use depends on how your custom fonts are provided from their source.

For example, Google Fonts gives you fonts as style sheets. In that case, you would add them to your WordPress site this way:

function add_google_fonts() {
wp_enqueue_style( ‘google_web_fonts’, ‘https://fonts.googleapis.com/css?         family=Open+Sans|Roboto’ );
}
add_action( ‘wp_enqueue_scripts’, ‘add_google_fonts’ );

In contrast to that, fonts from Adobe Edge Web Fonts come as JavaScript. Therefore, to enqueue them on your site, the code would look like this:

function add_adobe_fonts() {
wp_enqueue_script( ‘adobe_edge_web_fonts’, ‘//use.edgefonts.net/open-sans.js’ );
}
add_action( ‘wp_enqueue_scripts’, ‘add_adobe_fonts’ );

Wasn’t so difficult, was it? You now know how to add custom fonts to WordPress manually. Congratulate yourself. Obviously, same actions are possible via plugins. That’s what we will talk about next.

In this article, we will show you how to add custom fonts to wordpress manually and via plugin.

How to Add Custom Fonts to WordPress Manually

When it comes to adding custom fonts to WordPress by hand, you have three main options: HTML, JavaScript and CSS. There are pros and cons to each method and which one is the right one for you depends on your setup. Don’t worry, we will go through each of them in detail.

1. using css and @import

If you plan to install custom typefaces from Google Fonts, you might have noticed that it has a tab labeled @import. The service gives you a piece of CSS code.

To embed your selected fonts into a webpage, copy this code into the <head> of your HTML document. Or copy without the <script> brackets to the beginning of your theme’s (or child theme’s) style.css file.

Seems like a simple solution, right? But this is the least recommended method. Why?

The reason is the performance issues. Using @import is no longer the recommended way to go because it prevents browsers from downloading several style sheets at once. The consequence: slower page loading times. Stay away from it if you can.

2. Using a wordPress template file

A second method to get the fonts on your site is to take the code provided by the font libraries and copy it in your header.php template file. Most standard WordPress themes have it.

Make sure to place it somewhere between the <head> and </head> brackets. That way, your font will load whenever a page is loaded.

If you are using a child theme, be sure to copy the parent theme’s header.php file into the child theme directory and make the changes in there.

Some themes come with settings allowing you to add custom to your header and footer via the backend. This is also a viable option.

click here to continue >>

Add Custom Fonts to WordPress

Custom fonts can help you freshen up your theme and stand out. Like colors, images and other elements, typography plays a big part in how your site is perceived by visitors. You can use pretty much any free custom font on your WordPress site you want.

In this article, we will show you how to add custom fonts in WordPress.

Using custom fonts in WordPress themes has become a common trend. However loading too many fonts can slow down your website. This is why you should select two fonts and use them throught your design. This will also bring consistency your design.

How to Find Custom Fonts to Use in WordPress

Fonts used to be expensive, but not any more. There are many places to find great free web fonts such as Google FontsTypekitFontSquirrel, and fonts.com.

  1. Use Google Fonts to Find  Custom Typography
    As the name suggests, it’s a service by Google that offers 800+ different fonts. Free to use. For everyone.
    Add Custom Fonts
  2. Additional Sources for Custom Fonts
    Google Fonts is not the only service of their kind. We have other options to find custom fonts for our WordPress sites.
  • Font Squirrel: A large collection of free fonts with different licenses. The site has many filter options including type of application, categories, number of styles and more. It also offers a font identification service. Just upload an image and find fonts that match.
  • Fonts.com
  • MyFonts
  • 1001 Free Fonts

Why Use Custom Fonts on Your WordPress Website

Typography is a science in itself. After all, it’s not just about the font but also its size, slant, thickness and a lot of other things. Using custom fonts on your WordPress site is a good idea.

Typography is part of the first impression

First of all, the font you use influences a lot of how your site is perceived. Is your site fun and playful? Are you a blogger professional? Visitors decide this within one glance and your typography plays a big role in their perception.

click here to continue >>

To create a new admin account. For developers who want to speed this process up, you will need to do this by interacting directly with database. Below is a step by step guide for doing just that.

Creating a new admin account via MySQL

  1. To begin, log into your cPanel interface.
  2. From the main cPanel screen, find the Databases category and click on the icon entitled phpMyAdmin.
    add admin via mysql
  3. Once the first screen appears, look to the left hand sidebar and click on the database for your specific WordPress installation. If you do not know which database is the correct one, you can review step 1 in the previous article.
  4. After the database information loads, you will need to find the tab named SQL and click on it.
  5. This leads you to an SQL editor where you will enter some code that will creat a new admin account for you. Below is the code to create a new admin account named admin with the password admin123. You may change any content that has underlining red to fit your needs, but leave all other data as is.
  6. After replacing any data fields you need, click the Go button to perform the insertion
  7. This should simply refresh the screen and you should see the message ‘1 row affected’ after each of the three SQL statements. This means the insertion ran smoothly. From here, visit your wordpress admin login area as normal and use the new admin login information. You should get to the admin interface without issue.

 

Note: the following instructions assume that your database table prefix is set to “wp_“. If you are using something different, then make sure to adjust your code accordingly. For example, if you are using “wptables_”  instead of “wp_“, then the code INSERT INTO `wp_users`”  would be “INSERT INTO `wptables_users`”.

As you can see from previous posts, phpMyAdmin is a powerful tool which every WordPress user and website owner should be familiar with. It enables you to perform complex operations without the need of learning to write SQL commands.

Knowing your way around the database administration tool can make running your website a lot of easier. Save you a lot of nerve and gooling in case of a crisis.

In this article, we will show you a step by step guide on how to create an admin user in WordPress Database via phpMyAdmin. (Note: You should always make a backup of your database before performing any MySQL edits. This tutorial requires basic understanding of how phpMyAdmin works.

Add an Admin User

  1. First, you need to login to phpMyAdmin and locate your WordPress database. Go to cPanel > File section > File Manager menu. Find the wp-config.php file. Right-click on the file and select View or Edit option :
    Add an Admin UserYou will see the database name in this line:
  2.  Go to phpMyAdmin menu in the Databases section. Click on the name of your database to expand the list of the tables and select wp_users table:
  3. Go to the Insert tab:
    Fill in the following information:
    ID: select any number you wish to assign to the user
    user_login: username you want to use
    user_pass: password for this user to access WordPress admin dashboard. You need to select MD5 from the drop-down menu in the Function column
    user_nicename: you can set a nickname here
    user_email: contact email of the new user
    user_url: your website url
    user_registered: date and time for when this user is registered
    user_status: set this to 0
    display_name: name, that will be displayed on the website
    Once all the fields are filled in, click the Go button
  4. Now, go to the wp_usermeta table. And go to Insert tab
    In the first form, fill in the following information:unmeta_id: leave this blank (it will be auto-generated)
    user_id: ID you used for the user while adding it to wp_users table
    meta_key: set it to wp_capabilities
    meta_value: put the following:
    a:1:{s:13:”administrator”;s:1:”1″;}Fill the form below with the following details:
    unmeta_id: leave this blank (it will be auto-generated)
    user_id: ID you used for the user while adding it to wp_users table
    meta_key: input following -> wp_users table
    meta_value: insert following -> 10

Once all the fields are filled in, click the Go button at the bottom.

Now, you can access your WordPress admin dashboard using these new user details.

click here to continue >>

Dropping tables

Deleting or dropping a table can be necessary if you want to import a backup file and need to make space. In other cases deleted plugins sometimes leave tables in your database that are no longer used. However, you need to be sure you know what you are doing before dropping a table as this can potentially break your entire site!

If you are, here is how to do it:

  1. In your database, mark the table or tables you want to delete via check box on the left.
  2. In the drop-down menu at the bottom, choose “drop”.
  3. You will then be taken to a confirmation screen. If you choose “yes”, the table will be delete irreversibly.

Dropping An Entire Database

You can not only drop tables one by one, but you can also get rid of a database all at once. A case where that might be neccessary is when you have moved your site to another server and no longer need the database. Of course, only drop it if you have successfully exported and imported the database to its new location.

  1. Click on “Databases” to view all databases in your account.
  2. Mark the checkbox of the database you no longer need. Double check that the tick mark is in the right place!
  3. At the bottom of the list, click on “Drop”. A confirmation prompt will pop up. If you press “ok”, the database in question will be history.

Copying Your Database

Making a copy of your database is a good idea if you are setting up a development environment to test out themes and plugins before introducing them to your live site. It’s done quickly within phpMyAdmin by choosing your database and going to “Operations” > “Copy database to:”.

Replacing The Table Prefix

For security’s sake,it is a good idea to use a different table prefix for your WordPress install than the default “wp_”. However, if you have forgotten to change this during the install, phpMyAdmin can help you remedy the situation by replacing “wp_” with something else via the bottom menu. Just make sure you also update wp-config.php to reflect the change.

In Short: phpMyAdmin, The WordPress User’s Best Friend.

 

Optimizing your WordPress Database in phpMyadmin

After using WordPress for a while your database becomes fragmented. Because  over time memory overheads which increases your overall database size and query execution time. You can see it in the right column when looking at your database. Optimizing Database

Optimization means clearing up this data and should be done regularly. Optimizing your database with phpMyadmin is really easy:

  • Access the database you want to optimize. Click on the “check all” box at the bottom of the screen to mark all tables within that database.
  • Use the drop-down menu on the right to select “Optimize table”.
  • Depending on your version of phpMyadmin you might have to click on “Go” to start the optimization process.
    Done! This will optimize your WordPress tables by defragmenting tables. It will make your WordPress queries run a little faster and slightly reduce the size of your database.

CHECKING AND REPAIRING TABLES

Sometimes tables will crash. It’s not pretty and might result in all of your posts or drafts disappearing or cause some other kind of mayhem. However, oftentimes phpMyadmin can repair the table and everything will go back to normal.

If something is amiss on your website, you might first to check if any of the tables in your database is at fault:

  1. Open the database in question.
  2. Select all tables by clicking on “check all” at the bottom of the screen.
  3. Use the drop-down menu to choose “check table”. You might also have to click the “Go” button at the bottom to start the process.
    phpMyAdmin will show a page with the results. In the right column you will be able to see if your tables are deemed OK or not.Should any of theme exhibit a problem, repairing it is just as easy as optimizing:
  4. Mark the tables that needs to be repaired by checking their boxes.
  5. From the drop-down menu, choose “Repair table” to start the process. Alternatively, you might have to click on “Go” to get it going.

Renaming Your Database

Should you ever need to rename your database, that is entirely within the scope of phpMyAdmin. You can find that option under “Operations” while viewing your database. If you do rename it, make sure the data within your website’s wp-config.php gets updated accordingly.

click here to continue >>

Creating the WordPress Database

Creating a database for your fresh WordPress install is most commonly the gateway for people to use phpMyAdmin for first time.

To install WordPress, on the database side you will need the following:

  • A database name
  • Username of database
  • User password of database

Let’s see how we can set up all of these in phpMyadmin:

  • A click on “Databases” will bring you to the following menu:
    Create Database
  • Pick a name for your database and enter it in the “Create Database” field. Choose something that describes what the database is used for, it will be very helpful when you have more than one database running in the same place.
    Next, choose a collation from the drop-down menu. Pick the one that fits best for your language and encoding. In most cases you should go with “utf8mb4_general_ci” for coding.
    Create Database_languageWhen you are done with this, click the “Create” button. The new database should then appear in the list.

Add user

  • Next up you will have to create a user who has all access privileges to your newly created database. There are several ways to do so. The one that i find most convenient is to click on your newly created database. From there pick “Privileges.”
    Clicking on “Add user account” will lead you to the screen where you can create a dedicated user for that database. Enter a user name in the respective field (make sure that “Use text field:” is selected from the drop-down menu) and then enter a hard-to-guess password. Again, make sure it says “Use text field” in front of it and don’t forget to write everything down so you don’t forget!
    The “Host” field will most often be filled with “localhost”, however, you have to check with your provider for this.
    Under “Database for User” make sure that the checkbox that says “Grant all privileges on database [your database name]” is enabled.
    Create_userNow click “Go”
    Create_Database_doneCongratulations, you now have the database name, username, and password you will need to install WordPress.

Continue >>