Mysql配置技巧

注：以下操作在Redhat 2.6.9 + mysql-standard-4.1.8-pc-linux-i686上验证通过

1. Redhat上Mysql配置51Testing软件测试网UhD F8d2e
1.1 以root身份登录Redhat系统，配置mysql服务，注意将其中的路径改为实际路径
8p!HA&Iyn n/B0Shell>tar -zxvf mysql-standard-4.1.8-pc-linux-i686.tar.gz
s6heW kgds"Q r0Shell>mv mysql-standard-4.1.8-pc-linux-i686 ../mysql51Testing软件测试网bxiTe4Y
Shell>cd ..51Testing软件测试网1VuN7|S2u0w.{
Shell>groupadd mysql
0M5wZ$};^4b0x7@0Shell>useradd -g mysql mysql51Testing软件测试网+k+J+| C0mo_"d
Shell>scrīpts/mysql_install_db --user=mysql51Testing软件测试网UN0asr?C1z5u!ZJ
Shell>chown -R mysql:mysql ./mysql51Testing软件测试网;Tz*^Y(Z7R
Shell>cp /home/fenet/my.cnf /etc51Testing软件测试网.@%n-[;d"e9Iic
Shell>cd /usr/local51Testing软件测试网Gr,i~&o8W,o!^(}jp
Shell>ln -s /home/fenet/mysql mysql51Testing软件测试网'[Te r G:t7g1g

c8L#ggp01.2 启动mysql服务
j@ U6pd'Gd0Shell>cd /usr/local/mysql/bin51Testing软件测试网8b@'["T:S(tErI
Shell>./mysqld_safe &

1.3 确认mysql服务启动完成51Testing软件测试网+izp \C9zBP
Shell>netstat -an|grep 330651Testing软件测试网sK/{-i5|\

1.4 停止mysql服务51Testing软件测试网/lz2Mdv(O'W
Shell>cd /usr/local/mysql/bin
4B*j,c9b0d9o6LOi%K0Shell>./mysqladmin shutdown51Testing软件测试网2K8yI9HHM ~

2. Mysql上创建数据库及用户授权51Testing软件测试网1f(pP(h%jg)sD
mysql>drop database if exists `Database`;51Testing软件测试网C+g;`s!Y.h+Zk
mysql>create database Database DEFAULT CHARACTER SET GBK;
] \Z}?V0mysql>use Database;
#T+ogvS6F0mysql>GRANT ALL PRIVILEGES ON Database.* TOUsername@"%" IDENTIFIED BY 'Password' WITH GRANT OPTION;
nn"?.~?0}#i"I0a0mysql>GRANT ALL PRIVILEGES ON Database.* TOUsername@"localhost" IDENTIFIED BY 'Password' WITH GRANT OPTION;51Testing软件测试网{/L4?a}ikU
mysql>update mysql.user set password = OLD_PASSWORD('Password') where user = 'Username';
3x Kmv1R/J+f2?0mysql>flush privileges;

3.Mysql 实用的数据备份及回复方式
m9pGAE0ae/^*w0# 备份指定的mysql数据库
g6R%@;{kA0mysqldump --user=Username --password=Password --host=Hostname --port=PortNumber --default-character-set=gbk  DatabaseName > DBDump.sql51Testing软件测试网|PWcc
k$_(t[

V({+A5}.U#cw7C0# 将mysqldump的数据脚本还原到指定的mysql数据库
Elqg/\S0mysql --host=Hostname --user=Username --password=Password --database=DatabaseName < DBDump.sql51Testing软件测试网8wm&Tb%mu5k
Vr]

4. Windows下mysql服务注册及删除51Testing软件测试网{ p"Eb;O}hj4@$A*no
mysqld-nt --install <service_name> --defaults-file=<mysql-ini>51Testing软件测试网:}-OMtPP m
mysqld-nt --remove <service_name>