The access address must be unified. 127.0.0.1 is different from localhost or ip. There are also special characters in passwords. Different clients have different support for special characters
I searched and found this thread, http://bbs.chinaunix.net/thread-658853-1-1.html
Is the subject accessing the database locally? Or access the database from other networks (LAN, different network segments, public network).
It is also possible that the root password did not take effect in time after being set. In this case, the subject can try to log in using the default password of root.
If you have installed an integrated environment, it is possible that there are two mysql databases locally. The databases you connect to are different according to the access address, so even if it is the root user name or password, an error may be reported
The access address must be unified. 127.0.0.1 is different from localhost or ip. There are also special characters in passwords. Different clients have different support for special characters
I searched and found this thread, http://bbs.chinaunix.net/thread-658853-1-1.html
Is the subject accessing the database locally? Or access the database from other networks (LAN, different network segments, public network).
It is also possible that the root password did not take effect in time after being set. In this case, the subject can try to log in using the default password of root.
If you have installed an integrated environment, it is possible that there are two mysql databases locally. The databases you connect to are different according to the access address, so even if it is the root user name or password, an error may be reported