Mac使用mysql报Mac ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)错误
来源:互联网 发布:宿舍 知乎 编辑:程序博客网 时间:2024/06/14 04:01
转自:http://blog.csdn.net/say_c_box/article/details/72842286
- 用安全模式进入数据库
1.1 打开系统偏好设置,如果你的电脑已经安装mysql,会在下面有一个mysql的按钮。点进去关闭mysql服务
1.2 打开一个终端,输入一下命令
$ cd /usr/local/mysql/bin$ sudo su
然后便可以看到终端命令变成这个开头: sh-3.2#
输入一下命令
sh-3.2#./mysqld_safe --skip-grant-tables &
之后边可以以安全模式进入数据库了。
1.3 现在打开一个新的终端
输入以下命令:
mysql -u -root
然后便会发现你不需要密码就进入数据库了。
这个方法成功的解决了我的问题!
阅读全文
0 0
- Mac使用mysql报Mac ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)错误
- ERROR 1045 (28000):Access denied for user 'root'@'localhost' (using password: NO) Mac解决方案
- 解决MySQL 报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Mac下解决mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mac系统中mysql登录报错:Access denied for user 'root'@'localhost' (using password: NO)
- [linux][mysql]ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password:No)错误
- 解决MySql登录错误ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- MySQL错误:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mac 'Access denied for user 'root'@'localhost' (using password: NO)'
- 解决数据库连接报ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)问题
- ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)错误解决方法
- CentOS 命令登录MySQL时,报错 ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- linux下登录mysql报错“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO“)
- mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- MySQL 报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 的解决办法
- mysql-->ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- oracle启动
- Opencv3.x安装教程 mac
- Vue监听全局变量
- 打开层级比较深的Activity并返回到App的主页面
- insert into select与select into的区别
- Mac使用mysql报Mac ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)错误
- httpClient传cookie
- uboot的GPIO驱动分析--基于全志的A10芯片
- linux命令学习
- x64 asm汇编记录
- web service 解析服务器
- mysql把表中某一字段拆分为多列
- Drools
- 欢迎使用CSDN-markdown编辑器