mysqld_safe --skip-grant&提示mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
来源:互联网 发布:免费视频格式转换软件 编辑:程序博客网 时间:2024/05/17 06:29
一、问题
今天整理Windows和Linux修改mysql数据库密码的时候,忘记密码的情况下,需要跳过安全检查,即
#mysqld_safe --skip-grant &
但是却提示mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
二、说明
Windows停止、启动mysql
#net stop mysql
#net start mysql
Linux停止、启动mysql
#service mysql stop
#service mysql start
二、解决办法
#停止mysql
#mkdir -p /var/run/mysqld
#chown mysql:mysql /var/run/mysqld
#mysqld_safe --skip-grant &
此时当前命令窗无法操作了,重新打开一个新的命令窗,无需密码mysql即可连接上mysql
#mysql
mysql>
往下修改mysql密码即可。Linux/Windows修改mysql密码可以参考博文:http://blog.csdn.net/justinqin/article/details/78871679
修改完成后记得刷新权限。
mysql>flush privileges;
mysql>exit;
今天整理Windows和Linux修改mysql数据库密码的时候,忘记密码的情况下,需要跳过安全检查,即
#mysqld_safe --skip-grant &
但是却提示mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
二、说明
Windows停止、启动mysql
#net stop mysql
#net start mysql
Linux停止、启动mysql
#service mysql stop
#service mysql start
二、解决办法
#停止mysql
#mkdir -p /var/run/mysqld
#chown mysql:mysql /var/run/mysqld
#mysqld_safe --skip-grant &
此时当前命令窗无法操作了,重新打开一个新的命令窗,无需密码mysql即可连接上mysql
#mysql
mysql>
往下修改mysql密码即可。Linux/Windows修改mysql密码可以参考博文:http://blog.csdn.net/justinqin/article/details/78871679
修改完成后记得刷新权限。
mysql>flush privileges;
mysql>exit;
阅读全文
0 0
- mysqld_safe --skip-grant&提示mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
- 解决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
- 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
- 解决mysqld_safe A mysqld process already exists
- mysqld_safe mysqld restarted
- mysqld_safe mysqld区别
- Xampp使用mysql命令提示Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- mysqld_safe mysqld from pid file /mysqldata/mysql_data/cl1.pid ended
- usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid
- mysqld与mysqld_safe的区别
- mysqld与mysqld_safe的区别
- mysqld与mysqld_safe的区别
- mysqld与mysqld_safe的区别
- 再谈C++的多态性
- java----异常
- Web Service详解
- 洛谷 p1208 混合牛奶
- 无穷小分析的研究现状
- mysqld_safe --skip-grant&提示mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
- 文件上传:HTTP错误 404.13-Not Found 请求筛选模块被配置为拒绝超过请求内容长度的请求
- 19. Remove Nth Node From End of List
- 面试纪录
- Sublime Text 工具使用
- android开发笔记之高德地图使用
- 我的姥爷走了,今后再也没有这个严厉而又较真儿的人
- CodeForces 9 D.How many trees?(dp)
- [duyi]171222 DOM