|
Replies:
1
-
Pages:
1
-
Last Post:
Apr 11, 2011 1:16 AM
by: Peter@sids
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
1
Registered:
1/3/11
|
|
|
|
Connection to DB
Posted:
Jan 3, 2011 9:19 AM
|
|
|
Here's my configuration:
1. Windows 7 OS
2. UBUNTU Linux
3. MySQL 5.0 installed on the Linux
4. Successfully created database and tables using command line MySQL in Linux
5. Toad for MySQL version 5.0.0.345 installed on my PC
The IP address of my Linux box is known as I did an ifconfig.
When I try to connect to the server from Toad, I get the following popup error: Unable to connect to any of the specified MySQL hosts.
I have configured my connection as follows:
Connection type: TCP
Host: <ip address>
user: <username>
password: <password>
database: <db name I created>
port: 3306
I didn't want to include the actual ip address, username, and password for security reasons.
|
|
|
Posts:
2
Registered:
4/11/11
|
|
|
|
Re: Connection to DB
Posted:
Apr 11, 2011 1:16 AM
in response to: Jerry Scannell
|
|
|
Hi : Just a thought some install for the MYSQL have the network turned off by default in the config file on the server
I think the flag is:
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
