首页 / MYSQL / 初始化MySQL后服务不能正常启动
初始化MySQL后服务不能正常启动
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了初始化MySQL后服务不能正常启动,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2267字,纯文字阅读大概需要4分钟。
内容图文
初始化MySQL服务后,使用/etc/init.d/mysqld启动MySQL服务,报错,查看其错误日志error.log:
150413 21:26:54 mysqld_safe mysqld from pid file /data/mysqldata/mysql.pid ended
150413 21:30:19 mysqld_safe Starting mysqld daemon with databases from /data/mysqldata
2015-04-13 21:30:21 27464 [Note] Plugin ‘FEDERATED‘ is disabled.
2015-04-13 21:30:21 27464 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-04-13 21:30:21 27464 [Note] InnoDB: The InnoDB memory heap is disabled
2015-04-13 21:30:21 27464 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-04-13 21:30:21 27464 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-04-13 21:30:21 27464 [Note] InnoDB: Using Linux native AIO
2015-04-13 21:30:21 27464 [Note] InnoDB: Using CPU crc32 instructions
2015-04-13 21:30:21 27464 [Note] InnoDB: Initializing buffer pool, size = 24.0G
2015-04-13 21:30:23 27464 [Note] InnoDB: Completed initialization of buffer pool
2015-04-13 21:30:24 27464 [Note] InnoDB: Highest supported file format is Barracuda.
2015-04-13 21:30:25 27464 [Note] InnoDB: 128 rollback segment(s) are active.
2015-04-13 21:30:25 27464 [Note] InnoDB: Waiting for purge to start
2015-04-13 21:30:25 27464 [Note] InnoDB: 5.6.19 started; log sequence number 1626134
2015-04-13 21:30:25 27464 [Note] Server hostname (bind-address): ‘*‘; port: 3306
2015-04-13 21:30:25 27464 [Note] IPv6 is available.
2015-04-13 21:30:25 27464 [Note] - ‘::‘ resolves to ‘::‘;
2015-04-13 21:30:25 27464 [Note] Server socket created on IP: ‘::‘.
2015-04-13 21:30:25 27464 [ERROR] Can‘t start server: Bind on TCP/IP port: Address already in use
2015-04-13 21:30:25 27464 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-04-13 21:30:25 27464 [ERROR] Aborting
通过其报错信息,我们可以明显的看到3306端口已经被占用
原因:初始化MySQL的使用没有停止MySQL服务
-
netstat -nputl|grep 3306 结果发现已经有一个MySQL服务在启动
150413 21:30:29 mysqld_safe mysqld from pid file /data/mysqldata/mysql.pid ended
-
通过/etc/init.d/mysqld stop将MySQL服务停止,如果不行,则使用kill -9 pid将其杀死
-
再次启动MySQL服务:/etc/init.d/mysqld start
[root@localhost ~]# /etc/init.d/mysqld start
Starting MySQL........ SUCCESS!
切记:初始化MySQL时,一定要先停止数据库服务
service mysqld stop
本文出自 “nagios故障” 博客,请务必保留此出处http://5250070.blog.51cto.com/5240070/1636316
原文:http://5250070.blog.51cto.com/5240070/1636316
内容总结
以上是互联网集市为您收集整理的初始化MySQL后服务不能正常启动全部内容,希望文章能够帮你解决初始化MySQL后服务不能正常启动所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。