mysql dbvisualizer,MySQL与DBVisualizer的连接

I've created a user (1caap) in mysql root account and given read only privileges for this user to one of my database. Now my client(1caapuser) is unable to access this database. I've established the connection using Workbench. He's getting the following error when he's trying to access this database using DBVisualizer:

An error occurred while establishing the connection:

Type: java.sql.SQLException Error Code: 1045 SQL State: 28000

Message:

Access denied for user '1caapuser'@'x.x.x.x' (using password: YES)

Please help me out if i'd missed any settings at the earliest.

解决方案

To resolve this issue you have to grant all privileges on database with identified by the password

Command to run:

GRANT ALL PRIVILEGES ON yourDBname.* TO username@'%' IDENTIFIED BY 'password';