mac下安装mysql5.7.18,连接出现Access denied for user 'root'@'localhost' (using password: YES)
来源:互联网 发布:mac window 编辑:程序博客网 时间:2024/06/06 17:48
mac下,mysql5.7.18连接出错,错误信息为:Access denied for user'root'@'localhost' (using password: YES)
()里面的为shell中输入的命令,一定要输全包括;&等符号
第一步:苹果->系统偏好设置->最下面点mysql,关闭mysql服务
第二步:进入终端输入(cd /usr/local/mysql/bin/)回车
输入(sudo su)回车以获取管理员权限
输入(./mysqld_safe --skip-grant-tables &)回车以禁止mysql验证功能,mysql会自动重启,偏好设置中的mysql状态会变成running
第三步:输入命令(./mysql)回车
输入命令(flush privileges;)分号别忘记输了
输入命令(set password for 'root'@'localhost' = password('root');) password('root')中的root为新密码,自己随便设置,分号别忘记输入
至此,密码修改成功,可以正常登入了。
参考文章:
http://www.jb51.net/article/107028.htm
3 0
- mac下安装mysql5.7.18,连接出现Access denied for user 'root'@'localhost' (using password: YES)
- mac下安装mysql5.7.18,连接出现Access denied for user 'root'@'localhost' (using password: YES)
- Linux下连接Mysql出现:Access denied for user 'root'@'localhost' (using password:YES)的解决方法
- 下安装mysql后出现 Access denied for user 'root'@'localhost' (using password: YES)
- mac Access denied for user 'root'@'localhost' (using password: YES)
- java连接mysql5.7报错Access denied for user 'root'@'localhost' (using password: YES)解决
- java连接mysql5.7报错Access denied for user 'root'@'localhost' (using password: YES)解决
- Mac安装MySQL5.7.19 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- win7下mysql5.6遇到Access denied for user 'root'@'localhost'(using password :NO/YES)
- ubuntu下mysql5.7的'Access denied for user 'root'@'localhost' (using password: YES)'错误
- MySQL for mac 连接报错:Access denied for user 'root'@'localhost' (using password: YES)
- 出现错误 连接MySQL数据库,出现问题:Access denied for user 'root'@'localhost' (using password:YES)
- JSP连接MySQL时出现--错误:Access denied for user 'root'@'localhost' (using password: YES)'解决方案
- 连接池配置出现access denied for user 'root'@'localhost'(using password:YES)异常
- 关于Navicat mysql连接出现1045 access denied for user 'root'@'localhost' using password: yes
- navicat连接数据库出现1045 access denied for user 'root'@'localhost' using password yes
- mac下的error: 'Access denied for user 'root'@'localhost' (using password: YES)'
- Mac下解决mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 编码规范
- JavaScript语言基础---(五)函数
- oracle高级查询之数据优化(1)------如何创建效率高sql-建立索引
- mac 自制app 打包安装工具(2)
- 关于oracle 登陆ie信任证书问题
- mac下安装mysql5.7.18,连接出现Access denied for user 'root'@'localhost' (using password: YES)
- 论代码注释的重要性。
- SSM配置文件详解
- Hadoop机架感知配置
- Oracle12c jdbc版本驱动问题
- 简单的sql注入式攻击 教程(小白 )
- composer的简单使用
- DEBUG 之 指令
- Java 源码 ——顺序存取文件的创建及写入(Writing data to a sequential text file with class Formatter)