Home / Tag Archives: mysql (page 3)

Tag Archives: mysql

February, 2010

  • 4 February

    Monitoring your server from your iPhone

    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 …

  • 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 …