In the last three days, the following problems have been solved: I myeclipse in the Java EE project, after running the prompt access denied for user ' root ' @ ' localhost ' (using Password:yes), When I connect a MySQL database with a Java file, there is no problem. So I found some solutions on the Internet:
(1) Allow the root to grant the current user the right to delete and change the search:Grant Select,insert,update,delete on * * to username @ "%" identified by "password"; as a result I didn't solve the problem.
(2) Modify the user's password:SET PASSWORD for [email protected]"%" = PASSWORD (' PASSWORD '); As a result I didn't solve the problem.
(3) Reinstall the software. I reinstalled it three times, but I haven't solved the problem yet.
(4) Other solutions: http://stackoverflow.com/questions/10299148/ MYSQL-ERROR-1045-28000-ACCESS-DENIED-FOR-USER-BILLLOCALHOST-USING-PASSW. None of this solves my problem, you can try it.
Here's my solution:
A. I reinstalled the MyEclipse2015 (changed from 8.5 to 2015).
B. I have installed the latest Tomcat7.0.64 (personally considered the most important solution).
Copyright NOTICE: This article for Bo Master original article, if need to reprint, please indicate the source, thank you.
About the Java EE Project connection database prompt access denied for user ' root ' @ ' localhost ' (using password:yes) solution