centos67mysql5716源碼編譯安裝(完整版)
【正文】 ot用戶登錄MySQL，提示密碼直接回車 mysql mysql flush privileges。 or \g.Your MySQL connection id is 6Server version: Source distributionCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 39。++| Database |++| information_schema || mysql || performance_schema || sys |++4 rows in set ( sec)mysql use mysql。 WITH GRANT OPTION。 IDENTIFIED BY 39。39。 thatanyone can access. This is also intended only for testing,and should be removed before moving into a productionenvironment.Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y 刪除 test 庫及相應(yīng)權(quán)限 Dropping test database...Success. Removing privileges on test database...Success.Reloading the privilege tables will ensure that all changesmade so far will take effect immediately.Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y 重新加載權(quán)限表使設(shè)置生效 Success.All done!2重啟服務(wù)器，檢測(cè) mysql 是否能開機(jī)自動(dòng)啟動(dòng):[rootcpmysql01 ~] reboot 。2運(yùn)行安全設(shè)置腳本，強(qiáng)烈建議生產(chǎn)服務(wù)器使用(可選): [rootcpmysql01 ~] /usr/local/mysql/bin/mysql_secure_installation mysql_secure_installation: [ERROR] unknown variable 39。 WITH GRANT OPTION。mysql exit。mysqlGRANT ALL PRIVILEGES ON *.* TO 39。39。root39。ppassword:（這里直接回車）（4）修改root密碼，并刷新權(quán)限mysql update set authentication_string=password(39。 配置解釋:DCMAKE_INSTALL_PREFIX=/usr/local/mysql 設(shè)置安裝目錄 DMYSQL_DATADIR=/home/mysql/data 設(shè)置數(shù)據(jù)庫存放目錄 DMYSQL_UNIX_ADDR=/usr/local/mysql/ 設(shè)置 UNIX socket 目錄DMYSQL_USER=mysql 設(shè)置運(yùn)行用戶DDEFAULT_CHARSET=utf8 設(shè)置默認(rèn)字符集，默認(rèn) latin1 DEFAULT_COLLATION=utf8_general_ci 設(shè)置默認(rèn)校對(duì)規(guī)則，默認(rèn) latin1_general_ciDWITH_INNOBASE_STORAGE_ENGINE=1 添加 InnoDB 引擎支持DENABLE_DOWNLOADS=1 自動(dòng)下載可選文件，比如自動(dòng)下載谷歌的測(cè)試包DMYSQL_TCP_PORT=3306 設(shè)置服務(wù)器監(jiān)聽
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1