How to connect to MySQl db on linux server using t

2019-09-14 19:56发布

问题:

How to connect to MySQl db on linux server using toad?

what i should give on host?

i get the error

Can't connect to MySQL server on 'tinywall' (10061)

回答1:

Do you use Toad for MySQL? If so, check out this installation guide if you missed anything, or this PDF guide from ToadSoft.

Also, have a look at this quote from MySQL's page on connection problems:

The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the server.



回答2:

Please check you /etc/mysql/my.conf

  • Is "skip-networking" active?
  • Is "bind-address" set to 127.0.0.1?