search

Home >Database >Mysql Tutorial >解决error 1045: Access denied for user: 'root@lo_MySQL

解决error 1045: Access denied for user: 'root@lo_MySQL

WBOY
WBOYOriginal
2016-06-01 13:07:54948browse

转载连接：http://jianfw2009.blog.163.com/blog/static/13431366020111016112459158/


1、先停止mysql服务2、在mysql的目录下找到my.ini，在[mysqld]后面加上skip-grant-tables3、启动mysql服务,打开Command Line Client以空密码登录4、退出mysql,并停止服务5、把my.ini中添加的：skip-grant-tables 去掉5、再次开启mysql服务，直接回车登录，输入：set password for root@localhost=password('newpwd');6、退出重新配置，大功告成！

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：通过JDBC链接Mysql数据库_MySQLNext article：如何在mysql中存取utf8mb4编码的字符_MySQL

Related articles

See more