预览加载中，请您耐心等待几秒...

linux中mysql启动服务命令.docx

预览
1/7
2/7
3/7
4/7
5/7
6/7
7/7

在线预览结束，喜欢就下载吧，查找使用更方便

下载提示 文本预览

如果您无法下载资料，请参考说明：

1、部分资料下载需要金币，请确保您的账户上有足够的金币

2、已购买过的文档，再次下载不重复扣费

3、资料包下载后请先用软件解压，在使用对应软件打开

linux中mysql启动服务命令linux的mysql启动服务命令1：使用mysqld启动、关闭MySQL服务mysqld是MySQL的守护进程，我们可以用mysqld来启动、关闭MySQL服务，关于mysqld,MySQL5.6官方介绍资料如下所示：mysqld,alsoknownasMySQLServer,isthemainprogramthatdoesmostoftheworkinaMySQLinstallation.MySQLServermanagesaccesstotheMySQLdatadirectorythatcontainsdatabasesandtables.Thedatadirectoryisalsothedefaultlocationforotherinformationsuchaslogfilesandstatusfiles.WhenMySQLserverstarts,itlistensfornetworkconnectionsfromclientprogramsandmanagesaccesstodatabasesonbehalfofthoseclients.Themysqldprogramhasmanyoptionsthatcanbespecifiedatstartup.Foracompletelistofoptions,runthiscommand:shell>mysqld--verbose--helpMySQLServeralsohasasetofsystemvariablesthataffectitsoperationasitruns.Systemvariablescanbesetatserverstartup,andmanyofthemcanbechangedatruntimetoeffectdynamicserverreconfiguration.MySQLServeralsohasasetofstatusvariablesthatprovideinformationaboutitsoperation.Youcanmonitorthesestatusvariablestoaccessruntimeperformancecharacteristics.如果MySQL是rpm方式安装的话，mysqld位于/usr/sbin下，如果MySQL是二进制安装的话，mysqld则位于bin目录下面。[root@localhost~]#whereismysqldmysqld:/usr/sbin/mysqld/usr/share/man/man8/mysqld.8.gz[root@localhost~]#/usr/sbin/mysqldstop2016-06-2714:52:540[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).2016-06-2714:52:549315[ERROR]Fatalerror:Pleaseread"Security"sectionofthemanualtofindouthowtorunmysqldasroot!2016-06-2714:52:549315[ERROR]Aborting2016-06-2714:52:549315[Note]Binlogend2016-06-2714:52:549315[Note]/usr/sbin/mysqld:Shutdowncomplete[root@localhost~]#/usr/sbin/mysqldstart2016-06-2714:52:590[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).2016-06-2714:52:599316[ERROR]Fatalerror:Pleaseread"Security"sectionofthemanualtofindouthowtorunmysqldasroot!2016-06-2714:52:599316[ERROR]Aborting2016-06-2714:52:599316[Note]Binlogend2016-06-2714:52:599316[Note]/usr/sbin/mysqld:Shutdowncomplet