win7上SQLyog登入本地mysql提示:1045 access denied for user'root'@'localhost'
来源:互联网 发布:poi java解析excel 编辑:程序博客网 时间:2024/04/29 21:12
1、打开DOS进入mysql下bin目录:本人:C:\Program Files\MySQL\MySQL Server 5.1\bin
2、停止mysql服务,net stop mysql
2、停止mysql服务,net stop
3、在C:\Program Files\MySQL\MySQL Server 5.1\bin后面输入:mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server \my.ini" --console --skip-grant-tables
Version: '5.1.33-community-log' socket: '' port: 3306 MySQL Community Server
(GPL)
4.看到这个结果就说明MySQL已经起来了。
再开一个DOS窗口,同样切到mysql bin目录下,
C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -uroot mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.33-community-log MySQL Community Server (GPL)
5.
mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
1 0
- win7上SQLyog登入本地mysql提示:1045 access denied for user'root'@'localhost'
- Win7下mysql root账户登录提示:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:
- 连接mysql提示Access denied for user 'root'@'localhost'
- mac上: mysql Access denied for user root@localhost
- navicat 提示“1045 access denied for user 'root'@'localhost' ”解决方法
- mysql Access denied for user 'root'@'localhost'
- MySQL Access denied for user 'root'@'localhost'
- windows mysql提示:1045 access denied for user'root'@'localhost' using password yes
- MySQL提示:1045 access denied for user 'root'@'localhost' using password yes
- Mysql登录提示1045 error:access denied for user 'root'@'localhost <using password: yes>
- MYSQL 提示:1045 access denied for user 'root'@'localhost' using password yes
- mysql提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- windows mysql提示:1045 access denied for user 'root'@'localhost' using password ye
- windows mysql提示:1045 access denied for user 'root'@'localhost' using password yes 解决方案
- windows mysql提示:1045 access denied for user'root'@'localhost' using password yes
- 解决MySql 数据库 提示:1045 access denied for user 'root'@'localhost' using password yes
- centos 6.5 连接MySQL 提示:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:
- 解决MySql 数据库 提示:1045 access denied for user 'root'@'localhost' using password yes
- Vim快捷键使用笔记
- 将一个文本打乱顺序的简单方法
- ksoap调用webservice
- Linux下安装Tomcat9.0
- 数据库连接大全
- win7上SQLyog登入本地mysql提示:1045 access denied for user'root'@'localhost'
- Java Double相加出现的怪事
- iFunk翼只换不修强出新高度
- Egg Dropping Puzzle
- 微信读书解读
- 用chrome浏览器打开百度,显示“您的连接不是私密连接”,如何解决该问题?
- C++:表达式翻译
- Benchmark Code on DSP using the Time Stamp Counter (TSC)
- xhttp解析