MySQL報錯：Starting MySQL ERROR! Couldn‘t find MySQL server (/usr/local/mysql/bin/mysqld_safe)

更新時間：2024年03月15日 08:56:39 作者：DATA TOO

本文主要介紹了MySQL報錯：Starting MySQL ERROR! Couldn‘t find MySQL server (/usr/local/mysql/bin/mysqld_safe)

1. 要對MySQL數據庫清除原來已有的數據，重新初始化數據庫。

Linux系統(tǒng)：CentOS7.6，數據庫：MySQL5.6.40。先將mysql進程強行停止掉。

pkill mysqld

2. 對數據庫進行清理：

[root@mv172 ~]# rm -rf /application/mysql/data/*
[root@mv172 ~]# \rm -rf /data/mysql/*

3. 配置文件安裝在/application/mysql-5.6.40/my.cnf

[mysqld]
basedir=/application/mysql
datadir=/application/mysql/data
socket=/tmp/mysql.sock
log_error=/var/log/mysql.log
log_bin=/data/mysql/mysql-bin
binlog_format=row
skip-name-resolve
server_id=172
gtid-mode=on
enforce-gtid-consistency=true
log-slave-updates=1
[client]
socket=/tmp/mysql.sock

4. 執(zhí)行數據庫初始化命令：這次初始化沒有把配置文件添加進去，導致問題的開始。

[root@mv172 ~]# /application/mysql/scripts/mysql_install_db --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data/

......出現一堆的執(zhí)行代碼，此處就省略：

5. 將mysql啟動復制到系統(tǒng)為默認啟動路徑

[root@mv172 ~]# \cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld

6. # 啟動mysql，這時候有報錯：

[root@mv172 ~]# /etc/init.d/mysqld start
/etc/init.d/mysqld: line 244: my_print_defaults: command not found
/etc/init.d/mysqld: line 264: cd: /usr/local/mysql: No such file or directory
Starting MySQL ERROR! Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe)

7. 經過不斷嘗試，終于找到問題根源。因為起初初始化時，沒有將mysql路徑和數據庫保存路徑綁定好，而導致一連串問題。

查配置文件，沒有配置的保存mysql-bin二進制保存路徑。

[root@mv172 /]# mkdir -p /data/mysql
[root@mv172 /]# chown -R mysql.mysql /data/*

8. 重新初始化數據，自此增加“--defaults-file=/application/mysql/my.cnf”

[root@mv172 data]# /application/mysql/scripts/mysql_install_db --defaults-file=/application/mysql/my.cnf --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data

9 . # 于是查看mysqld文件
發(fā)現
“basedir=
datadir=”
這兩個路徑，突然想到mysql啟動順手時以這個mysqld優(yōu)先，于是將配置文件這兩個路徑添加到這里來，

#   [mysqld]
#   basedir=<path-to-mysql-installation-directory>
# - Add the above to any other configuration file (for example ~/.my.ini)
#   and copy my_print_defaults to /usr/bin
# - Add the path to the mysql-installation-directory to the basedir variable
#   below.
#
# If you want to affect other MySQL variables, you should make your changes
# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.

# If you change base dir, you must also change datadir. These may get
# overwritten by settings in the MySQL configuration files.


basedir=
datadir=

......

10 . 重新再執(zhí)行初始化數據庫，執(zhí)行

啟動數據庫命令

[root@mv172 data]# /etc/init.d/mysqld start
Starting MySQL.. SUCCESS!

到此這篇關于MySQL報錯：Starting MySQL ERROR! Couldn‘t find MySQL server (/usr/local/mysql/bin/mysqld_safe)的文章就介紹到這了,更多相關Starting MySQL ERROR!內容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: