|
Replies:
3
-
Pages:
1
-
Last Post:
Mar 3, 2010 12:16 AM
by: DocJones
|
|
|
Posts:
2
Registered:
2/16/10
|
|
|
|
Need help connecting to MySQL
Posted:
Feb 16, 2010 9:16 PM
|
|
|
I've just installed MySQL 5.5 on my Windows XP computer. I can connect on that machine, but I can't seem to connect from any other on my network. What's going on?
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Need help connecting to MySQL
Posted:
Feb 17, 2010 12:00 AM
in response to: Quantium
|
|
|
Have you enabled the TCP protocol on your computer. Also do you happen to have a firewall that might get in the way of you connecting to the server perhaps?
|
|
|
Posts:
2
Registered:
2/16/10
|
|
|
|
Re: Need help connecting to MySQL
Posted:
Mar 1, 2010 1:53 PM
in response to: Mauritz
|
|
|
Mauritz,
I'm still pretty new to MySQL, so I'm not sure how you enable TCP protocol. Where is such a setting?
|
|
|
Posts:
50
Registered:
2/22/10
|
|
|
|
Re: Need help connecting to MySQL
Posted:
Mar 3, 2010 12:16 AM
in response to: Quantium
|
|
|
Heyas,
depending on the errormessage you get, it may be MySQL itself preventing your to sign in. Best would be to sign in locally and check the mysql.user table:
Access to MySQL is regulated on a host/user combination. If the host value is '%', access from outside is allowed. Typically, root access is limited to "localhost", you have to consider yourself what you want to do: open up root access or create a dedicated remote user.
regards
/M
|
Level 197 Nanomage NT from Rimor speaking... err, wait: Wrong Forum!
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
