PPTslinux视频MySQL Chapter 1

MySQL,IntroductiontotheMySQLproducts,2020/5/24,RHELClusteringOR.mysqlUPDATEmysql.userSETPassword=PASSWORD(new_password)WHEREUser=rootandHost=;mysqlFLUSHPRIVILEGES;,2020/5/24,RHELClusteringToensurethatyouhavedroppedallanonymoususers,runthefollowingquery:mysqlSELECTuser,host,passwordFROMmysql.userWHEREuser=;,2020/5/24,RHELClusteringNoticethattherearenoquotesaroundthenameofthefileThefilemustbelocatedontheclienthostwhereyourerunningmysqlTheotherwaytoexecuteascriptfileisbynamingitonthemysqlcommandline.Invokemysqlandusetheinputredirectionoperatortospecifythefilefromwhichtoreadqueryinput:#mysqldb_namepromptThegeneralsyntaxforaccessingserver-sidehelpisHELPkeyword,2020/5/24,RHELClustering&StorageManagement,page:84,Usingthe-safe-updatesOption,ItspossibletoinadvertentlyissuestatementsthatmodifymanyrowsinatableorthatreturnextremelylargeresultsetsThe-safe-updatesoptionhelpspreventtheseproblems.TheoptionisparticularlyusefulforpeoplewhoarejustlearningtouseMySQL.-safe-updateshasthefollowingeffects:UPDATEandDELETEstatementsareallowedonlyiftheyincludeaWHEREclausethatspecificallyidentifieswhichrecordstoupdateordeletebymeansofakeyvalue,oriftheyincludeaLIMITclauseOutputfromsingle-tableSELECTstatementsisrestrictedtonomorethan1,000rowsunlessthestatementincludesaLIMITclause,2020/5/24,RHELClustering&StorageManagement,page:85,mysqladmin,UsedtoperformadministrativetasksSomeofthetasksincludecreatinganddroppingdatabases,displayingserverconfiguration,currentstatusinformation,changingapassword,andstoppingaserver.mysqladmincanbeveryusefulinscriptingsituationsSystax:mysqladminoptionscommandargcommandarg.,2020/5/24,RHELClustering&StorageManagement,page:86,mysqladminCommandParameters,2020/5/24,RHELClustering&StorageManagement,page:87,2020/5/24,RHELClustering&StorageManagement,page:88,2020/5/24,RHELClustering&StorageManagement,page:89,mysqladminstatus,Usedtoreturnsomebasicinformationfrommysqldincludinguptime,currentnumberofthreads,andqueriespersecondbeingexecutedCancombinethestatuscommandwiththe-sleepoptiontohavemysqladminpauseforthespecifiednumberofsecondsandthendisplayupdatedstatusinformation.Unlessyouspecifythe-countoption(whichonlyworksinconjunctionwiththe-sleepoption),2020/5/24,RHELClustering&StorageManagement,page:90,GUITools,NavicatformysqlSQLyogMySQLFrontphpMyAdminMySQLQueryBrowserMySQLAdministratorMySQLWorkbench,2020/5/24,RHELClustering&StorageManagement,page:91,SQLyog,TheSQLyogprogramisprobablythemostpopularGUItoolforMySQLTheprogramhasbeenaroundsinceAugust2002andthematurityoftheproductisevidentwhenyouusethetoolForpeoplewhocomefromaWindowsdesktopbackgroundthiscanbeaveryusefulandpracticaltoolThoughitonlyrunsonWindowsdesktops,thereisbothafreecommunityversionthatissomewhatlimitedandanenterpriseversionthatcurrentlycostslessthan100USDforasingleuserlicense,2020/5/24,RHELClustering&StorageManagement,page:92,phpMyAdmin,phpMyAdminisafreesetofPHPscriptsthatareusedtomanageaMySQLserverviaawebinterfaceBecausephpMyAdminisbasedonthesePHPscriptsitdoesrequireawebservertorunThoughthismightbeseenasadrawback,italsomeansthatyoucanaccessyourMySQLserversfromanycomputerthathasawebbrowserphpMyAdmincanbeusedtomanageanentireMySQLserverorasingledatabase,2020/5/24,RHELClustering&StorageManagement,page:93,MySQLQueryBrowser,TheQueryBrowserisaGUItoolforcreating,executing,andoptimizingqueries.TheQueryBrowserincludesthefollowingcomponents:QueryToolbar:Createsmallqueriesandexecutethem.BrowseoldqueriesScriptEditor:UsefulforeditingmorecomplexqueriesResultsWindow:DisplaysqueryresultsDatabaseExplorer:Navigate,create,anddroptablesandfields,2020/5/24,RHELClustering&StorageManagement,page:94,MySQLAdministrator,MySQLAdministratorisaGUIconsolethatenablesyoutoadministeramysqldserverinstanceSomeofthefunctionalitythatMySQLAdministratorallowsincludes:UsermanagementMonitoringdatabasehealthPerformingbackupsandrestoresManagingserverlogsMonitoringserverconnections,2020/5/24,RHELClustering&StorageManagement,page:95,MySQLWorkbench,MySQLWorkbenchisavisualdatamodelinganddatabasedesigntool.Schemacreationandchangescriptscanbeautomaticallycreatedfromthedatabasedesigns.TherearetwoversionsofMySQLWorkbench:anopensourceCommunityEditionandacommercialStandardEdition(SE)TheSEversionincludesenhancementsforreverseandforwardengineeringofdatabases,synchronizationtoandfromlivedatabases,documentation,andmodelvalidation,2020/5/24,RHELClustering&StorageManagement,page:96,MySQLArch,2020/5/24,RHE