Membuat Tables [Creating tables]

In this section of the mysql training course we will explore the MySQL commands to create database tables and selecting the database.
Databases store data in tables. So what are these tables?
In simplest terms, tables consist of rows and columns. Each column defines data of a particular type. Rows contain individual records.
Consider the following:

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.

Tutorial Step By Step Setting Mikrotik

MikroTik RouterOS™ adalah sistem operasi linux yang dapat digunakan untuk menjadikan komputer menjadi router network yang handal, mencakup berbagai fitur yang dibuat untuk ip network dan jaringan wireless, cocok digunakan oleh ISP dan provider hostspot.

Ada pun fitur2 nya sbb:

Hotspot Mikrotik

Begitu mudahnya untuk menggunakan mikrotik. Konsep networking yang sudah anda pahami akan sangat mudah di implementasikan di operating sistem router yang berbasis kepada linux kernel ini. Kali ini kita akan praktekan sebuah judul yang banyak di nanti orang banyak. Judul yang di ambil adalah, membuat hotspot dan user manager dengan router yang sama.

Memisahkan Bandwidth Lokal dan International menggunakan Mikrotik

Perubahan dari versi sebelumnya:

1. Proses mangle berdasarkan address-list
2. Pemisahan traffic Indonesia dan overseas lebih akurat

Semakin berkembangnya konten Internet lokal di Indonesia telah memberikan peluang bisnis baru dalam industri Internet di Indonesia. Saat ini banyak Internet Service Provider

Tutorial Mikrotik VPN : Point to Point Tunnel Protocol (PPTP)

PPTP (Point to Point Tunnel Protocol) supports encrypted tunnels over IP. The MikroTik RouterOS implementation includes support fot PPTP client and server.
General applications of PPTP tunnels:
* For secure router-to-router tunnels over the Internet
* To link (bridge) local Intranets or LANs (when EoIP is also used)

Mikrotik Web Proxy Setting for Transparant proxy

1. first se t web proxy
/ ip web-proxy
set enabled=yes –>> to make ip web proxy enable
set src-address=0.0.0.0 –>> to make source address to access web proxy will allow
set port=8080 –>> to make port for web proxy
set hostname=”proxy.war.net.id” –>> setting for visble hostname web proxy
set transparent-proxy=yes –>> make transparant proxy enable
set parent-proxy=0.0.0.0:0–>> if we used parent proxy x