Home >Database >Mysql Tutorial >ERROR 1142 (42000):UPDATE command denied to user ''@'loca_MySQL
ERROR 1142 (42000):UPDATE command denied to user ''@'loca_MySQL
- WBOYOriginal
- 2016-06-01 13:48:025766browse
bitsCN.com
ERROR 1142 (42000):UPDATE command denied to user ''@'localhost' for table 'user的问题 mysql> update mysql.user set password='123456'where User='root';
出现ERROR 1142 (42000): UPDATE command denied to user ''@'localhost' for table 'user'错误 解决方法如下：
进入mysql/bin目录，执行mysqladmin -uroot password 密码
之后，再进mysql -uroot -p 回车后，显示 passwd: ok！ bitsCN.com
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：mysql问题：using expire_logs_days without log_bin crashes th_MySQLNext article：MySql官方手册学习笔记2―MySql的模糊查询和正则表达式_MySQL