解决mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
来源:互联网 发布:轩辕剑 还原数据库 编辑:程序博客网 时间:2024/06/05 19:23
事情是这样的,原先创建MySQL中的root用户,指定的host为localhost,就想改一下为某个网段的,结果改完之后就退出了,然后就悲剧了,无法连接了。网上找的大部分解决办法是:
ubuntu下操作
#先停止MySQL服务service msyql stop#跳过安全检查/usr/bin/mysqld_safe --skip-grant-tables &#重开一个shell进入mysql#更改密码...#刷新权限#重新启动MySQL服务
结果我走到第二步就错了啊,报错信息
mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
解决办法还是很简单的
mkdir -p /var/run/mysqldchown mysql:mysql /var/run/mysqld
然后再执行
/usr/bin/mysqld_safe --skip-grant-tables &
另开一个shell修改,修改完成后,flush privileges;
结束掉当前执行的进程即可
阅读全文
0 0
- 解决mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
- mysqld_safe --skip-grant&提示mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
- mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.
- linux安装mysql提示mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid1 ended
- mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- linux安装mysql提示mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'解决
- xampp的mysql --》Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'解决
- 解决mysqld_safe A mysqld process already exists
- usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid
- mysql启动报can't create/write to file 'var/run/mysqld/mysqld.pid 错误解决办法
- java中String相关操作方法
- 微信小程序二维码解析遇到的问题
- webpack入门(1)
- THREE.js案例源码学习-geometry_birds
- 数据结构与算法Java版——双向链表
- 解决mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
- shell循环etl跑历史数据
- 一篇随笔
- GCD信号量控制并发
- Object转Flaot解决方案
- 解决Firefox不响应window.resize事件
- 使用Spark完成基于TF-IDF特征的新闻热点聚类
- NIO系列(五)——Udp协议(DatagramChannel)
- TCP通信