MariaDB10。5安装二源码和二进制安装安装

　　MariaDB10。5安装一安装包方式安装
　　MariaDB10。5安装二源码和二进制安装安装
　　9de7bb31d0644e7393039222babfed10
　　闲话少说，本次演示源码和二进制安装安装安装MariaDB10。5Oracle8。4源码安装MariaDB10。5yumyinstallgitgccgcccmakebisonncursesncursesdevelzlibdevellibeventdevelcmakeopensslopenssldevelcurldevellibaiolibaiodevelncursescompatlibsgnutlsgnutlsdevel解压编译tarxfsoftwaremariadb10。5。10。tar。gzCtmpcdtmpmariadb10。5。10cdbuildcmakeDCMAKEBUILDTYPEReleaseDCMAKEINSTALLPREFIXusrlocalmariadbDMYSQLDATADIRu01mysqldataDSYSCONFDIRetcDMYSQLUNIXADDRtmpmysql。sock。。makej2makeinstall环境准备groupaddmysqluseraddgmysqlmysqllnsusrlocalmariadbusrlocalmysqlchownRroot：mysqlusrlocalmysql准备配置文件〔fetcmy。cnf〕mvetcmy。cnfetcmy。cnf。（dateYmdHMS）catetcmy。cnfEOF〔mysqld〕datadiru01mysqldatasockettmpmysql。socklogerroru01mysqlmysqld。logpidfileu01mysqlmysqld。pidlogbintrustfunctioncreatorsonskipnameresolveonmaxconnections1000waittimeout1200interactivetimeout1200〔client〕sockettmpmysql。sockEOFmkdirpu01chownRmysqlu01mysql创建数据库，注意路径在bin下mkdirauthpamtooldirtouchauthpamtooldirauthpamtoolchownRmysql。mysqlauthpamtooldirusrlocalmysqlscriptsmysqlinstalldbusermysqlbasedirusrlocalmysqldatadiru01mysqldata设置服务运行systemctlstartmariadb不返回，但数据库可以正常连接，不清楚原因，也没有找到解决方法或者使用以下两种方式都可以启动，使用，但不退出。可以加后台运行usrlocalmysqlbinmysqldsafeusermysqlusrlocalmysqlbinmysqldusermysql允许3306端口通过防火墙firewallcmdzonepublicaddport3306tcppermanentfirewallcmdreload设置环境变量cat｛HOME｝。bashprofileEOFexportPATH｛PATH｝：usrlocalmysqlbinEOFsource｛HOME｝。bashprofile登陆，修改密码后plugin自动由unixsocket变成mysqlnativepasswordmysql不需要账号密码，默认认证方式为unixsocketALTERUSERrootlocalhostIDENTIFIEDBYRoot1Oracle8。4二进制安装MariaDB10。5yumyinstalllibaioncursescompatlibsgroupaddmysqluseraddgmysqlmysqltarzxfsoftwaremariadb10。5。10linuxsystemdx8664。tar。gzCusrlocallnsusrlocalmariadb10。5。10linuxsystemdx8664usrlocalmysqlchownRroot：mysqlusrlocalmysql准备配置文件〔fetcmy。cnf〕mvetcmy。cnfetcmy。cnf。（dateYmdHMS）catetcmy。cnfEOF〔mysqld〕datadiru01mysqldatasockettmpmysql。socklogerroru01mysqlmysqld。logpidfileu01mysqlmysqld。pidlogbintrustfunctioncreatorsonskipnameresolveonmaxconnections1000waittimeout1200interactivetimeout1200〔client〕sockettmpmysql。sockEOFmkdirpu01chownRmysqlu01mysql创建数据库usrlocalmysqlscriptsmysqlinstalldbusermysqlbasedirusrlocalmysqldatadiru01mysqldata设置服务使用官方文档cpusrlocalmysqlsupportfilessystemdmariadb。serviceusrlibsystemdsystem设置服务失败，具体原因未调查，参考mysqld手写了服务脚本catusrlibsystemdsystemmariadb。serviceEOFDescriptionMariaDB10。5。10databaseserverDocumentationman：mariadbd（8）Documentationhttps：mariadb。comkbenlibrarysystemdAfternetwork。target〔Install〕WantedBymultiuser。target〔Service〕UsermysqlGroupmysqlTypenotifyTimeoutSec900PermissionsStartOnlytrueExecStartusrlocalmysqlbinmysqldusermysqlLimitNOFILE65536RestartonfailureRestartPreventExitStatus1EnvironmentMYSQLDPARENTPID1PrivateTmpfalseEOFsystemctlstartmariadb允许3306端口通过防火墙firewallcmdzonepublicaddport3306tcppermanentfirewallcmdreload设置环境变量cat｛HOME｝。bashprofileEOFexportPATH｛PATH｝：usrlocalmysqlbinEOFsource｛HOME｝。bashprofile登陆，修改密码后plugin自动由unixsocket变成mysqlnativepasswordmysql不需要账号密码，默认认证方式为unixsocketALTERUSERrootlocalhostIDENTIFIEDBYRoot1
　　至此，安装包方式，源码方式，二进制方式安装Mariadb完成，请关注防丢失。9de7bb31d0644e7393039222babfed10谢谢