其實(shí)我的安裝沒(méi)有問(wèn)題,唯一的問(wèn)題就是和官方文檔給出的示例不一樣導(dǎo)致我以為自己錯(cuò)了..
試著硬著頭皮往下走沒(méi)什么大問(wèn)題..
打擾了..
服務(wù)器是剛剛初始化磁盤(pán)之后的 centos7 的阿里云服務(wù)器.
所有的步驟都按照官網(wǎng)的安裝教程:
https://dev.mysql.com/doc/mys...
錯(cuò)誤出在第四步啟動(dòng) mysql 服務(wù)器 之前我感覺(jué)應(yīng)該都 OK
[root@Adam mysql]# sudo service mysqld start
Redirecting to /bin/systemctl start mysqld.service
[root@Adam mysql]# sudo service mysqld status
Redirecting to /bin/systemctl status mysqld.service
mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
Active: active (running) since Thu 2018-05-03 14:48:47 CST; 19min ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 1180 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 1107 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 1184 (mysqld)
CGroup: /system.slice/mysqld.service
└─1184 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysql...
May 03 14:48:47 Adam systemd[1]: Started MySQL Server.
May 03 15:06:53 Adam systemd[1]: Started MySQL Server.
查看錯(cuò)誤日志
cat /var/log/mysqld.log
得到:
2018-05-03T06:48:40.433045Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-03T06:48:42.653691Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-05-03T06:48:42.987991Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-05-03T06:48:43.053417Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0500bdb0-4e9e-11e8-a47e-00163e08240e.
2018-05-03T06:48:43.055498Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-05-03T06:48:43.055946Z 1 [Note] A temporary password is generated for root@localhost: *wGve+dHu1Y(
2018-05-03T06:48:46.745567Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-03T06:48:46.747041Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.22) starting as process 1184 ...
2018-05-03T06:48:46.750539Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-05-03T06:48:46.750562Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-05-03T06:48:46.750570Z 0 [Note] InnoDB: Uses event mutexes
2018-05-03T06:48:46.750574Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-05-03T06:48:46.750578Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-03T06:48:46.750581Z 0 [Note] InnoDB: Using Linux native AIO
2018-05-03T06:48:46.750849Z 0 [Note] InnoDB: Number of pools: 1
2018-05-03T06:48:46.751127Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-05-03T06:48:46.752547Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-05-03T06:48:46.763777Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-05-03T06:48:46.766286Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-05-03T06:48:46.778460Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-05-03T06:48:46.788598Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-05-03T06:48:46.788640Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-05-03T06:48:46.994265Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-05-03T06:48:46.995082Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-05-03T06:48:46.995093Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-05-03T06:48:46.996046Z 0 [Note] InnoDB: Waiting for purge to start
2018-05-03T06:48:47.046201Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 2589318
2018-05-03T06:48:47.046511Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-05-03T06:48:47.051515Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-05-03T06:48:47.054110Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180503 14:48:47
2018-05-03T06:48:47.055609Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-05-03T06:48:47.055818Z 0 [Warning] CA certificate ca.pem is self signed.
2018-05-03T06:48:47.057502Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-05-03T06:48:47.057539Z 0 [Note] IPv6 is available.
2018-05-03T06:48:47.057549Z 0 [Note] - '::' resolves to '::';
2018-05-03T06:48:47.057570Z 0 [Note] Server socket created on IP: '::'.
2018-05-03T06:48:47.066966Z 0 [Note] Event Scheduler: Loaded 0 events
2018-05-03T06:48:47.067077Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
linux 系統(tǒng)真是折騰..按照官網(wǎng)的方法安裝還總是會(huì)遇上毛病
另外想問(wèn)一句能解決這個(gè)問(wèn)題的前輩...你們是怎么修煉到這個(gè)程度的?
謝謝
北大青鳥(niǎo)APTECH成立于1999年。依托北京大學(xué)優(yōu)質(zhì)雄厚的教育資源和背景,秉承“教育改變生活”的發(fā)展理念,致力于培養(yǎng)中國(guó)IT技能型緊缺人才,是大數(shù)據(jù)專業(yè)的國(guó)家
北大青鳥(niǎo)中博軟件學(xué)院創(chuàng)立于2003年,作為華東區(qū)著名互聯(lián)網(wǎng)學(xué)院和江蘇省首批服務(wù)外包人才培訓(xùn)基地,中博成功培育了近30000名軟件工程師走向高薪崗位,合作企業(yè)超4
中公教育集團(tuán)創(chuàng)建于1999年,經(jīng)過(guò)二十年潛心發(fā)展,已由一家北大畢業(yè)生自主創(chuàng)業(yè)的信息技術(shù)與教育服務(wù)機(jī)構(gòu),發(fā)展為教育服務(wù)業(yè)的綜合性企業(yè)集團(tuán),成為集合面授教學(xué)培訓(xùn)、網(wǎng)
達(dá)內(nèi)教育集團(tuán)成立于2002年,是一家由留學(xué)海歸創(chuàng)辦的高端職業(yè)教育培訓(xùn)機(jī)構(gòu),是中國(guó)一站式人才培養(yǎng)平臺(tái)、一站式人才輸送平臺(tái)。2014年4月3日在美國(guó)成功上市,融資1
曾工作于聯(lián)想擔(dān)任系統(tǒng)開(kāi)發(fā)工程師,曾在博彥科技股份有限公司擔(dān)任項(xiàng)目經(jīng)理從事移動(dòng)互聯(lián)網(wǎng)管理及研發(fā)工作,曾創(chuàng)辦藍(lán)懿科技有限責(zé)任公司從事總經(jīng)理職務(wù)負(fù)責(zé)iOS教學(xué)及管理工作。
浪潮集團(tuán)項(xiàng)目經(jīng)理。精通Java與.NET 技術(shù), 熟練的跨平臺(tái)面向?qū)ο箝_(kāi)發(fā)經(jīng)驗(yàn),技術(shù)功底深厚。 授課風(fēng)格 授課風(fēng)格清新自然、條理清晰、主次分明、重點(diǎn)難點(diǎn)突出、引人入勝。
精通HTML5和CSS3;Javascript及主流js庫(kù),具有快速界面開(kāi)發(fā)的能力,對(duì)瀏覽器兼容性、前端性能優(yōu)化等有深入理解。精通網(wǎng)頁(yè)制作和網(wǎng)頁(yè)游戲開(kāi)發(fā)。
具有10 年的Java 企業(yè)應(yīng)用開(kāi)發(fā)經(jīng)驗(yàn)。曾經(jīng)歷任德國(guó)Software AG 技術(shù)顧問(wèn),美國(guó)Dachieve 系統(tǒng)架構(gòu)師,美國(guó)AngelEngineers Inc. 系統(tǒng)架構(gòu)師。