2023學(xué)年完整公開課版22configurationdatabaseservice

ConfigurationDatabaseServiceCatalog1.ControllernodeMySQLserviceinstallationandconfiguration2.InstallMySQLPythonlibraryforcomputenode231.ControllernodeMySQLserviceinstallationandconfiguration(1)InstallMySQLclientandserver,MySQLPython#yuminstallmysqlmysql-serverMySQL-python(2)EditthemainprofileofMySQL[root@controller~]#vi/etc/f[mysqld]configurationsection,addthefollowingconfiguration:bind-address=1default-storage-engine=innodbinnodb_file_per_tablecollation-server=utf8_general_Ciinit-connect='SETNAMESutf8'character-set-server=utf841.ControllernodeMySQLserviceinstallationandconfiguration(3)StartMySQLserver[root@controller~]#servicemysqldstart(4)ConfigureMySQLservertostartautomaticallyafterpoweron[root@controller~]#chkconfigmysqldon(5)InstallMySQLdatabase[root@controller~]#mysql_install_db51.ControllernodeMySQLserviceinstallationandconfiguration（6）mysql_secure_InstallationstrengthensthesecurityofMySQLserver[root@controller~]#mysql_secure_installationNOTE:RUNNINGALLPARTSOFTHISSCRIPTISRECOMMENDEDFORALLMySQLSERVERSINPRODUCTIONUSE!PLEASEREADEACHSTEPCAREFULLY!……InordertologintoMySQLtosecureit,we'llneedthecurrentpasswordfortherootuser.Ifyou'vejustinstalledMySQL,andyouhaven'tsettherootpasswordyet,thepasswordwillbeblank,soyoucanjustpressenterhere.Entercurrentpasswordforroot(enterfornone): #EntertherootpasswordofMySQLdatabase,andenterdirectlywhenitisempty……6Youalreadyhavearootpasswordset,soyoucansafelyanswer'n'.Changetherootpassword?[Y/n]YEnteranewrootpassword：000000...skipping.……Removeanonymoususers?[Y/n]y...Success!7……Disallowrootloginremotely?[Y/n]y...Success!……Removetestdatabaseandaccesstoit?[Y/n]y-Droppingtestdatabase......Success!……Reloadprivilegetablesnow?[Y/n]y...Success!……Alldone!Ifyou'vecompletedalloftheabovesteps,yourMySQLinstallationshouldnowbesecure.ThanksforusingMySQL!2.InstallMySQLPythononthecomputenodeInstallMySQL