Belajar MySQL

mysql> = ini adalah prompt setelah masuk mysql lewat command prompt, pada tulisan ini saya

ganti dengan simbol #>.

#>use mysql; [enter]

#>insert into user(user, host, password) [enter]
#>values(‘tes’,’localhost’,password(‘123′)); [enter]

#>update user set password=password(‘12345′) [enter]
#>where user=’tes'; [enter]
#>flush privileges; [enter]

#>create database counterku; [enter]

#>grant all on counterku.* to tes@localhost; [enter]
#>flush privileges; [enter]

#>create table koin_master( [enter]
#>ap int(2),regu int(5),telpon char(20)); [enter]

(bersambung)

About these ads

1 comment so far

  1. Trackback on

    Comentario…

    [..]Articulo Indexado Correctamente[..]…


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: