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]
Connecting to remote server
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? Mike Tuller -- 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
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
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
connecting to remote server
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
Re: MySql Gui connecting to remote server problem
Matthew Darcy writes: > > Hi, > > my laptop is running windows 2000 and is called jaguar. > I have mysql running on a linux server called jordan. > > when I fire up mysqlui and tell it to connec to jordan as root I get > prompted for a password. I enter the password (that I have tested and is > correct) and it say at the bottom of the gui > > Host 'jaguar.no-dns.co.uk' is not allowed to connect to this MySQL server > > how can I fix this. > > Thanks, > > Matt. The above is MySQL access problem. You have not granted user rights to login from jaguar.no-dns.co.uk host. Either grant access to [EMAIL PROTECTED] or to user@"%", which means any host. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ 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
MySql Gui connecting to remote server problem
Hi, my laptop is running windows 2000 and is called jaguar. I have mysql running on a linux server called jordan. when I fire up mysqlui and tell it to connec to jordan as root I get prompted for a password. I enter the password (that I have tested and is correct) and it say at the bottom of the gui Host 'jaguar.no-dns.co.uk' is not allowed to connect to this MySQL server how can I fix this. Thanks, Matt. - 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