• 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
  • 相关阅读:
    研究人员用数据统计的方法来做文学研究
    导致大数据项目失败的4大痛点及应对策略
    导致大数据项目失败的4大痛点及应对策略
    excel怎么制作三维圆环图表
    excel怎么制作三维圆环图表
    ios开发之Swift新手入门
    ZOJ3629 Treasure Hunt IV(找规律,推公式)
    nginx源代码分析--进程间通信机制 & 同步机制
    <LeetCode OJ> 326. Power of Three
    二进制整数的乘除运算
  • 原文地址:https://www.cnblogs.com/liuxiutianxia/p/10986138.html
Copyright © 2020-2023  润新知