Browse Our MySQL Archive :

Globat Tutorial – How To Create a MySQL Database

Globat Tutorial – Learn how to create a MySQL database using Globat’s control panel.

Plesk Basics: How To Create a MySQL Database

Since signing up with ZipHosters.com, I got the chance to try out Plesk (a web hosting control panel) a little more. I am using Parallels’ control panel for my VPS but I didn’t try out Plesk a lot.
In this post, I’m going to show you how to create a MySQL database. I’ve already done some [...]

How To Create a MySQL Database with DirectAdmin

While less known than cPanel and Plesk, DirectAdmin is a very good hosting control panel. A few days ago, I’ve made a post on How To Create a MySQL Database Using cPanel so this time around, I’m going to show DirectAdmin users how to do the same thing.

cPanel Basics: How To Create a MySQL Database

One of the most common step in installing a web application is to create a MySQL database. And while the process may seem simple to most experienced users, a lot of people can struggle with it.
So for all the cPanel users out there who don’t know how to create a MySQL database properly, here’s how [...]

How To Install Your Own Web Server – Installing phpMyAdmin

This is finally the last post of this series on How To Install Your Own Web Server. In my last post I’ve shown you how to setup a virtual host and now we’re going to use this to install phpMyAdmin.
Of course, the purpose of this tutorial is not really to install phpMyAdmin but it’s rather [...]

How To Install Your Own Web Server – Adding A Virtual Host

In my last post of this series, I’ve shown you how to create a MySQL database using the GUI tools. In the fifth part of this tutorial, we’re now going to see how to add a virtual host.
What Is A Virtual Host?
A virtual host allows your web server to serve multiple websites from a unique [...]

How To Install Your Own Web Server – MySQL Database Management

Unfortunately I haven’t seen any good web hosting control panel for Apache on Windows (if you know some, leave a comment!). So that’s why we’re going to need something else to manage the MySQL server.
MySQL provides a set of GUI tools that allows you to perform such tasks as managing databases, managing database users, configuring [...]

How To Install Your Own Web Server – Installing PHP

In the third part of this tutorial, we’re now going to install PHP 5 on Windows.
In the two previous posts, we’ve seen how to install Apache and MySQL on a Windows computer so you you should already have a working web server and database server.

How To Install Your Own Web Server – Installing MySQL 5

This is the second part of our tutorial on how to install your own home web server. In the first, you’ve seen how to install Apache HTTP Server on Windows. Now we’re going to see how to install MySQL, a free database server.
MySQL comes in two flavors: Enterprise Edition and the MySQL Community Server. Of [...]

How To Install Your Own Web Server – Installing Apache HTTP Server

Sometimes I like to have my own web server, whether it is for testing or development purposes. Since I use Windows XP or Vista on my personnal computer, my favorite setup is Windows, Apache, PHP and MySQL. This setup is also known as WAMP. And maybe you guessed it, the Linux equivalent of this setup [...]

How To Install MySQL 5.x On Windows 2008 Server (Video)

Lately I’ve made a post on how to install MySQL on Windows 2008. I’ve decided to turn it into a video so it would be easier to see how it’s done.
Installing MySQL on Windows 2008 is pretty much the same as with any other versions of Windows so you can apply this to Windows 2003, [...]

How To Install IIS 7, PHP5 and MySQL 5.1 on Windows Server 2008 – Part 3

Now that we have installed PHP 5 on IIS 7 successfully, we’re going to install MySQL Server 5.1.

First of all, get yourself a copy of the MySQL Server 5.1 ZIP Setup from http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.22-rc-win32.zip/from/pick#mirrors
Extract all the files from the archive and launch Setup.exe
I’ve chosen to use the Typical Setup but feel free to customize the installation [...]

How To Install IIS 7, PHP5 and MySQL 5.1 on Windows Server 2008 – Part 2

Following up on my last post, I’ve now got a working IIS 7 web server running on Windows 2008. We’re now going to install PHP5 and MySQL 5.1.
Installing PHP5 on IIS 7
First of all, grab yourself a copy of PHP over at http://www.php.net/downloads.php. I always use the zip package, I never use the installer. The [...]

How To Install IIS 7, PHP5 and MySQL 5.1 on Windows Server 2008 – Part 1

I’ve just got myself an evaluation copy of Windows 2008 Server out of curiosity. I’ve installed it on VMware Workstation 6 running on a Windows Vista computer. While a virtualized Windows 2008 Server is a sucker on resource, it’s performance is still acceptable for those who just want to try it out like me.
Let’s see how to install PHP5 [...]

How To Backup And Restore A MySQL Database Through Command Line

Most of the time, you can easily manage your database with web-based tools such as phpMyAdmin. Unfortunately there are times when you need to restore a large amount of data which can’t be done through phpMyAdmin because if PHP’s limits (either the maximum time a PHP script can use or the maximum file size upload).

 
 
 

Tutorials by Category

 
 
 
 

Recent Comments