Springboot using JAP to connect MySQL database error
Access denied for user ' @ ' localhost ' (using Password:no)
Database connection password, use local database localhost, no password set, run the program to report the error above,
Database connection password parameter is not set or set to an empty string are reported above the error, helpless, set a password for the local database
Check: The process is as follows, the pro-test pipe
Windows:
Modify the My.ini file, at the end of the add Skip-grant-tables, skip the process of entering the password, otherwise it seems not to enter the MySQL command line interface,
Then restart the MySQL service
Go to cmd
Switch to the MySQL installation directory under bin
Execute the following command at once
Use MySQL;
Update user set Password=password (") where user= ' root ';
Flush privileges;
Quit
Note: Each line must be preceded by a semicolon followed by a return
Prompt for query OK to execute successfully
MySQL connection error