Membuat Database [Creating a database]

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.

Installing MySQL on Linux

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:

Installing MySQL on Windows

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

Download MySQL

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.

Dasar MySQL dan Administrasi User

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)

Backup Mysql Tutorial

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.