DB服务器mysql的安装配置

DB服务器mysql的安装配置文档作者kong日期2008-9-24公司深圳市华磊通讯技术有限公司

操作系统：RHEL5.2x86-64硬盘分区：/data432GB /boot100MB /15GB#####操作系统：RHEL5.2x86-64硬盘分区：/data432GB /boot100MB /15GB#####此分区用作备用nfs挂载分区：/data/mysql_backup内存容量：8GB安装mysqlmysql软件：软件使用 redhat的rpm包perl-DBD-MySQL-3.0007-1.fc6.x86_64.rpmmysql-server-5.0.45-7.el5.x86_64.rpmmysql-5.0.45-7.el5.x86_64.rpm安装软件rpm-ivhmysql-5.0.45-7.el5.x86_64.rpmrpm-ivhperl-DBD-MySQL-3.0007-1.fc6.x86_64.rpmrpm-ivhmysql-server-5.0.45-7.el5.x86_64.rpm注：如果安装时遇到软件依赖性提示，可根据提示安装相关软件配置mysql修改/etc/f,参数设置如下[mysql]no-auto-rehashdefault-character-set=utf8[mysqld]datadir=/data/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysqldefault-character-set=utf8init_connect='SETNAMESutf8'old_passwords=1skip-name-resolveback_log=384key_buffer_size=512Mmax_allowed_packet=4Mthread_stack=256Ktable_cache=128Ksort_buffer_size=12Mread_buffer_size=4Mjoin_buffer_size=8Mtmp_table_size=512Mmax_connections=2048max_connect_errors=10000000wait_timeout=10thread_concurrency=16####二进制文件的名称，可设主机名########二进制文件的名称，可设主机名####binlog_cache_size=4Mmax_biniog_cache_size=8Mmax_biniog_size=512MIong_query_time=3log_slow_queries=/data/mysql/slow_query.log[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid[mysqldump]quickmax_allowed_packet=32M

4.mysql服务的启动与停止/etc/init.d/mysqldstart 启动/etc/init.d/mysqldstop 停止datadir=/data/mysql第一次执行/etc/init.d/m