pairBlog

Web Hosting Tips + Tricks + News

Category

Tutorials

featured image
How To, Tutorials

MySQL Basics: How to Delete a MySQL User

If you haven’t read the other installments in our MySQL blog series, we recommend you check them out: MySQL Basics: How to Create a MySQL User MySQL Basics: How to Create a MySQL Database Since the previous blog posts have already walked you through creating a MySQL user, you’re now prepared for the next step: deleting a MySQL user. Deleting a MySQL user is very simple. Unlike the process of creating a user, where you have to add permissions, deleting a user only requires you to enter the command and the username. Deleting a user from your MySQL database will…

Continue reading
MySQL Basics: How to Create Users featured image
How To, Tutorials

MySQL Basics: How to Create a MySQL User

Not familiar with MySQL? You may want to also check out our blog article, MySQL Basics: How to Create a MySQL Database. Why Would I Need Users in MySQL? Creating users is like creating login accounts for your database. If you want to give people access to work on your database, your best course of action is to create an account for them to log in on their own. You can then delete their account if they no longer need access. You can also limit their access by giving their account specific permissions. As the administrator, you can edit their…

Continue reading
How to Put Varnish Cache on WordPress featured image
How To, Tutorials, WordPress

How to Put Varnish Cache on Your WordPress Site

What is Varnish Cache? Varnish Cache is a web accelerator, which is used to speed up site loading times. So, how does it work? Well, a web accelerator acts as a proxy server that reduces the time it takes to access a website. A proxy server operates as a go-between for requests to the server. When a computer wants to load a site, it will contact the server and request the site’s information and resources. A proxy server intercepts those requests and processes them according to its instructions.

Continue reading
How To, Tutorials

Setting Up an .htaccess Redirect

What is a 301 Redirect? A 301 redirect reroutes site traffic from one place to another. If example1.com has a 301 redirect setup to send people to example2.net, all the visitors who type in “example1.com” will end up at example2.net, instead.   What are 301 Redirects Good For? 301 redirects are particularly useful for things like site maintenance and moving traffic to a new site.   Using a 301 Redirect for Site Maintenance Using 301 redirects for site maintenance allows you to reroute traffic from all over the site to a “Sorry, our site is down for maintenance” page. 301…

Continue reading
How To, Tutorials

MySQL Basics: How to Create a MySQL Database

What is SQL? SQL, or Structured Query Language, is a language that helps you interact with databases. Using SQL, you can set up databases, tear them down, fill them up with data, create inter-database relationships, and much, much more.   What are Databases? Databases are virtual structures that hold data. They are very efficient for data storage and retrieval. When a computer needs certain information, it will send a question to the database. This question is called a query. The database will search internally and give the computer the data that fits the query’s conditions. Ever wonder how a website…

Continue reading
How To, Tutorials, Web Hosting

Password Protect Your Site: Two Different Methods with Examples

Password Protect Your Site   Whether the reason is to restrict access to your team, protect sensitive content, keep your in-progress content hidden, or all of the above, a password can go a long way to ease the process (and your mind).   The nifty thing about password protecting your website is that it gives you control of the users. You can control who accesses what pages, what their passwords are, and, if the need arises, you can delete users completely so that they no longer have access to anything related to your site.   .htaccess: What is it? .htaccess…

Continue reading
Design & Development, Email, How To, Tutorials

All About SPF Records

SPF records list the authorized sending hosts for a particular domain name. A receiving mail client can then check that incoming mail comes from a host authorized to be sending mail from a particular domain. This allows mail clients to check that an e-mail’s sender address isn’t being spoofed.

Continue reading