资源描述：
《mysql安装配置文档v1.1》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、[公司名称]MySQL安装配置文档[文档副标题]2014年8月1日5目录1安装环境11.1系统环境12MYSQL安装过程12.1创建安装目录12.2安装RPM包22.3参数配置42.4启停MySQL551安装环境1.1系统环境硬件：一台物理服务器：80C（Intel(R)Xeon(R)CPUE7-4850@2.00GHz），1TRAM。软件：操作系统：RedHatEnterpriseLinuxServerrelease6.3(Santiago)MySQL版本：mysqlVer14.14Distrib5.6.14,forLin
2、ux(x86_64)服务器IP132.228.26.147操作系统账号root/rootxtzMySQL管理员账号root/mssdwMySQL端口3306数据库默认字符集UTF8数据文件目录/mysqldb/mssdw2MySQL安装过程2.1创建安装目录[root@mss-mysqldb~]#lvcreate-L4608G-nlvmysqldatavgmysqldataLogicalvolume"lvmysqldata"created[root@mss-mysqldb~]#mkfs.ext4/dev/vgmysqldat
3、a/lvmysqldatamke2fs1.41.12(17-May-2010)Filesystemlabel=OStype:LinuxBlocksize=4096(log=2)Fragmentsize=4096(log=2)Stride=0blocks,Stripewidth=0blocks301989888inodes,1207959552blocks560397977blocks(5.00%)reservedforthesuperuserFirstdatablock=0Maximumfilesystemblocks=42
4、9496729636864blockgroups32768blockspergroup,32768fragmentspergroup8192inodespergroupSuperblockbackupsstoredonblocks:32768,98304,163840,229376,294912,819200,884736,1605632,2654208,4096000,7962624,11239424,20480000,23887872,71663616,78675968,102400000,214990848,51200
5、0000,550731776,644972544Writinginodetables:doneCreatingjournal(32768blocks):doneWritingsuperblocksandfilesystemaccountinginformation:doneThisfilesystemwillbeautomaticallycheckedevery31mountsor180days,whichevercomesfirst.Usetune2fs-cor-itooverride.[root@mssmpdb01~]#
6、mkdir/mysqldb[root@mssmpdb01~]#vi/etc/fstab添加：/dev/mapper/vgmysqldata-lvmysqldata/mysqldbext4defaults12[root@mssmpdb01~]#mount/mysqldb/[root@mss-mysqldbtmp]#df-hFilesystemSizeUsedAvailUse%Mountedon/dev/mapper/vg_mssmysqldb-LogVol0050G409M47G1%/tmpfs505G76K505G1%/de
7、v/shm/dev/sda1485M39M422M9%/boot/dev/mapper/vg_mssmysqldb-LogVol0120G172M19G1%/home/dev/mapper/vg_mssmysqldb-LogVol059.9G151M9.2G2%/opt/dev/mapper/vg_mssmysqldb-LogVol0220G238M19G2%/tmp/dev/mapper/vg_mssmysqldb-LogVol039.9G5.5G4.0G59%/usr/dev/mapper/vg_mssmysqldb-L
8、ogVol0420G469M19G3%/var/dev/mapper/vgmysqldata-lvmysqldata4.5T192M4.3T1%/mysqldb1.1安装RPM包有些版本的RHEL已经安装了MySQL，在安装前先将其卸载。安装MySQL服务[root@mss-mysqldb
