After installing MySQL and N, the following error occurred after opening navicat:
1045-access denied for user ' root ' @ ' localhost ' (using Password:yes) **********
(episode: Remember do not know how many times this is installed MySQL, used to be sqlyog, suddenly installed a navicat, altogether error, let their small shame a!!! After the internet to check the information, the solution statement below)
"Problem": the root user is not assigned all permissions.
"Resolution steps": For example: User name:AAA Password:123456
First, open the MySQL 5.5 command line Client commands window:
Enter password:123456;
Second, enter the following command: Grant all on * * to [email protected] '% ' identified by ' 123456 ';
Mysql>grant all on * * to AAA@ ' percent ' identified by '123456'; (Remember to add the English semicolon after this statement)
Third, then will appear: Query ok,0 rows affected <0.00 Sec> explained that the permissions have been changed successfully, the problem solved!!!
Four, open Navicat, double-click localhost, will not report the error, at this time can operate, do whatever it took 650) this.width=650; "Src=" Http://img.baidu.com/hi/jx2/j_0069.gif " alt= "J_0069.gif"/>650) this.width=650, "src=" Http://img.baidu.com/hi/jx2/j_0069.gif "alt=" J_0069.gif "/>650" this.width=650, "src=" Http://img.baidu.com/hi/jx2/j_0069.gif "alt=" J_0069.gif "/>650" this.width=650; "src=" http ://img.baidu.com/hi/jx2/j_0069.gif "alt=" J_0069.gif "/>
"Problem extension": Grant all on * * to AAA@ '% ' of ' identified by '123456'; for this sentence, one word has been granted to AAA users all permissions.
This article is from "Bo's World" blog, please be sure to keep this source http://6190523.blog.51cto.com/6180523/1614142
Navicat error occurred after installation: 1045-access denied for user ' root ' @ ' localhost ' (using Password:yes)