mysql replication
<!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:2 7 4 9 2 2 5 2 4 4;
mso-font-alt:"Courier New";
mso-font-charset:0;
mso-generic-font-family:modern;
mso-font-format:other;
mso-font-pitch:fixed;
mso-font-signature:3 0 0 0 1 0;}
@font-face
{font-family:宋体;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@宋体";
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:Arial;
mso-fareast-font-family:宋体;
mso-fareast-language:EN-US;}
h3
{mso-style-next:Normal;
margin-top:13.0pt;
margin-right:0cm;
margin-bottom:13.0pt;
margin-left:0cm;
line-height:173%;
mso-pagination:widow-orphan lines-together;
page-break-after:avoid;
mso-outline-level:3;
font-size:16.0pt;
font-family:Arial;
mso-fareast-language:EN-US;}
p.MsoHeading9, li.MsoHeading9, div.MsoHeading9
{mso-style-update:auto;
mso-style-parent:"List Bullet";
mso-style-next:Normal;
margin:0cm;
margin-bottom:.0001pt;
line-height:150%;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:9;
font-size:12.0pt;
font-family:Arial;
mso-fareast-font-family:宋体;
mso-fareast-language:EN-US;
mso-bidi-font-weight:bold;}
p.MsoFooter, li.MsoFooter, div.MsoFooter
{margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
tab-stops:center 216.0pt right 432.0pt;
font-size:8.0pt;
font-family:Arial;
mso-fareast-font-family:宋体;
mso-fareast-language:EN-US;}
p.MsoListBullet, li.MsoListBullet
相关文档：
一 下载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_ ......
mysql 命令学习：
1. mysql -uroot ;
2.mysql -h ip -ubusiusr -pbusiusr newdrmdb;
3.show databases ; //显示所有的数据库 ;
4.show tables ; ......
linux
下 mysql
用户的管理
文章分类:数据库
关键字: linux
mysql
用户管理
自从上在redhat Enterprise 5 中安装了MySQL
,这次来实践操作一下MySQL
用户的管理；
一、root用户密码的维护：
由于安装MySQL
完后,MySQL
会自动提供一个不带 ......
首先安装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 &nbs ......
