web analytics

When you own a Cheap VPS, generally speaking, you might not have a control panel to work from, so installing web applications such as Wordpress or Joomla takes a bit more work to get setup. One of the steps is to create your MySQL Database where the data will reside. This tutorial will walk you through a basic SSH workflow in creating your MySQL database via command line.

After opening the terminal and connecting to your VPS server, you will want to enter into MySQL by typing the following command in your terminal:

$ sudo mysql -u root -p

You will be prompted for the password to authenticate. You should now be at the following prompt:

mysql>

To see a list of current databases, type:

SHOW DATABASES;

The output should be close to this, but with your databases in the list:

mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.01 sec)

To create a new database, you just enter:

CREATE DATABASE databasename;

where "databasename" is the name of your database.

If you ever need to delete a database, enter:

DROP DATABASE database name;

Free CPanel Alternative

Virtualmin (GPL) is a free alternative to CPanel that we use on almost all of our servers. It's robust, faster than CPanel and uses less resources.

 

We've decided to write up a quick tututorial for everyone to follow.
Note --This setup uses Webmin/Virtualmin GPL, which is 100% Free. 

Become Root:

user@ubuntu:~$ sudo -s

[sudo] password for user: your-password

root@ubuntu:~#

Read more ...

From my notes for how to set up a cheap, low memory Virtual Private Server that can run multiple instances of the WordPress blogging platform.

Why? Shared hosting is okay, but you are limited in your control over the resources on your account. Sharing a server is also sharing resources, and if someone is using their hosting account for videos, large flash or MP3 streaming, you could see a significant drop in performance. Another significant downside is not having the ability to configure the server based on the applications that you want to run.

A Virtual Private Server, or VPS gives you complete control (known as Root access) over your server. The virtual server sits on a physical server, but acts independently of the physical server, and the other VPS instances also residing on the physical box.

The following instructions show you how to set up your own WordPress blog on a low memory VPS for free. You have root access and you wont have to worry about other shared users hogging all the resources of the server. The following instructions will automatically configure the server for WordPress, and you will be able to set up multiple instances of WordPress on the server. The number of instances can vary depending on how much traffic your websites receive.

 

Tip: If you want a 100% free domain name go to http://dot.tk to get it!

Note:

The # sign is what your terminal displays for the command prompt to signify the terminal is waiting for you to type a command.

The means you have to wait for the command to execute. You’ll know when the process is done when you see the # display again on the next line.

Download the SSH client Putty or similar http://bit.ly/ui5DpU

1. Purchase a VPS Server

2. Deploy a Debian/Ubuntu VPS

3. SSH as Root using SSH Client and type:

# apt-get update

# apt-get upgrade -y

 

4. Enter the following commands at the prompts:

 

# wget http://wbhst.us/setupdebian

# bash setup-deb.sh system

# bash setup-deb.sh exim4

# bash setup-deb.sh nginx

# bash setup-deb.sh mysql

# bash setup-deb.sh php

5. Your system is now ready for the first instance of WordPress to be installed.

Type the following command, replacing the example.com with your domain name.

# bash setup-debian.sh wordpress example.com

6. Change the ownership of the files – this is done so WordPress can install plugins and themes

#chmod -R www-data:www-data /var/www/example.com

Now you can open a browser and type in your domain name. Your new instance of WordPress will be waiting for you to set the site configuration values (Site name, admin name, password, etc…)

The database is already set up.

7. To add more WordPress sites, just re-run the command (replace nextexample.com with your next domain name:

# bash setup-debian.sh wordpress NextExample.com

That’s it! All Done.

How to install a VPS FireWall using Config Server Firewall (CSF)

ConfigServer FireWall in a common linux firewall security suite. CSF is a more advanced firewall with more options than standard firewalls, such as AFP iptables.

ConfigServer Firewall is relatively easy to install and configure for intermediate Server Administrators, and comes with a security plugin, LFD or Login Failure Daemon.

You first must remove AFP or other firewalls. If you have AFP, find and identify the AFP package name:
rpm -qa |grep -i apf

In this example, we can see that is as shown below:
[root@host ~]# rpm -qa | grep apf
apf-9.6_5-1

Read more ...

Complexity Level: Beginner

This quick and really easy tutorial will stop all logins through your SSH Damon by the root user. In the interest of security, this is one of the first things you should be doing when you setup a new server.

Hackers try to brute force the Root account and gain full access to the server, so it is also recommended to switch from port 22 to a non-standard port to make it a little more difficult for the Hacker.

Rather than user the root account when you login into your server through SSH, you should use a normal user login and "Sudo" or "su" to elevate to 'super user'. This allows you to perform tasks that require root permissions.

At the command prompt:
#nano /etc/ssh/sshd_config

and change the line
PermitRootLogin yes
to
PermitRootLogin no

Then you will want to change the port from 22 to some other unused port, such as 2130 for example.

In the same file that you opened above, look for this line:
# What ports, IPs and protocols we listen for
Port 22
and change to:
# What ports, IPs and protocols we listen for
Port XXXX

where port XXXX is a 4 digit number for an unused port.

Installation and Configuration of Uncomplicated FireWall (UFW)

Ubuntu Server Beginner Tutorial

UFW is a simple command line interface to add or remove firewall rules to the iptables, the default Linux frewall.

As of Ubuntu 10.04, IPTables is not enabled by default on a fresh installation, leaving your server open for attack. In this tutorial, We will install and configure uncomplicated firewall to protect your server from malicious attacks. This is known as a step in 'server hardening'.

Read more ...

Don't Know Which Host Is Best?

confused

CONFUSED?

Don't know which web host to use for your next website? Don't worry, it happens all the time! You know what you want your website to be and do, but you don't know what's going to work when it comes to hosting. That's ok. 

Let Our Team Of Hosting Experts Work For You

We take your requirements and go to the hosting providers to get you the best hosting for your hard earned cash based on your needs and wants. Usually it takes four or five hours to do a proper shopping comparison, but we'll do this for you 100% FOR FREE!

GET A RECOMMENDATION NOW!




inmotion hosting wordpress web hosting