Mysql配置技巧

W^6]V3D,zk%t YW3cN6g0注：以下操作在Redhat 2.6.9 + mysql-standard-4.1.8-pc-linux-i686上验证通过

1. Redhat上Mysql配置51Testing软件测试网0a:t3cF I[J]
1.1 以root身份登录Redhat系统，配置mysql服务，注意将其中的路径改为实际路径
%o,i*^:F#n;}0Shell>tar -zxvf mysql-standard-4.1.8-pc-linux-i686.tar.gz
L ^
G&B5?C$QeM0Shell>mv mysql-standard-4.1.8-pc-linux-i686 ../mysql51Testing软件测试网~'xT!q+C o+^j }"Q
Shell>cd ..
$b*LC$HT'p!t4gH0Shell>groupadd mysql51Testing软件测试网Iq,A
u8p@L[
Shell>useradd -g mysql mysql
)t.h&@D7Yo.Bp0Shell>scrīpts/mysql_install_db --user=mysql
&M&O~AL0Shell>chown -R mysql:mysql ./mysql
bd
`%|W$Nwb0Shell>cp /home/fenet/my.cnf /etc
K3oBlqM-Y0Shell>cd /usr/local51Testing软件测试网\:N|7J+n7xr*cL
Shell>ln -s /home/fenet/mysql mysql

Q W*W2?e%s},{01.2 启动mysql服务
7P+LbL,z+{0Shell>cd /usr/local/mysql/bin51Testing软件测试网 H&r/m*u*Q
Shell>./mysqld_safe &

1.3 确认mysql服务启动完成
Vl&LN'uq*Nb l,h8u~0Shell>netstat -an|grep 3306

1.4 停止mysql服务
)S;aX4S"p I$Edw~0Shell>cd /usr/local/mysql/bin
nz%ZK7K:t7[T0Shell>./mysqladmin shutdown51Testing软件测试网 fq%d5pc

2. Mysql上创建数据库及用户授权
h6ep},V^ \0mysql>drop database if exists `Database`;
k;Nr+yTB)D$CT0mysql>create database Database DEFAULT CHARACTER SET GBK;51Testing软件测试网!xVm;F|4p-i
mysql>use Database;51Testing软件测试网DUN{#Yw"E ]
mysql>GRANT ALL PRIVILEGES ON Database.* TOUsername@"%" IDENTIFIED BY 'Password' WITH GRANT OPTION;51Testing软件测试网$KSKr'`-F
mysql>GRANT ALL PRIVILEGES ON Database.* TOUsername@"localhost" IDENTIFIED BY 'Password' WITH GRANT OPTION;
Pw)M BJ0mysql>update mysql.user set password = OLD_PASSWORD('Password') where user = 'Username';51Testing软件测试网
z/BY1M6i
mysql>flush privileges;

#Bz+BbeB:l#J'nip03.Mysql 实用的数据备份及回复方式
8EvGv3NXw {E1p0# 备份指定的mysql数据库
4L|MH2{]0mysqldump --user=Username --password=Password --host=Hostname --port=PortNumber --default-character-set=gbk  DatabaseName > DBDump.sql51Testing软件测试网
?X-Wlx.fA

# 将mysqldump的数据脚本还原到指定的mysql数据库
)o \8G,QE;h7QH3}0mysql --host=Hostname --user=Username --password=Password --database=DatabaseName < DBDump.sql51Testing软件测试网 __G0{2CQ%J%M?#d

4. Windows下mysql服务注册及删除
IZ-alj:a3a#Sn0mysqld-nt --install <service_name> --defaults-file=<mysql-ini>51Testing软件测试网2K9H;VBT MM+FZxl
mysqld-nt --remove <service_name>51Testing软件测试网H0ERK4KJwDD;V