Membuat Database [Creating a database]

October 30, 2008

In this section of the MySQL primer we will learn how to create a database.

The commands for creating a database in Windows and Linux are the same. However, the prelimnary commands in Linux are slightly more complex. Since this tutorial is meant for the complete newbie, I’ll discuss the Windows and Linux systems separately. Read the rest of this entry »


Installing MySQL on Linux

October 30, 2008

It’s simple to install MySQL on Linux using the RPM file.

  1. Become the superuser if you are working in your account. (Type “su” and the prompt and give the root password).
  2. Change to the directory that has the RPM download.
  3. Type the following command at the prompt: Read the rest of this entry »

Installing MySQL on Windows

October 30, 2008

Once you have successfully downloaded the Windows version, installing it is a breeze… trust me!

(The installation steps below have be tested on Win95 and Win98 using mysql-shareware-3_22_34-win.zip Read the rest of this entry »


Download MySQL

October 30, 2008

Downloading MySQL

MySQL is available for Windows, Linux and other Unix variants. The Windows version is a shareware, which must registered after evaluation. I learnt SQL using this version. Later I shifted completely to Linux…. the Linux version is 100% free.

Read the rest of this entry »


Dasar MySQL dan Administrasi User

October 27, 2008

Mengenal MySQL
Apa itu MySQL?

MySQL adalah salah satu jenis database server yang sangat terkenal.
MySQL menggunakan SQL sebagai bahasa dasar untuk mengakses databasenya.
Selain itu, MySQL bersifat free (Anda tidak perlu membayar untuk menggunakannya) pada pelbagai platform (kecuali pada Windows, yang bersifat shareware) Read the rest of this entry »


Backup Mysql Tutorial

October 13, 2008

This tutorial explains the how to backup and restore the MySQL Database. Databases are used to store large amount of precious data and it becomes very important to Backup your data. In case case of some hardware or software failures backup data can be used to restore the Database. Read the rest of this entry »