mysqld_safe启动报错问题

在我启动第一次启动mysql脚本时候发现

[root@template 3306]# /data/3306/mysql_3306 start
Starting MySQL...
220226 21:20:32 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

1、mysqld_safe只认识/usr/local/mysql/bin/mysqld(也许是配置问题)

2、my.cnf只能放置在/etc/下面,不然使用–defaults-file也不能读取my.cnf文件(疑惑???)解决方法

配置一个软连接指向 /usr/local/mysql/bin

mkdir /usr/local/mysql/bin
​
[root@template bin]# ln -s /appmysql/mysql-5.6.34-linux-glibc2.5-x86_64/bin/mysqld /usr/local/mysql/bin/mysqld

再次启动查看结果

[root@template 3306]# /data/3306/mysql_3306 start
Starting MySQL...
[root@template 3306]# ll
total 1432
drwxr-xr-x 5 mysql mysql     126 Feb 26 21:28 data
-rw-r--r-- 1 mysql mysql     319 Dec 21 22:28 my.cnf
drwxr-xr-x 2 mysql mysql       6 Dec 21 22:28 mysql
-rwx------ 1 mysql mysql     929 Feb 26 21:21 mysql_3306
-rw-r----- 1 mysql root     3445 Feb 26 21:28 mysql_3306_error.log
-rw-rw---- 1 mysql mysql   69420 Feb 26 20:57 mysql-bin.000001
-rw-rw---- 1 mysql mysql 1371047 Feb 26 20:57 mysql-bin.000002
-rw-rw---- 1 mysql mysql     120 Feb 26 21:28 mysql-bin.000003
-rw-rw---- 1 mysql mysql      84 Feb 26 21:28 mysql-bin.index
-rw-rw---- 1 mysql mysql       6 Feb 26 21:28 mysqld_3306.pid
srwxrwxrwx 1 mysql mysql       0 Feb 26 21:28 mysql.sock

 

posted @ 2022-02-27 10:38  yuezenghui  阅读(322)  评论(0编辑  收藏  举报