MySQL phpMyAdmin 安装
首先安装phpMyadmin
[root@aladdin phpMyAdmin]# uname -a
Linux aladdin.leadtek.com.cn 2.6.32.11-99.fc12.i686.PAE #1 SMP Mon Apr 5 16:15:03 EDT 2010 i686 i686 i386 GNU/Linux
[root@aladdin phpMyAdmin]# yum info phpmyadmin
Loaded plugins: presto, refresh-packagekit
Installed Packages
Name : phpMyAdmin
Arch : noarch
Version : 3.2.5
Release : 1.fc12
Size : 11 M
Repo : installed
from repo : updates
Summary : Web based MySQL browser written in php
URL : http://www.phpmyadmin.net/
License : GPLv2+
Description: phpMyAdmin is a tool written in PHP intended to handle the
: administration of MySQL over the Web. Currently it can create and
: drop databases, create/drop/alter tables, delete/edit/add fields,
: execute any SQL statement, manage keys on fields, manage
: privileges,export data into various formats and is available in 50
: languages
安装完成后访问 http://localhost/phpMyAdmin, 需要http认证, 故需要修改配置文件.
修改配置文件, 参考 http://www.phpmyadmin.net/documentation/#config
在/etc/phpMyAdmin/中
# cd /etc/phpMyAdmin
# mkdir config # create directory for saving
# chmod o+rw config # give it world writable permissions
# cp config.inc.php config/ # copy current configuration for editing
# chmod o+w config/config.inc.php # give it world writable permissions
使用浏览器访问 http://localhost/phpMyAdmin/setup
选择Connect without passwo
相关文档：
define("DB_SERVER","127.0.0.1");
define("DB_PORT",3306);
define("DB_CATALOG","uab");
define("DB_USERID","root");
define("DB_PASSWORD","");
$dsn="mysql:host=".DB_SERVER.";port=".DB_PORT.";dbname=".DB_CATALOG;
self::$__PDO=new PDO($dsn, DB_USERID, DB_PASSWORD);
//support long connection
self:: ......
有很多应用项目, 刚起步的时候用MYSQL数据库基本上能实现各种功能需求，随着应用用户的增多，数据量的增加，MYSQL渐渐地出现不堪重负的情况：连接很慢甚至宕机，于是就有把数据从MYSQL迁到ORACLE的需求，应用程序也要相应做一些修改。本人总结出以下几点注意事项，希望对大家有所帮助。
1.自动增长的数据类型处理
MYSQL有 ......
一 下载MySQL
http://dev.mysql.com/downloads/mysql/5.0.html
解压MySQL（F:\Program Files\MySQL\）MySQL安装目录
二 新建my.ini
在F:\Program Files\MySQL\下建立my.ini文件，内容为
my.ini
[mysqld]
# 设置mysql的安装目录
basedir=F:\\Program Files\\MySQL
# 设置mysql数据库的数据的存放目录，必� ......
mysql 可以通过子查询得到要删除的记录条件，然后通过子查询得结果匹配要删除的记录。但是 mysql 不能直接删除子查询表中的数据，必须通过一个临时表来解决。例如：
delete from t_transaction where exists
(select d.* from t_ti_category a,t_category b,t_ ......
英文原文：
http://www.packtpub.com/article/visual-mysql-database-design-in-mysql-workbench
下面是部分翻译过来的，转载自：http://zuolo.info/2008/11/%e4%bd%bf%e7%94%a8-mysql-workbench-%e5%8f%af%e8%a7%86%e5%8c%96%e7%9a%84%e8%ae%be%e8%ae%a1-mysql-%e6%95%b0%e6%8d%ae%e5%ba%93-1%e8%af%91%e6%96%87/
MySQL ......
