JDBC usage exercise in Java-error MySQL access denied for user ODBC @ localhost

1.

After installing and setting MySQL, run CMD in windows and run the MySQL Command. An error occurs:

Cause:

In Windows, the default DoS user is ODBC, but there is no ODBC user in MySQL, so an error occurs. You can change it to MySQL-uroot-P. Here the root user is used, you can also use other users, provided that they have local logon permissions.

My solution:

Run the command-mysql-H localhost-u root-P

Enter the password of the root account.

2. Use in crazy Java

Mysql-P password-u user name-H Host Name

No database is created on the machine, so the password after-P does not need to be entered; otherwise, an error is reported.

Run:

Mysql-p-u root-H localhost

Enter the password again.