星期四, 七月 17, 2008

MySQL 权限的定义

格式:
GRANT 权限 on 数据库.表名 to 用户名@登录主机 identified by "密码";
Grant [gra:nt] n. 拨款 vt. 授予,同意,承认

实例如下:
创建一个名为 ahwei 的用户,密码 1234 拥有 localhost 的 phpbook 的所有权限:

mysql> GRANT ALL PRIVILEGES ON phpbook.* TO ahwei@localhost IDENTIFIED BY '1234';


创建一个新用户名为:walker:

mysql> GRANT select, update, insert, delete ON *.* TO walker@192.168.11.1 identified BY "mima";


看结果:

mysql> use mysql;
mysql> select host, user, password from user;

mysql>

就看到了。

主机名:

将主机名字段值改为 "%" 就表示在任何客户端机器上都可以用 walker 名登录,可以在开发时设为 "%" 。

UPDATE user SET host = '%' WHERE user = 'walker' ;

An angel 天使

I wish I had your pair of wings      我希望拥有你的一双翅膀
Had them last night in my dreams     昨夜在梦中实现
I was chasing butterflies         我追逐着蝴蝶
Till the sunrise broke my eyes      直到黎明的光芒照亮我的眼睛

Tonight the sky has glued my eyes    今晚的天空吸引了我的双眼
Cause what they see's an angel hive    因为它们看到了一片天使的领域
I've got to touch that magic star     我触摸到了那颗神奇的星
And greet the angels in their hive    (我飞到那片)天使的领域里向她们问候

Sometimes I wish I were an angel    有时我希望我是个天使
Sometimes I wish I were you      有时我希望自己就是你
Sometimes I wish I were an angel    有时我希望我是个天使
Sometimes I wish I were you一个    像你一样的天使

And all the sweet honey from above   所有上天赐予的甜蜜
Pour it all over me sweet love      倾注给我最美妙的爱
And while you're flying around my head  当你在我的脑海中萦绕
Your honey kisses keep me fed     你甜蜜的吻让我感到满足

I wish I had your pair of wings     我希望拥有你的一双翅膀
Just like last night in my dreams    就像昨夜梦中一样
I was lost in paradise         我迷失在天堂
Wish I'd never opened my eyes    希望再也不要醒来

Sometimes I wish I were an angel   有时我希望我是天使
Sometimes I wish I were you     有时我希望自己就是你
Sometimes I Wish I were an angel   有时我希望自己是个天使
Sometimes I wish I were you     一个像你一样的天使

But there's danger in the air      但是天空中又隐藏着危险
Tryin' so hard to be unfair       它正竭力变得不公正
Danger's in the air           那天空中的危险啊
Tryin' so hard to give us a scare     正试图带给我们惊恐
But were not afraid         但我们却决不胆怯

Sometimes I wish I were an angel   有时我希望我是天使
Sometimes I wish I were you     有时我希望自己就是你
Sometimes I wish I were an angel   有时我希望我是个天使
Sometimes I wish I were you     像你一样的天使

Wish I were you           就像你那样
Oh I wish I were you         像你一样的天使

欢迎回来

博客又可以直接访问了,当我输入地址后看到页面顺利地打开的时侯,我心里还是很高兴的。是的,这一瞬间的心情是高兴的。且不去管它能被访问多久,享受一下这喜悦的心情先。

星期六, 五月 03, 2008

别人的 make.conf 文件

原文链接:http://bao3.pdx.cn/blog/diary,337040.html

MASTER_SITE_OVERRIDE?=\
http://ports.hshh.org/${DIST_SUBDIR}/\
ftp://ftp2.tsinghua.edu.cn/mirror/FreeBSD/distfiles/${DIST_SUBDIR}/\
ftp://ftp2.cn.freebsd.org/pub/FreeBSD/ports/distfiles/${DIST_SUBDIR}/\
ftp://ftp.jp.freebsd.org/pub/FreeBSD/distfiles/${DIST_SUBDIR}/\
ftp://ftp3.jp.freebsd.org/pub/FreeBSD/distfiles/${DIST_SUBDIR}/\

SUP_UPDATE= yes
SUP= /usr/local/bin/cvsup
SUPFLAGS= -g -L 2
SUPHOST= cvsup.cn.FreeBSD.org
PORTSUPFILE= /etc/ports-supfile
WITH_CJK= yes

KERNCONF=Mykernel

劳动节

今天五月二号,劳动节放假。昨天和媳妇回"反吞"。今天去徐经理那里。

没睡觉,因为我要编译一台FreeBSD 的机器用。但是已经能够编译4个小时了。

有点感冒了,身体不好。

今天随便搜一下FreeBSD 的命令,找到了我在这里写的博客,很有意思。就留言了。

天晚了,还有点困。不知所云。晕晕的。。。