MySQL5.7启动数据库报错'doesnotexistorisnotexecutable'怎么解决

本篇内容介绍了“MySQL5.7启动数据库报错'does not exist or is not executable'怎么解决”的有关知识,在实际案例的操作过程中,不少人都会遇到这样的困境,接下来就让小编带领大家学习一下如何处理这些情况吧!希望大家仔细阅读,能够学有所成!

专注于为中小企业提供成都网站设计、成都网站制作、外贸网站建设服务,电脑端+手机端+微信端的三站合一,更高效的管理,为中小企业十堰郧阳免费做网站提供优质的服务。我们立足成都,凝聚了一批互联网行业人才,有力地推动了上千企业的稳健成长,帮助中小企业通过网站建设实现规模扩充和转变。

MySQL 5.7启动数据库报错
[root@localhost ~]# mysqld_safe --defaults-file=/etc/my.cnf &
[1] 23687
[root@localhost ~]#  mysqld_safe Adding '/mysql_software_57/lib/mysql/libjemalloc.so.1' to LD_PRELOAD for mysqld
2017-04-08T00:21:30.162718Z mysqld_safe Logging to '/mysql_log_57/mysqld_error.log'.
2017-04-08T00:21:30.166075Z mysqld_safe Logging to '/mysql_log_57/mysqld_error.log'.
2017-04-08T00:21:30.171866Z mysqld_safe The file /usr/local/Percona-Server-5.7.17-11-Linux.x86_64.ssl101/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

[1]+  Exit 1                  mysqld_safe --defaults-file=/etc/my.cnf

解决方法:
在MySQL 5.7中,安全性提升,要求切换到软件安装目录,来启动数据库
[root@localhost ~]# cd /mysql_software_57/
[root@localhost mysql_software_57]# bin/mysqld_safe --defaults-file=/etc/my.cnf &
[1] 25341
[root@localhost mysql_software_57]#  mysqld_safe Adding '/mysql_software_57/lib/mysql/libjemalloc.so.1' to LD_PRELOAD for mysqld
2017-04-08T00:22:31.981599Z mysqld_safe Logging to '/mysql_log_57/mysqld_error.log'.
2017-04-08T00:22:31.984805Z mysqld_safe Logging to '/mysql_log_57/mysqld_error.log'.
2017-04-08T00:22:32.070881Z mysqld_safe Starting mysqld daemon with databases from /mysql_data_57

“MySQL5.7启动数据库报错'does not exist or is not executable'怎么解决”的内容就介绍到这里了,感谢大家的阅读。如果想了解更多行业相关的知识可以关注创新互联网站,小编将为大家输出更多高质量的实用文章!


文章标题:MySQL5.7启动数据库报错'doesnotexistorisnotexecutable'怎么解决
网页网址:http://ybzwz.com/article/gdppce.html