Penrose连接Mysql解决方案
最近一直在进行Penrose连接Mysql的尝试，可总是提示无法连接到Mysql，无论是检查端口是否开启，设置Mysql远程访问权限等都不管用，后来在Penrose的官网找到一个建立样例数据库及设置远程连接的文档，没想到一举成功，痛快啊！
下面就把文档和大家共享一下！（是英文，大家就凑合着看下吧！因为最近搞Penrose太累了，懒的再去翻译了！）
我安装的Penrose版本是2.0的，Mysql是5.0
The following are the instructions to setup the sample database. The instructions were written for MySQL 4.x, but you can use other database systems.
Create Database
Make sure you have a MySQL server running on your local machine. Create a MySQL database called "penrose_demo". Exececute the following commands inside a MySQL client:
create database penrose_demo;
Create Database User
Create a MySQL user called "penrose" with password "penrose". Exececute the following commands inside a MySQL client:
grant all privileges on *.* to 'penrose'@'<hostname>' identified by 'penrose' with grant option;
grant all privileges on *.* to 'penrose'@'localhost' identified by 'penrose' with grant option;
grant all privileges on *.* to 'penrose'@'%' identified by 'penrose' with grant option;
注：主要是这边关于权限的设置导致我总是连接不成功！有高手能详细解释下不？
Change the <hostname> with your machine name.
Create Database Tables
Populate the database with the SQL script provided in PENROSE_HOME/samples/sql. Exececute the following commands inside a MySQL client:
use penrose_demo;
source PENROSE_HOME/samples/sql/example.sql;
注：此脚本在相应目录中没有，需自己准备sql脚本！可在mysql官网上下载到！
The script was written for MySQL 4.x. If you are using a different database system, you might need to modify the script.
相关文档：
取mysql表和字段注释的语句
1、取字段注释
Select COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释
from INFORMATION_SCHEMA.COLUMNS
Where table_name = 'companies'##表名
AND table_schema = 'testhuicard'##数据库名
AND column_name LIKE 'c_name'##字段名
2、取得表注释
Select tab ......
select id from message where author_id in (select followed_id from Relation where follower_id=1) order by id desc 和 分别执行 $userlist = select followed_id from Relation where follower_id=1 再 select id from message where author_id in ($userlist) order by id desc 竟然有两个数� ......
前一篇文章中说到了LOAD命令，这里就来详细的给自己，顺便也给大家讲解下LOAD命令和批处理的数据导入功能。用的时候感觉MySQL用起来真的比较滋润。。。。
批处理导入文件，从sql文件导入数据到数据库中 ，批处理是一种非交互式运行mysql程序的方法， ......
有时候nginx，apache，mysql，php编译完了想看看编译参数可以用以下方法
nginx编译参数：
#/usr/local/nginx/sbin/nginx -V
CODE:
nginx version: nginx/0.6.32
built by gcc 4.1.2 20071124 (Red Hat 4.1.2-42)
configure arguments: --user=www --group=www --prefix=/usr/local/nginx/ --with-http_stub_status_mo ......
一、安装系统环境
1、系统：centos5
2、测试在vm5.5
准备软件
lighttpd-1.4.18
下载地址
mysql-5.0.41
part1下载地址
part2下载地址
part3下载地址
php-5.2.3
下载地址
SupeSite/X-Space
part1下载地址
part2下载地址
part3下载地址
discuz
下载地址
二、搭建web服务器安装过程
1、mysql5安装
$ tar zx ......
