上午刚装完 MySQL，启动时报如下错误： Starting MySQL.Manager of pid-file quit without updating file....删除 mysql 的日志文件，重启 mysql 发现错误：Starting MySQL.Manager of pid-file quit without updating file.
quick max_allowed_packet = 100M pid-file=/data/3306/mysqld.pid [mysqladmin] pid-file=/data/3306/mysqld.pid...socket = /data/3306/mysql.sock [client] pid-file=/data/3306/mysqld.pid socket = /data.../3306/mysql.sock [mysqld_safe] log-error=/data/3306/mysql_3306.err pid-file=/data/3306/mysqld.pid 1...quick max_allowed_packet = 100M pid-file=/data/3307/mysqld.pid [mysqladmin] pid-file=/data/3307/mysqld.pid.../3307/mysql.sock [mysqld_safe] log-error=/data/3307/mysql_3307.err pid-file=/data/3307/mysqld.pid 1
mysqld.pid --- > PIDFile=/var/run/mysqld/mysqld_glibc.pid 47c47 pid-file...=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS --- > ExecStart=/usr/local/mysql/bin/mysqld --daemonize --pid-file...my.cnf [mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/data socket=/tmp/mysql.sock port=3306 pid-file...00:00:00 /usr/local/mysql/bin/mysqld \ --daemonize --pid-file=/var/run/mysqld/mysqld_glibc.pid 开启自启动...PermissionsStartOnly=true ExecStartPre=/usr/bin/mysqld_pre_systemd ExecStart=/usr/local/mysql/bin/mysqld --daemonize --pid-file
00:01:00 /usr/bin/ceph-osd -i 10 --pid-file /var/run/ceph/osd.10.pid -c /etc/ceph/ceph.conf --cluster...00:01:02 /usr/bin/ceph-osd -i 11 --pid-file /var/run/ceph/osd.11.pid -c /etc/ceph/ceph.conf --cluster...00:01:09 /usr/bin/ceph-osd -i 12 --pid-file /var/run/ceph/osd.12.pid -c /etc/ceph/ceph.conf --cluster...00:01:02 /usr/bin/ceph-osd -i 13 --pid-file /var/run/ceph/osd.13.pid -c /etc/ceph/ceph.conf --cluster...00:01:02 /usr/bin/ceph-osd -i 14 --pid-file /var/run/ceph/osd.14.pid -c /etc/ceph/ceph.conf --cluster
;; --datadir=*) datadir=`echo "$arg" | sed -e 's/^[^=]*=//'` datadir_set=1;; --pid-file...$1" # created | removed pid="$2" # process ID of the program operating on the pid-file...test -s "$pid_file_path" && i='' && break ;; 'removed') # wait for this PID-file to...created|removed pid pid_file_path" exit 1 ;; esac # if server isn't running, then pid-file...$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>
/mysqld_safe –datadir=/data/mysql –socket=/var/lib/mysql/mysql.sock –log-error=/var/log/mysqld.log –pid-file...40456 9076 pts/0 Sl 03:03 0:00 /usr/libexec/mysqld –basedir=/usr –datadir=/data/mysql –user=mysql –pid-file...get_mysql_option mysqld_safe log-error “/var/log/mysqld.log” errlogfile=”$result” get_mysql_option mysqld_safe pid-file
cp -p /etc/my.cnf /tmp/my.cnf.bak 原原来的删除，先将5.7初始化再说 vim /etc/my.cnf [mysqld_safe] nice = 0 pid-file...default-storage-engine=INNODB lower_case_table_name=1 max_allowed_packet=16M log-error=/var/log/mysql/mysql.log pid-file...=/var/log/mysql/mysql.pid bind-address = 0.0.0.0 #3307的，多加了一个pid-file。...datadir = /data/seven socket = /data/seven/mysql.sock port = 3307 log-error = /data/seven/mysql.log pid-file
2、parse_server_arguments：该函数处理my_print_defaults传递过来的参数赋值给--basedir、--datadir、--pid-file、--service-startup-timeout...datadir=`echo "$arg" | sed -e 's/^[^=]*=//'` datadir_set=1 ;; --pid-file...$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &...: pts/ :: /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file.../mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file
解决办法 在/etc/my.cnf 中查看pid-file的位置 pid-file=/var/run/mysqld/mysqld.pid 创建对应的目录并修改权限 最好给 777权限（chmod -R
--datadir=*) datadir=`echo "$arg" | sed -e 's/^[^=]*=//'` datadir_set=1 ;; --pid-file...$1" # created | removed pid="$2" # process ID of the program operating on the pid-file...test $i -ne $service_startup_timeout ; do case "$verb" in 'created') # wait for a PID-file...test -s "$pid_file_path" && i='' && break ;; 'removed') # wait for this PID-file...bindir/mysqld_safe then $bindir/mysqld_safe --defaults-file="$conf" --datadir="$datadir" --pid-file
x86_64/bin/mysqld_safe --defaults-file=/etc/my-ib.cnf --log-queries-not-using-indexes --user=root --pid-file...oradata/app/iee/data --user=root --log-queries-not-using-indexes --log-error=/oradata/app/iee/data.err --pid-file...x86_64/bin/mysqld_safe --defaults-file=/etc/my-ib.cnf --log-queries-not-using-indexes --user=root --pid-file...datadir=/oradata/app/iee/data --log-queries-not-using-indexes --log-error=/oradata/app/iee/data.err --pid-file
hostname`.pid #如果my.cnf有指定，会使用my.cnf的 $bindir/mysqld_safe --defaults-file=/home/mysql3306/data/my.cnf --pid-file...--datadir=*) datadir=`echo "$arg" | sed -e 's/^[^=]*=//'` datadir_set=1 ;; --pid-file...test -s "$pid_file_path" && i='' && break ;; 'removed') # wait for this PID-file...|removed pid pid_file_path" exit 1 ;; esac # if server isn't running, then pid-file...: # the server still runs else # The server may have exited between the last pid-file
/0 00:00:00 /bin/sh /usr/bin/mysqld_safe –datadir=/var/lib/mysql –socket=/var/lib/mysql/mysql.sock –pid-file...datadir=/var/lib/mysql –plugin-dir=/usr/lib/mysql/plugin –user=mysql –log-error=/var/log/mysqld.log –pid-file
二、如何查看pid文件位置 通过查看 my.cnf 文件（通常位于/etc/my.cnf）即可得知pid文件的位置，如pid-file=/var/run/mysqld/mysqld.pid。...如果MySQL安装后没有PID文件，可能是由于配置文件中的pid-file参数未正确设置或MySQL服务未以预期的用户身份运行。...systemctl stop mysql 检查MySQL配置文件 打开MySQL的配置文件，通常是my.cnf，找到mysqld部分，确认pid-file的路径设置正确 pid-file=/var/run...需要注意的是，手动创建PID文件通常不是常规操作，因为MySQL在启动时会自动创建PID文件（如果配置文件中指定了pid-file参数）。
556213321 --log-bin --skip-name-resolve --character-set-server=utf8mb4 --log-error=lhrmysqlall.err --pid-file...564813331 --log-bin --skip-name-resolve --character-set-server=utf8mb4 --log-error=lhrmysqlall.err --pid-file...log-timestamps=SYSTEM --skip-name-resolve --character-set-server=utf8mb4 --log-error=lhrmysqlall.err --pid-file...556213321 --log-bin --skip-name-resolve --character-set-server=utf8mb4 --log-error=lhrmysqlall.err --pid-file...564813331 --log-bin --skip-name-resolve --character-set-server=utf8mb4 --log-error=lhrmysqlall.err --pid-file
;; --datadir=*) datadir=`echo "$arg" | sed -e 's/^[^=]*=//'` datadir_set=1;; --pid-file...$1" # created | removed pid="$2" # process ID of the program operating on the pid-file...test -s "$pid_file_path" && i='' && break ;; 'removed') # wait for this PID-file to...created|removed pid pid_file_path" exit 1 ;; esac # if server isn't running, then pid-file...$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &
= on #GENERAL_LOG=ON general-log-file = /app/mysql5722/logs/mysqld.log slow-query-log = 1 pid-file... #innodb_buffer_pool_size=2G [mysqld_safe] log-error=/app/mysql5722/logs/mysql_error.log pid-file...general.log slow-query-log=1 long_query_time=1 slow_query_log_file=/app/mysql5722/slowquery.log pid-file...symbolic-links=0 #skip-grant-tables [mysqld_safe] log-error=/app/mysql5722/logs/error.log pid-file
password = my_password [mysqld1] socket = /usr/local/var/mysql1/mysql1.sock port = 3306 pid-file...english user = mysql [mysqld2] socket = /usr/local/var/mysql2/mysql2.sock port = 3307 pid-file...english user = mysql [mysqld3] socket = /usr/local/var/mysql3/mysql3.sock port = 3308 pid-file...english user = mysql [mysqld4] socket = /usr/local/var/mysql4/mysql4.sock port = 3309 pid-file...mysql port = 3306 socket = /data/3306/mysql.sock basedir = /application/mysql datadir = /data/3306/data pid-file
mysqld_safe [mysqld1] # 基础配置 port=3306 user=root basedir = /usr/local/mysql datadir=/mysql/3306/data pid-file...port=3307 user=root basedir = /usr/local/mysql datadir=/mysql/3307/data socket=/mysql/3307/mysql.sock pid-file...mysql/bin/mysqld_safe [mysqld1] port=3306 user=root basedir = /usr/local/mysql datadir=/mysql/3306/data pid-file...binlog_cache_size=4M [mysqld2] port=3307 user=root basedir = /usr/local/mysql datadir=/mysql/3307/data pid-file
领取专属 10元无门槛券
手把手带您无忧上云
云服务器
ICP备案
腾讯会议
云直播
对象存储
