Re: Accessing remote machine (Ubuntu) from Window
Do you have skip networkin in my.cnf ? No, no skip-networking is in the my.cnf file. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing remote machine (Ubuntu) from Window
Do you have skip networkin in my.cnf ? --Original Message-- From: Jesse To: Curtis Maurand Cc: MySQL List Sent: Jul 17, 2008 16:54 Subject: Re: Accessing remote machine (Ubuntu) from Window My settings are the same, except I have the bind-address set to my local IP of 192.168.1.128. I tried 0.0.0.0, and I still cannot connect from other machines. Jesse - Original Message - From: "Curtis Maurand" <[EMAIL PROTECTED]> To: "Jesse" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Thursday, July 17, 2008 5:41 PM Subject: RE: Accessing remote machine (Ubuntu) from Window I just checked my ubuntu config and I have: Port = 3306 Bind-address = 0.0.0.0 Pid-file = /var/run/mysqld/mysqld.pid Socket = /var/run/mysqld/mysqld.sock Nothig is in upper case. My phone is doing that for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Sent via BlackBerry from T-Mobile
Re: Accessing remote machine (Ubuntu) from Window
My settings are the same, except I have the bind-address set to my local IP of 192.168.1.128. I tried 0.0.0.0, and I still cannot connect from other machines. Jesse - Original Message - From: "Curtis Maurand" <[EMAIL PROTECTED]> To: "Jesse" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Thursday, July 17, 2008 5:41 PM Subject: RE: Accessing remote machine (Ubuntu) from Window I just checked my ubuntu config and I have: Port = 3306 Bind-address = 0.0.0.0 Pid-file = /var/run/mysqld/mysqld.pid Socket = /var/run/mysqld/mysqld.sock Nothig is in upper case. My phone is doing that for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Accessing remote machine (Ubuntu) from Window
I just checked my ubuntu config and I have: Port = 3306 Bind-address = 0.0.0.0 Pid-file = /var/run/mysqld/mysqld.pid Socket = /var/run/mysqld/mysqld.sock Nothig is in upper case. My phone is doing that for me. -Original Message- From: "Jesse" <[EMAIL PROTECTED]> To: "Curtis Maurand" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: 7/17/2008 4:46 PM Subject: Re: Accessing remote machine (Ubuntu) from Window I was wondering how I get it to listed on all ports. When I try 0.0.0.0, and try to restart, the restart fails, and when it tries to start again, I get the error, /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password:YES)' This has been happening for a day or so, and I don't know if it's related to my problem or not. After changing the grant to use an IP address, I still cannot log in. Jesse [truncated by sender] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing remote machine (Ubuntu) from Window
I was wondering how I get it to listed on all ports. When I try 0.0.0.0, and try to restart, the restart fails, and when it tries to start again, I get the error, /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password:YES)' This has been happening for a day or so, and I don't know if it's related to my problem or not. After changing the grant to use an IP address, I still cannot log in. Jesse - Original Message - From: "Curtis Maurand" <[EMAIL PROTECTED]> To: "Jesse" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Thursday, July 17, 2008 4:31 PM Subject: Re: Accessing remote machine (Ubuntu) from Window I cannot. Are you trying to connect via the localhost. It may still be trying to connect to localhost. You might try changing the bind-address statement to bind-address = 0.0.0.0 so that it also listens to localhost as well. Also if you're trying to connect to an ip address instead of a named host, I've found that you have to code your grant statement to have an ip address instead of a hostname. Curtis Jesse wrote: Obvious question: Did you restart MySQL? netstat -l should show you what's listening for connections. you'll want to see if its listening on port 3306. Yes. When that didn't work, I re-started the whole server. netstat -l tells me that 192.168.1.128:mysql is listening. It lists a foreign address of "*.*" When I re-issue the command with "-n", I can seee that it is, indeed, listening on port 3306. Can you think of any other reasons why the connection would fail? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing remote machine (Ubuntu) from Window
I cannot. Are you trying to connect via the localhost. It may still be trying to connect to localhost. You might try changing the bind-address statement to bind-address = 0.0.0.0 so that it also listens to localhost as well. Also if you're trying to connect to an ip address instead of a named host, I've found that you have to code your grant statement to have an ip address instead of a hostname. Curtis Jesse wrote: Obvious question: Did you restart MySQL? netstat -l should show you what's listening for connections. you'll want to see if its listening on port 3306. Yes. When that didn't work, I re-started the whole server. netstat -l tells me that 192.168.1.128:mysql is listening. It lists a foreign address of "*.*" When I re-issue the command with "-n", I can seee that it is, indeed, listening on port 3306. Can you think of any other reasons why the connection would fail? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing remote machine (Ubuntu) from Window
Obvious question: Did you restart MySQL? netstat -l should show you what's listening for connections. you'll want to see if its listening on port 3306. Yes. When that didn't work, I re-started the whole server. netstat -l tells me that 192.168.1.128:mysql is listening. It lists a foreign address of "*.*" When I re-issue the command with "-n", I can seee that it is, indeed, listening on port 3306. Can you think of any other reasons why the connection would fail? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
