Page 1 of 1

DBForge cant connect to my DB but MySQLWorkBench can

Posted: Thu 15 May 2014 02:44
by ntlam121
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.

Re: DBForge cant connect to my DB but MySQLWorkBench can

Posted: Thu 15 May 2014 07:02
by alexa
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.

Re: DBForge cant connect to my DB but MySQLWorkBench can

Posted: Thu 15 May 2014 09:46
by ntlam121
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 :?

Re: DBForge cant connect to my DB but MySQLWorkBench can

Posted: Fri 16 May 2014 10:54
by alexa
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.