Learn?UsetheInnoDBstorageenginetostoredataindifferentfilesandthusimproveefficiency?Establishalertmechanismstoletyouknowwhentablespaceisrunninglow?IdentifyandchangeMySQLvariables?Enableandconfigurebinarylogging?UnderstandandconfigureMySQLandInnoDBtimeoutoptions?RunmultipleMySQLServerInstancesinparallelonaLinuxserver?ManageMySQLuseraccountsandassignappropriateprivileges?ConfigureMySQLAdministratortodisplayglobalprivilegesandhosts?RestrictaccesssensiblyandregainaccesstoyourdatabaseincaseoflossofadministrativeusercredentialsAboutMySQListhemostpopularopen-sourcedatabaseandisalsoknownforitseasysetupfeature.However,properconfigurationbeyondthedefaultsettingsremainsachallenge,alongwithday-to-daymaintenancetaskssuchasconfiguration,servermonitoringandmanagingusercredentials.ThisMySQLAdminCookbookLITEbookprovidesbothstep-by-steprecipesandrelevantbackgroundinformationonmanybasicandadvancedaspectsofMySQLadministrationandconfiguration.ThreekeyaspectsofMySQLadministrationarecoveredindetail;monitoringandanalyzingaMySQLinstallation,configuringMySQL,helpingyou,amongstotherthings,toregainlostadministrativeusercredentials,andmanagingusersbyassigningprivileges.Alloftherecipesarebasedonreal-worldexperiencederivedfromprovensolutionsusedinanenterpriseenvironment.Tofindoutmoreaboutupgradingtothefulledition,visitwww.packtpub.com/lite-editionsandlogintoyouraccountforoffersandhelp.Ifyoudon’thaveanaccountonPacktPub.com,visittodayandsetoneup!Features?SetupMySQLtoperformadministrativetaskssuchasconfiguration,servermonitoringandmanagingusercredentials?WorkwithInnoDBinordertoimprovetheorganizationofyourdatabase?Restrictaccesssensiblyandregainaccesstoyourdatabaseincaseoflossofadministrativeusercredentials?PartofPackt'sCookbookseries:Eachrecipeisacarefullyorganizedsequenceofinstructionstocompletethetaskasefficientlyaspossible