DBForge cant connect to my DB but MySQLWorkBench can

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
ntlam121
Posts: 2
Joined: Thu 15 May 2014 02:31

DBForge cant connect to my DB but MySQLWorkBench can

Post by ntlam121 » Thu 15 May 2014 02:44

Hi everybody,
I am using DBForge, today when I try to connect my remote DB, DBForge said :

---------------------------
dbForge Studio Express for MySQL
---------------------------
Access denied for user 'msb'@'10.2.142.51' (using password: YES)
---------------------------
OK
---------------------------

But when I try with MySqlWorkBench, it can connect. I think server was used command "GRANT ALL PRIVILEGES...", because WB can connect to. I prefer using DBForge to using WB. Please help me. Thank you.

alexa

Re: DBForge cant connect to my DB but MySQLWorkBench can

Post by alexa » Thu 15 May 2014 07:02

The error message 'msb'@'10.2.142.51 (using password: YES)' means that there is a connection to your server, but the access for the user msb from the IP-address 10.2.142.51 is forbidden.

Therefore, you need to create the user msb@%.

Please also check that you are using the same user msb and connecting from the same machine having IP address 10.2.142.51 when successfully establishing a connection with MySqlWorkBench.

ntlam121
Posts: 2
Joined: Thu 15 May 2014 02:31

Re: DBForge cant connect to my DB but MySQLWorkBench can

Post by ntlam121 » Thu 15 May 2014 09:46

alexa wrote:The error message 'msb'@'10.2.142.51 (using password: YES)' means that there is a connection to your server, but the access for the user msb from the IP-address 10.2.142.51 is forbidden.

Therefore, you need to create the user msb@%.

Please also check that you are using the same user msb and connecting from the same machine having IP address 10.2.142.51 when successfully establishing a connection with MySqlWorkBench.
Im sure that I used same account for DBForge and WB, because I only know one account for this server :?

alexa

Re: DBForge cant connect to my DB but MySQLWorkBench can

Post by alexa » Fri 16 May 2014 10:54

Could you please let us know whether you are using SSH or HTTP tunneling when connecting to the MySQL server?

Also, please try to double-check that you are entering a correct password for the user msb.

Post Reply