MySQL connection error parsing in MyEclipse

Connect to MySQL: window --> show view --> other --> MyEclipse Database --> DB Browser in MyEclipse, for example:

 

Click DB Browser, and the View Interface will change. In the blank area of the DB Browser tab, right-click and choose New ..., That is, to create a connection to MySQL, the following dialog box is displayed to fill in the information:

The Driver name can be set according to your preferences. When the Driver template is selected for the Connection URL, jdbc: mysql: //

In order to verify whether the password is wrong, I immediately tried it on the MySQL terminal. after entering the same password, I successfully connected to the MySQL database, why can't the same password be used in MyEclipse on the terminal? Some online searches still fail. The final problem is solved in this way. Open the MySQL terminal, enter the password, and query the user table (select * from mysql. only one root user exists in the result. You can change the User name in to root.

Now the truth is clear. Click Test Driver again. The following dialog box is displayed, indicating that MySQL is successfully connected.

To better understand the problem, I re-installed MySQL. This installation is not just to see every step of the installation. When installing this step, I found that the user is not actually another one, it must be root. Why is it a step in installation:

If the check item is Modify Security Settings, the user is root by default (circled in red), and the password of the root user is in the next two text boxes, this explains why select * from mysql is used. the user only finds the root user.

Link: http://www.cnblogs.com/kmyangyang/archive/2012/07/15/2592314.html

Edit recommendations]

1. MySQL source code learning: MDL dictionary lock
2. Simple deployment of MySQL Cluster Development Environment
3. Analysis of four different MySQL queries
4. Oracle Releases MySQL cluster 7.2
5. Features and usage of MySQL memory tables