Navicat error occurred after installation: 1045-access denied for user ' root ' @ ' localhost ' (using Password:yes)

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)