Home > database >  How to modify the mysql root username, navicat can't new connections
How to modify the mysql root username, navicat can't new connections

Time:09-22



The user name can login via the command in the CMD mysql, new disconnected in navicat

CodePudding user response:

Root login in, create a new user name, the other note: programming can not Chinese, do not have to use Chinese,

CodePudding user response:

The user name in Chinese, it has never been tried, may be because of problems caused by the character set,

This advice is better in English as much as possible,

CodePudding user response:

First, I'm not sure if the user name is support in Chinese, but this is not recommended, because in some cases, the support for the Chinese is not good,
Second, is highly suspected the SELECT Todd Harper ost FROM mysql. The user t WHERE t.u ser=? Field has a problem, you replace the question mark with your user name, try changing the host to the percent of English,
  • Related