RES: [SPAM] RE: Remote connection
It´s working. The problem was related to grant permission. Thank you. Cheers, Hugo -Mensagem original- De: Gavin Towey [mailto:gto...@ffn.com] Enviada em: terça-feira, 4 de agosto de 2009 19:46 Para: Hugo Leonardo Ferrer Rebello; mysql@lists.mysql.com Assunto: [SPAM] RE: Remote connection 1.) remove bind-address= and skip-networking from my.cnf 2.) grant permission to the external 'user'@'host' 3.) remove any firewall rules blocking port 3306 4.) make sure no overrides on the mysqld commandline. See http://hashmysql.org/index.php?title=Remote_Clients_Cannot_Connect If you continue to have problems, give us the exact steps you have tried and the exact error message you are receiving. Please try to connect using the mysql command line. Regards, Gavin Towey -Original Message- From: Hugo Leonardo Ferrer Rebello [mailto:hugo.rebe...@t-systems.com.br] Sent: Tuesday, August 04, 2009 1:09 PM To: mysql@lists.mysql.com Subject: Remote connection Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't work. I have tried to include the bind_address = 0.0.0.0 but it still doesn't work. Sure I have commented the skip-networking option before enable the bind_address. I don't know what else I must do. Please, anybody can help me ? Look at the error message below. # mysql -u root -p -h 192.168.12.50 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using password: YES) Cheers, Hugo The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Remote connection
1.) remove bind-address= and skip-networking from my.cnf 2.) grant permission to the external 'user'@'host' 3.) remove any firewall rules blocking port 3306 4.) make sure no overrides on the mysqld commandline. See http://hashmysql.org/index.php?title=Remote_Clients_Cannot_Connect If you continue to have problems, give us the exact steps you have tried and the exact error message you are receiving. Please try to connect using the mysql command line. Regards, Gavin Towey -Original Message- From: Hugo Leonardo Ferrer Rebello [mailto:hugo.rebe...@t-systems.com.br] Sent: Tuesday, August 04, 2009 1:09 PM To: mysql@lists.mysql.com Subject: Remote connection Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't work. I have tried to include the bind_address = 0.0.0.0 but it still doesn't work. Sure I have commented the skip-networking option before enable the bind_address. I don't know what else I must do. Please, anybody can help me ? Look at the error message below. # mysql -u root -p -h 192.168.12.50 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using password: YES) Cheers, Hugo The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Remote connection
Are you sure that root has granted access to connect remotely ?? Carlos On 8/4/2009 3:09 PM, Hugo Leonardo Ferrer Rebello wrote: Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't work. I have tried to include the bind_address = 0.0.0.0 but it still doesn't work. Sure I have commented the skip-networking option before enable the bind_address. I don't know what else I must do. Please, anybody can help me ? Look at the error message below. # mysql -u root -p -h 192.168.12.50 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using password: YES) Cheers, Hugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Remote connection
May not have root access to remotely! Try to reconfigure the parameters of the engine. although it is not good idea to allow remote access to the root user!. Greetings, Pablo -Mensaje original- De: Hugo Leonardo Ferrer Rebello [mailto:hugo.rebe...@t-systems.com.br] Enviado el: Martes, 04 de Agosto de 2009 05:09 p.m. Para: mysql@lists.mysql.com Asunto: Remote connection Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't work. I have tried to include the bind_address = 0.0.0.0 but it still doesn't work. Sure I have commented the skip-networking option before enable the bind_address. I don't know what else I must do. Please, anybody can help me ? Look at the error message below. # mysql -u root -p -h 192.168.12.50 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using password: YES) Cheers, Hugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Remote connection
Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't work. I have tried to include the bind_address = 0.0.0.0 but it still doesn't work. Sure I have commented the skip-networking option before enable the bind_address. I don't know what else I must do. Please, anybody can help me ? Look at the error message below. # mysql -u root -p -h 192.168.12.50 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using password: YES) Cheers, Hugo
Re: remote connection
Chris, it's somewhat common for hosting companies to restrict outbound connections like what you describe. They may have a firewall preventing what you are trying to do. From your hosting account, can you telnet to your machine on port 3306 ? I get something like this: $ telnet 192.168.2.4 3306 Trying 192.168.2.4... Connected to 192.168.2.4. Escape character is '^]'. A 5.0.21-standard-log8E]&@R[Tq,^bSW;_ONv)gO and then after a couple of seconds, Connection closed by foreign host. If you can get this, then your connection is probably not restricted at the firewall. If you can't, then it probably is. HTH, Dan On 10/14/06, Chris W <[EMAIL PROTECTED]> wrote: I have set up a hosting account on godaddy and they have a ridiculously old version of mysql so I am trying to set it up to use the my server instead. But it refuses to connect. I can't figure out what could be the problem. I have tried connecting to my machine from a few other servers and they all connect fine. The only thing php gives me back is ... *Warning*: mysql_connect(): Lost connection to MySQL server during query in *Test.php* on line *18* Could not connect: Lost connection to MySQL server during query The user I am connecting with has host set to '%' with only one entry for that user. Can someone give me some ideas? Php info gives me this ... PHP Version 4.3.11 MySQL Client API version 3.23.49 My version of mysql is 4.1.15 and I have set it to use the old style password. Anyone have any ideas on what to look for? -- Chris W KE5GIX "Protect your digital freedom and privacy, eliminate DRM, learn more at http://www.defectivebydesign.org/what_is_drm"; Gift Giving Made Easy Get the gifts you want & give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- 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]
remote connection
I have set up a hosting account on godaddy and they have a ridiculously old version of mysql so I am trying to set it up to use the my server instead. But it refuses to connect. I can't figure out what could be the problem. I have tried connecting to my machine from a few other servers and they all connect fine. The only thing php gives me back is ... *Warning*: mysql_connect(): Lost connection to MySQL server during query in *Test.php* on line *18* Could not connect: Lost connection to MySQL server during query The user I am connecting with has host set to '%' with only one entry for that user. Can someone give me some ideas? Php info gives me this ... PHP Version 4.3.11 MySQL Client API version 3.23.49 My version of mysql is 4.1.15 and I have set it to use the old style password. Anyone have any ideas on what to look for? -- Chris W KE5GIX "Protect your digital freedom and privacy, eliminate DRM, learn more at http://www.defectivebydesign.org/what_is_drm"; Gift Giving Made Easy Get the gifts you want & give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Remote Connection Problem
Thanks Shawn. It seems to be just that. >>> [EMAIL PROTECTED] 08/08/05 03:02PM >>> "Kent Roberts" <[EMAIL PROTECTED]> wrote on 08/08/2005 04:50:15 PM: > I am having inconsistent behavior maintaining a remote connection > with MySql Administrator/Browser. Brand new installations of clients > on Windows XP and MySql server on Windows 2003 server. It worked > fine at first then suddenly I could no longer connect (Error #1045. > Access denied for user '[EMAIL PROTECTED]' Using password: YES). I tweaked > permissions to the [EMAIL PROTECTED] (MDAS2 is the name of the client > machine) to add SELECT for both the mysql and information_schema > schemas. Connections worked well for most of today when suddenly my > connection was no longer valid and now I can't connect again. Any ideas? > > Thanks in advance, > Kent Roberts > Missoula, MT > DNS issues? Reverse DNS lookups seem to be emerging as a weak point for MySQL. Try running your server with --skip-name-resolve and setting your permissions to be IP address (not domain name) specific and see if the problem persists. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Remote Connection Problem
"Kent Roberts" <[EMAIL PROTECTED]> wrote on 08/08/2005 04:50:15 PM: > I am having inconsistent behavior maintaining a remote connection > with MySql Administrator/Browser. Brand new installations of clients > on Windows XP and MySql server on Windows 2003 server. It worked > fine at first then suddenly I could no longer connect (Error #1045. > Access denied for user '[EMAIL PROTECTED]' Using password: YES). I tweaked > permissions to the [EMAIL PROTECTED] (MDAS2 is the name of the client > machine) to add SELECT for both the mysql and information_schema > schemas. Connections worked well for most of today when suddenly my > connection was no longer valid and now I can't connect again. Any ideas? > > Thanks in advance, > Kent Roberts > Missoula, MT > DNS issues? Reverse DNS lookups seem to be emerging as a weak point for MySQL. Try running your server with --skip-name-resolve and setting your permissions to be IP address (not domain name) specific and see if the problem persists. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Remote Connection Problem
I am having inconsistent behavior maintaining a remote connection with MySql Administrator/Browser. Brand new installations of clients on Windows XP and MySql server on Windows 2003 server. It worked fine at first then suddenly I could no longer connect (Error #1045. Access denied for user '[EMAIL PROTECTED]' Using password: YES). I tweaked permissions to the [EMAIL PROTECTED] (MDAS2 is the name of the client machine) to add SELECT for both the mysql and information_schema schemas. Connections worked well for most of today when suddenly my connection was no longer valid and now I can't connect again. Any ideas? Thanks in advance, Kent Roberts Missoula, MT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Remote Connection?
Hello. Do you have a shell account on that server? Are you allowed to connect to your server from remote machines (ask support of your hosting about this). "Badr Al-Muzini" <[EMAIL PROTECTED]> wrote: > hi, > i try to access the MySQL server remotely using Command prompet how can i do > so? i mean i want to run all MySQL command on my hosting server > ... > > _ > Dont just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Remote Connection?
Most of MySQL commands have "--host" option that allows you to address remote MySQL server. One needs: * To have MySQL server be running on all machines you want to "reach" * Each remote host must allow remote users, from your hosting server, to execute commands on that server. -Original Message- From: Badr Al-Muzini [mailto:[EMAIL PROTECTED] Sent: Friday, June 24, 2005 11:51 AM To: mysql@lists.mysql.com Subject: MySQL Remote Connection? hi, i try to access the MySQL server remotely using Command prompet how can i do so? i mean i want to run all MySQL command on my hosting server ... _ Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- 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]
MySQL Remote Connection?
hi, i try to access the MySQL server remotely using Command prompet how can i do so? i mean i want to run all MySQL command on my hosting server ... _ Dont just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection
Hi, haven't you added "identified by *" int he grant statement. I don't see it in your show grants comand. Mathias Selon Chris Faulkner <[EMAIL PROTECTED]>: > Hello > > I am trying to connect from host 192.168.0.8 on my home network to a > database on 192.168.0.7. When I connect as root on 192.168.0.7 itself, > I can do this > > mysql> show grants for 'root'@'192.168.0.8'; > ++ > | Grants for [EMAIL PROTECTED]| > ++ > | GRANT USAGE ON *.* TO 'root'@'192.168.0.8' | > ++ > 1 row in set (0.00 sec) > > However, when I try to connect from 192.168.0.8, I get an error (1045: > Access denied). What else do I have to do ? > > Thanks > > Chris > > -- > 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]
remote connection
Hello I am trying to connect from host 192.168.0.8 on my home network to a database on 192.168.0.7. When I connect as root on 192.168.0.7 itself, I can do this mysql> show grants for 'root'@'192.168.0.8'; ++ | Grants for [EMAIL PROTECTED]| ++ | GRANT USAGE ON *.* TO 'root'@'192.168.0.8' | ++ 1 row in set (0.00 sec) However, when I try to connect from 192.168.0.8, I get an error (1045: Access denied). What else do I have to do ? Thanks Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection problem
Hello. Your server listens only on a single interface. Options could be given in different ways, not only from configuration file. If you want MySQL server to listen on every interface you should find where the bind option is given and remove it. See: http://dev.mysql.com/doc/mysql/en/program-options.html Andy McHargue <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 7bit, charset: us-ascii, 29 lines --] > > I'm having trouble connecting remotely from Server A (local) to Server B > (remote). Both Linux. > > From Server A, I'm issuing this command > mysql -h [domain.com] -u [user] -p > > And I get > ERROR 2003: Can't connect to MySQL server on 'domain.com' (110) > I assume this is a time out. > > 1. The user on Server B is set up with all privileges. > 2. Server B's my.cnf has the line "bind-address=127.0.0.1" but it is > commented out with # > 3. Server B's skip_networking is OFF. > 4. A netstat -tl on Server B gives the line > tcp0 0 domain.com:3306 *:* LISTEN > > I notice that on a different server, I get this > tcp0 0 *:mysql > *:* LISTEN > > and there's no line containing 3306. > > What's with that? > > 5. for troubleshooting's sake, ssh [remote-ip] -p 3306 times out. > telnet is unavailable. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection problem
Hello. After checking that MySQL server listens on the interface to which you are connecting, solve network problems. If you're able to connect from one host to another it doesn't mean that the opposite is true. Andy McHargue <[EMAIL PROTECTED]> wrote: > Here's some more data on this, if anyone can help. > > --I can connect the other way around ... i.e. I can connect from B to > A. So there's no general connectivity problem. > --did an nmap on B, > $ nmap -sT -T Polite -p3306 xx.com > > Starting nmap V. 2.54BETA22 ( www.insecure.org/nmap/ ) > Interesting ports on s191.n33.xx.com (66.84.xx.xx): > Port State Service > 3306/tcp filteredmysql > > nmap on B indicates 'open' rather than 'filtered' ... how can i change? > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection problem
Here's some more data on this, if anyone can help. --I can connect the other way around ... i.e. I can connect from B to A. So there's no general connectivity problem. --did an nmap on B, $ nmap -sT -T Polite -p3306 xx.com Starting nmap V. 2.54BETA22 ( www.insecure.org/nmap/ ) Interesting ports on s191.n33.xx.com (66.84.xx.xx): Port State Service 3306/tcp filteredmysql nmap on B indicates 'open' rather than 'filtered' ... how can i change? Andy McHargue wrote: I'm having trouble connecting remotely from Server A (local) to Server B (remote). Both Linux. From Server A, I'm issuing this command mysql -h [domain.com] -u [user] -p And I get ERROR 2003: Can't connect to MySQL server on 'domain.com' (110) I assume this is a time out. 1. The user on Server B is set up with all privileges. 2. Server B's my.cnf has the line "bind-address=127.0.0.1" but it is commented out with # 3. Server B's skip_networking is OFF. 4. A netstat -tl on Server B gives the line tcp0 0 domain.com:3306 *:* LISTEN I notice that on a different server, I get this tcp0 0 *:mysql *:* LISTEN and there's no line containing 3306. What's with that? 5. for troubleshooting's sake, ssh [remote-ip] -p 3306 times out. telnet is unavailable. -- Andy McHargue Webmaster Annenberg School for Communication University of Southern California http://annenberg.usc.edu [EMAIL PROTECTED] Phone: 213.740.1290 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
remote connection problem
I'm having trouble connecting remotely from Server A (local) to Server B (remote). Both Linux. From Server A, I'm issuing this command mysql -h [domain.com] -u [user] -p And I get ERROR 2003: Can't connect to MySQL server on 'domain.com' (110) I assume this is a time out. 1. The user on Server B is set up with all privileges. 2. Server B's my.cnf has the line "bind-address=127.0.0.1" but it is commented out with # 3. Server B's skip_networking is OFF. 4. A netstat -tl on Server B gives the line tcp0 0 domain.com:3306 *:* LISTEN I notice that on a different server, I get this tcp0 0 *:mysql *:* LISTEN and there's no line containing 3306. What's with that? 5. for troubleshooting's sake, ssh [remote-ip] -p 3306 times out. telnet is unavailable.
Re: remote connection problem
Not necessary to change my.cnf, unless --skip-networking was specified. Also assuming that you are using port 3306. mysql> show variables like 'port'; +---+---+ | Variable_name | Value | +---+---+ | port | 3306 | +---+---+ 1 row in set (0.00 sec) Can you verify that network traffic is getting from your remote client to the MySQL server? When you attempt to connect, do you see network packets coming to port 3306 on the MySQL server machine? On Tue, 2005-03-22 at 16:35 -0600, gerardo Villanueva wrote: > I execute your query and > the skip_networking is OFF. > the file my.cnf, have to ubicated in C:\my.cnf or is > not > necesary?? > > Regards > > Gerardo Campos > > _ > Do You Yahoo!? > InformaciÃn de Estados Unidos y AmÃrica Latina, en Yahoo! Noticias. > VisÃtanos en http://noticias.espanol.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection problem
One other thing to check, make sure --skip-networking isn't specified in your configuration. mysql> show variables like 'skip_networking'; +-+---+ | Variable_name | Value | +-+---+ | skip_networking | OFF | +-+---+ 1 row in set (0.00 sec) If the value is ON, you won't be allowed to make connections to the server via TCP/IP. On Tue, 2005-03-22 at 15:43 -0600, gerardo Villanueva wrote: > I have mysql version 4.0.15-nt in a server NT, I can > connecting with mysql localy, but when i try remote > connection the error is: > "Error Number 2003 Can't connect to MySQL server on > 'IP' (10060) " . > I use mysql odbc 3.51 > Is necesary the file my.cnf in c:\my.cnf > > Regards > > Gerardo Campos > > _ > Do You Yahoo!? > InformaciÃn de Estados Unidos y AmÃrica Latina, en Yahoo! Noticias. > VisÃtanos en http://noticias.espanol.yahoo.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: remote connection problem
When you are running as root, but are you running as 'root'@'%' or 'root'@'localhost'? This does make a big difference. The '%' means all network connections, which isn't secure. I would only using it as testing purposes. However, because your error message says that you cannot see the server, are you sure that your remote connection can see the NT server? This may be a bigger problem, i.e. DNS or IP routing/access lists. You may also want to check the .err logs on the MySQL server to see if there is a connection problem there. J.R. -Original Message- From: gerardo Villanueva [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 5:03 PM To: [EMAIL PROTECTED] Subject: RE: remote connection problem 1.- Yes I have a firewall but the port 3306 is open 2.- Mysql is running in the server 3.- I connecting with user root and his has all the permissions I try to remote connection to my server NT 4.0 , mysql run there. Gerardo Campos _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com smime.p7s Description: S/MIME cryptographic signature
RE: remote connection problem
1) Are you running a firewall? If so, make sure that port 3306 is open. 2) Is your MySQL server is up and running? 3) Do you have the correct permissions to connect to the server via your mysql.hosts table? Just some thoughts. J.R. -Original Message- From: gerardo Villanueva [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 4:43 PM To: mysql@lists.mysql.com Subject: remote connection problem I have mysql version 4.0.15-nt in a server NT, I can connecting with mysql localy, but when i try remote connection the error is: "Error Number 2003 Can't connect to MySQL server on 'IP' (10060) " . I use mysql odbc 3.51 Is necesary the file my.cnf in c:\my.cnf Regards Gerardo Campos _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] smime.p7s Description: S/MIME cryptographic signature
remote connection problem
I have mysql version 4.0.15-nt in a server NT, I can connecting with mysql localy, but when i try remote connection the error is: "Error Number 2003 Can't connect to MySQL server on 'IP' (10060) " . I use mysql odbc 3.51 Is necesary the file my.cnf in c:\my.cnf Regards Gerardo Campos _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Remote Connection via Toad for MySQL
You can try SQLyog (www.webyog.com), it supports 3.23.x to 5.0. Lightweight and very fast! Karam --- [EMAIL PROTECTED] wrote: > Good good. > > On 24 Feb 2005, at 20:46, > [EMAIL PROTECTED] wrote: > > BINGO!!! > Thanks Dan! > Kelly > > > > Daniel Walker <[EMAIL PROTECTED]> > What version of MySQL are you using? 4.1.1 uses an > enhanced password > hashing system that isn't compatible with clients > built for older > versions. > > This page on MySQL's own documentation provides a > number of workarounds, > one of which will hopefully work in your case > (assuming the problem is > caused by the version number of your DBM, of course > ;) > > http://dev.mysql.com/doc/mysql/en/old-client.html > > HTH > > Daniel Walker > > On 24 Feb 2005, at 20:35, > [EMAIL PROTECTED] wrote: > > Client does not support authentication > __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Remote Connection via Toad for MySQL
Good good. On 24 Feb 2005, at 20:46, [EMAIL PROTECTED] wrote: BINGO!!! Thanks Dan! Kelly Daniel Walker <[EMAIL PROTECTED]> What version of MySQL are you using? 4.1.1 uses an enhanced password hashing system that isn't compatible with clients built for older versions. This page on MySQL's own documentation provides a number of workarounds, one of which will hopefully work in your case (assuming the problem is caused by the version number of your DBM, of course ;) http://dev.mysql.com/doc/mysql/en/old-client.html HTH Daniel Walker On 24 Feb 2005, at 20:35, [EMAIL PROTECTED] wrote: Client does not support authentication
Remote Connection via Toad for MySQL
Hello, I have downloaded Toad for MySQL to give it a test run. MySQL 4.1.10 is on Redhat AS 2.1 and Toad for MySQL is on Win XP. Everytime I attempt to connect via Toad, I get the following error: Unable to connect to the database. Host 'XX.XX.XX.XX' is not allowed to connect to this MySQL server What do I need to do to allow the host to connect? Thanks, Kelly Kelly S. Brace Information Technology Exchange Center Twin Rise 200 1300 Elmwood Avenue Buffalo, NY 14222 http://www.itec.suny.edu Main: 716-878-4832 Fax: 716-878-3485 Office: 716-878-3984 Cell: 716-432-4978 [EMAIL PROTECTED]
Re: remote connection with 4.0.22 on win32
Hello. See: http://dev.mysql.com/doc/mysql/en/Access_denied.html "Massimo Petrini" <[EMAIL PROTECTED]> wrote: > I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs > correctly (it is a slave member of my domain). But if I try to connect from > a remote client with mysql administrator, I receive this error: > Could not connect to the specified instance > Mysql error number 1130 > Host "name" is not allowed to connect tothis MYSQL sever > > The ping result correct. > > Which is my configuration error ? (see my.ini below) > > Thanks > Massimo > > -- > > > # The MySQL server > [mysqld] > port=3306 > #socket=MySQL > skip-locking > set-variable=key_buffer=16K > set-variable=max_allowed_packet=16M > set-variable=thread_stack=64K > set-variable=table_cache=4 > set-variable=sort_buffer=1024K > set-variable=net_buffer_length=2K > > #PARTE PER REPLICA > > server-id=33 > master-host=SEURAT > report-host=SEURAT > master-user=root > replicate-wild-ignore-table=OMTWRK.WRK_% > replicate-wild-ignore-table=omtwrk.wrk_% > set-variable=slave-net-timeout=172800 > > #skip-slave-start > # Uncomment the following if you want to log updates > #log-bin > > # Uncomment the following rows if you move the MySQL distribution to another > # location > basedir=C:\mysql\ > #datadir=C:\AnnaNoBck\DATI\MySQL\data\ > datadir=D:\mysql\Data\ > > > log-error=d:\mysql\data\mysql.err > > # Uncomment the following if you are NOT using BDB tables > skip-bdb > > # Uncomment the following if you are using Innobase tables > innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend > > #innodb_data_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB > #innodb_log_group_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog > #innodb_log_arch_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog > > innodb_data_home_dir=D:\mysql\InnoDB > innodb_log_group_home_dir=D:\mysql\InnoDB\InnoLog > innodb_log_arch_dir=D:\mysql\InnoDB\InnoLog > > set-variable=innodb_mirrored_log_groups=1 > set-variable=innodb_log_files_in_group=3 > set-variable=innodb_log_file_size=5M > set-variable=innodb_log_buffer_size=8M > innodb_flush_log_at_trx_commit=1 > innodb_log_archive=0 > set-variable=innodb_buffer_pool_size=16M > set-variable=innodb_additional_mem_pool_size=16M > set-variable=innodb_file_io_threads=4 > set-variable=innodb_lock_wait_timeout=50 > default-table-type=innodb > > [mysqldump] > quick > set-variable=max_allowed_packet=16M > > [mysql] > no-auto-rehash > # Remove the next comment character if you are not familiar with SQL > #safe-updates > > [isamchk] > set-variable=key_buffer=8M > set-variable=sort_buffer=8M > > [myisamchk] > set-variable=key_buffer=8M > set-variable=sort_buffer=8M > > [mysqlhotcopy] > interactive-timeout > > [WinMySQLAdmin] > Server=C:/mysql/bin/mysqld-max-nt.exe > > > - > Massimo Petrini > c/o Omt spa > Via Ferrero 67/a > 10090 Cascine Vica (TO) > Tel.+39 011 9505334 > Fax +39 011 9575474 > E-mail [EMAIL PROTECTED] > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
remote connection with 4.0.22 on win32
I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs correctly (it is a slave member of my domain). But if I try to connect from a remote client with mysql administrator, I receive this error: Could not connect to the specified instance Mysql error number 1130 Host "name" is not allowed to connect tothis MYSQL sever The ping result correct. Which is my configuration error ? (see my.ini below) Thanks Massimo -- # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable=key_buffer=16K set-variable=max_allowed_packet=16M set-variable=thread_stack=64K set-variable=table_cache=4 set-variable=sort_buffer=1024K set-variable=net_buffer_length=2K #PARTE PER REPLICA server-id=33 master-host=SEURAT report-host=SEURAT master-user=root replicate-wild-ignore-table=OMTWRK.WRK_% replicate-wild-ignore-table=omtwrk.wrk_% set-variable=slave-net-timeout=172800 #skip-slave-start # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir=C:\mysql\ #datadir=C:\AnnaNoBck\DATI\MySQL\data\ datadir=D:\mysql\Data\ log-error=d:\mysql\data\mysql.err # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using Innobase tables innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend #innodb_data_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB #innodb_log_group_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog #innodb_log_arch_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog innodb_data_home_dir=D:\mysql\InnoDB innodb_log_group_home_dir=D:\mysql\InnoDB\InnoLog innodb_log_arch_dir=D:\mysql\InnoDB\InnoLog set-variable=innodb_mirrored_log_groups=1 set-variable=innodb_log_files_in_group=3 set-variable=innodb_log_file_size=5M set-variable=innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable=innodb_buffer_pool_size=16M set-variable=innodb_additional_mem_pool_size=16M set-variable=innodb_file_io_threads=4 set-variable=innodb_lock_wait_timeout=50 default-table-type=innodb [mysqldump] quick set-variable=max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable=key_buffer=8M set-variable=sort_buffer=8M [myisamchk] set-variable=key_buffer=8M set-variable=sort_buffer=8M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection php code
> Hi All
> Could someone give me a clue or a snippet of PHP code I can test a romte
> connection to my MySQL DB for my website please?
Just take the one you're currently using and replace 'localhost' with
'someotherserver.com'
$cnx = mysql_connect('someotherserver.com','uname','pword');
mysql_select_db('dbname',$cnx);
mysql_query('Select * from table',$cnx);
etc
As long as the GRANT's are set up to accept connections from an exteral
client and Firewall ports are open(if needed), it will not differ much from
local testing.
HTH
Jeff
> Thank you
> Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
remote connection php code
Hi All Could someone give me a clue or a snippet of PHP code I can test a romte connection to my MySQL DB for my website please? Thank you Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Remote connection: "Lost connection to MySQL server during query"
Hi all! I'm connecting from one server (192.168.0.2; 4.1.1-alpha-log) to another server (192.168.0.1; 4.1.0-alpha-log) like this: # mysql -h192.168.0.1 -uusername -ppassword But all I get is: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 82 to server version: 4.1.0-alpha-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select unix_timestamp(); ERROR 2013 (HY000): Lost connection to MySQL server during query This error occurs on EVERY query, no matter how simple: i.e. show databases; When I run the "mysql" command locally on the server I'd like to connect to, everythings fine. MySQL seems to be able to connect to the other machine and the query is started, but the error says it failed "during query"... Thanks a lot for any hints! Cheers, Hannes. --- Alles Kaufen und Verkaufen! eBay.at - der eigene Marktplatz für Österreich. http://www.austronaut.at/ebay.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: remote connection
For anyone else that stumbles over this problem, there were two
problems...
1. My firewall was blocking the remote mysql port (duh)
2. Unlike what I expected from reading the docs, I had to give my remote
user rights in the user table (Select_priv='Y', Insert_priv='Y', etc.)
to get a connection. I'm still not sure why this should be (I'm willing
to be told), but it works, so I'm happy.
-- John
Identry, LLC
Northport, NY 11768
Ph: 631.754.8440
Fx: 631.980.4262
Em: [EMAIL PROTECTED]
Member: ASDA, APS, ANA, Ephemera Society
of America, Long Island Web Developers Guild
<><><><><><><><><><><><><><><><><><><><><><><><>
Visit us at: www.identry.com
Building You A Better Online Business
<><><><><><><><><><><><><><><><><><><><><><><><>
-Original Message-
From: Curtis Maurand [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 10:57 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: remote connection
For some reason, MySQL treats "localhost" as a special case (at least
that
seems to be the behavior." If you run grant on
to user@'%' identified by 'password'; will allow login
from
anywhere but the localhost. That account must be created seperately.
Curtis
John Almberg said:
> Yes I was already pretty sure it was a rights issue. What I'm
trying
> to do is modify the rights for a particular user so I can log in
> remotely. The question is what I should use for the host fields in the
> various tables so that I can log in remotely *and* the web server can
> log in through localhost.
>
> Problem is, everything I try blocks access from everywhere, even when
I
> use '%'. I did some more reading last night and figured out that it
has
> something to do with the sorting done in the first connection phase. I
> think just changing the host field to '%' or '%.optonline.net'
actually
> lowers that user account below one of the default accounts (one with a
> blank in the User field), so that I'm logging in on the other account.
>
> I'm sure there's a logic behind this set up, so I'm not changing it
> haphazardly, but the logic escapes me at the moment!
>
> -- John
>
>
> Identry, LLC
> Northport, NY 11768
>
> Ph: 631.754.8440
> Fx: 631.980.4262
> Em: [EMAIL PROTECTED]
>
> Member: ASDA, APS, ANA, Ephemera Society
> of America, Long Island Web Developers Guild
>
> <><><><><><><><><><><><><><><><><><><><><><><><>
>Visit us at: www.identry.com
>Building You A Better Online Business
> <><><><><><><><><><><><><><><><><><><><><><><><>
>
>
>
>
>
> -Original Message-
> From: Curtis Maurand [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 07, 2003 1:44 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: remote connection
>
>
> Its a permissions thing on the server end. You have to have set up a
> user
> account on the server. Very important are hostnames.
>
> Curtis
>
> John Almberg said:
>> I'm trying to set up a remote connection to a mysql database using
> Perl
>> DBI. I have done this without problem on another database. I suspect
> the
>> rights are set up differently on this one. I have root access.
>>
>> When I try to connect, I get the following error (hostname, username,
>> password have been edited for the purpose of this email):
>>
>> DBI connect('database:host','user','password') failed: Host
>> 'ool-182f1a5f.dyn.optonline.net' is not allowed to connect to this
> MySQL
>> server at D:\My Documents\Identry Shared\Operations\Stamp Center --
>> website\database\update_inv.pl line 7
>>
>> After reading section 4.2.8 in the manual (Connecting to the MySQL
>> Server), I am pretty sure this is a rights problem. The user I am
> trying
>> to connect as has 'localhost' set in the Host field of both the
'user'
>> and 'db' tables. There are no entries whatsoever in the 'host' table.
>>
>> What I
RE: remote connection
For some reason, MySQL treats "localhost" as a special case (at least that
seems to be the behavior." If you run grant on
to user@'%' identified by 'password'; will allow login from
anywhere but the localhost. That account must be created seperately.
Curtis
John Almberg said:
> Yes I was already pretty sure it was a rights issue. What I'm trying
> to do is modify the rights for a particular user so I can log in
> remotely. The question is what I should use for the host fields in the
> various tables so that I can log in remotely *and* the web server can
> log in through localhost.
>
> Problem is, everything I try blocks access from everywhere, even when I
> use '%'. I did some more reading last night and figured out that it has
> something to do with the sorting done in the first connection phase. I
> think just changing the host field to '%' or '%.optonline.net' actually
> lowers that user account below one of the default accounts (one with a
> blank in the User field), so that I'm logging in on the other account.
>
> I'm sure there's a logic behind this set up, so I'm not changing it
> haphazardly, but the logic escapes me at the moment!
>
> -- John
>
>
> Identry, LLC
> Northport, NY 11768
>
> Ph: 631.754.8440
> Fx: 631.980.4262
> Em: [EMAIL PROTECTED]
>
> Member: ASDA, APS, ANA, Ephemera Society
> of America, Long Island Web Developers Guild
>
> <><><><><><><><><><><><><><><><><><><><><><><><>
>Visit us at: www.identry.com
>Building You A Better Online Business
> <><><><><><><><><><><><><><><><><><><><><><><><>
>
>
>
>
>
> -Original Message-
> From: Curtis Maurand [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 07, 2003 1:44 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: remote connection
>
>
> Its a permissions thing on the server end. You have to have set up a
> user
> account on the server. Very important are hostnames.
>
> Curtis
>
> John Almberg said:
>> I'm trying to set up a remote connection to a mysql database using
> Perl
>> DBI. I have done this without problem on another database. I suspect
> the
>> rights are set up differently on this one. I have root access.
>>
>> When I try to connect, I get the following error (hostname, username,
>> password have been edited for the purpose of this email):
>>
>> DBI connect('database:host','user','password') failed: Host
>> 'ool-182f1a5f.dyn.optonline.net' is not allowed to connect to this
> MySQL
>> server at D:\My Documents\Identry Shared\Operations\Stamp Center --
>> website\database\update_inv.pl line 7
>>
>> After reading section 4.2.8 in the manual (Connecting to the MySQL
>> Server), I am pretty sure this is a rights problem. The user I am
> trying
>> to connect as has 'localhost' set in the Host field of both the 'user'
>> and 'db' tables. There are no entries whatsoever in the 'host' table.
>>
>> What I want to do is to add the ability for my Perl program to connect
>> as a certain user (call him 'bob') from a certain IP address.
>> Unfortunately, all my attempts result block access from every host,
> even
>> localhost. Thus, even the webserver can't access the database.
>>
>> In desperation, I've even tried using '%' in the Host fields of both
>> user & db tables. This doesn't work, either, so I'm obviously missing
>> something.
>>
>> Any help much appreciated!
>>
>> Brgds: John
>>
>>
>> Identry, LLC
>> Northport, NY 11768
>>
>> Ph: 631.754.8440
>> Fx: 631.980.4262
>> Em: [EMAIL PROTECTED]
>>
>> Member: ASDA, APS, ANA, Ephemera Society
>> of America, Long Island Web Developers Guild
>>
>> <><><><><><><><><><><><><><><><><><><><><><><><>
>>Visit us at: www.identry.com
>>Building You A Better Online Business
>> <><><><><><><><><><><><><><><><><><><><><><><><>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> 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]
>
>
>
> --
> 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: remote connection
Yes I was already pretty sure it was a rights issue. What I'm trying
to do is modify the rights for a particular user so I can log in
remotely. The question is what I should use for the host fields in the
various tables so that I can log in remotely *and* the web server can
log in through localhost.
Problem is, everything I try blocks access from everywhere, even when I
use '%'. I did some more reading last night and figured out that it has
something to do with the sorting done in the first connection phase. I
think just changing the host field to '%' or '%.optonline.net' actually
lowers that user account below one of the default accounts (one with a
blank in the User field), so that I'm logging in on the other account.
I'm sure there's a logic behind this set up, so I'm not changing it
haphazardly, but the logic escapes me at the moment!
-- John
Identry, LLC
Northport, NY 11768
Ph: 631.754.8440
Fx: 631.980.4262
Em: [EMAIL PROTECTED]
Member: ASDA, APS, ANA, Ephemera Society
of America, Long Island Web Developers Guild
<><><><><><><><><><><><><><><><><><><><><><><><>
Visit us at: www.identry.com
Building You A Better Online Business
<><><><><><><><><><><><><><><><><><><><><><><><>
-Original Message-
From: Curtis Maurand [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: remote connection
Its a permissions thing on the server end. You have to have set up a
user
account on the server. Very important are hostnames.
Curtis
John Almberg said:
> I'm trying to set up a remote connection to a mysql database using
Perl
> DBI. I have done this without problem on another database. I suspect
the
> rights are set up differently on this one. I have root access.
>
> When I try to connect, I get the following error (hostname, username,
> password have been edited for the purpose of this email):
>
> DBI connect('database:host','user','password') failed: Host
> 'ool-182f1a5f.dyn.optonline.net' is not allowed to connect to this
MySQL
> server at D:\My Documents\Identry Shared\Operations\Stamp Center --
> website\database\update_inv.pl line 7
>
> After reading section 4.2.8 in the manual (Connecting to the MySQL
> Server), I am pretty sure this is a rights problem. The user I am
trying
> to connect as has 'localhost' set in the Host field of both the 'user'
> and 'db' tables. There are no entries whatsoever in the 'host' table.
>
> What I want to do is to add the ability for my Perl program to connect
> as a certain user (call him 'bob') from a certain IP address.
> Unfortunately, all my attempts result block access from every host,
even
> localhost. Thus, even the webserver can't access the database.
>
> In desperation, I've even tried using '%' in the Host fields of both
> user & db tables. This doesn't work, either, so I'm obviously missing
> something.
>
> Any help much appreciated!
>
> Brgds: John
>
>
> Identry, LLC
> Northport, NY 11768
>
> Ph: 631.754.8440
> Fx: 631.980.4262
> Em: [EMAIL PROTECTED]
>
> Member: ASDA, APS, ANA, Ephemera Society
> of America, Long Island Web Developers Guild
>
> <><><><><><><><><><><><><><><><><><><><><><><><>
>Visit us at: www.identry.com
>Building You A Better Online Business
> <><><><><><><><><><><><><><><><><><><><><><><><>
>
>
>
>
>
>
>
>
> --
> 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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection
Its a permissions thing on the server end. You have to have set up a user
account on the server. Very important are hostnames.
Curtis
John Almberg said:
> I'm trying to set up a remote connection to a mysql database using Perl
> DBI. I have done this without problem on another database. I suspect the
> rights are set up differently on this one. I have root access.
>
> When I try to connect, I get the following error (hostname, username,
> password have been edited for the purpose of this email):
>
> DBI connect('database:host','user','password') failed: Host
> 'ool-182f1a5f.dyn.optonline.net' is not allowed to connect to this MySQL
> server at D:\My Documents\Identry Shared\Operations\Stamp Center --
> website\database\update_inv.pl line 7
>
> After reading section 4.2.8 in the manual (Connecting to the MySQL
> Server), I am pretty sure this is a rights problem. The user I am trying
> to connect as has 'localhost' set in the Host field of both the 'user'
> and 'db' tables. There are no entries whatsoever in the 'host' table.
>
> What I want to do is to add the ability for my Perl program to connect
> as a certain user (call him 'bob') from a certain IP address.
> Unfortunately, all my attempts result block access from every host, even
> localhost. Thus, even the webserver can't access the database.
>
> In desperation, I've even tried using '%' in the Host fields of both
> user & db tables. This doesn't work, either, so I'm obviously missing
> something.
>
> Any help much appreciated!
>
> Brgds: John
>
>
> Identry, LLC
> Northport, NY 11768
>
> Ph: 631.754.8440
> Fx: 631.980.4262
> Em: [EMAIL PROTECTED]
>
> Member: ASDA, APS, ANA, Ephemera Society
> of America, Long Island Web Developers Guild
>
> <><><><><><><><><><><><><><><><><><><><><><><><>
>Visit us at: www.identry.com
>Building You A Better Online Business
> <><><><><><><><><><><><><><><><><><><><><><><><>
>
>
>
>
>
>
>
>
> --
> 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]
remote connection
I'm trying to set up a remote connection to a mysql database using Perl
DBI. I have done this without problem on another database. I suspect the
rights are set up differently on this one. I have root access.
When I try to connect, I get the following error (hostname, username,
password have been edited for the purpose of this email):
DBI connect('database:host','user','password') failed: Host
'ool-182f1a5f.dyn.optonline.net' is not allowed to connect to this MySQL
server at D:\My Documents\Identry Shared\Operations\Stamp Center --
website\database\update_inv.pl line 7
After reading section 4.2.8 in the manual (Connecting to the MySQL
Server), I am pretty sure this is a rights problem. The user I am trying
to connect as has 'localhost' set in the Host field of both the 'user'
and 'db' tables. There are no entries whatsoever in the 'host' table.
What I want to do is to add the ability for my Perl program to connect
as a certain user (call him 'bob') from a certain IP address.
Unfortunately, all my attempts result block access from every host, even
localhost. Thus, even the webserver can't access the database.
In desperation, I've even tried using '%' in the Host fields of both
user & db tables. This doesn't work, either, so I'm obviously missing
something.
Any help much appreciated!
Brgds: John
Identry, LLC
Northport, NY 11768
Ph: 631.754.8440
Fx: 631.980.4262
Em: [EMAIL PROTECTED]
Member: ASDA, APS, ANA, Ephemera Society
of America, Long Island Web Developers Guild
<><><><><><><><><><><><><><><><><><><><><><><><>
Visit us at: www.identry.com
Building You A Better Online Business
<><><><><><><><><><><><><><><><><><><><><><><><>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection 4
At 22:55 +0200 10/4/03, Ms Carlsson wrote: when i try to connect to my mysql database from another machine i get a error like this %mysql -h domain.com -u tellus ERROR 2003: Can't connect to MySQL server on 'domain.com' (61) The port don't listen Apparently the MySQL server on domain.com is not running. Or perhaps domain.com is firewalled and doesn't allow connections to the MySQL port. and this is disabled in my.cfg # #skip-networking whats wrong and how do i allow remote connections? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
remote connection 4
when i try to connect to my mysql database from another machine i get a error like this %mysql -h domain.com -u tellus ERROR 2003: Can't connect to MySQL server on 'domain.com' (61) The port don't listen and this is disabled in my.cfg # #skip-networking whats wrong and how do i allow remote connections? _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: remote connection with JDBC
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Erwin Adi wrote: I can connect to MySQL through JDBC with the following URL without any problem: jdbc:mysql://localhost:3306/mydatabase However, when I simulate the above URL as though I'm calling from a remote machine using the following URL, jdbc:mysql://192.168.0.10:3306/mydatabase I got the following exception (the file name is Lookup.java) : Exception in thread "main" java.sql.SQLException: Communication link failure: java.io.IOException at com.mysql.jdbc.MysqlIO.init(Unknown Source) at com.mysql.jdbc.Connection.connectionInit(Unknown Source) at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source) at com.mysql.jdbc.Driver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at Lookup.main(Lookup.java:16) I would very much appreciate if anybody could tell me how to connect the database from a remote machine (if possible with which library to import from). Thank you very much in advance. What OS is running on the remote machine? It looks like it is RedHat-8.0. On RedHat 8.0, if you use RedHat's mysql binaries, remote TCP/IP connections won't work. If this is the case, please try one of our binaries, and also look at the directions here: http://www.mysql.com/doc/en/Linux-x86.html -Mark - -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+deX2tvXNTca6JD8RArUNAJ4vIuve3vU697q3GlwqQRw0/19BfwCfVt9z OdIEp97O8cLJAEdoOtcoYeM= =sZDH -END PGP SIGNATURE- - 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
remote connection with JDBC
I can connect to MySQL through JDBC with the following URL without any problem: jdbc:mysql://localhost:3306/mydatabase However, when I simulate the above URL as though I'm calling from a remote machine using the following URL, jdbc:mysql://192.168.0.10:3306/mydatabase I got the following exception (the file name is Lookup.java) : Exception in thread "main" java.sql.SQLException: Communication link failure: java.io.IOException at com.mysql.jdbc.MysqlIO.init(Unknown Source) at com.mysql.jdbc.Connection.connectionInit(Unknown Source) at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source) at com.mysql.jdbc.Driver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at Lookup.main(Lookup.java:16) I would very much appreciate if anybody could tell me how to connect the database from a remote machine (if possible with which library to import from). Thank you very much in advance. _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - 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
Remote connection to server
Hi List, I'm a newby at MySql. I've setup a server for use with Bugzilla but I am also trying to connect to an other database on that server. Each time as I try to connect I get ERROR 2013: Lost connection to MySQL server during query. Is there a setting I must change to be allowed to logon from an other machine apart form the Bugzilla machine TIA. Ronald Hermans QA Manager Every Angle tel: +31 (0)182 577749 gsm: +31 (0)6 23227948 http://www.every-angle.com mailto:[EMAIL PROTECTED] - 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-Max dies when remote connection opened
Version: 4.0.8, installed from the RPMs downloaded from the mysql.com webpages. The server runs RedHat 8.0, all updates installed. The hardware is a Dell 2650. Problem: Any connection, using the command line client for example, from any other node fails even though the access should be allowed. The error message is: ERROR 2013: Lost connection to MySQL server during query On the server side this is logged on the console: # /usr/bin/mysqld_safe: line 312: 30764 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 The error log contains: mysqld-max process hanging, pid 30774 - killed A simple "fix" is to uninstall the Max rpm: rpm -e MySQL-Max-4.0.8-0 After restarting the problem goes away and the remote access is allowed. Something about the Max package seems to be incompatible with RedHat 8.0 ? -psi - 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: Remote Connection, please help
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Muhammad Salman wrote: > Dear Mark, real thanks , Are you refering to this > issues: > > Issue: > > "When I try to connect to the database with MySQL > Connector/J , I get the > following exception: > Yes. [snip] >>>Thanks Mark for your real quick response. The >> >>error I >> >>>am getting is when I try to connect with the >> >>machine's >> >>>ip is : >>> >>>Invalid authorization specification: Access denied >> >>for >> >>>user: >>>'***@**' >>>(Using password: YES) >>> >>>But when I connect it with localhost instead of >> >>the ip >> >>>I am able to connect to MySQL, by putting the code >> >>on >> >>>the same machine. This machine has several >> >>databases Your permissions are not setup correctly. You need to add GRANTs to allow this to happen as it appears that none currently exist that do allow it. You need to do a "GRANT [foo] ON [blah] TO 'user'@'host' identified by 'some_password'" to get this to work. I am deliberately leaving out what you need to put in for [foo] and [blah], because you _really_ need to read the MySQL manual (http://www.mysql.com/doc/en/GRANT.html) and understand exactly what you're doing here. -Mark -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9+N9WtvXNTca6JD8RAtpRAJ9+mZRg4gudtabx3yREo2RD+tNj/wCeKuOJ KeCv39g/Agxk4WG1m0PGFXo= =LyU/ -END PGP SIGNATURE- - 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: Remote Connection, please help
Subject: Remote Connection, please help
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using the
following code for simple remote connection test:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection con =
DriverManager.getConnection("jdbc:mysql://66.137.7.185:3306/prefill","prefill","jeem");
Are there no Exceptions thrown?
- Cs.
-
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: Remote Connection, please help
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
first a note: this is a topic best discussed on
[EMAIL PROTECTED]
* On Thu, Dec 12, 2002 at 08:35:40AM -0800, Muhammad Salman wrote:
> I am using the official type 4 mysql driver from
> www.mysql.com but unable to make a remote connection
> with the mysql database running on our companie's
> remote server. I mailed some mailing mailing lists but
> didnt find out the right answer yet. I am using the
> following code for simple remote connection test:
>
> Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> Connection con =
>
>DriverManager.getConnection("jdbc:mysql://66.137.7.185:3306/prefill","prefill","jeem");
> out.println("Testing Database Connectivity");
> Statement stmt = con.createStatement();
> ResultSet rs = stmt.executeQuery("select * from
> state");
> int i = 0;
> while(rs.next() && i < 10)
> {
> out.println(" Output: "+rs.getString(2) +
> "");
> i ++;
> }
> rs.close();
> stmt.close();
> con.close();
that all looks pretty good. what error are you getting?
have you checked out the readme that comes with the driver?
it is pretty good at addressing some of the more often run
into problems of this variety.
- --
Peter Abplanalp
PGP: pgp.mit.edu
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9+NFVggA8sH0iRXQRArzMAJwLngnF/ouMCFMEEU846oExQE3H5gCgsrGv
IICJvZ3VPu4+MUtBAKsTAkU=
=NLko
-END PGP SIGNATURE-
-
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: Remote Connection, please help
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Muhammad Salman wrote:
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using the
following code for simple remote connection test:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection con =
DriverManager.getConnection("jdbc:mysql://66.137.7.185:3306/prefill","prefill","jeem");
out.println("Testing Database Connectivity");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from
state");
int i = 0;
while(rs.next() && i < 10)
{
out.println(" Output: "+rs.getString(2) +
"");
i ++;
}
rs.close();
stmt.close();
con.close();
Your quick response will be highly appreciated.
You need to tell us what the error you're receiving is, otherwise we
can't be of much help.
-Mark
- --
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE9+MnBtvXNTca6JD8RAkxBAJ9tZD8OF6XByll9AW7IPabqMBZbiQCfdx4g
0lK6FUi8jP331x9czJqqK/E=
=kn1O
-END PGP SIGNATURE-
-
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: Remote Connection, please help
I've never connected your way before. I'm using J/Connector from the MySQL site
(http://www.mysql.com/downloads/api-jdbc-stable.html). That way I have no problems
connecting. I do it this way:
// connect to the database
Class.forName("com.mysql.jdbc.Driver");
Connection dbConnection =
DriverManager.getConnection("jdbc:mysql://localhost/myTable", "username", "password");
Works like a charm. Give it a try...
-Pete
-Original Message-
From: Muhammad Salman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 11:36
To: [EMAIL PROTECTED]
Subject: Remote Connection, please help
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using the
following code for simple remote connection test:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection con =
DriverManager.getConnection("jdbc:mysql://66.137.7.185:3306/prefill","prefill","jeem");
out.println("Testing Database Connectivity");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from
state");
int i = 0;
while(rs.next() && i < 10)
{
out.println(" Output: "+rs.getString(2) +
"");
i ++;
}
rs.close();
stmt.close();
con.close();
Your quick response will be highly appreciated.
=
Muhammad Salman
Sun Certified Java 2 Programmer
+92214932737 (H)
+923332234828(C 1)
+923332103334(C 2)
Email: [EMAIL PROTECTED]
Text Pager: [EMAIL PROTECTED]
Work Web: http://www.jeemsolutions.com
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.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
-
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
Remote Connection, please help
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using the
following code for simple remote connection test:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection con =
DriverManager.getConnection("jdbc:mysql://66.137.7.185:3306/prefill","prefill","jeem");
out.println("Testing Database Connectivity");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from
state");
int i = 0;
while(rs.next() && i < 10)
{
out.println(" Output: "+rs.getString(2) +
"");
i ++;
}
rs.close();
stmt.close();
con.close();
Your quick response will be highly appreciated.
=
Muhammad Salman
Sun Certified Java 2 Programmer
+92214932737 (H)
+923332234828(C 1)
+923332103334(C 2)
Email: [EMAIL PROTECTED]
Text Pager: [EMAIL PROTECTED]
Work Web: http://www.jeemsolutions.com
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.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: Remote connection is blocked because of many connection errors
On Wed, Dec 04, 2002 at 12:21:06PM -0500, Jason Hall wrote: > I have a problem here. > > I cannot connect to a particular server remotely at certain times. > I get the error remote connection is blocked because of many > connection errors. I can login locally on the box. Ok. > To resolve this problem i would run FLUSH HOST and i can connect > remotely. But say about every 10 hours i get the same error and i > have to run FLUSH HOST. You shoud fix the bug that's causing connection errors. Are you checking for errors in your code? Watching return values on connecting to MySQL? > So to further investigate i ran SHOW VARIABLES on the mysql server > and the variable max_connections is set to 100 and i ran SHOW STATUS > and max_used_connections is 17. So Therefore, the server should > allow more connections because it only states that 17 connections is > used. Right, but that has nothing to do with connection *errors*. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 434,386,735 queries (344/sec. avg) - 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
Remote connection is blocked because of many connection errors
I have a problem here. I cannot connect to a particular server remotely at certain times. I get the error remote connection is blocked because of many connection errors. I can login locally on the box. To resolve this problem i would run FLUSH HOST and i can connect remotely. But say about every 10 hours i get the same error and i have to run FLUSH HOST. So to further investigate i ran SHOW VARIABLES on the mysql server and the variable max_connections is set to 100 and i ran SHOW STATUS and max_used_connections is 17. So Therefore, the server should allow more connections because it only states that 17 connections is used. I also ran mysqladmin processlist to see how many processes are running and it's only one. Is there a bug. I am using MySQL 3.22.32 Any ideas? _ Jason Hall Senior Integration Analyst ATT Canada | AES | Managed Hosting & Security Operations Office: 905-896-6250 Mobile: 416-884-4255 - 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
Segmentation Fault on remote connection
I have a few servers running MySQL and regularly (almost every web page!) connect from one to the other to update or query a remote database. I have never had any problems (love that mySQL) until I upgraded one of the systems and re-loaded the websites etc. Now, when I try to connect to the new system, from PHP or just using mySQL, I get a ang or a segmentation fault . Server - Mysql version 3.23.52-log - Suse 8.1 professional Client - Suse ?? - Mysql version 3.23.32 On server machine start up mysqld in the standard way ... mysql /etc/init.d/mysql start On client machine, try to connect mysql -h server -u user -pPassword Client hangs and server either kills all mysqld services or reports a segmentation fault Server>> /usr/bin/safe_mysqld: line 273: 28084 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 Number of processes running now: 3 mysqld process hanging, pid 28115 - killed mysqld process hanging, pid 28115 - killed mysqld process hanging, pid 28115 - killed 021121 17:14:06 mysqld restarted 021121 17:14:06 mysqld ended Any help gratefull receivd Regards Robert UK Theatre Web - www.uktw.co.uk Arts Archive- www.arts-archive.com DynamicListing - www.dynamiclisting.com A: New House, High Street, Fernham, Oxon, SN7 7NY T: 01367 820 828F: 01367 820 827 All information provided in good faith - 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 Crashes When a Remote Connection Is Made
On Fri, Nov 08, 2002 at 10:25:01PM -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> is thought to have said: > >Description: > MySQL crashes when a remote computer attempts to make a standard > connection. Making a local connection does not cause this problem, > connecting to other systems does not cause this problem, but a connection > from a remote computer to mySQL immediately crashes mySQL. Update your glibc packages: https://rhn.redhat.com/errata/RHSA-2002-197.html The previous glibc security update caused things to break. -- Tabor J. Wells [EMAIL PROTECTED] Fsck It! Just another victim of the ambient morality - 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 Crashes When a Remote Connection Is Made
>Description: MySQL crashes when a remote computer attempts to make a standard connection. Making a local connection does not cause this problem, connecting to other systems does not cause this problem, but a connection from a remote computer to mySQL immediately crashes mySQL. The details I have available (from safe_mysqld restarting) is [the segfault is at the exact moment we connect via mysql from a remote computer]: [root@george root]# Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: line 269: 17274 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 Number of processes running now: 2 mysqld process hanging, pid 17277 - killed mysqld process hanging, pid 17277 - killed 021108 22:16:03 mysqld restarted >How-To-Repeat: Connect from another computer on the internet. Use the mysql client. This syntax does it for us: mysql -hhostname -ppassword >Fix: Unknown >Submitter-Id: W_DW >Originator:root >Organization: sqlcoders >MySQL support: none >Synopsis: Remote connection crash server (also possible attack method) >Severity: critical >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.41 (Source distribution) >Environment: System: Linux ensim.rackshack.net 2.4.18-17.7.x #1 Tue Oct 8 13:33:14 EDT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-108.7.2) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 25 07:09 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x2 root root 1285884 Sep 9 12:10 /lib/libc-2.2.4.so -rw-r--r--1 root root 27336078 Sep 9 11:48 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 9 11:48 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --disable-assember --with-berkeley-db --enable-large-files=yes --enable-largefile=yes --with-thread-safe-client --enable-assembler - 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: ODBC install and remote connection quetions
David Lloyd wrote: How do you mean not able to "see it"? Under the control panel there should be an "ODBC Data Source Administrator"... (mysql, query) DSL The driver is not listed in the driver. I cannot select it from the list of drivers as it is not there. Jerry - 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: ODBC install and remote connection quetions
Jerry, > I have some questions on using ODBC with My SQL. :-) > I have a MySQL on on an ISPs database server. I'd like to > pull data from it into Excel. It appears that I need to > use ODBC to do this. Do the server need to have ODBC > installed or do I just need it installed on the PC I want > to connect from? On the PC you want to connect from. The ODBC driver is a client and will speak to the server. > I am using Win98 2nd edition. I downloaded and installed > My ODBC. For some reason, I am not able to see the MySQL > ODBC driver. What do I need to do so that it is available > to me? How do you mean not able to "see it"? Under the control panel there should be an "ODBC Data Source Administrator"... (mysql, query) DSL -- Angel of Music, why deny me? Turning from true beauty! Angel of music, do not shun me, Turn to your strange Angel! - 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
ODBC install and remote connection quetions
I have some questions on using ODBC with My SQL. I have a MySQL on on an ISPs database server. I'd like to pull data from it into Excel. It appears that I need to use ODBC to do this. Do the server need to have ODBC installed or do I just need it installed on the PC I want to connect from? I am using Win98 2nd edition. I downloaded and installed My ODBC. For some reason, I am not able to see the MySQL ODBC driver. What do I need to do so that it is available to me? I am really lost with this. Jerry - 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
Is this possible - Remote Connection with SSL
I would like to know if this is at all possible using MySQL 4.0.4 in Windows. We want to be able to host our web site using either Windows and ASP or Linux and PHP in our service provider server. All the scripts will be in their machine away from our network. Then I would like for those scripts to have access to our MySQL Server in our internal network. The reason is that we sell airline tickets and we would like the travel agents to book on the site and be able to read the inventory as it changes either form bookings on-line or in site. I was wondering about using SSL from the ISP's machine to ours or using some kind of VPN. Please, any help in this matter will be really appreciated. Thank you, Fernando *** sql, query *** - 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: Remote Connection Probem
I tried this and got a different result: [root@daevid root]# telnet 127.0.0.1 3306 Trying 127.0.0.1... Connected to 127.0.0.1. Escape character is '^]'. ?Host 'daevid' is not allowed to connect to this MySQL serverConnection closed by foreign host. [root@daevid root]# telnet localhost 3306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. ?Host 'daevid' is not allowed to connect to this MySQL serverConnection closed by foreign host. [root@daevid root]# telnet daevid.com 3306 Trying 12.228.95.58... mysql> select * from host ; +-++-+-+-+-- ---+-+---++-+--- -++ | Host| Db | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-++-+-+-+-- ---+-+---++-+--- -++ | localhost | % | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | 192.168.0.% | % | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | %daevid%| % | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | +-++-+-+-+-- ---+-+---++-+--- -++ 3 rows in set (0.00 sec) > -Original Message- > From: Stefan Kuss [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 11:04 AM > To: Ronald Petty > Cc: [EMAIL PROTECTED] > Subject: Re: Remote Connection Probem > > > Thanks for your response. > I tried to connect to the server via telnet as you suggested > with the following result. > > telnet my.machine.ip 3306 > > Trying my.machine.ip... > Connected to my.machine.ip. > Escape character is '^]'. > Connection closed by foreign host. > > Is this the behaivior I should expect, or am I correct to > assume that the remote host should not terminate the > connection. Somebody else on this list reported having the > exact same problems after an upgrade from Redhat 7 to Redhat > 8 in response to my post. Any more ideas of what could be wrong? > > > - Original Message - > From: "Ronald Petty" <[EMAIL PROTECTED]> > To: "Stefan Kuss" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, October 07, 2002 10:59 PM > Subject: Re: Remote Connection Probem > > > > Try this > > telnet yourmachine 3306 > > > > If you do not get something like > > Trying yourmachine > > Conneced to yourmachine > > Escape character is '^]'. > > (then sits there on a blank line) > > > > Your port is not open, > > Ron > > > > > > > >> > >>Hi, > >> > >>I am running MySQL 3.23 on Redhat 8.0. I can connect to > MySQL from the > local > >>machine without any problem and I created a user with remote login > >>privileges. Trying to connect to it from another machine > (on the same > >>network as well as the same subnet) gives "ERROR: 10061 > Connection to > mysql > >>server failed." I have no problems connecting to the linux > machine via > hhtp, > >>ftp, and ssh and a port scan shows that MySQL is infact > running on the > >>remote machine (default port 3306). Has anyone heard of similar > >>problems > and > >>an idea of how to solve this? > >> > >>-Stefan > > > > - > 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: Remote Connection Probem
Thanks for your response. I tried to connect to the server via telnet as you suggested with the following result. telnet my.machine.ip 3306 Trying my.machine.ip... Connected to my.machine.ip. Escape character is '^]'. Connection closed by foreign host. Is this the behaivior I should expect, or am I correct to assume that the remote host should not terminate the connection. Somebody else on this list reported having the exact same problems after an upgrade from Redhat 7 to Redhat 8 in response to my post. Any more ideas of what could be wrong? - Original Message - From: "Ronald Petty" <[EMAIL PROTECTED]> To: "Stefan Kuss" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 07, 2002 10:59 PM Subject: Re: Remote Connection Probem > Try this > telnet yourmachine 3306 > > If you do not get something like > Trying yourmachine > Conneced to yourmachine > Escape character is '^]'. > (then sits there on a blank line) > > Your port is not open, > Ron > > > >> >>Hi, >> >>I am running MySQL 3.23 on Redhat 8.0. I can connect to MySQL from the local >>machine without any problem and I created a user with remote login >>privileges. Trying to connect to it from another machine (on the same >>network as well as the same subnet) gives "ERROR: 10061 Connection to mysql >>server failed." I have no problems connecting to the linux machine via hhtp, >>ftp, and ssh and a port scan shows that MySQL is infact running on the >>remote machine (default port 3306). Has anyone heard of similar problems and >>an idea of how to solve this? >> >>-Stefan - 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: Remote Connection Probem
I have the exact same problem. Nothing has changed other than I upgraded from RH7.3 to RH8.0. I've tried at least five (5) different mySQL windows clients and all refuse to connect. However I can use phpMyAdmin locally (via web) and also all my web based database pages work fine too. I've tried adding some entries to the mysql/hosts table and still nothing. It's very confusing and frustrating indeed. Anyone know how to get this working again? And for what it's worth. I have no firewall on the linux box (removed all that crap), and both my winxp and linux boxes are sitting on an internal LAN 192.168.0.% [root@daevid var]# rpm -qa | grep "mysql" mysql-server-3.23.52-3 libdbi-dbd-mysql-0.6.5-2 mysql-3.23.52-3 mysql-devel-3.23.52-3 mod_auth_mysql-1.11-1 mysqlclient9-3.23.22-6 php-mysql-4.1.2-7.3.4 DÆVID. "A good friend will come and bail you out of jail...but a true friend will be sitting next to you in the holding cell, laughing and saying -'That was fucking awesome!'" > -Original Message- > From: Stefan Kuss [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 07, 2002 7:41 PM > To: [EMAIL PROTECTED] > Subject: Remote Connection Probem > > > Hi, > > I am running MySQL 3.23 on Redhat 8.0. I can connect to MySQL > from the local machine without any problem and I created a > user with remote login privileges. Trying to connect to it > from another machine (on the same network as well as the same > subnet) gives "ERROR: 10061 Connection to mysql server > failed." I have no problems connecting to the linux machine > via hhtp, ftp, and ssh and a port scan shows that MySQL is > infact running on the remote machine (default port 3306). Has > anyone heard of similar problems and an idea of how to solve this? > > -Stefan - 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
Remote Connection Probem
Hi, I am running MySQL 3.23 on Redhat 8.0. I can connect to MySQL from the local machine without any problem and I created a user with remote login privileges. Trying to connect to it from another machine (on the same network as well as the same subnet) gives "ERROR: 10061 Connection to mysql server failed." I have no problems connecting to the linux machine via hhtp, ftp, and ssh and a port scan shows that MySQL is infact running on the remote machine (default port 3306). Has anyone heard of similar problems and an idea of how to solve this? -Stefan - 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
Remote connection problem
Hello, I'm having a problem connecting to a remote MySQL database and was hoping someone could give me a pointer on where to look. Both machines are running Red Hat Linux 7.2 and MySQL version 3.23.52. I have it compiled and running succesfully on each machine as long as I log in to the database on localhost. However, when I try to connect remotely, I get the following error: [jcoltrin@persephone jcoltrin]$ mysql -h hades.vernier.com -u verniercart -p Enter password: ERROR 2003: Can't connect to MySQL server on 'hades.vernier.com' (110) Now, I can SSH between Persephone to Hades with no problem, so they can find each other via SSH. I know our network admin has closed down most of the ports and I suspect this is the problem. I tried opening port 3306 on both machines in the /etc/hosts.allow file to try to open the connection, but it didn't work. Other possibly useful information is that the hades machine is inside our firewall and the persephone machine is outside of the firewall Any help would be greatly appreciated. - jessica Jessica Coltrin Vernier Software and Technology (503)277-2299 [EMAIL PROTECTED] - 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: Remote connection
Dear all check this new tool at http://amr.activechannel.net http://amr.activechannel.net/setup.zip SQL server users will love it , same query analyzer but more powerful Amr Salah _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Run a small business? Then you need professional email like [EMAIL PROTECTED] from Everyone.net http://www.everyone.net?tag - 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: Remote connection
Hi Gokce, You can check the following (especially the second one); 1. Make sure that you have provided a password to root account on the server box; grant all on * to 'root'@'%' identified by 'your_root_password'; % here means that you can login to your server box as root from any host. However you must provide a difficult to guess password for security reasons because you have added any host with login permission. You may instead only add your client IP replacing with %. 2. Possibly you didn't active the client box's ethernet interface. Make sure pinging from client box is replied from the server box. I wish these above may help you.. If you want to administer you MySQL servers from Windows boxes I may suggest two powerful tools you to search; 1. EMS MySQL Manager 2. M2D - MySQL Database Admin v2.2 Murat. - 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: remote connection/users
Check the docs on GRANT. Sounds like you have an incorrect host. Either set the host to % on your current record (manually and then FLUSH PRIVILEGES) or figure out the hostname from the machine you are trying to connect from and grant yourname@hostname the necessary privileges. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Lee Connell [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 13, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: remote connection/users I am new with mysql. I have the latest version installed on a win2k = machine. I am trying to access mysql DB from another machine. It = returns invalid username/password, but if i connect locally with the = same login info it connects fine. What do i have to do to allow any = remote host to connect on a specific user account? _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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 - 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
remote connection/users
I am new with mysql. I have the latest version installed on a win2k = machine. I am trying to access mysql DB from another machine. It = returns invalid username/password, but if i connect locally with the = same login info it connects fine. What do i have to do to allow any = remote host to connect on a specific user account? _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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: Remote connection to MySQL Server using MS Access 2002
There are other windows front ends to mysql, but this one is the best: http://ems-hitech.com/mymanager/ Are you sure the server allows remote connections? Ken Charles McGrotty wrote: > > Hi, > > Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I > can connect to a remote MySQL database. > > I have tried putting an IP address in that I found by lookup of the > domain name, and I entered the database name and password, but I get an > error saying connection from ~db_name~@~whatever_ISP~ was refused, what > am I doing wrong. > > I do not know the actual servr name that the MySQL database lives on, so > what options do I have, this must be possible so how do I do it. > > Alternativly, if anyone knows of any alternative tools (not phpMyAdmin > (ie: not browser based)) that will allow me to look at, and work with > the data, even if only in a read only enviroment at this time, though > full access is desired. I would mych appreciate it. > > Thnx > > - > 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
Remote connection to MySQL Server using MS Access 2002
Hi, Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I can connect to a remote MySQL database. I have tried putting an IP address in that I found by lookup of the domain name, and I entered the database name and password, but I get an error saying connection from ~db_name~@~whatever_ISP~ was refused, what am I doing wrong. I do not know the actual servr name that the MySQL database lives on, so what options do I have, this must be possible so how do I do it. Alternativly, if anyone knows of any alternative tools (not phpMyAdmin (ie: not browser based)) that will allow me to look at, and work with the data, even if only in a read only enviroment at this time, though full access is desired. I would mych appreciate it. Thnx - 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: Remote Connection to Linux MySQL
Your problem is probably due to not having a grant entrry in the user table that allows your user name to log in from 192.168.1.253. Try GRANTing either that IP, or all IP's (%) access with that user name. This link should help you out. http://www.mysql.com/doc/G/R/GRANT.html Cary At 08:59 PM 3/10/02, delz wrote: >Hi, > >How do I configure mysql so that it will accept remote connections because I >get the error message "Host 192.168.1.253 is not allowed to connect to this >MySQL Server" > >Can someone help me with this. > >Delz > > >- >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
Remote Connection to Linux MySQL
Hi, How do I configure mysql so that it will accept remote connections because I get the error message "Host 192.168.1.253 is not allowed to connect to this MySQL Server" Can someone help me with this. Delz - 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 remote connection.
Hello, Can anybody provide input on commandline tool on solaris to connect to mysql server running on linux. And possibly configuring procedure if any involved. Thanks, Prabhu --- Beauty is bought by judgement of the eye. -- Shakespeare --- Prabhu SR. Sankhya Technologies Private Limited, Chennai-34. --- - 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
MySQLGUI remote connection
Hown do I connect to a MySql database that is outside the firewall with mysqlgui? Jens Erik - 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
remote connection with phpMyAdmin
Hi everybody, I've installed MySQL 3.23.38 on a RedHat 6.0 system with php 3.0.18. When I want to connect to the server with phpMyAdmin, it returns the following message : Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./lib.inc.php3 on line 220 Erreur But any other program connect to it. any hints ? Pericles
Remote Connection Strangeness
A bit bizarre: When I connect to MySQL through the localhost I have no problems; however when I connect from a remote server I get the error "Can't initialize character set 13 (path:default) in The localhost and the remote host both have versions of MySQL installed (the remote host doesn't have the sjis charset set as its default, the localhost does). However, it was my understanding that the remote host would use all the functionality of the host it is connecting to. I'm a bit confused by this error and it makes me think that I don't quite fully understand what is going on when a remote connection is made. Any clues? If so, please send a CC to my email address. TIA :-] - anatole - 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: Remote connection protocol
You don't. You can use telnet to connect and run mysql on that machine, displaying on yours. You can use mysql on your machine to connect to mysqld on the remote machine using the -h option to mysql. This requires that the grant command has been run on the server to allow you to connect, and that port 3306 ( or whatever the server is running on ) is not blocked by a firewall. Robert Feldbauer wrote: > > I'm trying to use a remote telnet connection to access a mysql > server. Anyone know where I could find protocols to connect to > a mysql server, with telnet? Thanks. > > Bob Feldbauer > [EMAIL PROTECTED] > > - > 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
Remote connection protocol
I'm trying to use a remote telnet connection to access a mysql server. Anyone know where I could find protocols to connect to a mysql server, with telnet? Thanks. Bob Feldbauer [EMAIL PROTECTED] - 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
Remote connection problem.
Hi,
I am using the MySQL server and it's myodbc_mysql client programme.
When i connect to the local machine, it works perfectly. But i don't
know how do i connect to remote machine when using it in pure ODBC
fashion.
--
Available way is like follwing,
1. mysql -u root -h abc.xyz.com -p
( for interactive command line tool )
or
2. real_connect( user, host, db, ..)
( for CAPI )
these works perfectly.
-
I actually want something like following, and want to give remote host
name in this programme. Following programme by default contacts to
localhost:3306 and does the query. Depending upon some conditions i will
be switching the localhost name and remote host name. I found couple of
solutions in PHP, CAPI etc, but that doesn't suite my need.
--
#include
#include
#include "isql.h"
#include "odbc_funcs.h"
#include "odbc_types.h"
#define MIB_DB_DSN "blob_test"
#define MIB_DB_USER "root"
#define MIB_DB_PASSWORD "venkat"
#define TRUE 1
#define FALSE 0
SQLHDBC hdbc;
SQLHENV henv;
void displayError( SQLHENV hEnv, SQLHDBC hDbc, SQLHSTMT hStmt,
int iRC, int iLineNum
)
{
SQLCHAR szBuffer[ SQL_MAX_MESSAGE_LENGTH ];/* msg.
buffer*/
SQLCHAR szSqlState[ SQL_SQLSTATE_SIZE ]; /* statement
buf. */
SQLINTEGERiSqlCode; /* return
code*/
SQLSMALLINT iLength; /* return
length */
fprintf( stderr, "---\n" );
fprintf( stderr, "SQL error : %d\n", iRC );
fprintf( stderr, "line number: %d\n", iLineNum );
while( SQL_SUCCESS == SQLError( hEnv, hDbc, hStmt, szSqlState,
&iSqlCode, szBuffer,
SQL_MAX_MESSAGE_LENGTH - 1, &iLength
)
)
{
fprintf( stderr, "SQL state : %s\n", szSqlState );
fprintf( stderr, "native error code : %ld\n", iSqlCode );
fprintf( stderr, "%s\n", szBuffer );
} /* while */
fprintf( stderr, "---\n" );
} /* displayError */
int
main( int argc, char* argv[] )
{
SQLRETURN nResult;
SQLHSTMThstmt;
if(SQLAllocEnv(&henv) != SQL_SUCCESS)
{
displayError( henv, hdbc, NULL, 0, __LINE__ );
printf( "\nUnable to get the database handle");
return FALSE;
}
if(SQLAllocConnect( henv, (SQLHDBC FAR *)&hdbc) != SQL_SUCCESS)
{
displayError( henv, hdbc, NULL, 0, __LINE__ );
printf( "\nUnable to get the database handle" );
return FALSE;
}
if((nResult = SQLConnect( hdbc,
(unsigned char *)MIB_DB_DSN, SQL_NTS,
(unsigned char *)MIB_DB_USER, SQL_NTS,
(unsigned char *)MIB_DB_PASSWORD, SQL_NTS)) !=
SQL_SUCCESS)
{
displayError( henv, hdbc, NULL, 0, __LINE__ );
printf( "\nUnable to connect to the database" );
return FALSE;
}
SQLDisconnect(hdbc);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
exit(0);
} /* end, main() */
---
Thaning you for speedier reponse,
with regards,
-peri
-
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
