Re: Connecting to remote server
I have the user hardware set to be able to connect to the database from any host. That is why I am so confused as to why this doesn't work. Mike > From: Andrew Boothman <[EMAIL PROTECTED]> > Date: Wed, 14 Jan 2004 01:04:36 + > To: Mike Tuller <[EMAIL PROTECTED]> > Cc: MySql List <[EMAIL PROTECTED]> > Subject: Re: Connecting to remote server > > Mike Tuller wrote: > >> I have a shell script that is supposed to connect to a remote server running >> MySql 3.23.53. It comes up with an error "ERROR 1045: Access denied for >> user: '[EMAIL PROTECTED]' (Using password: YES)" >> >> The script looks like this: >> /usr/local/mysql/bin/mysql --user=$username --password=$password >> cetechnology -e \ >> >> That makes sense to me, I don't have permissions set correctly right for the >> $username (hardware). I know the password is set correctly. >> >> Then why am I able to connect to the server in the terminal with: >> /usr/local/mysql/bin/mysql -h 204.xxx.xxx.xxx -u hardware -p cetechnology >> And then enter my password. >> >> What is the difference? > > I'm not certain about this one (I'm not totally confident with MySQL's > permission system myself). But it seems to me that assuming that the IP > that you x'd out in your second example _is_ the IP of the local server > in your first example then MySQL is going to treat them incoming > connections from two different locations. > > One is going to be a connection from [EMAIL PROTECTED] the other is a > connection from [EMAIL PROTECTED] - I think there's a good chance > that MySQL will treat these as entirely different hosts to be GRANTed on > despite the fact that they are actually the same physical machine. > > Therefore - if connections to 204.xxx.xxx.xxx work and connections to > localhost don't, you need to GRANT the right permissions to > [EMAIL PROTECTED] > > Have a look over the relevent section of the handbook for how to use GRANT > > HTH > > Andrew > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to remote server
Mike Tuller wrote: I have a shell script that is supposed to connect to a remote server running MySql 3.23.53. It comes up with an error "ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)" The script looks like this: /usr/local/mysql/bin/mysql --user=$username --password=$password cetechnology -e \ That makes sense to me, I don't have permissions set correctly right for the $username (hardware). I know the password is set correctly. Then why am I able to connect to the server in the terminal with: /usr/local/mysql/bin/mysql -h 204.xxx.xxx.xxx -u hardware -p cetechnology And then enter my password. What is the difference? I'm not certain about this one (I'm not totally confident with MySQL's permission system myself). But it seems to me that assuming that the IP that you x'd out in your second example _is_ the IP of the local server in your first example then MySQL is going to treat them incoming connections from two different locations. One is going to be a connection from [EMAIL PROTECTED] the other is a connection from [EMAIL PROTECTED] - I think there's a good chance that MySQL will treat these as entirely different hosts to be GRANTed on despite the fact that they are actually the same physical machine. Therefore - if connections to 204.xxx.xxx.xxx work and connections to localhost don't, you need to GRANT the right permissions to [EMAIL PROTECTED] Have a look over the relevent section of the handbook for how to use GRANT HTH Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Connecting to remote server
On Wednesday 19 February 2003 11:24, kk wrote: > I just installed mysql4.x into the home/username directory of a remote > machine. It is running good and I created a new user tester with all > privileges. > But how can i connect to the remote server running on a home directory > using a front end tool like MySQLFront. It is listening to default port > 3306. Use hostname of the remote box or IP address. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to remote server
Using the hostname or IP adders of the machine it is on. Jerry - Original Message - From: "kk" <[EMAIL PROTECTED]> To: "list mysql" <[EMAIL PROTECTED]> Sent: Wednesday, February 19, 2003 9:24 AM Subject: Connecting to remote server > Hello folks > I just installed mysql4.x into the home/username directory of a remote > machine. It is running good and I created a new user tester with all > privileges. > But how can i connect to the remote server running on a home directory using > a front end tool like MySQLFront. It is listening to default port 3306. > > Any lights? > > regards > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: connecting to remote server
> > >If I type the following at the command prompt, in this > example I'm using > > >username for the user name, and 66.66.66.66 for the IP address > > >(although I use real values) > > > > > >mysql -h 66.66.66.66 -u username -p > > > > > >it asks for my password then goes off and thinks for a while before > > >coming back with: > > > > > >ERROR 2003 - can't connect to MySQL server on 'ip address' (port) 1. Try to telnet to port 3306 on the server. Do you get any response at all? If it doesn't connect, either MySQL isn't running or it's not enabled remote connections. If it connects but just sits there and doesn't give you back a few bytes of junk, you have a different problem ;) 2. If you can connect and get garbage, you'll have to get on the server itself (or gain access to the server as a privileged user) to do anything further. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to remote server
Thanks for this, I may well need additional privileges, but I can't see how I can change these on the remote server without connecting first! Julia gerald_clark wrote: > Check the section of the manual covering the privilege system, > especially the "GRANT" command. > > Julia Maddocks wrote: > > >I would like to connect to MySQL database on a remote server using > >either the command prompt or MySQLFront. > > > >I have the IP address, username, password but I can't connect. > > > >MySQLfront just hangs when I enter all the information > > > >If I type the following at the command prompt, in this example I'm using > >username for the user name, and 66.66.66.66 for the IP address > >(although I use real values) > > > >mysql -h 66.66.66.66 -u username -p > > > >it asks for my password then goes off and thinks for a while before > >coming back with: > > > >ERROR 2003 - can't connect to MySQL server on 'ip address' (port) > > > >any ideas? > > > >Julia > > > > > > -- -- Julia Maddocks OOOOOOO \|/ \|/ \|/ \|/ \|/ \|/ \|/ / \ / \ / \ / \ / \ / \ / \ National Development Officer The Playwork Unit at SPRITO phone: 01865 247499 mobile: 07803 044986 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to remote server
Check the section of the manual covering the privilege system, especially the "GRANT" command. Julia Maddocks wrote: I would like to connect to MySQL database on a remote server using either the command prompt or MySQLFront. I have the IP address, username, password but I can't connect. MySQLfront just hangs when I enter all the information If I type the following at the command prompt, in this example I'm using username for the user name, and 66.66.66.66 for the IP address (although I use real values) mysql -h 66.66.66.66 -u username -p it asks for my password then goes off and thinks for a while before coming back with: ERROR 2003 - can't connect to MySQL server on 'ip address' (port) any ideas? Julia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php