Workaround for the Access denied for user ' ODBC ' @ ' localhost ' (using Password:no)

An error encountered while deploying the company's Web project to MyEclipse: Access denied for user ' ODBC ' @ ' localhost ' (using password:no), which seems to be the default for MySQL to not allow remote access.

The solution is documented as follows :

1. Stop the MySQL service

2. Locate the My.ini in the MySQL installation directory, locate the [mysqld] and add this sentence below: Skip_grant_tables (Skip permission table authentication when starting the MySQL service)

Remember to save the save.

3. In cmd, locate the Myql Bin directory and enter the command: Mysql-u root-p

No password, enter

　　　　　　

4. After entering, enter: use MySQL

　　　　　　　

5. Change Password input: Update mysql.user set authentication_string = password ("Newly set Password") where user= "root";( I am here MySQL version is 5.7, where the properties of the password column is called authentication_string;5.1 is password);

　　　　　　

6. Refresh permissions: Flush privileges;

7. Exit: Quit;

8. Remove the skip_grant_tables from My.ini and restore the login authorization form

9. Restart the MySQL service, then log in with root and modified password: mysql-u root-p

Then enter the password to verify that the successful entry instructions were successful.

　　　　　　

The above is a concrete step, hoping to help you with the problems you encountered,

Workaround for the Access denied for user ' ODBC ' @ ' localhost ' (using Password:no)