Make YM ID Status in your Blog

In this time i will try to write about "How to show YM ID status offline/online in your Blog".why we want to show our status?ok let think about this if in our blog there are a sign about your status , they can chat with you directly. and because of that your visitor more love you.

this is the step :
1. Login into your blogger.
2. click layout --> Add a Gadget --> HTML/Javascript
3. Copy this script :
<a href="ymsgr:sendIM? ainun "> <img src="http://opi.yahoo.com/online?u= ainun &amp;m=g&amp;t= 2 &amp;l=us"/>

</a>
4. and paste in your script.
5. save and look at your view.

DROP USER Database MySQL

The DROP USER statement removes one or more MySQL accounts. It removes privilege rows for the account from all grant tables. To use this statement, you must have the global CREATE USER privilege or the DELETE privilege for the mysql database. Each account is named using the same format as for the GRANT statement; for example, 'jeffrey'@'localhost'. If you specify only the user name part of the account name, a host name part of '%' is used. For additional information about specifying account names, see Section 12.5.1.3, “GRANT Syntax”.

With DROP USER, you can remove an account and its privileges as follows:

DROP USER user [, user] ...

example :

DROP USER ainun;

Important

DROP USER does not automatically close any open user sessions. Rather, in the event that a user with an open session is dropped, the statement does not take effect until that user's session is closed. Once the session is closed, the user is dropped, and that user's next attempt to log in will fail. This is by design.

DROP USER does not automatically delete or invalidate any database objects that the user created. This applies to tables, views, stored routines, triggers, and events.

How-To create a MySQL database and set privileges to a user

MySQL is a widely spread SQL database management system mainly used on LAMP (Linux/Apache/MySQL/PHP) projects.

In order to be able to use a database, one needs to create: a new database, give access permission to the database server to a database user and finally grant all right to that specific database to this user.

This tutorial will explain how to create a new database and give a user the appropriate grant permissions.

Here's an example of what I did recently to actually create a new database and user. Of course the database name, username, and password have been changed:

mysql -u root -p
(here I enter 'my_root_password' to get through the mysql prompt)

create database my_database;

GRANT ALL PRIVILEGES 
ON my_database.* 
TO 'my_user'@'localhost'
IDENTIFIED BY 'my_password' 
WITH GRANT OPTION;

All of this is pretty much straight from the manual, but hopefully one more example helps.

Yang ter ...............

Di saat menuju jam-jam istirahat kelas, dosen mengatakan pada
mahasiswa/siswinya:
"Mari kita buat satu permainan, mohon bantu saya sebentar."

Kemudian salah satu mahasiswi berjalan menuju pelataran papan tulis.

DOSEN: Silahkan tulis 20 nama yang paling dekat dengan anda, pada papan
tulis.
Dalam sekejap sudah di tuliskan semuanya oleh siswi tersebut. Ada nama
tetangganya, teman kantornya, orang terkasih dan lain-lain.
DOSEN: Sekarang silahkan coret satu nama diantaranya yang menurut anda
paling tidak penting!
Siswi itu lalu mencoret satu nama, nama tetangganya.
DOSEN: Silahkan coret satu lagi!
Kemudian Siswi itu mencoret satu nama teman kantornya lagi.
DOSEN: Silahkan coret satu lagi!
Siswi itu mencoret lagi satu nama dari papan tulis dan seterusnya. Sampai
pada akhirnya diatas papan tulis hanya tersisa tiga nama, yaitu nama orang
tuanya, suaminya dan nama anaknya.

Dalam kelas tiba-tiba terasa begitu sunyi tanpa suara, semua mahasiswa/siswi
tertuju memandang ke arah dosen, dalam pikiran mereka (para siswa/i) mengira
sudah selesai tidak ada lagi yang harus dipilih oleh siswi itu. Tiba-tiba
dosen memecahkan keheningan dengan berkata, "Silahkan coret satu lagi!"
Dengan pelahan-lahan siswi itu melakukan suatu pilihan yang amat sangat
sulit. Dia kemudian mengambil kapur tulis, mencoret nama orang tuanya.
DOSEN: Silahkan coret satu lagi! Hatinya menjadi bingung. Kemudian ia
mengangkat kapur tulis tinggi-tinggi.lambat laun menetapkan dan mencoret
nama anaknya. Dalam sekejap waktu,terdengar suara isak tangis, sepertinya
sangat sedih.

Setelah suasana tenang, Dosen lalu bertanya "Orang terkasihmu bukannya Orang
tuamu dan Anakmu? Orang tua yang membesarkan anda, anak adalah anda yang
melahirkan, sedang suami itu bisa dicari lagi. Tapi mengapa anda berbalik
lebih memilih suami sebagai orang yang paling sulit untuk dipisahkan?"

