MySQL 5.7啟動資料庫報錯'does not exist or is not executable'

feelpurple發表於2017-04-08
MySql資料庫
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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26506993/viewspace-2136837/，如需轉載，請註明出處，否則將追究法律責任。

相關文章