MySQL与DBVisualizer的连接 [英] MySQL connection with DBVisualizer

问题描述

我已经在mysql根帐户中创建了一个用户（1caap），并为此用户授予我的数据库之一的只读权限。现在我的客户端（1caapuser）无法访问该数据库。我已经使用Workbench建立了连接。尝试使用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

要运行的命令：

在 yourDBname 上授予所有特权。* TO username @'％'由'password'标识；

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

这篇关于MySQL与DBVisualizer的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！