The server quit without updating PID file

[root@fjgh ~]# service mysqld start
Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql-5.5.62/data/fjgh.pid).

  

查看日志文件 /usr/local/mysql-5.5.62/data/fjgh.err

190520  9:06:34 [Note] Plugin 'FEDERATED' is disabled.
190520  9:06:34 InnoDB: The InnoDB memory heap is disabled
190520  9:06:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190520  9:06:34 InnoDB: Compressed tables use zlib 1.2.11
190520  9:06:34 InnoDB: Using Linux native AIO
190520  9:06:34 InnoDB: Initializing buffer pool, size = 128.0M
190520  9:06:34 InnoDB: Completed initialization of buffer pool
190520  9:06:34 InnoDB: highest supported file format is Barracuda.
190520  9:06:34  InnoDB: Waiting for the background threads to start
190520  9:06:35 InnoDB: 5.5.62 started; log sequence number 1595675
190520  9:06:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
190520  9:06:35 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
190520  9:06:35 [Note] Server socket created on IP: '0.0.0.0'.
190520  9:06:35 [ERROR] Can't start server : Bind on unix socket: Permission denied
190520  9:06:35 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
190520  9:06:35 [ERROR] Aborting

注意  Can't start server : Bind on unix socket: Permission denied

发现  /var/lib/mysql 目录下并没有生成mysql.sock  预计是权限问题

于是修改 

[root@fjgh ~]# chmod 777 /var/lib/mysql
[root@fjgh ~]# service mysqld start
Starting MySQL.. SUCCESS! 

 启动成功

突然又发现 mysql -v 执行出错

[root@fjgh bin]# mysql -v
-bash: msysql: command not found

查看环境变量配置

[root@fjgh bin]# echo $PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/local/java/jdk1.8.0_212/bin:/root/bin:/usr/local/mysql-5.5.60/bin

发现配置的mysql的bin目录不对,应该是  /usr/local/mysql-5.5.62/bin

修改,刷新配置即可

[root@fjgh bin]# echo $PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/local/java/jdk1.8.0_212/bin:/root/bin:/usr/local/mysql-5.5.60/bin
[root@fjgh bin]# source ~/.bash_profile
[root@fjgh bin]# echo $PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/local/java/jdk1.8.0_212/bin:/root/bin:/usr/local/mysql-5.5.60/bin:/root/bin:/usr/local/mysql-5.5.62/bin

 

posted @ 2019-06-06 20:21  创可贴Y  阅读(351)  评论(0编辑  收藏  举报