mysql无法启动ERROR! MySQL is running but PID file could not be found ?
来源:互联网 发布:淘宝男装女装一起卖 编辑:程序博客网 时间:2024/05/24 06:32
有3种可能,我遇到的就是第二种:
第一种:
可能是硬盘满了,清理下垃圾文件。
第二种:
提示
ERROR! MySQL is running but PID file could not be found先打印MYSQL进程
ps aux | grep mysql
然后KILL进程
kill -9 pid1 pid2 …
再启动MYSQL
sudo support-files/mysql.server start //启动
sudo support-files/mysql.server restart //重启
sudo support-files/mysql.server stop //停止
sudo support-files/mysql.server status //检查 MySQL 运行状态
第三种:是修改过my.cnf配置出错引起 执行命令:vi /usr/local/mysql/my.cnf 修改内容:
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
在执行第二种命令,OK
------------------------------------------------------------------------------------------------------------顺便贴下mac下mysql的安装:
//解压到安装目录
/usr/local/mysql
//将解压后的包移动到安装目录下
sudo mv mysql-5.7.12-osx10.11-x86_64 /usr/local/mysql
//更改mysql安装目录所属用户与用户组(权限)
cd /usr/local sudochown -R root:wheel mysql
//完成一些默认的初始化,执行完下面这一步会出现一个临时的密码,请保存好这密码以便修改密码
sudo bin/mysqld--initialize--user=mysqlcd /usr/local/mysql
sudo support-files/mysql.server start //启动
sudo support-files/mysql.server restart //重启
sudo support-files/mysql.server stop //停止
sudo support-files/mysql.server status //检查 MySQL 运行状态//修改密码,输入上面给的密码
mysqladmin-u root -p旧密码 password 新密码
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- mysql无法启动ERROR! MySQL is running but PID file could not be found
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- linux无法启动mySQL解决办法,MySQL is running but PID file could not be found
- ERROR! MySQL is running but PID file could not be found ?
- Linux虚拟机的Mysql启动失败 ERROR! Multiple MySQL running but PID file could not be found (
- MySQL is running but PID file could not be found [FAILED]
- MySQL is running but PID file could not be found[失败]
- MySQL is running but PID file could not be found(解决方法)
- centOS下msyql启动错误-Multiple MySQL running but PID file could not be found
- Linux 下mysql 启动失败 Multiple MySQL running but PID file could not be found (1761 1448)[失败]
- MySQL is running but PID file is not found
- 解决Multiple MySQL running but PID file could not be found (179[失败])
- 将MySQL数据库搬迁到另一服务器中遇到的问题:MySQL is running but PID file could not be found[FAILED]&MySQL大小写
- mysql无法启动ERROR! MySQL is running but PID file coul
- openwrt创建应用软件包和内核软件包 Makefile的讲解
- 101个MySQL调试和优化技巧
- 架构漫谈(七):不要空设架构师这个职位,给他实权
- rsync error: protocol incompatibility / mismatch ?
- JavaScript 面向对象编程
- mysql无法启动ERROR! MySQL is running but PID file could not be found ?
- 获取短信验证码 倒计时 CountDownTimer
- sql脚本创建表【如已经有表,先删除,后创建】
- 【51Nod】1083 - 矩阵取数问题(dp)
- plsql中如何设置sql window背景颜色
- B+树|MYSQL索引使用原则
- spring 实现数据库读写分离
- C# 方法和属性的访问权限修饰符解析
- 工具类