mysql重置密码报错/usr/local/mysql/bin/mysqld does not exist
来源:互联网 发布:网络主播黑名单查询 编辑:程序博客网 时间:2024/06/06 09:25
mysql 通过mysqld_safe修改密码报错/usr/local/mysql/bin/mysqld does not exist
因为mysqld_safe默认会去寻找/usr/local/mysql/bin/这个目录下的mysqld,若mysql安装时不在此目录,则会报错
解决方法:
第一种:将mysql移到/usr/lcoal/目录下。
第二种:建立软连接
mkdir -p /usr/local/mysql/bin ln -s /usr/mysql/bin/mysqld /usr/local/mysql/bin/mysqld
重置密码:
关闭mysql后,使用mysqld_safe启动
mysqld_safe --skip-grant-tables &
开启另一个命令行窗口,此时登录mysql不需要密码
mysqluse mysql;update user set password=password("123456") where user="root";flush privileges;
详情参考
http://www.cnblogs.com/moss_tan_jun/p/6080058.html修改密码参考
http://www.linuxidc.com/Linux/2014-02/97109.htm
阅读全文
0 0
- mysql重置密码报错/usr/local/mysql/bin/mysqld does not exist
- mysqld_safe启动报错 mysqld_safe The file /usr/local/mysql/bin/mysqld does not exist or is not executable
- directory /usr/local/bin does not exist
- mysql 启动报错 /usr/local/mysql//libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid'
- mysql初始化出现:Installing MySQL system tables.../usr/local/mysql/bin/mysqld: error while loading shared
- [ERROR] Failed to execute/usr/local/mysql/bin/mysqld --bootstrap --datadir=……
- [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted: Server shutdown in progress
- 小黑小波比./usr/local/mysql/bin/mysqld_safe --user=mysql&报错
- [mysqldumpslow 报错] Died at /usr/local/mysql/bin/mysqldumpslow line 161, <> chunk 236.
- [mysqldumpslow 报错] Died at /usr/local/mysql/bin/mysqldumpslow line 161, <> chunk 236.
- /usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
- 启动Mysql时报错:mysqld_safe mysqld from pid file /usr/local/mysql/data/Linux.pid ended
- mysql出现The user specified as a definer ('root'@'%') does not exist报错!
- 关于mysql存储过程报错The user specified as a definer ('oem'@'%') does not exist
- mysql出现The user specified as a definer ('root'@'%') does not exist报错!
- MYSQL FUNCTION mysql.redis_servers_set_v2 does not exist
- MySQL报错Couldn’t find MySQL manager (/usr/bin/mysqlmanager) or server (/usr/bin/mysqld_safe)
- MySQL报错Couldn’t find MySQL manager (/usr/bin/mysqlmanager) or server (/usr/bin/mysqld_safe)
- OpenCV中Mat矩阵相乘——点乘、dot、mul运算详解
- 流形学习——Isomap算法
- android 资源仓库
- NOIP2017滚粗记
- django middleware
- mysql重置密码报错/usr/local/mysql/bin/mysqld does not exist
- 其他题目---Manacher算法
- linux删除文件后未释放空间解决办法
- leetcode Integer Break 整数拆分
- 未找到路径“/BOX/BoxInfo/Index”的控制器或该控制器未实现 IController。
- Mybatis与Hibernate的区别
- Python基本数据结构总结
- 适配iPhone X Push过程中TabBar位置上移
- 美国证监会主席:ICO交易疑存在价格操控