|
Replies:
1
-
Pages:
1
-
Last Post:
Jun 17, 2010 2:37 PM
by: al.miller_046
|
|
|
Posts:
16
Registered:
6/11/10
|
|
|
|
How to connect to remote mysql database (linux) from pc running Win XP
Posted:
Jun 17, 2010 1:19 PM
|
|
|
Hi,
My site has quite a few mysql databases on various linux servers. I've got a copy of "Toad for MySQL" ver 4.6 on my windows PC.
First thing I'm trying to do is connect to a mysql db (mysqld) on a server owned by my group.
I select "Connection Manager", select "create a new connection" and a Connection box opens.
Under connection type, I'm selecting TCP, enter in the host name, username, password and the database (mysqld).
I get a pop up window "Can't connect to MySQL server on 'hostname' (10061)
Would love some advice on trouble shooting this.
Al
|
|
|
Posts:
16
Registered:
6/11/10
|
|
|
|
Re: How to connect to remote mysql database (linux) from pc running Win XP
Posted:
Jun 17, 2010 2:37 PM
in response to: al.miller_046
|
|
|
The username is for a current user created in that mysql instance.
database - is for a database the is within that instance - by default - mysql
Once I used the correct username/password and a valid database - I was able to connect.
Still learning.
Al
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
