- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我正在尝试在 centos 7 上启动 mysql。(centos 运行在一个 vagrant box 中,使用 vmware-workstation 作为提供程序)我有一个 Chef 脚本,但尝试使用 Chef Recipe 启动 mysql 失败。
此时我只是尝试通过 ssh 进入盒子并手动启动 mysql,这是我得到的输出:
(cms-env)[GISO@localhost ~]$ sudo systemctl start mysql-cms
Job for mysql-cms.service failed. See 'systemctl status mysql-cms.service' and '
journalctl -xn' for details.
[GISO@localhost ~]$ sudo systemctl -l status mysql-cms.service
mysql-cms.service - mysql_service[mysql-cms]
Loaded: loaded (/usr/lib/systemd/system/mysql-cms.service; enabled)
Active: failed (Result: exit-code) since Sun 2015-07-05 18:03:59 EDT; 5h 51mi
n ago
Process: 11215 ExecStartPost=/usr/libexec/mysql-cms-wait-ready $MAINPID (code=
exited, status=1/FAILURE)
Process: 11214 ExecStart=/usr/sbin/mysqld --defaults-file=/etc/mysql-cms/my.cn
f --basedir=/usr (code=exited, status=1/FAILURE)
Main PID: 11214 (code=exited, status=1/FAILURE)
CGroup: /system.slice/mysql-cms.service
Jul 05 18:03:59 localhost.localdomain systemd[1]: Starting mysql_service[mysql-c
ms]...
Jul 05 18:03:59 localhost.localdomain mysqld[11214]: mysqld: [ERROR] Could not o
pen required defaults file: /etc/mysql-cms/my.cnf
Jul 05 18:03:59 localhost.localdomain mysqld[11214]: mysqld: [ERROR] Fatal error
in defaults handling. Program aborted!
Jul 05 18:03:59 localhost.localdomain systemd[1]: mysql-cms.service: main proces
s exited, code=exited, status=1/FAILURE
Jul 05 18:03:59 localhost.localdomain systemd[1]: mysql-cms.service: control pro
cess exited, code=exited status=1
Jul 05 18:03:59 localhost.localdomain systemd[1]: Failed to start mysql_service[
mysql-cms].
Jul 05 18:03:59 localhost.localdomain systemd[1]: Unit mysql-cms.service entered
failed state.
我花了好几个小时一直在努力解决这个问题。已下载所有推荐的开发库等...无法弄清楚是什么原因导致此失败。任何帮助是极大的赞赏!谢谢
编辑:我可以通过sudo journalctl -l | grep mysql
在这里挖掘更多日志(对于格式问题我深表歉意)
.
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.612681Z
0 [Note] /usr/sbin/mysqld (mysqld 5.7.7-rc) starting as process 2447 ...
Jul 06 00:43:32 localhost.localdomain mysqld[1639]: 2015-07-06T04:43:32.718655Z
0 [Warning] One can only use the --user switch if running as root
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.740870Z
0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.740950Z
0 [Note] InnoDB: Uses event mutexes
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.740957Z
0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.740961Z
0 [Note] InnoDB: Compressed tables use zlib 1.2.3
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.740989Z
0 [Note] InnoDB: Using Linux native AIO
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.742476Z
0 [Note] InnoDB: Number of pools: 1
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.747596Z
0 [Note] InnoDB: Using CPU crc32 instructions
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.797073Z
0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chu
nk size = 128M
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.935407Z
0 [Note] InnoDB: Completed initialization of buffer pool
Jul 06 00:43:32 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:32.995995Z
0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread
priority can be changed. See the man page of setpriority().
Jul 06 00:43:33 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:33.309642Z
0 [Note] InnoDB: Highest supported file format is Barracuda.
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.207332Z
0 [Note] InnoDB: Creating shared tablespace for temporary tables
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.207488Z
0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the f
ile full; Please wait ...
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.341340Z
0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.342346Z
0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s)
are active.
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.342359Z
0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.342802Z
0 [Note] InnoDB: Waiting for purge to start
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.398277Z
0 [Note] InnoDB: 5.7.7 started; log sequence number 2529895
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.406371Z
0 [Note] Plugin 'FEDERATED' is disabled.
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.433314Z
0 [Note] InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
Jul 06 00:43:34 localhost.localdomain systemd[1]: mysql-cms.service: main proces
s exited, code=exited, status=1/FAILURE
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.787281Z
0 [Warning] Failed to setup SSL
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.787331Z
0 [Warning] SSL error: SSL context is not usable without certificate and private
key
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.788123Z
0 [Note] Server hostname (bind-address): '*'; port: 3306
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.788187Z
0 [Note] IPv6 is available.
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.788207Z
0 [Note] - '::' resolves to '::';
Jul 06 00:43:34 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:34.788220Z
0 [Note] Server socket created on IP: '::'.
Jul 06 00:43:35 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:35.167395Z
0 [Note] InnoDB: Buffer pool(s) load completed at 150706 0:43:35
Jul 06 00:43:35 localhost.localdomain systemd[1]: mysql-cms.service: control pro
cess exited, code=exited status=1
Jul 06 00:43:35 localhost.localdomain systemd[1]: Failed to start mysql_service[
mysql-cms].
Jul 06 00:43:35 localhost.localdomain systemd[1]: Unit mysql-cms.service entered
failed state.
Jul 06 00:43:35 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:35.590242Z
0 [Note] Event Scheduler: Loaded 0 events
Jul 06 00:43:35 localhost.localdomain mysqld[2184]: 2015-07-06T04:43:35.590343Z
0 [Note] /usr/sbin/mysqld: ready for connections.
Jul 06 00:43:35 localhost.localdomain mysqld[2184]: Version: '5.7.7-rc' socket:
'/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
Jul 06 00:43:35 localhost.localdomain systemd[1]: PID file /var/run/mysqld/mysql
d.pid not readable (yet?) after start.
Jul 06 00:44:15 localhost.localdomain systemd[1]: Starting mysql_service[mysql-c
ms]...
Jul 06 00:44:16 localhost.localdomain mysqld[5225]: 2015-07-06T04:44:16.187336Z
0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --ex
plicit_defaults_for_timestamp server option (see documentation for more details)
.
Jul 06 00:44:16 localhost.localdomain mysqld[5225]: 2015-07-06T04:44:16.191829Z
0 [Note] /usr/sbin/mysqld (mysqld 5.7.7-rc) starting as process 5225 ...
Jul 06 00:44:16 localhost.localdomain mysqld[5225]: 2015-07-06T04:44:16.195418Z
0 [Warning] One can only use the --user switch if running as root
Jul 06 00:44:18 localhost.localdomain systemd[1]: mysql-cms.service: main proces
s exited, code=exited, status=1/FAILURE
Jul 06 00:44:19 localhost.localdomain systemd[1]: mysql-cms.service: control pro
cess exited, code=exited status=1
Jul 06 00:44:19 localhost.localdomain systemd[1]: Failed to start mysql_service[
mysql-cms].
Jul 06 00:44:19 localhost.localdomain systemd[1]: Unit mysql-cms.service entered
failed state.
Jul 06 00:44:59 localhost.localdomain systemd[1]: mysqld.service operation timed
out. Terminating.
Jul 06 00:44:59 localhost.localdomain systemd[1]: Unit mysqld.service entered fa
iled state.
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.996641Z
0 [Note] Giving 0 client threads a chance to die gracefully
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.996671Z
0 [Note] Shutting down slave threads
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.996677Z
0 [Note] Forcefully disconnecting 0 remaining clients
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.996685Z
0 [Note] Event Scheduler: Purging the queue. 0 events
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.996806Z
0 [Note] Binlog end
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997418Z
0 [Note] Shutting down plugin 'ngram'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997427Z
0 [Note] Shutting down plugin 'ARCHIVE'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997430Z
0 [Note] Shutting down plugin 'BLACKHOLE'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997438Z
0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997466Z
0 [Note] Shutting down plugin 'partition'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997469Z
0 [Note] Shutting down plugin 'MRG_MYISAM'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997474Z
0 [Note] Shutting down plugin 'CSV'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997477Z
0 [Note] Shutting down plugin 'MyISAM'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997484Z
0 [Note] Shutting down plugin 'MEMORY'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997489Z
0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997493Z
0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997496Z
0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
Jul 06 00:44:59 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997500Z
0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997502Z
0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997505Z
0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997507Z
0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997509Z
0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997512Z
0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997515Z
0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997518Z
0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997520Z
0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997523Z
0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997525Z
0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997528Z
0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997530Z
0 [Note] Shutting down plugin 'INNODB_METRICS'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997533Z
0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997535Z
0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997537Z
0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997539Z
0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997541Z
0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997544Z
0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997551Z
0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997554Z
0 [Note] Shutting down plugin 'INNODB_CMPMEM'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997557Z
0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997559Z
0 [Note] Shutting down plugin 'INNODB_CMP'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997562Z
0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997565Z
0 [Note] Shutting down plugin 'INNODB_LOCKS'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997567Z
0 [Note] Shutting down plugin 'INNODB_TRX'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997570Z
0 [Note] Shutting down plugin 'InnoDB'
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997628Z
0 [Note] InnoDB: FTS optimize thread exiting.
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:44:59.997751Z
0 [Note] InnoDB: Starting shutdown...
Jul 06 00:45:00 localhost.localdomain systemd[1]: mysqld.service holdoff time ov
er, scheduling restart.
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:45:00.100746Z
0 [Note] InnoDB: Dumping buffer pool(s) to .//ib_buffer_pool
Jul 06 00:45:00 localhost.localdomain mysqld[2184]: 2015-07-06T04:45:00.101118Z
0 [Note] InnoDB: Buffer pool(s) dump completed at 150706 0:45:00
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.323561Z
0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --ex
plicit_defaults_for_timestamp server option (see documentation for more details)
.
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.324161Z
0 [Note] /usr/sbin/mysqld (mysqld 5.7.7-rc) starting as process 5309 ...
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.328538Z
0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.328579Z
0 [Note] InnoDB: Uses event mutexes
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.328586Z
0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.328590Z
0 [Note] InnoDB: Compressed tables use zlib 1.2.3
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.328598Z
0 [Note] InnoDB: Using Linux native AIO
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.328885Z
0 [Note] InnoDB: Number of pools: 1
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.329050Z
0 [Note] InnoDB: Using CPU crc32 instructions
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.330182Z
0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chu
nk size = 128M
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.347015Z
0 [Note] InnoDB: Completed initialization of buffer pool
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.348927Z
0 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.348952Z
0 [Note] InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files.
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.348960Z
0 [Note] InnoDB: Retrying to lock the first data file
Jul 06 00:45:00 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:00.350842Z
0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread
priority can be changed. See the man page of setpriority().
Jul 06 00:45:01 localhost.localdomain mysqld[2184]: 2015-07-06T04:45:01.324411Z
0 [Note] InnoDB: Shutdown completed; log sequence number 2530296
Jul 06 00:45:01 localhost.localdomain mysqld[2184]: 2015-07-06T04:45:01.328516Z
0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Jul 06 00:45:01 localhost.localdomain mysqld[2184]: 2015-07-06T04:45:01.328550Z
0 [Note] Shutting down plugin 'sha256_password'
Jul 06 00:45:01 localhost.localdomain mysqld[2184]: 2015-07-06T04:45:01.328561Z
0 [Note] Shutting down plugin 'mysql_native_password'
Jul 06 00:45:01 localhost.localdomain mysqld[2184]: 2015-07-06T04:45:01.328836Z
0 [Note] Shutting down plugin 'binlog'
Jul 06 00:45:01 localhost.localdomain mysqld[2184]: 2015-07-06T04:45:01.329473Z
0 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.354531Z
0 [Note] InnoDB: Highest supported file format is Barracuda.
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.370145Z
0 [Note] InnoDB: Creating shared tablespace for temporary tables
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.370338Z
0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the f
ile full; Please wait ...
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.579908Z
0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.581476Z
0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s)
are active.
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.581498Z
0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.582462Z
0 [Note] InnoDB: Waiting for purge to start
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.635692Z
0 [Note] InnoDB: 5.7.7 started; log sequence number 2530296
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.636189Z
0 [Note] Plugin 'FEDERATED' is disabled.
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.639421Z
0 [Warning] Failed to setup SSL
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.639453Z
0 [Warning] SSL error: SSL context is not usable without certificate and private
key
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.640159Z
0 [Note] Server hostname (bind-address): '*'; port: 3306
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.640231Z
0 [Note] IPv6 is available.
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.640254Z
0 [Note] - '::' resolves to '::';
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.640269Z
0 [Note] Server socket created on IP: '::'.
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.648606Z
0 [Note] InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.650883Z
0 [Note] InnoDB: Buffer pool(s) load completed at 150706 0:45:01
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.673495Z
0 [Note] Event Scheduler: Loaded 0 events
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: 2015-07-06T04:45:01.674091Z
0 [Note] /usr/sbin/mysqld: ready for connections.
Jul 06 00:45:01 localhost.localdomain mysqld[5306]: Version: '5.7.7-rc' socket:
'/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
Jul 06 00:45:01 localhost.localdomain systemd[1]: PID file /var/run/mysqld/mysql
d.pid not readable (yet?) after start.
最佳答案
CentOS 正在将 mysql 转换为 mariadb。在 /usr/lib/systemd/system
下,您应该找到文件 mariadb.service
。只需运行
sudo systemctl start mariadb.service
然后mysql命令运行!
关于mysql - systemctl无法在centos 7上启动mysql,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/31235525/
我正在使用 CentOS 6 机器。我尝试遵循以下指南: How to open port in centOS http://ask.xmodulo.com/open-port-firewall-ce
我正在为 CentOS 7 创建一个脚本,但我正在努力根据变量连接值,这与我工作的其他发行版不同。例如,在下面的代码中: DIR_BKP=/tmp/_bkp_local PATH_LOG=$DIR_B
我从以下位置下载了文件: https://github.com/christiangalsterer/httpbeat/releaseshttpbeat-4.0.0-x86_64.rpm 并尝试通过以
我想在我的 Centos 8 中使用命令 mkimage。 我尝试使用命令 dnf install uboot-tools 以 root 身份安装 uboot-tools 但这不可用。 谁能指导我如何
我有一个 Centos 服务器。 结果 $ cat /etc/centos-release CentOS Linux release 7.9.2009 (Core) 和 $ yum list i
我在CentOs7 上安装Gitlab 后遇到了麻烦。我第一次被重定向到管理员密码创建页面,在输入管理员用户密码后,服务器发送错误。 422 The change you requested was
因此,我正在尝试从我的一个运行 centos 的邮箱中发送电子邮件,并且我已经安装并打开了 sendmail,但是发送一封电子邮件实际上需要几分钟时间。电子邮件不是应该几乎是即时的吗? 这是我的/et
我正在尝试在虚拟 Centos 7 发行版上构建一些 C++ 库。由于我还没有发现这个操作系统看不到/usr/local/lib 或/usr/local/lib64 的原因,这些库安装在其他 linu
我正在尝试通过以下网址在我的服务器(centos 7.1 minimal)上安装 imagemagick: imagemagick installation steps 在第 1 步得到这个错误: L
当我尝试安装 rpmforge(我需要安装 phpmyadmin)时出现此错误,将不胜感激任何帮助! [root@plasticarmy ~]# yum http://pkgs.repoforge.o
我需要安装一个centos 5 repo 来在centos 7 机器上下载用于el5 的dhclient,以便在centos 5 机器上传输dhclient rpms。有可能的 ? 谢谢! 最佳答案
我正在开发一个可以在 CentOS 8 和 CentOS 7 系统上运行的程序。在其中,我使用 gethostbyname 将 DNS 名称解析为 IP 地址。 为了尝试使代码可移植,我正在使用以下命
我想在 CentOS7(或 CentOS6)上安装 cgal 模块。它需要 pgrouting 才能使用 PostGIS。 我一直用 CGAL Manual Installation 安装 cgal
我在 CentOS 平台上使用 R/RStudio。我需要查看二进制日志文件(/var/log/messages)是否包含有关图形设备绘图问题的更多信息,但我无法从 RStudio 中读取它。 我在社
我正在尝试在我的 CentOS 上本地安装 Kubernetes。我正在关注这个博客 http://containertutorials.com/get_started_kubernetes/inde
来自 http://kubernetes.io/docs/getting-started-guides/kubeadm/ CentOS Linux 版本 7.2.1511(核心) (1/4) 在主机上
使用tcpdump监控网络流量时,发现很多dns反向查询记录。 像这样: A_IP.55276 > DNS_IP.domain: 9247+ PTR?查询 IP.in-addr.arpa。 (45)
我正在尝试在 CentOS 6.7 和 ./configure --prefix=$HOME/local 上安装 mutt运行良好,但在 make install步骤,我在下面遇到了这个错误,我不知道
如何在 CENTOS 中删除所有以 *0x0.jpg 结尾的文件?我需要删除嵌套在文件夹和子文件夹中的多个文件 最佳答案 我假设你有一个外壳 - 试试 find /mydirectory -type
我需要检索安装在我的 Linux (Centos) 主机上的所有软件包的软件包版本。 rpm -qa 给了我所有已安装软件包的列表。 我知道 rpm -qi "package name"给了我包信息。
我是一名优秀的程序员,十分优秀!