MySQL connection error

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