Semua teman sekelas mengarah padanya, menunggu apa yang akan di jawabnya.
Setelah agak tenang, kemudian pelahan-lahan ia berkata "Sesuai waktu yang
berlalu, orang tua akan pergi dan meninggalkan saya, sedang anak jika sudah
besar setelah itu menikah bisa meninggalkan saya juga, Yang benar-benar bisa
menemani saya dalam hidup ini hanyalah suami saya".

SEBENARNYA, KEHIDUPAN BAGAIKAN BAWANG BOMBAI, JIKA DIKUPAS SESIUNG DEMI
SESIUNG, ADA KALANYA KITA DAPAT DIBUAT MENANGIS

Baju dan Kuda

Nasrudin diundang berburu, tetapi hanya dipinjami kuda yang lamban.
Tidak lama, hujan turun deras. Semua kuda dipacu kembali ke rumah.
Nasrudin melepas bajunya, melipat, dan menyimpannya, lalu membawa
kudanya ke rumah.

Setelah hujan berhenti, dipakainya kembali bajunya. Semua orang
takjub melihat bajunya yang kering, sementara baju mereka semuanya
basah, padahal kuda mereka lebih cepat.

"Itu berkat kuda yang kau pinjamkan padaku," ujar Nasrudin ringan.

Keesokan harinya, cuaca masih mendung. Nasrudin dipinjami kuda yang
cepat, sementara tuan rumah menunggangi kuda yang lamban. Tak lama
kemudian hujan kembali turun deras. Kuda tuan rumah berjalan lambat,
sehingga tuan rumah lebih basah lagi. Sementara itu, Nasrudin
melakukan hal yang sama dengan hari sebelumnya.

Sampai rumah, Nasrudin tetap kering.

"Ini semua salahmu!" teriak tuan rumah, "Kamu membiarkan aku
mengendarai kuda brengsek itu!"

"Masalahnya, kamu berorientasi pada kuda, bukan pada baju."

Understanding MySQL Table Types

MySQL supports various of table types or storage engines to allow you to optimize your database. The table types are available in MySQL are:

• ISAM
• MyISAM
• InnoDB
• BerkeleyDB (BDB)
• MERGE
• HEAP

The most important feature to make all the table types above distinction is transaction-safe or not. Only InnoDB and BDB tables are transaction safe and only MyISAM tables support full-text indexing and searching feature. MyISAM is also the default table type when you create table without declaring which storage engine to use. Here are some major features of each table types:

ISAM

ISAM had been deprecated and removed from version 5.x. All of it functionality entire replace by MyISAM. ISAM table has a hard size 4GB and is not portable.

MyISAM

MyISAM table type is default when you create table. MyISAM table work very fast but not transaction-safe. The size of MyISAM table depends on the operating system and the data file are portable from system to system. With MyISAM table type, you can have 64 keys per table and maximum key length of 1024 bytes.

InnoDB

Different from MyISAM table type, InnoDB table are transaction safe and supports row-level locking. Foreign keys are supported in InnoDB tables. The data file of InnoDB table can be stored in more than one file so the size of table depends on the disk space. Like the MyISAM table type, data file of InnoDB is portable from system to system. The disadvantage of InnoDB in comparison with MyISAM is it take more disk space.

BDB

BDB is similar to InnoDB in transaction safe. It supports page level locking but data file are not portable.

MERGE

Merge table type is added to treat multiple MyISAM tables as a single table so it remove the size limitation from MyISAM tables.

HEAP

Heap table is stored in memory so it is the fastest one. Because of storage mechanism, the data will be lost when the power failure and sometime it can cause the server run out of memory. Heap tables do not support columns with AUTO_INCREMENT, BLOB and TEXT characteristics.

a Love Letter

This is a love letter from a boy to a girl....
However,the_ girl's father does not like him and want them to stop
the relationship......
So,_ the boy wrote this letter to the little girl.

1_______ "The great love that I have for you
2_______ is gone, and I find my dislike for you
3_______ grows every day._ When I see you,
4_______ I do not even like your face;
5_______ the one thing that I want to do is to
6_______ look at other girls._ I never wanted to
7_______ marry you. Our last conversation
8_______ was very boring and has not
9_______ made me look forward to seeing you again.
10______ You think only of yourself
11______ If we were married, I know that I would_ find
12______ life very difficult, and I would have no
13______ pleasure in living with you. I have a heart
14______ to give, but it is not something that
15______ I want to give to you._ No one is more
16______ foolish and selfish than you, and you are_ not
17______ able to care for me and help
18______ I sincerely want you to understand that
19______ I speak the truth. You will do me a favor
20______ if you think this the end. Do not try
21______ to answer this._ Your letters are full of
22______ things that do not interest me._ You have_ no
23______ true love for me._ Good-bye! Believe me,
24______ I do not care for you._ Please do not think that
25______ I am still your boyfriend."

So bad....._ However, the boy told the girl before to
"READ BETWEEN THE LINES", meaning only to read 1.3.5.7.9.11.13......
So...
Please_ read it again!....