Picture this. You’re on the go, traveling, working, going on a date, or even just taking a nap, and you suddenly start getting phone calls. Little do you know that those phone calls are from angry customers or your boss. The server went down two hours ago, but you had …
February, 2010
-
2 February
What is 127.0.0.1?
Question: I have been setting up my own server, and a lot of help documents refer to the 127.0.0.1 address. What is 127.0.0.1? Answer: 127.0.0.1 is the standard ip address assigned to the lookback network interface in IPv4. Because it is a standard, all server should conform to it, and …
January, 2010
-
20 January
Installing software on an OpenSolaris server
Continuing with our tour of server operating systems, today we will take a look at Sun Microsystems’ OpenSolaris, the free and open source version of the popular Unix-based Solaris OS. Those who experience with other Unix or Linux servers should find much of OpenSolaris familiar. Nevertheless, there are some key …
-
18 January
WampServer on Windows
We have spent a great deal of blog space learning about Linux servers and how to optimize them, but Linux is certainly not the only kid on the block. This week we will look at some other operating systems and how they interact with the Web. First up is Microsoft …
December, 2009
-
28 December
How to manually grant privileges in MySQL
There are plenty of reasons why you might want to grant various privileges to a user in MySQL manually rather than with a control panel or phpMyAdmin. But regardless of the reason, the process is quick and easy, once you learn how to do it. For this you will need …
-
21 December
How to create a MySQL database in cPanel
Question: How can I use cPanel to create a MySQL database? Answer: cPanel uses its own web-based frontend to make database creation very easy. Just follow these simple steps: 1. Login to cPanel 2. Under the Databases section, click “MySQL Databases” 3. Where it says “Create New Database” enter a …
November, 2009
-
26 November
Restoring a huge MySQL database
Question: I have a shared hosting account but need to import a 3GB MySQL database. I do not have shell access, and phpMyAdmin always times out. How can I restore it? Answer: You can use a script called BigDump to import your dumped MySQL database a little at a time. …
-
10 November
Changing the MySQL root password
Question: How do I change my MySQL root password on my dedicated server? Answer: If you have never set the password for MySQL, the server will allow you to connect as root without any password at all. This is obviously not secure and needs to be fixed. Consider it an …
October, 2009
-
28 October
Database Management with phpMyAdmin
Question: I have a shared hosting account and need an easy way to manage my databases. What can I use? Answer: Chances are, if you are using a server that has both PHP and MySQL, your web hosting provider has given you some type of tool to manage your databases. …
-
16 October
Linux Dedicated Server Logs
Question: Where do I view logs on my dedicated server? Answer: Most of the logs on a Linux operating system are kept in the /var/log directory. There you will find logs for the main system, kernel, network, hardware, Apache, MySQL, and often times other third-party applications that you might happen …