创建mysql用户与用户组sudogroupaddmysqlsudouseraddgmysqlmysqlssbinnologin修改用户目录权限cdusrlocalmysqlsudomkdirdatasudochownRmysql:mysql。初始化安装sudocpsupportfilesmysql。serveretcinit。dsudobinmysqldusermysqlbasedirusrlocalmysqldatadirusrlocalmysqldatainitialize记下安装过程中的临时密码,后边用于修改root密码(yq7AIhE5kl0) mysql临时密码修改配置sudovietcmy。cnf输入以下内容〔mysqld〕RemoveleadingandsettotheamountofRAMforthemostimportantdatacacheinMySQL。Startat70oftotalRAMfordedicatedserver,else10。innodbbufferpoolsize128MRemoveleadingtoturnonaveryimportantdataintegrityoption:loggingchangestothebinarylogbetweenbackups。logbinThesearecommonlyset,removetheandsetasrequired。basedir。。。。。datadir。。。。。port。。。。。basedirusrlocalmysqldatadirusrlocalmysqldatasockettmpmysql。sockbindaddress0。0。0。0serverid。。。。。socket。。。。。Removeleadingtosetoptionsmainlyusefulforreportingservers。TheserverdefaultsarefasterfortransactionsandfastSELECTs。Adjustsizesasneeded,experimenttofindtheoptimalvalues。joinbuffersize128Msortbuffersize2Mreadrndbuffersize2MsqlmodeNOENGINESUBSTITUTION,STRICTTRANSTABLES将mysql添加到PATH路径启动服务与修改mysqlroot用户密码sudoservicemysqlstart输入安装时生成的临时密码进行登录mysqlurootp修改密码ALTERUSERrootlocalhostidentifiedBY123456;