Re: Accessing MySQL across private network
On Saturday, April 3, 2004, at 06:22 PM, Enrique Samson Jr. wrote: Mark Gillingham wrote: In terms of mysql commands, I cannot do the follow mysql command from server2: mysql -hserver1 -umyuser -p can you do that from server1? No. S.D.A. had the solution. Neither MySQL was configured to accept network connections. "skip-network" in my.cnf. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Accessing MySQL across private network
Mark Gillingham wrote: In terms of mysql commands, I cannot do the follow mysql command from server2: mysql -hserver1 -umyuser -p can you do that from server1? I get the error: ERROR 2003: Can't connect to MySQL server on '192.168.1.3' (111) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Accessing MySQL across private network
On Saturday, April 3, 2004, at 11:35 AM, S.D.A. wrote: In your mysql.conf do you have networking enabled? Nope! Thanks. I never would have figured this out without help. For others in this boat, the line "skip-networking" must be commented out in my.cnf. The caution is that you will want to study carefully how users and host are created not that networking is on. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Accessing MySQL across private network
On Sat, Apr 03, 2004 at 09:23:21AM -0600 or thereabouts, Mark Gillingham wrote: > I suppose the answer to my question is obvious, but I don't see it. I have two > nearly identical Woody servers set up for LAMP on a private network. I want to > access MySQL on server2 (192.168.1.4) from server1 (192.168.1.3). The user and > host settings for MySQL work from either server as long as the host is > localhost or the same IP or domain name. For instance, Apache/PHP on server1 > can access MySQL on server1 and likewise on server2. I am wondering of > hosts.allow is set incorrectly (ALL: 192.168.1.*: ALLOW) or if there is > another default protection that disallows network MySQL access. > I hope this makes sense to someone. Thanks. In your mysql.conf do you have networking enabled? -- Steve + Saturday Apr 03 2004 12:31:01 PM EST + Calling you stupid is an insult to stupid people! -- Wanda, "A Fish Called Wanda" pgp0.pgp Description: PGP signature
Accessing MySQL across private network
I suppose the answer to my question is obvious, but I don't see it. I have two nearly identical Woody servers set up for LAMP on a private network. I want to access MySQL on server2 (192.168.1.4) from server1 (192.168.1.3). The user and host settings for MySQL work from either server as long as the host is localhost or the same IP or domain name. For instance, Apache/PHP on server1 can access MySQL on server1 and likewise on server2. I am wondering of hosts.allow is set incorrectly (ALL: 192.168.1.*: ALLOW) or if there is another default protection that disallows network MySQL access. In terms of mysql commands, I cannot do the follow mysql command from server2: mysql -hserver1 -umyuser -p I get the error: ERROR 2003: Can't connect to MySQL server on '192.168.1.3' (111) I can do the following from server2: mysql -hserver2 -umyuser -p or mysql -hlocalhost -umyuser -p or mysql -h192.168.1.4 -umyuser -p I hope this makes sense to someone. Thanks. Mark -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
