mysql在mysqld_safe安全模式下启动报错
发布:smiling 来源: PHP粉丝网 添加日期:2014-10-04 11:30:31 浏览: 评论:0
费话不说多我们来看看在我linux中的mysql在mysqld_safe安全模式下启动报错失败的原因与解决办法,有需要了解的朋友可尝试此方法来解决你的问题.
使用二进制编译文件的mysqld_safe启动报错,如下:
- [mysql@ECP-UC-DB1 ~]$ mysqld_safe
- 110707 21:31:19 mysqld_safe Logging to ‘/opt/mysql/mysqldata/ECP-UC-DB1.err’.
- 110707 21:31:19 mysqld_safe The file /usr/local/mysql/bin/mysqld
- does not exist or is not executable. Please cd to the mysql installation
- directory and restart this script from there as follows:
- ./bin/mysqld_safe&
- See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information
解决方法:
- su – root
- mkdir /usr/local/mysql/bin
- ln -s /opt/mysql/product/5.5/bin/mysqld /usr/local/mysql/bin/mysqld
再次执行mysqld_safe
- [mysql@ECP-UC-DB1 ~]$ mysqld_safe
- 110707 21:32:37 mysqld_safe Logging to ‘/opt/mysql/mysqldata/ECP-UC-DB1.err’. --phpfensi.com
- 110707 21:32:37 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/mysqldata
启动结果:
- mysql 26885 23452 0 21:32 pts/0 00:00:00 /bin/sh /opt/mysql/product/5.5/bin/mysqld_safe
- mysql 27653 26885 0 21:32 pts/0 00:00:00 /usr/local/mysql/bin/mysqld –basedir=/opt/mysql/product/5.5 –datadir=/opt/mysql/mysqldata –plugin-dir=/usr/local/mysql/lib/plugin –log-error=/opt/mysql/mysqldata/ECP-UC-DB1.err –open-files-limit=8192 –pid-file=/var/run/mysqld/mysqld.pid –socket=/var/run/mysqld/mysqld.sock –port=3306
问题存在原因:
1、mysqld_safe只认识/usr/local/mysql/bin/mysqld(也许是配置问题)
2、my.cnf只能放置在/etc/下面,不然使用–defaults-file也不能读取my.cnf文件(有疑惑)
总结,不一样的问题可能会有一点区别,大家需要根据自己的经验来分析原因.
Tags: mysqld_safe mysql安全模式
相关文章
- ·解决mysqld_safe无法启动问题的方法(2015-04-18)
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)