RE: Connecting Remotely to MySQL Server
If you only allow local connection, your setup should works, otherwise, you need to specify from which host you allow the connection in your grant statement. I think you need a DNS entry for your first question, not so sure about the question. From: Andy [mailto:listan...@gmail.com] Sent: Monday, June 07, 2010 5:58 PM To: Qu, Gang Cc: mysql@lists.mysql.com Subject: Re: Connecting Remotely to MySQL Server OK so I managed to open 3306. Now when I connect using 127.0.0.1 from the intranet box it works, but when I connect using it's IP it's still the same situation :( And now when I connect remotely (from my front end which is accessible via WWW), it says "ERROR 1045 (28000): Access denied for user 'andy'@'frontend.internal' (using password: YES)". Does it have something to do with the fact that 'andy' in the mysql user tables is only authorized to connect from 'localhost'? How do I fix this problem. Thank you very much. Andy On Mon, Jun 7, 2010 at 3:41 PM, Qu, Gang mailto:gan...@quickenloans.com>> wrote: Make sure the port is open from the db server. you can test it using "telnet server 3306(if that's what you use)". If not, have your network admin open the port for you. -Original Message- From: listan...@gmail.com<mailto:listan...@gmail.com> [mailto:listan...@gmail.com<mailto:listan...@gmail.com>] Sent: Monday, June 07, 2010 3:37 PM To: mysql@lists.mysql.com<mailto:mysql@lists.mysql.com> Subject: Connecting Remotely to MySQL Server Hello all, New to MySQL and still exploring. I have MySQL installed on one of the boxes on the intranet (on which I am not the root) and am trying to connect to it remotely via a box (that can be see from the "external world"). Unfortunately it does not seem to be working. Here's what I did from the shell: my sql -h -u andy -p After I do this, it asks for my password, and after I enter it, it just sits there doing nothing. I am however able to login using my credentials from the intranet box directly. However when from the intranet box, I try to login using the exact command above, it's exactly the same situation - it just sits there after I enter the password. Any suggestions? Thanks. Andy
Re: Connecting Remotely to MySQL Server
OK so I managed to open 3306. Now when I connect using 127.0.0.1 from the intranet box it works, but when I connect using it's IP it's still the same situation :( And now when I connect remotely (from my front end which is accessible via WWW), it says "ERROR 1045 (28000): Access denied for user 'andy'@'frontend.internal' (using password: YES)". Does it have something to do with the fact that 'andy' in the mysql user tables is only authorized to connect from 'localhost'? How do I fix this problem. Thank you very much. Andy On Mon, Jun 7, 2010 at 3:41 PM, Qu, Gang wrote: > Make sure the port is open from the db server. you can test it using > "telnet server 3306(if that's what you use)". If not, have your network > admin open the port for you. > > > -Original Message- > From: listan...@gmail.com [mailto:listan...@gmail.com] > Sent: Monday, June 07, 2010 3:37 PM > To: mysql@lists.mysql.com > Subject: Connecting Remotely to MySQL Server > > Hello all, > > New to MySQL and still exploring. I have MySQL installed on one of the > boxes > on the intranet (on which I am not the root) and am trying to connect to it > remotely via a box (that can be see from the "external world"). > Unfortunately it does not seem to be working. Here's what I did from the > shell: > > my sql -h -u andy -p > > After I do this, it asks for my password, and after I enter it, it just > sits > there doing nothing. I am however able to login using my credentials from > the intranet box directly. However when from the intranet box, I try to > login using the exact command above, it's exactly the same situation - it > just sits there after I enter the password. > > Any suggestions? > > Thanks. > Andy >
RE: Connecting Remotely to MySQL Server
Make sure the port is open from the db server. you can test it using "telnet server 3306(if that's what you use)". If not, have your network admin open the port for you. -Original Message- From: listan...@gmail.com [mailto:listan...@gmail.com] Sent: Monday, June 07, 2010 3:37 PM To: mysql@lists.mysql.com Subject: Connecting Remotely to MySQL Server Hello all, New to MySQL and still exploring. I have MySQL installed on one of the boxes on the intranet (on which I am not the root) and am trying to connect to it remotely via a box (that can be see from the "external world"). Unfortunately it does not seem to be working. Here's what I did from the shell: my sql -h -u andy -p After I do this, it asks for my password, and after I enter it, it just sits there doing nothing. I am however able to login using my credentials from the intranet box directly. However when from the intranet box, I try to login using the exact command above, it's exactly the same situation - it just sits there after I enter the password. Any suggestions? Thanks. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Connecting from a remote computer
If you have that short a script to test wit, try it from the command line. Your HTML might be obscuring the error messages. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Kay C. Tien [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 18, 2007 4:32 PM > To: Chris White > Cc: mysql@lists.mysql.com > Subject: Re: Connecting from a remote computer > > I got it working perfectly on a Linux server, but my boss wants this > on a Windows IIS server. > > The remote connection seems to be working now but I have another > problem now... the page is not doing anything - doesn't seem to be > connecting to the database, but I got no error messages > whatsoever. The page just indicated Done on the bottom. The > mysql_connect.php file is listed below. Is there a privilege problem > or is there something else I need to enable? > > Much thanks. > Kay > > > // This file contains the database access information for the > database. This file also establishes a connection to MySQL and > selects the database. > > // Set the database access information as constants. > define ('DB_USER', 'username); > define ('DB_PASSWORD', 'userpass'); > define ('DB_HOST', 'localhost'); > define ('DB_NAME', 'databasename'); > > // Make the connnection and then select the database. > $dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could > not connect to MySQL: ' . mysql_error() ); > mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . > mysql_error() ); > > // Function for escaping and trimming form data. > function escape_data ($data) { > global $dbc; > if (ini_get('magic_quotes_gpc')) { > $data = stripslashes($data); > } > return mysql_real_escape_string (trim ($data), $dbc); > } // End of escape_data() function. > ?> > > At 10:53 AM 1/18/2007 Thursday, Chris White wrote: > >Just to toss something else in here. A lot of times you have a > >server that you can connect to by ssh, but because of firewalls, > >can't access mysql through. If you can, however, connect to the > >database through ssh, you can do port forwarding. In *nix systems > >it should be something like this: > > > >ssh -L 3306:server.com:3306 -N -f [EMAIL PROTECTED] > > > >This will forward requests from port 3306 locally to port 3306 on > >server.com. If you're on windows, you can also do port forwarding > >through putty: > > > >http://www.cs.uu.nl/technical/services/ssh/putty/puttyfw.html > > > >This becomes pretty easy when you get the hang of it. You > can also do like: > > > >ssh -L 3000:server.com:3306 -N -f [EMAIL PROTECTED] > > > >if you're, say, running a local mysql instance. As a reminder > >connections will have to occur to localhost, not the server. > Hope this helps. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting from a remote computer
I got it working perfectly on a Linux server, but my boss wants this on a Windows IIS server. The remote connection seems to be working now but I have another problem now... the page is not doing anything - doesn't seem to be connecting to the database, but I got no error messages whatsoever. The page just indicated Done on the bottom. The mysql_connect.php file is listed below. Is there a privilege problem or is there something else I need to enable? Much thanks. Kay // This file contains the database access information for the database. This file also establishes a connection to MySQL and selects the database. // Set the database access information as constants. define ('DB_USER', 'username); define ('DB_PASSWORD', 'userpass'); define ('DB_HOST', 'localhost'); define ('DB_NAME', 'databasename'); // Make the connnection and then select the database. $dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error() ); mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error() ); // Function for escaping and trimming form data. function escape_data ($data) { global $dbc; if (ini_get('magic_quotes_gpc')) { $data = stripslashes($data); } return mysql_real_escape_string (trim ($data), $dbc); } // End of escape_data() function. ?> At 10:53 AM 1/18/2007 Thursday, Chris White wrote: Just to toss something else in here. A lot of times you have a server that you can connect to by ssh, but because of firewalls, can't access mysql through. If you can, however, connect to the database through ssh, you can do port forwarding. In *nix systems it should be something like this: ssh -L 3306:server.com:3306 -N -f [EMAIL PROTECTED] This will forward requests from port 3306 locally to port 3306 on server.com. If you're on windows, you can also do port forwarding through putty: http://www.cs.uu.nl/technical/services/ssh/putty/puttyfw.html This becomes pretty easy when you get the hang of it. You can also do like: ssh -L 3000:server.com:3306 -N -f [EMAIL PROTECTED] if you're, say, running a local mysql instance. As a reminder connections will have to occur to localhost, not the server. Hope this helps.
Re: Connecting from a remote computer
Just to toss something else in here. A lot of times you have a server that you can connect to by ssh, but because of firewalls, can't access mysql through. If you can, however, connect to the database through ssh, you can do port forwarding. In *nix systems it should be something like this: ssh -L 3306:server.com:3306 -N -f [EMAIL PROTECTED] This will forward requests from port 3306 locally to port 3306 on server.com. If you're on windows, you can also do port forwarding through putty: http://www.cs.uu.nl/technical/services/ssh/putty/puttyfw.html This becomes pretty easy when you get the hang of it. You can also do like: ssh -L 3000:server.com:3306 -N -f [EMAIL PROTECTED] if you're, say, running a local mysql instance. As a reminder connections will have to occur to localhost, not the server. Hope this helps. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting from a remote computer
Hi All, This is a dump and simple question but I can't seem to get it to work. How do I enable a user to be able to connect from a remost host using MySQL Administrator? I added "%" but once signed in, I still can't access the user panel in the administrator. Thanks. Kay I don't know if I can help but MySQL users have some privileges ans one of the configurations on the privileges of a user is the host from where it can connect. If the user is configured to connect only from localhost you won't be able to connect as that user from a remote machine. -Nuno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting mySQL to ColdfusionMX7
Ruth divulged the following in an email dated 8/30/2006 11:58 AM : > All, > > I am having difficulties getting the Coldfusion Administrator to establish a > database connection to a database called "accounting" that I created using > the command line utility. Any help would be very appreciated > > This is the error that CF is throwing: > > "Connection verification failed for data source: accounting > java.sql.SQLException: Communication failure during handshake. Is there a > server running on localhost:3306?" > > Thank you in advance! > > rruth > > > > > > Sent via the WebMail system at ruthgirls.com > > > > http://www.adobe.com/go/6ef0253 If you have any more problems, ask them at the coldfusion forums ...most have already been answered. HTH Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting mySQL to ColdfusionMX7
Ruth wrote: All, I am having difficulties getting the Coldfusion Administrator to establish a database connection to a database called "accounting" that I created using the command line utility. Any help would be very appreciated This is the error that CF is throwing: "Connection verification failed for data source: accounting java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?" Is mysql accepting tcp/ip connections and is it running on port 3306? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connecting to the embedded server
Jim Winstead wrote: > On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote: >> Dear all, >> >> is it a desired feature that the embedded version of the client library >> still tries to create a network connection when I pass a hostname into >> connect? > > Yes, the embedded version also acts as a standard MySQL client. > >> Is it possible to influence this behaviour, so that the API just ignores >> settings like the hostname and the port and always connects to the >> embedded server? > > You can call mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, 0) > after calling mysql_init() and before calling mysql_real_connect(). > > http://dev.mysql.com/doc/refman/5.1/en/mysql-options.html > > Jim Winstead > MySQL Inc. Thanks for the quick reply. What I am looking for is a way of setting this globally, as the connection is created in a third party library where I can't set options. Thanks for your help, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connecting to the embedded server
On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote: > Dear all, > > is it a desired feature that the embedded version of the client library > still tries to create a network connection when I pass a hostname into > connect? Yes, the embedded version also acts as a standard MySQL client. > Is it possible to influence this behaviour, so that the API just ignores > settings like the hostname and the port and always connects to the embedded > server? You can call mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, 0) after calling mysql_init() and before calling mysql_real_connect(). http://dev.mysql.com/doc/refman/5.1/en/mysql-options.html Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to mysql 4.1 server with a 4.0 client
Cheers Dan. Exactly what I needed :) Iain Dan Trainor wrote: Iain Conochie wrote: Afternoon, Apologies if this has been discussed before, I could not find a reference of it. So here we go :) Currently, I have a need to get a mysql 4.0 client to talk to a mysql 4.1 database. The error message I get is ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client Unfortunately, this is not possible. Is there any way of getting the server to use the 4.0 method of authentication? Cheers Hi - This will help: http://dev.mysql.com/doc/refman/4.1/en/old-client.html Unfortunately I've been in this position a few times, as well. Thanks -dant -- Iain Conochie UNIX System Administrator UK COLT Telecom Units 9-13 Powergate Business Centre, Volt Avenue, London NW10 6PW Tel: +44 (0) 20 7947 1286 Tel: +44 (0) 78 1514 5493 Email: [EMAIL PROTECTED] www.colt.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to mysql 4.1 server with a 4.0 client
Iain Conochie wrote: Afternoon, Apologies if this has been discussed before, I could not find a reference of it. So here we go :) Currently, I have a need to get a mysql 4.0 client to talk to a mysql 4.1 database. The error message I get is ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client Unfortunately, this is not possible. Is there any way of getting the server to use the 4.0 method of authentication? Cheers Hi - This will help: http://dev.mysql.com/doc/refman/4.1/en/old-client.html Unfortunately I've been in this position a few times, as well. Thanks -dant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to queries into one
Courtney, >SELECT consumers.id FROM consumers >WHERE date_of_birth = ? AND consumer.id = >(SELECT consumer_id FROM cases WHERE last_name = ? >AND full_first_name = ? ) >Is there a way to form the above statement in MYSQL? Something like this would be faster ... SELECT co.id FROM cases AS ca INNER JOIN consumers AS co USING (consumer_id) WHERE co.date_of_birth = AND ca.last_name = AND ca.first_name = ; PB Courtney Braafhart wrote: MY GOAL To collect any consumers.id WHERE date of birth, last name and first name matches what was entered by the user. The trick is that date of birth lives in the consumer table and last name and first name lives in the cases table (which can be joined to consumers by consumers.id and cases.consumer_id). Can anyone think of way to do this in one mysql statement instead of doing a loop? I am thinking it would work something like this: SELECT consumers.id FROM consumers WHERE date_of_birth = ? AND consumer.id = (SELECT consumer_id FROM cases WHERE last_name = ? AND full_first_name = ? ) Is there a way to form the above statement in MYSQL? MY HOPE That there is a really obvious solution to this question and that I am simply suffering from a case of the Mondays! Thanks in advance! Courtney Braafhart --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connecting to queries into one
SELECT consumers.id FROM consumers, cases WHERE consumers.id=cases.consumers_id AND consumers.date_of_birth = ? AND cases.last_name = ? AND cases.first_name = ? John A. McCaskey -Original Message- From: Courtney Braafhart [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 10:31 AM To: mysql@lists.mysql.com Subject: Connecting to queries into one MY GOAL To collect any consumers.id WHERE date of birth, last name and first name matches what was entered by the user. The trick is that date of birth lives in the consumer table and last name and first name lives in the cases table (which can be joined to consumers by consumers.id and cases.consumer_id). Can anyone think of way to do this in one mysql statement instead of doing a loop? I am thinking it would work something like this: SELECT consumers.id FROM consumers WHERE date_of_birth = ? AND consumer.id = (SELECT consumer_id FROM cases WHERE last_name = ? AND full_first_name = ? ) Is there a way to form the above statement in MYSQL? MY HOPE That there is a really obvious solution to this question and that I am simply suffering from a case of the Mondays! Thanks in advance! Courtney Braafhart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connecting to queries into one
select consumers.id from consumers LEFT JOIN cases ON consumers.id = cases.id WHERE consumers.date_of_birth = '?' AND cases.last_name = '?' AND cases.full_first_name = '?' -Original Message- From: Courtney Braafhart [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 1:31 PM To: mysql@lists.mysql.com Subject: Connecting to queries into one MY GOAL To collect any consumers.id WHERE date of birth, last name and first name matches what was entered by the user. The trick is that date of birth lives in the consumer table and last name and first name lives in the cases table (which can be joined to consumers by consumers.id and cases.consumer_id). Can anyone think of way to do this in one mysql statement instead of doing a loop? I am thinking it would work something like this: SELECT consumers.id FROM consumers WHERE date_of_birth = ? AND consumer.id = (SELECT consumer_id FROM cases WHERE last_name = ? AND full_first_name = ? ) Is there a way to form the above statement in MYSQL? MY HOPE That there is a really obvious solution to this question and that I am simply suffering from a case of the Mondays! Thanks in advance! Courtney Braafhart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting using MyODBC
Hello. I'm not familiar with this subject, however, have you been at: http://dev.mysql.com/doc/mysql/en/howto-cf.html http://dev.mysql.com/doc/mysql/en/programs-known-to-work-with-myodbc.html http://dev.mysql.com/doc/mysql/en/myodbc-tested-applications.html http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17262 "Ryan Stille" <[EMAIL PROTECTED]> wrote: > I am trying to connect to MySQL from within ColdFusion on a linux box. > ColdFusion (version 5) came with a Merant driver, but it is too old to > support transactions. > > I've downloaded libmyodbc_mysql.so (MyODBC 2.5) and also libmyodbc3.so > (MyODBC 3.5) and could not get either of these to work. But I'm not > sure if I'm using them correctly. > > Basically all I've done is copy these files to my machine and change > this line in ColdFusion's odbc.ini file: > Old: Driver=3D/opt/coldfusion/lib/CFmysql15.so > New: Driver=3D/opt/coldfusion/lib/libmyodbc_mysql.so > > Does this sound like I'm using them correctly? Most of the > documentation I find about MyODBC talks about installing an odbc > manager, I believe ColdFusion already has one built in, since the > odbc.ini file already exists and is used. > > When I use ODBC 3.5 my server just hangs. When I use the 2.5 driver I > get this error: > ODBC Error Code =3D IM003 (Specified driver could not be loaded) > > Thanks for any help. > -Ryan > > -- 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: connecting with PHP from remote server - security breach?
Ideally you would want to encrypt the connection, if only to add another layer of security. But regardless, there are other steps you can and should take even before implementing a secure connection between PHP and MySQL. It's actually a smart idea to separate your database from the front end host. Your external router, the one directly connected to the internet, should not allow any connections to or from the MySQL box from the "outside". Your PHP/Apache box would be in a DMZ zone, basically sitting between two routers/firewalls (between a rock and a hard place?). Your internal router/firewall would only allow connections from the PHP/Apache box to the MySQL box on the appropriate ports. That's the basics on setting up your network to restrict access to your machines. You should then also configure your machines to restrict access to themselves. So PHP can only talk to the MySQL machine and MySQL can only talk to the PHP machine on the appropriate ports. With this setup, even if someone from the outside new the proper name and password for MySQL, they wouldn't be able to connect because the routers, firewalls, OS and MySQL wouldn't allow it. In theory, someone would have to be on the inside in order to sniff the unencrypted connection and connect to one of your machines. Or they would need to compromise one of your machines (router, firewall, pc, etc.). These are some basic steps you should take whether or not you have an encrypted connection. Close all doors and make each path a one way street if possible. No system is secure, it's just sufficiently difficult to crack to make it not worthwhile. On Apr 27, 2005, at 3:43 AM, Nikola Skoric wrote: Hello, I'm wondering whether there is a way to hack into my database if I'm connecting with PHP from remote web server to my MySQL server with unencrypted connection? I'm using phpBB forums (residing on one server and using the database on other server) which do not suport SSH connections, so I'd like to know if I'm opening a security hole in my system this way? -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connecting with PHP from remote server - security breach?
Hello. Somebody with the sniffer on the transit router could get enough information about MySQL credentials. Try to use SSL connection. Nikola Skoric <[EMAIL PROTECTED]> wrote: > Hello, > > I'm wondering whether there is a way to hack into my database if I'm= > connecting with PHP > from remote web server to my MySQL server with unencrypted connection? I'm= > using phpBB > forums (residing on one server and using the database on other server) which= > do not suport > SSH connections, so I'd like to know if I'm opening a security hole in my= > system this way? > -- 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: connecting with PHP from remote server - security breach?
Nikola Skoric wrote: Hello, I'm wondering whether there is a way to hack into my database if I'm connecting with PHP from remote web server to my MySQL server with unencrypted connection? I'm using phpBB forums (residing on one server and using the database on other server) which do not suport SSH connections, so I'd like to know if I'm opening a security hole in my system this way? Well, this is how I understand (and I don't profess to having a thorough understanding). There are two aspects of security in a MySQL server, Host and Password, echnically Username can't count as a third I suppose. An unencrypted connection leaves you open to packet sniffing, the connection info and data being passed through in an easy to read manner (relatively).. Through that someone could learn your Username, and hashed password. Anyone with that information and access to a host that the user is allowed to connect from will be able to login as that user. So, in this instance, you would need a very restrictive Host requirement (ideally one server, that no one else has access to). Whether this is good enough is really up to the admin. This is really a case in possibility, not really something you'd have to deal with every day. As long as it's not a shared server you're connecting from and MySQL is set up to only allow connections from that server, it seems like it should be good enough. Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting MySQL to OpenOffice
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jay Scherrer wrote: > I am having areal time trying to get my Open Office to recognize my > MySQL server. I am using the j-connector : > "Generally Available (GA) 3.0.6" > I have this installed in my path $HOME/java. > I have notified the tools->Options->Security->ClassPath. > but I still keep getting an error: > "A driver is not registered for jdbc:mysql://localhost/services" > On a fedora core1 machine. > Running Open Office 1.1, MySQL 3.23.58 > Any suggestions? 3.0.6 is quite old, you might want to consider upgrading, although it sounds more like you have a CLASSPATH problem. Did you restart OOo after you configured it? > Another question: Are the j-connectors matched for versions of MySQL > or available by releases? Covered in the docs at http://dev.mysql.com/doc/connector/j/en/index.html#id2425523 "Version Guidelines When connecting to MySQL server version 4.1 or newer, it is best to use MySQL Connector/J version 3.1, as it has full support for features in the newer versions of the server, including Unicode characters, views, stored procedures and server-side prepared statements. While Connector/J version 3.0 will connect to MySQL server, version 4.1 or newer, and implements Unicode characters and the new authorization mechanism, Connector/J 3.0 will not be updated to support new features in current and future server versions." -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Client Connectivity Office: +1 408 213 6557 www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFB2ZhbtvXNTca6JD8RAoplAKCDgnf83IoXIHJBKNkVWMCpGg+mFgCfRbIG LGg3VlV/XGtCED3kxkIj7s8= =LINb -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to MySQL using C API
Have you tried my MySQL C API Site ? I have posted some C API examples here. http://www.geocities.com/jahan.geo Aftab Jahan Subear Subedar Technologies Subedar Baag Bibir Bagicha #1 North Jatrabari Dhaka 1204 Bangladesh http://www.DhakaStockExchangeGame.com Tel: +880-2-7519050 /* Get customized T-Shirts with logo for your IT company for 12 units @ US$14 ~ US$16. Order quantity must be atleast USD$5000++. IT company to IT company. */ premal mishra wrote: I'm using MySQL version 4.0.20a on win98. Compiler is Bloodshed Dev-C++ version 4. My program compiles and links but gives a page fault error on running. I'm linking the '\mysql\lib\opt\mysqlclient.lib' file. Linker gives the warning >> ignoring duplicate section '.text' CODE: #include #include #include int main(int argc, char *argv[]) { MYSQL mysql; MYSQL *connection; connection= mysql_real_connect(&mysql, "localhost", "root", "premal", "test", 0, NULL, 0); return 0; } Regards Premal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to MySQL using C API
At 21:20 + 11/14/04, premal mishra wrote: I'm using MySQL version 4.0.20a on win98. Compiler is Bloodshed Dev-C++ version 4. My program compiles and links but gives a page fault error on running. I'm linking the '\mysql\lib\opt\mysqlclient.lib' file. Linker gives the warning >> ignoring duplicate section '.text' CODE: #include #include #include int main(int argc, char *argv[]) { MYSQL mysql; MYSQL *connection; connection= mysql_real_connect(&mysql, "localhost", "root", "premal", "test", 0, NULL, 0); return 0; } You forgot to initialize your MYSQL struct. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connecting via TCP/IP
Did you insert into the permission tables or did you use a GRANT statement? You may need to flush your permissions (FLUSH PRIVILEGES). On Sat, 9 Oct 2004 20:57:29 +0200, roland <[EMAIL PROTECTED]> wrote: > Hello again, > > refering to my previous question I forgot to mention that xxx.xxx.xxx.xxx is > an IP number. > > using mysql -h xxx.xxx.xxx.xxx -u user -puserpassword > > I would exect to be able to achieve a connection. > > The user and userpassword I must add are isnerted with grant with TO > 'user'@'%' as well as localhost. > > I can ping the server so the network connection is fine etc. > > Do I need some option to be able to supply the host as an IP address to the > mysql call? > > Thanks again. > > Regards. > > Roland > > -- > -"I have not failed. I've just found 10,000 ways that won't work." > > -(Thomas Alva Edison 1847-1931) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connecting via TCP/IP
Does the user have permission to access the server remotely, from the IP address of the client? You may have to add an entry in the user table in the mysql database specifying the IP address from which you're trying to log in. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting MySQL in Panther
chueewowee wrote: >[raisinspace:/usr/local/mysql] chueewow% Starting mysqld daemon with >databases from /usr/local/mysql/data >040612 23:32:05 mysqld ended mysqld isn't starting. See what the error log says, it will likely be in /usr/local/mysql/data --Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to db via win32 (Word or Excel)
Thomas Nyman wrote: Hi all I'm a mysql beginner. I have my database up and running and can query it via php and apache. I would like to set things up so that MSExcel and or MSWord can query the database and extract info from it. For this reason I downloaded the and installed MyODBC-standard-3.51.04-win.exe. No errors where generated upon install on my W2K machine. But when I look in Datasources ODBC under administrative tools there is no mysql-driver installed. What am I missing? Is there something else that needs to be installed? Thanks Thomas You need to configure a datasource. All you've done so far is install the drivers ( and old ones at that ). In the administrative tools, create a new System DSN. If you need help with this, have a look at my page on it: http://enthalpy.homelinux.org/MySQL/setup.html Also note that using MS Query from Word or Excel ( or anything else ) will *not* work well with MySQL. MS Query seems to be quite buggy. The only reliable way of talking to MySQL from Word or Excel is to use ADO. Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting 2 MySQL databases: how?
* Steijn, B.S. > I would like to make a connection between 2 databases in > MySQL that are on the same server. If you by "connection" mean to join tables from the two databases on the same server, you can do that. > The purpose is that a > class X in database A uses a class Y in database B by a > foreign key. Thus, the table in B can be re-used by other > databases which will make my databases more efficient. Right. > I've already thought of a solution like FOREIGN KEY c_id > REFERENCES A.customer(c_id)ON DELETE CASCADE but I think > this will not work. Is there any other solution to do this? Right, this will not work. But this is a foreign key constraint, you don't need a constraint to make a join work. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to remote server
I have the user hardware set to be able to connect to the database from any host. That is why I am so confused as to why this doesn't work. Mike > From: Andrew Boothman <[EMAIL PROTECTED]> > Date: Wed, 14 Jan 2004 01:04:36 + > To: Mike Tuller <[EMAIL PROTECTED]> > Cc: MySql List <[EMAIL PROTECTED]> > Subject: Re: Connecting to remote server > > Mike Tuller wrote: > >> I have a shell script that is supposed to connect to a remote server running >> MySql 3.23.53. It comes up with an error "ERROR 1045: Access denied for >> user: '[EMAIL PROTECTED]' (Using password: YES)" >> >> The script looks like this: >> /usr/local/mysql/bin/mysql --user=$username --password=$password >> cetechnology -e \ >> >> That makes sense to me, I don't have permissions set correctly right for the >> $username (hardware). I know the password is set correctly. >> >> Then why am I able to connect to the server in the terminal with: >> /usr/local/mysql/bin/mysql -h 204.xxx.xxx.xxx -u hardware -p cetechnology >> And then enter my password. >> >> What is the difference? > > I'm not certain about this one (I'm not totally confident with MySQL's > permission system myself). But it seems to me that assuming that the IP > that you x'd out in your second example _is_ the IP of the local server > in your first example then MySQL is going to treat them incoming > connections from two different locations. > > One is going to be a connection from [EMAIL PROTECTED] the other is a > connection from [EMAIL PROTECTED] - I think there's a good chance > that MySQL will treat these as entirely different hosts to be GRANTed on > despite the fact that they are actually the same physical machine. > > Therefore - if connections to 204.xxx.xxx.xxx work and connections to > localhost don't, you need to GRANT the right permissions to > [EMAIL PROTECTED] > > Have a look over the relevent section of the handbook for how to use GRANT > > HTH > > Andrew > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting to remote server
Mike Tuller wrote: I have a shell script that is supposed to connect to a remote server running MySql 3.23.53. It comes up with an error "ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)" The script looks like this: /usr/local/mysql/bin/mysql --user=$username --password=$password cetechnology -e \ That makes sense to me, I don't have permissions set correctly right for the $username (hardware). I know the password is set correctly. Then why am I able to connect to the server in the terminal with: /usr/local/mysql/bin/mysql -h 204.xxx.xxx.xxx -u hardware -p cetechnology And then enter my password. What is the difference? I'm not certain about this one (I'm not totally confident with MySQL's permission system myself). But it seems to me that assuming that the IP that you x'd out in your second example _is_ the IP of the local server in your first example then MySQL is going to treat them incoming connections from two different locations. One is going to be a connection from [EMAIL PROTECTED] the other is a connection from [EMAIL PROTECTED] - I think there's a good chance that MySQL will treat these as entirely different hosts to be GRANTed on despite the fact that they are actually the same physical machine. Therefore - if connections to 204.xxx.xxx.xxx work and connections to localhost don't, you need to GRANT the right permissions to [EMAIL PROTECTED] Have a look over the relevent section of the handbook for how to use GRANT HTH Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connecting to MySQL from ASP
See http://www.connectionstrings.com/ Regards, Ulises -Mensaje original- De: Ratmil Torres [mailto:[EMAIL PROTECTED] Enviado el: Miércoles 6 de Agosto de 2003 07:11 AM Para: [EMAIL PROTECTED] Asunto: Connecting to MySQL from ASP Hi. I am developing a web site using ASP. I need to connect to a MySQL Server. I am using ODBC, so how should the connection string be? I have already installed the ODBC driver for MySQL. Thanks.
RE: Connecting to MySQL from ASP
Depending on what driver of MySQL ODBC you are using. The one below I use for v3.51: strConnString = "drver={MySQL ODBC 3.51 Driver};server=SERVER_IP;database=DB_NAME;user=UID;password=PWD;OPTION=4 The one below I used in the past for v2.50: strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" Bill -Original Message- From: Ratmil Torres [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 8:11 AM To: [EMAIL PROTECTED] Subject: Connecting to MySQL from ASP Hi. I am developing a web site using ASP. I need to connect to a MySQL Server. I am using ODBC, so how should the connection string be? I have already installed the ODBC driver for MySQL. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connecting ASP
Can anybody help me? I have a Windows PC, however to test this I'm doing something like this: In Notepad I create a file test.asp Write some ASP code into the file Save the File Upload the file to my remote host that works in Linux Run my ASP script See my script working ok /*So ASP can run in a Linux Server with a Perl mod*/ At my local PC I already have worked in ASP with IIS and made the connection to the MySQL database that is also on the remote Host, this I did with MyODBC. How ever when I upload, Linux as far as I know, doesn't have DNS, I'm right? So MyODBC is no longer needed because the remote server is, as I told, a Linux sever. So what is the code for ASP to talk with my remote host once it's also in the same remote host? Thanks -Mensaje original- De: Mike Hillyer [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 20 de Junio de 2003 10:44 a.m. Para: Jorge Cornejo; [EMAIL PROTECTED] Asunto: RE: Connecting ASP You can access MySQL databases from ASP by using MyODBC (now Connector/ODBC) just like you would any other ODBC datasource. I would suggest doing google searches on MyODBC and ASP in the same search, or adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ for examples. Also subscribe to the MyODBC list at lists.mysql.com Here's a sample linked to from the MyODBC FAQ: http://www.devarticles.com/art/1/50 Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Jorge Cornejo [mailto:[EMAIL PROTECTED] > Sent: Friday, June 20, 2003 1:44 AM > To: [EMAIL PROTECTED] > Subject: Connecting ASP > > > Hi, I'm hosting a website in a Linux server. By now I'm > learning PHP and > it's amazing. How ever I need to create a online system and meanwhile > I'll to do it in ASP (which I already handle). My host gives me MySQL > and I use it ok. Now, what I'll like to do is to know how to > connect my > ASP page to a MySQL database? I can do it in my Win32 PC, but with > MyODBC. So, how can I do it? Hope somebody helps me. > > Thanks > -- 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: Connecting ASP
True, I have a Windows PC, however to test this I'm doing something like this: In Notepad I create a file test.asp Write some ASP code into the file Save the File Upload the file to my remote host that works in Linux Run my ASP script See my script working ok /*So ASP can run in a Linux Server with a Perl mod*/ At my local PC I already have worked in ASP with IIS and made the connection to the MySQL database that is also on the remote Host, this I did with MyODBC. How ever when I upload, Linux as far as I know, doesn't have DNS, I'm right? So MyODBC is no longer needed because the remote server is, as I told, a Linux sever. So what is the code for ASP to talk with my remote host once it's also in the same remote host? Thanks -Mensaje original- De: Mike Hillyer [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 20 de Junio de 2003 10:44 a.m. Para: Jorge Cornejo; [EMAIL PROTECTED] Asunto: RE: Connecting ASP You can access MySQL databases from ASP by using MyODBC (now Connector/ODBC) just like you would any other ODBC datasource. I would suggest doing google searches on MyODBC and ASP in the same search, or adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ for examples. Also subscribe to the MyODBC list at lists.mysql.com Here's a sample linked to from the MyODBC FAQ: http://www.devarticles.com/art/1/50 Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Jorge Cornejo [mailto:[EMAIL PROTECTED] > Sent: Friday, June 20, 2003 1:44 AM > To: [EMAIL PROTECTED] > Subject: Connecting ASP > > > Hi, I'm hosting a website in a Linux server. By now I'm > learning PHP and > it's amazing. How ever I need to create a online system and meanwhile > I'll to do it in ASP (which I already handle). My host gives me MySQL > and I use it ok. Now, what I'll like to do is to know how to > connect my > ASP page to a MySQL database? I can do it in my Win32 PC, but with > MyODBC. So, how can I do it? Hope somebody helps me. > > Thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting ASP
Sorry about my last comment, I check the documentation and the ODBC connector (also called MyODBC) is indeed the driver for ODBC in Windows. E! - Original Message - From: "Ernesto Silva" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 1:27 PM Subject: Re: Connecting ASP > If I recall well MyODBC is used when you want to access ODBC compliant > databases on a Linux based computer, however if you want to acces mySQL from > ASP means that you are programming on a Windows based computer, and > therefore you have ODBC client access built-in. What you need to do is to > create a System Data Source Name using (at least when I did it) the Sybase > driver. > > Best > E > > > - Original Message - > From: "Mike Hillyer" <[EMAIL PROTECTED]> > To: "Jorge Cornejo" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, June 20, 2003 10:43 AM > Subject: RE: Connecting ASP > > > You can access MySQL databases from ASP by using MyODBC (now > Connector/ODBC) just like you would any other ODBC datasource. I would > suggest doing google searches on MyODBC and ASP in the same search, or > adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ > for examples. Also subscribe to the MyODBC list at lists.mysql.com > > > Here's a sample linked to from the MyODBC FAQ: > http://www.devarticles.com/art/1/50 > > Regards, > Mike Hillyer > www.vbmysql.com > > > > -Original Message- > > From: Jorge Cornejo [mailto:[EMAIL PROTECTED] > > Sent: Friday, June 20, 2003 1:44 AM > > To: [EMAIL PROTECTED] > > Subject: Connecting ASP > > > > > > Hi, I'm hosting a website in a Linux server. By now I'm > > learning PHP and > > it's amazing. How ever I need to create a online system and meanwhile > > I'll to do it in ASP (which I already handle). My host gives me MySQL > > and I use it ok. Now, what I'll like to do is to know how to > > connect my > > ASP page to a MySQL database? I can do it in my Win32 PC, but with > > MyODBC. So, how can I do it? Hope somebody helps me. > > > > Thanks > > > > -- > 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: Connecting ASP
If I recall well MyODBC is used when you want to access ODBC compliant databases on a Linux based computer, however if you want to acces mySQL from ASP means that you are programming on a Windows based computer, and therefore you have ODBC client access built-in. What you need to do is to create a System Data Source Name using (at least when I did it) the Sybase driver. Best E - Original Message - From: "Mike Hillyer" <[EMAIL PROTECTED]> To: "Jorge Cornejo" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 10:43 AM Subject: RE: Connecting ASP You can access MySQL databases from ASP by using MyODBC (now Connector/ODBC) just like you would any other ODBC datasource. I would suggest doing google searches on MyODBC and ASP in the same search, or adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ for examples. Also subscribe to the MyODBC list at lists.mysql.com Here's a sample linked to from the MyODBC FAQ: http://www.devarticles.com/art/1/50 Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Jorge Cornejo [mailto:[EMAIL PROTECTED] > Sent: Friday, June 20, 2003 1:44 AM > To: [EMAIL PROTECTED] > Subject: Connecting ASP > > > Hi, I'm hosting a website in a Linux server. By now I'm > learning PHP and > it's amazing. How ever I need to create a online system and meanwhile > I'll to do it in ASP (which I already handle). My host gives me MySQL > and I use it ok. Now, what I'll like to do is to know how to > connect my > ASP page to a MySQL database? I can do it in my Win32 PC, but with > MyODBC. So, how can I do it? Hope somebody helps me. > > Thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connecting ASP
You can access MySQL databases from ASP by using MyODBC (now Connector/ODBC) just like you would any other ODBC datasource. I would suggest doing google searches on MyODBC and ASP in the same search, or adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ for examples. Also subscribe to the MyODBC list at lists.mysql.com Here's a sample linked to from the MyODBC FAQ: http://www.devarticles.com/art/1/50 Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Jorge Cornejo [mailto:[EMAIL PROTECTED] > Sent: Friday, June 20, 2003 1:44 AM > To: [EMAIL PROTECTED] > Subject: Connecting ASP > > > Hi, I'm hosting a website in a Linux server. By now I'm > learning PHP and > it's amazing. How ever I need to create a online system and meanwhile > I'll to do it in ASP (which I already handle). My host gives me MySQL > and I use it ok. Now, what I'll like to do is to know how to > connect my > ASP page to a MySQL database? I can do it in my Win32 PC, but with > MyODBC. So, how can I do it? Hope somebody helps me. > > Thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting WO 5.2.1 to MySQL 4.0.13 on Windows 2000?
Hi! Most probably the drivers will be fine placing the jar file under c:\jdk_dir\jre\lib\ext This way there should be no classpath problem Adding JDK_HOME and JAVA_HOME variables to your environment should help also As for the drivers, both should work, just fine =) On Sunday 01 June 2003 19:15, Kieran Kelleher wrote: > Getting EO Modeler in WO 5.2.1 to connect to MySQL 4.0.12 on Windows 2000 > is evading us somehow and giving us a dreaded connection error. It works > fine on OS X I know it is something to do with Classpaths and the fact > that EO Modeler uses a different JDBC connector than WO. > > 1) If someone out there has MySQL 4.0.XX and WO 5.2.1 Development on > Windows 2000 can you tell me what JDBC drivers you have in what folders and > what customization, if any you had to do to classpath, connection string, > etc.? > > 2) Should I use the latest Connector/J 3.0.8 with MySQL 4.0.XX or does > 2.0.14 work with MySQL 4.0.XX and which JDBC connector is best for WO > 5.2.1? > > Thanks, Kieran -- Victor Medina M Ferreteria EPA - [EMAIL PROTECTED] Geek by nature, Linux by choice! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Connecting to remote server
On Wednesday 19 February 2003 11:24, kk wrote: > I just installed mysql4.x into the home/username directory of a remote > machine. It is running good and I created a new user tester with all > privileges. > But how can i connect to the remote server running on a home directory > using a front end tool like MySQLFront. It is listening to default port > 3306. Use hostname of the remote box or IP address. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to remote server
Using the hostname or IP adders of the machine it is on. (B (BJerry (B (B- Original Message - (BFrom: "kk" <[EMAIL PROTECTED]> (BTo: "list mysql" <[EMAIL PROTECTED]> (BSent: Wednesday, February 19, 2003 9:24 AM (BSubject: Connecting to remote server (B (B (B> Hello folks (B> I just installed mysql4.x into the home/username directory of a remote (B> machine. It is running good and I created a new user tester with all (B> privileges. (B> But how can i connect to the remote server running on a home directory (Busing (B> a front end tool like MySQLFront. It is listening to default port 3306. (B> (B> Any lights? (B> (B> regards (B> (B> (B> (B> - (B> Before posting, please check: (B>http://www.mysql.com/manual.php (the manual) (B>http://lists.mysql.com/ (the list archive) (B> (B> To request this thread, e-mail <[EMAIL PROTECTED]> (B> To unsubscribe, e-mail (B<[EMAIL PROTECTED]> (B> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php (B> (B (B (B- (BBefore posting, please check: (B http://www.mysql.com/manual.php (the manual) (B http://lists.mysql.com/ (the list archive) (B (BTo request this thread, e-mail <[EMAIL PROTECTED]> (BTo unsubscribe, e-mail <[EMAIL PROTECTED]> (BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Control Center: Bug in multy/re connecting to a server.
Hello all, I suppose that there is a bug in the mysqlcc version 0.8.9-beta (Windows) and previous versions 0.8.7 and 0.8.8. The bug is repeatable in different constellations: 1.1) Connecting to a localhost server (version 3.23.39-max-nt) as user '', 1.2) Trying to open e second connection to the same server as user '' brings the application to crash 2.1) Connecting to a localhost server (version 3.23.39-max-nt) as user '', 2.2) Stopping the connection 2.3) Trying to connection to the same server as user '' brings the application to crash Here the Dr Watson output of the application exception perhaps it helps. Thanks for your help and for working on a GPL Software. Georges Schutz --- Microsoft (R) Windows NT (TM) Version 4.00 DrWtsn32 Copyright (C) 1985-1996 Microsoft Corp. All rights reserved. Application exception occurred: App: (pid=265) When: 2/5/2001 @ 10:51:16.641 Exception number: c005 (access violation) *> System Information <* Computer Name: LTI_02 User Name: schutz Number of Processors: 1 Processor Type: x86 Family 6 Model 7 Stepping 3 Windows Version: 4.0 Current Build: 1381 Service Pack: 4 Current Type: Uniprocessor Free Registered Organization: CRP Henri Tudor Registered Owner: LTI *> Task List <* 0 Idle.exe 2 System.exe 21 smss.exe 30 CSRSS.exe 35 WINLOGON.exe 41 SERVICES.exe 44 LSASS.exe 71 SPOOLSS.exe 79 amgrsrvc.exe 83 cpqalert.exe 90 CpqDFWAg.exe 93 webdmi.exe 103 LCRMS.exe 113 Mcshield.exe 120 VsTskMgr.exe 129 mysqld-nt.exe 141 RPCSS.exe 149 PSTORES.exe 152 Win32sl.exe 173 cpqdmi.exe 46 NDDEAGNT.exe 193 EXPLORER.exe 199 systray.exe 195 chkadmin.exe 201 LOADWC.exe 186 shstat.exe 212 fpdisp3.exe 216 realplay.exe 218 winampa.exe 247 tsystray.exe 252 MSOFFICE.exe 190 OSA.exe 223 nlnotes.exe 214 nweb.exe 175 naldaemn.exe 244 nhldaemn.exe 249 netscape.exe 261 CMD.exe 270 notepad.exe 265 identify.exe 167 DRWTSN32.exe 0 _Total.exe (0040 - 0040) (77f6 - 77fbc000) dll\ntdll.dbg (1000 - 1000) (0024 - 0024) (7800 - 7804) (77f0 - 77f5e000) dll\kernel32.dbg (776d - 776d8000) dll\wsock32.dbg (776b - 776c4000) dll\ws2_32.dbg (77e7 - 77ec4000) dll\user32.dbg (77ed - 77efc000) dll\gdi32.dbg (77dc - 77dff000) dll\advapi32.dbg (77e1 - 77e67000) dll\rpcrt4.dbg (776a - 776a7000) dll\ws2help.dbg (6650 - 6650) (6640 - 6640) (6620 - 6620) (6752 - 6752) (670c - 670c) State Dump for Thread Id 0x100 eax= ebx=003c8884 ecx= edx=003c0548 esi=000c edi=000c eip=10045f96 esp=0012b018 ebp=1003bee0 iopl=0 nv up ei pl zr na po nc cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs= efl=0246 function: 10045f85 85f6 testesi,esi 10045f87 7504 jnz 10045f8d 10045f89 33c0 xor eax,eax 10045f8b 5e pop esi 10045f8c c3 ret 10045f8d 53 pushebx 10045f8e 57 pushedi 10045f8f 8bfe mov edi,esi 10045f91 83c9ff or ecx,0xff 10045f94 33c0 xor eax,eax FAULT ->10045f96 f2ae repne scasb es:000c=?? 10045f98 f7d1 not ecx 10045f9a 81c17f06 add ecx,0x67f 10045fa0 51 pushecx 10045fa1 e8fa50 call1003b0a0 10045fa6 8bd8 mov ebx,eax 10045fa8 83c404 add esp,0x4 10045fab 85db testebx,ebx 10045fad 7517 jnz 10045fc6 10045faf 68ac300710 push0x100730ac 10045fb4 6810590910 push0x10095910 10045fb9 689001 push0x190 *> Stack Back Trace <* FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name 1003bee0 74c08510 244c8b14 24548b0c 4c8b5108 51520824 *> Raw Stack Dump <* 0012b018 e0 61 04 10 84 88 3c 00 - 4c ff 12 00 0a 62 04 10 .a <.Lb.. 0012b028 0c 00 00 00 4c ff 12 00 - 72 1a 52 67 4c ff 12 00 L...r.RgL... 0012b038 0c 00 00 00 48 ff 12 00 - fc 61 52 67 68 88 3c 00 HaRgh. <. 0012b048 96 88 3c 00 84 88 3c 00 - 44 ff 12 00 a8 7c 03 78 ..<...<.D |.x 0012b058 3b e1 02 00 52 02 00 00 - 00 00 00 00 52 02 00 00 ;...R...R... 0012b068 49 03 00 00 00 00 00 00 - 00 00 00 00 03 00 00 00 I... 0012b078 b8 b0 12 00 3b e1 02 00 - 60 a3 3c 00 00 00 00 00 ;...`. <. 0012b088 00 00 f0 3f 00 00 00 00 - 00 00 f0 3f 00 00 00 00 ...?...? 0012b098 00 98 82 40 00 00 00 00 - 00 50 8a 40 52 02 00 00 ...@.P. @R... 0012b0a8 49 03 00 00 00 00 00 00 - 00 00 00 00 01
RE: Connecting M. Access Forms to insert data into mysql
Have you tried Linking the MySQL tables into access? I do not know why you would still have a memo field. Also if you need it you could map the memo field in Access to a TEXT or a BLOBTEXT in MySQL. If you have access to Visual Basic it could be a bettere option. HTH JFernando ** sql ** -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: December 14, 2002 22:11 To: MySQL List Subject: Re: Connecting M. Access Forms to insert data into mysql I've installed about 12 client gui's and here's my conclusion. DBQwikEdit - has the best editor for Data Entry - nice form to add one record at a time - similar to access forms (I want this) - As far as I can tell, is the only product that has this feture http://www.mysqlstudio.com/ - nice for management - but the shit for a single user wanting to add data like access in forms. My problem is if I use Access for the front end it doesn't always out put the memo fields right. So I want a client GUI that specifically will allow one record / page. Making it very user friendly. Is using Access the way to go or is there a product I'm missing? - Original Message - From: "Grant Cooper" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Saturday, December 14, 2002 6:49 PM Subject: Connecting M. Access Forms to insert data into mysql > I am trying to find a package to insert data. And was wondering if I can use > odbc drivers to connect Access to mysql in real time? > > > - > 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting M. Access Forms to insert data into mysql
I've installed about 12 client gui's and here's my conclusion. DBQwikEdit - has the best editor for Data Entry - nice form to add one record at a time - similar to access forms (I want this) - As far as I can tell, is the only product that has this feture http://www.mysqlstudio.com/ - nice for management - but the shit for a single user wanting to add data like access in forms. My problem is if I use Access for the front end it doesn't always out put the memo fields right. So I want a client GUI that specifically will allow one record / page. Making it very user friendly. Is using Access the way to go or is there a product I'm missing? - Original Message - From: "Grant Cooper" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Saturday, December 14, 2002 6:49 PM Subject: Connecting M. Access Forms to insert data into mysql > I am trying to find a package to insert data. And was wondering if I can use > odbc drivers to connect Access to mysql in real time? > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to mysql
Your 'root' password was probably not set hence, you didn't need a password. Bhavin. - Original Message - From: "Pikasz Gyorgy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 17, 2002 7:46 AM Subject: Connecting to mysql > I'm logged in to RedHat Linux as an user and I'd like to connect to mysql > with "mysql -uroot -p" (and then must type the passw), but I could'nt in > this way, only whit this: "mysql -uroot", without passw. Why? > > picas > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting via 127.0.0.1 --SOLVED (still ironing out details)
Thanks gerald, I totally forgot about the 'identified by' part. Doh! I had to tell mysql to bind to 127.0.0.1 also, which I had tried before but without assigning the password so combining the two steps certainly worked better than one at a time. :) I got in and am now seeing a different error but I'll hammer on that awhile before I post; hopefully I'll figure it out. grant all on *.* to 'root'@'127.0.0.1' identified by 'somepassword' twig les wrote: In this episode I figured out that the problem is not stunnel or the remote connection. I simply cant log in with the command: mysql -u root -h 127.0.0.1 -p I just get a connection refused message. There should be a trick here that I'm missing if history is a lesson, but I'm a noob to mysql. Anyone know it? I can't use my other mere mortal account to log in either although both work fine if I say: mysql -u root -h localhost -p = --- If you give a man a fish, he can eat for a day If you bludgeon him to death, you can eat the fish yourself --- __ 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: Connecting via 127.0.0.1 (was Need to force Mysql to use port, NOT socket)
In the last episode (Nov 26), twig les said: > In this episode I figured out that the problem is not > stunnel or the remote connection. I simply cant log > in with the command: > > mysql -u root -h 127.0.0.1 -p > > I just get a connection refused message. There should > be a trick here that I'm missing if history is a > lesson, but I'm a noob to mysql. Anyone know it? I Make sure you don't have the skip-networking option enabled (check my.cnf and your startup scripts). If you didn't set it I can't tell you who did, though :) -- Dan Nelson [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: connecting a remote mysql-server always fails
Jochen, Saturday, November 02, 2002, 3:49:18 PM, you wrote: JK> when I try to connect to a remote computer running mysql JK> I always get the following error on the remote machine: JK> Number of processes running now: 1 JK> mysqld process hanging, pid 7262 - killed JK> 021029 21:28:13 mysqld restarted JK> /usr/local/libexec/mysqld: ready for connections JK> mysql -uroot -hxxx.xxx.xxx.xxx -p JK> When I use PHP and the according sql commands I get the same JK> results. JK> Isn't this the right command? JK> Even when I setup phpmyadmin to show me different hosts running JK> mysql I only can connect to the local machine running mysql. JK> Any tips? This problem is related to RedHat and glibc: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 Check also mailing list archives, there were a lot of similar posts. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql server from other machines
See this thread : https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 - Original Message - From: "Michael Gargiullo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 04, 2002 9:26 AM Subject: connecting to mysql server from other machines > I have a huge problem. I have several remote machines that connect to a > mysql server. On Friday, the mysql server started returning ERROR 2013: > Lost connection to MySQL server during query > > Any idea. > > > Michael Gargiullo > Network Administrator > Warp Drive Networks > 590 Valley Health Plaza > Paramus NJ 07650 > > 1-201-576-9292 x260 > 1-201-225-0007 - F > > www.warpdrive.net > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: connecting to remote server
> > >If I type the following at the command prompt, in this > example I'm using > > >username for the user name, and 66.66.66.66 for the IP address > > >(although I use real values) > > > > > >mysql -h 66.66.66.66 -u username -p > > > > > >it asks for my password then goes off and thinks for a while before > > >coming back with: > > > > > >ERROR 2003 - can't connect to MySQL server on 'ip address' (port) 1. Try to telnet to port 3306 on the server. Do you get any response at all? If it doesn't connect, either MySQL isn't running or it's not enabled remote connections. If it connects but just sits there and doesn't give you back a few bytes of junk, you have a different problem ;) 2. If you can connect and get garbage, you'll have to get on the server itself (or gain access to the server as a privileged user) to do anything further. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to remote server
Thanks for this, I may well need additional privileges, but I can't see how I can change these on the remote server without connecting first! Julia gerald_clark wrote: > Check the section of the manual covering the privilege system, > especially the "GRANT" command. > > Julia Maddocks wrote: > > >I would like to connect to MySQL database on a remote server using > >either the command prompt or MySQLFront. > > > >I have the IP address, username, password but I can't connect. > > > >MySQLfront just hangs when I enter all the information > > > >If I type the following at the command prompt, in this example I'm using > >username for the user name, and 66.66.66.66 for the IP address > >(although I use real values) > > > >mysql -h 66.66.66.66 -u username -p > > > >it asks for my password then goes off and thinks for a while before > >coming back with: > > > >ERROR 2003 - can't connect to MySQL server on 'ip address' (port) > > > >any ideas? > > > >Julia > > > > > > -- -- Julia Maddocks OOOOOOO \|/ \|/ \|/ \|/ \|/ \|/ \|/ / \ / \ / \ / \ / \ / \ / \ National Development Officer The Playwork Unit at SPRITO phone: 01865 247499 mobile: 07803 044986 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to remote server
Check the section of the manual covering the privilege system, especially the "GRANT" command. Julia Maddocks wrote: I would like to connect to MySQL database on a remote server using either the command prompt or MySQLFront. I have the IP address, username, password but I can't connect. MySQLfront just hangs when I enter all the information If I type the following at the command prompt, in this example I'm using username for the user name, and 66.66.66.66 for the IP address (although I use real values) mysql -h 66.66.66.66 -u username -p it asks for my password then goes off and thinks for a while before coming back with: ERROR 2003 - can't connect to MySQL server on 'ip address' (port) any ideas? Julia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine. -- Resolved !!
Well, after much fussing around with RPM's and searching this list, I have resolved my problem. The clue was the discussion on this list regarding the glibc bug. I upgraded to the 4.0.x RPM's that I got from the MySQL site and after I got all of the dependency problems fixed I was able to start up a MySQL/PHP setup that worked. Now both the website development works and I can use MyCC on the windows machine to administer the database. Thank you to all that considered my problem. --Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
> Thank you, but at this point I am pretty sure that my problem is not a > matter of entries in the user table. When I attempt to telnet > into port 3306 > the connection is immediately dropped. I don't really know if > any connection > is actually established at all, it may be established and immediately > dropped on simply refused from the start. There does not appear to be any > exchange of user names or passwords. I have several variations of my > username and host name in the user table. I believe that one of > them should > have worked if that was the problem. If you try and telnet to port 3306 on the machine that MySQL is running on, you will see the connection being established, then you'll see garbage, as MySQL is designed to talk to clients on that port, not humans ;) If you are seeing the connection being established, then *immediately* dropped, not refused, then the problem may be in MySQL. If the connection is refused, this is a different issue. Depending on what version of MySQL and Linux/whatever you're running, I believe there's a verified problem with MySQL and RedHat Linux - mismatch of glibc version, I think. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Thank you, but at this point I am pretty sure that my problem is not a matter of entries in the user table. When I attempt to telnet into port 3306 the connection is immediately dropped. I don't really know if any connection is actually established at all, it may be established and immediately dropped on simply refused from the start. There does not appear to be any exchange of user names or passwords. I have several variations of my username and host name in the user table. I believe that one of them should have worked if that was the problem. I believe that the problem lies in the mysql configuration. I think that it is not responding to the TCP/IP port in the way that I need it to. I have verified that the --skip-network flag is NOT set (set to OFF) so it is not that simple, but I cannot find any other flag that looks any more promising. Any other Ideas? BTW Thanks for the webmin tip, I'll give it a try. Doesn't solve all of my problem, but it may help. Thanks, --Will > -Original Message- > From: STIBS [mailto:stibs-pi@;gmx.de] > Sent: Friday, October 18, 2002 1:35 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Connecting to MySQL on Linux from a Windows machine. > > > Will, > > |||)So I still need some more ideas. > > I have to learn your problem each time again when I setup a new > machine every half a year. > > I try each time the following hostnames: > > localhost (didn't work 4u) > 127.0.0.1 (IP for localhost) > hostname (e.g. databaseserver.mydomain.com- what you called the machine) > 192.168.0.x (Your real network IP, can also be in 10.* or 172.25.*) > localhost.localdomain (results to same as hostname) > > one of them fit's ;o) ... if not I install webmin from > www.webmin.com and connect via Browser to the machine > (http://IP.ADD.RE.SS:1 - login as root). In Webmin's server > section you have a complete webbased MySQL administration. There > I make all settings and forget about it. It just works after this setup. > > STIBS > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Will, |||)So I still need some more ideas. I have to learn your problem each time again when I setup a new machine every half a year. I try each time the following hostnames: localhost (didn't work 4u) 127.0.0.1 (IP for localhost) hostname (e.g. databaseserver.mydomain.com- what you called the machine) 192.168.0.x (Your real network IP, can also be in 10.* or 172.25.*) localhost.localdomain (results to same as hostname) one of them fit's ;o) ... if not I install webmin from www.webmin.com and connect via Browser to the machine (http://IP.ADD.RE.SS:1 - login as root). In Webmin's server section you have a complete webbased MySQL administration. There I make all settings and forget about it. It just works after this setup. STIBS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Thank you to both of you who responded to my question. I have checked both of these issues and found that neither solve my situation. 1) I have (and had) both a 'will@localhost' and a 'will@"%"' entry in the user table. Is there something else that has to be done to set up the host? 2) According to 'mysqladmin variables' the --skip-networking option is set to OFF. That should mean that Olaf's suggestion is satisfied, right? So I still need some more ideas. Why am I not able to connect to MySQL from another machine? Thanks, -- Will Randy Witt wrote: >Will, > >Do you have a user/host pair for the client in the user table within the >mysql database?? It's not good enough just to have a user, the host has >to be setup too. And Olaf van Zandwijk wrote: > Hi, > > It seems to me that you can't connect to MySQL from an other machine at > all. Did you start MySQL with the --skip-networking option? Try removing > that option from the start-up scripts. > > \Olaf > In response to my Original Post: >Will Merrell wrote: > >I cannot connect from my Windows machine to the MySQL database running on >the Linux server. > >I have tried several different programs and they all report an error that >says "Lost connection to MySQL server during connection". > >I have read all the articles I can find and searched the archives as well as >I can figure out but I am still stumped. > >Here are some pertinent details. > >1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local >network at 192.168.3.2 and there are no firewalls between it and the Windows >machine. (Both are behind the same firewall, and completely open to each >other.) > >2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP). > >3) On the linux machine I can access MySQL just fine. The mysql command >works, and I can serve web pages with PHP/MySQL content. > >4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can >telnet to port 80 and get a connection although it doesn't do much there. > >5) I cannot telnet to port 3306. When I try, I get an immediate "Host >connection lost." error. > >Any ideas would be most appreciated. > > Thanks, > -- Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL on Linux from a Windows machine.
Hi, It seems to me that you can't connect to MySQL from an other machine at all. Did you start MySQL with the --skip-networking option? Try removing that option from the start-up scripts. \Olaf Will Merrell wrote: I cannot connect from my Windows machine to the MySQL database running on the Linux server. I have tried several different programs and they all report an error that says "Lost connection to MySQL server during connection". I have read all the articles I can find and searched the archives as well as I can figure out but I am still stumped. Here are some pertinent details. 1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local network at 192.168.3.2 and there are no firewalls between it and the Windows machine. (Both are behind the same firewall, and completely open to each other.) 2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP). 3) On the linux machine I can access MySQL just fine. The mysql command works, and I can serve web pages with PHP/MySQL content. 4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can telnet to port 80 and get a connection although it doesn't do much there. 5) I cannot telnet to port 3306. When I try, I get an immediate "Host connection lost." error. Any ideas would be most appreciated. Thanks, -- Will - 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 -- __XXX__ (0-0) +--ooO--(_)--Ooo---+ | | | Olaf van Zandwijk| | | | ICQ# 30231605| | PGP Public Key: http://www.vanzandwijk.net/pgp.txt | +--+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Will, Do you have a user/host pair for the client in the user table within the mysql database?? It's not good enough just to have a user, the host has to be setup too. > I cannot connect from my Windows machine to the MySQL database running on > the Linux server. > > I have tried several different programs and they all report an error that > says "Lost connection to MySQL server during connection". > > I have read all the articles I can find and searched the archives as well > as > I can figure out but I am still stumped. > > Here are some pertinent details. > > 1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local > network at 192.168.3.2 and there are no firewalls between it and the > Windows > machine. (Both are behind the same firewall, and completely open to each > other.) > > 2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP). > > 3) On the linux machine I can access MySQL just fine. The mysql command > works, and I can serve web pages with PHP/MySQL content. > > 4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can > telnet to port 80 and get a connection although it doesn't do much there. > > 5) I cannot telnet to port 3306. When I try, I get an immediate "Host > connection lost." error. > > Any ideas would be most appreciated. > > Thanks, > -- Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql via ODBC from asp.net
ops, sorry jay, i forgot this... do you install mysql in your web server? if you install it on your web server, so i think you should install the odbc driver for mysql in your web server... and after that u can use your asp script to make connection to your mysql database have a nice try :-) Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: Jay Fields <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 27, 2002 21:35 Subject: connecting to mysql via ODBC from asp.net > I've installed the windows version of mysql. I configured nothing. > This is the code I'm trying to use to access mysql from an asp web service > (in vb): > - > Public Function dbConnect() As String > Dim connString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _ > "SERVER=localhost;" & _ > "DATABASE=test;" & _ > "UID=test;" & _ > "PASSWORD=test;" & _ > "OPTION=3" > Dim MyConnection As New OdbcConnection(connString) > Try > MyConnection.Open() > MyConnection.Close() > Return connString > Catch e As Exception > Return e.Message > End Try > End Function > -- > It's returning the following exception: ERROR [IM002] [Microsoft][ODBC > Driver Manager] Data source name not found and no default driver specified > > Any ideas? > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql via ODBC from asp.net
dear jay fields, pls try this, hope this can help u... dim objconn, objrs set objconn = server.createobject("adodb.connection") set objrs = server.createobject("adodb.recordset") objconn.connectionstring="server=192.168.0.1;driver=MySQL;db=[database_name] ;uid=[user_name];pwd=[user_password]" objconn.open connectionstring dim find_text, delete_text, mxopr_cd, deletelog_text mxopr_cd = session("oprcd") find_text = "select * from tcity where tcity_code = '" &cd &"' order by tcity_code asc" delete_text = "delete from tcity where tcity_code = upper('" &cd &"');" objrs.open find_text, objconn if objrs.eof then objrs.close objconn.close set objrs = nothing set objconn = nothing response.redirect "/source/err/err_recnotexist.html" else objrs.close objconn.execute delete_text objconn.close set objrs = nothing set objconn = nothing response.redirect "/source/city/result_city_dele_ok.html" end if cheers, Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: Jay Fields <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 27, 2002 21:35 Subject: connecting to mysql via ODBC from asp.net > I've installed the windows version of mysql. I configured nothing. > This is the code I'm trying to use to access mysql from an asp web service > (in vb): > - > Public Function dbConnect() As String > Dim connString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _ > "SERVER=localhost;" & _ > "DATABASE=test;" & _ > "UID=test;" & _ > "PASSWORD=test;" & _ > "OPTION=3" > Dim MyConnection As New OdbcConnection(connString) > Try > MyConnection.Open() > MyConnection.Close() > Return connString > Catch e As Exception > Return e.Message > End Try > End Function > -- > It's returning the following exception: ERROR [IM002] [Microsoft][ODBC > Driver Manager] Data source name not found and no default driver specified > > Any ideas? > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Connecting to remote database using MyODBC
>>> AW> Have been trying to connect to a remote MySQL server from Matlab through >>> an >>> AW> ODBC connection, however the error is receive is >>> >>> AW> [TCX][MyODBC]Can't connect to MySQL server on >>> AW> '' (10060) >>> >>> AW> I have searched the docs and archives and google... But can't see any >>> answer >>> AW> to what this error means. >>> >>> Is MySQL server running? > > AW> Yup, it is running. > > AW> The connection works fine from machines within the building However > AW> remote machines cannot connect. I have also checked that the the database > is > AW> available outside the firewall. > > Did you run MySQL server with --skip-networking options? or does > skip-networking present in the my.cnf file? I always start the server with safe_mysqld. And the connections work from other machines within this building I received another message from someone to say that the 10060 error is a windows networking error Apparently the remote client is timing out as it is not getting a response or the right response from the server. Any ideas as to track down why its timing out? Thanks adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Connecting to remote database using MyODBC
Adam, Tuesday, September 24, 2002, 2:57:04 PM, you wrote: >> Subject: re: Connecting to remote database using MyODBC >> From: Egor Egorov >> Date: Fri, 20 Sep 2002 16:33:01 +0300 >> >> Adam, >> Thursday, September 19, 2002, 8:33:17 PM, you wrote: >> >> AW> Have been trying to connect to a remote MySQL server from Matlab through >> an >> AW> ODBC connection, however the error is receive is >> >> AW> [TCX][MyODBC]Can't connect to MySQL server on >> AW> '' (10060) >> >> AW> I have searched the docs and archives and google... But can't see any >> answer >> AW> to what this error means. >> >> Is MySQL server running? AW> Yup, it is running. AW> The connection works fine from machines within the building However AW> remote machines cannot connect. I have also checked that the the database is AW> available outside the firewall. Did you run MySQL server with --skip-networking options? or does skip-networking present in the my.cnf file? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to remote MySQL server.. nevermind!
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) From: "Richard Fox" <[EMAIL PROTECTED]> Date: Fri, 20 Sep 2002 11:19:37 -0400 X-Priority: 3 X-MSMail-Priority: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600. News-Group: list.mysql Reply-To: <[EMAIL PROTECTED]> Ha ha, I changed the remote permissions for the user to 'any host' and now it works. Doh! sql An evil grin is out there someplace thanking you. Something more restrictive is good prevention. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to remote MySQL server
IT is working as of yesterday. The problem was that I was granting select, insert, update privileges to the webuser and the change would not appear in the user table of the mysql database. Learn a new one yesterday. I try changing the privileges using the GRANT on an existing user and they do not change. I think this might be an error. I try this on several machines and the solution is to performa a query on the privileges on the user table of the mysql database. Nestor :-) On Fri, 20 Sep 2002 09:48:09 -0700 "Clayburn W. Juniel, III" <[EMAIL PROTECTED]> wrote: On Friday, September 20, 2002, at 08:09 AM, Richard Fox wrote: > Hi, > > I am on the machine 192.168.0 230, and I am trying to connect to the > server > on 192.168.0.10. > >> mysql -h 192.168.0.10 -u username -p > > I get back > >> ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (111) > > OK, so I tried to connect to the local server > >> mysql -h 192.168.0.230 -u username -p > > And I get back > >> ERROR 1130: Host '192.168.0.232' is not allowed to connect to this >> MySQL >> "mysql -h 192.168.0.230 -u username -p" is correct. But when you created the grant for this user, you needed to list the host as 192.168.0.230 or I think "%" might have worked. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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
Re: Connecting to remote MySQL server
On Friday, September 20, 2002, at 08:09 AM, Richard Fox wrote: > Hi, > > I am on the machine 192.168.0 230, and I am trying to connect to the > server > on 192.168.0.10. > >> mysql -h 192.168.0.10 -u username -p > > I get back > >> ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (111) > > OK, so I tried to connect to the local server > >> mysql -h 192.168.0.230 -u username -p > > And I get back > >> ERROR 1130: Host '192.168.0.232' is not allowed to connect to this >> MySQL >> "mysql -h 192.168.0.230 -u username -p" is correct. But when you created the grant for this user, you needed to list the host as 192.168.0.230 or I think "%" might have worked. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to remote MySQL server.. nevermind!
Ha ha, I changed the remote permissions for the user to 'any host' and now it works. Doh! sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Connecting to remote database using MyODBC
Adam, Thursday, September 19, 2002, 8:33:17 PM, you wrote: AW> Have been trying to connect to a remote MySQL server from Matlab through an AW> ODBC connection, however the error is receive is AW> [TCX][MyODBC]Can't connect to MySQL server on AW> '' (10060) AW> I have searched the docs and archives and google... But can't see any answer AW> to what this error means. Is MySQL server running? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to another machine with myCC
Sorry everyone, I must've forgotten to set the password with an 'identified by' clause, or I needed to grant to *.*: grant all on *.* to "fred"@"192.168.0.230" identified by 'fred'; it works now. thanks! Fred > -Original Message- > From: Alexander Burbello [mailto:[EMAIL PROTECTED]] > Sent: 29 August 2002 13:17 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Connecting to another machine with myCC > > > Hi, > > Try another tool named "My Database Manager". You can download the site > br.geocities.com/burbello. > > Greedings > > > Alexander > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to another machine with myCC
Hi, Try another tool named "My Database Manager". You can download the site br.geocities.com/burbello. Greedings Alexander - Original Message - From: "Fred Tsang" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 7:38 AM Subject: Connecting to another machine with myCC > Folks, > > I have a question about myCC. I can't connect to a local linux machine (ip > 192.168.0.232) for the life of me from my win2k box (ip 192.168.0.232) using > myCC. I've done the following: > > GRANT ALL ON test.* TO 'fred'@'192.168.0.230'; > FLUSH PRIVILEGES; > > but, in my mysql.log I still get: > > 020816 14:11:18 6 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > > My user table looks like: > mysql> select user,host from user; > ++---+ > | user | host | > ++---+ > | root | 192.168.0.230 | > | fred | 192.168.0.230 | > || lancelot | > | root | lancelot | > || localhost | > | fred | localhost | > | root | localhost | > ++---+ > > What have I done wrong? I know that mysql is up and running and listening > to port 3306. If anyone has an idea, please let me know. > > Cheers, > Fred > > > - > 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 ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.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: Connecting to MySQL using OLEDB
Tell me what you do ADODB -> OLEDB driver for ODBC -> MyODBC -> MySQL ADODB -> MyOLEDB -> MySQL or anything else? first case: check "don't promt on connect" Did you create a data source? (First thing you don't need to do...) But whatever you do with VB, MS ADODB and MySQL - you will need time. (Many time ;-) ) Chris - Original Message - From: "Darrell A. Sullivan, II" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 9:04 PM Subject: Connecting to MySQL using OLEDB > Can anyone tell me if it is possible to connect to a MySQL server running on > Linux from a Windows Visual Basic application without setting up a DSN on > the Windows computer? > > I know this can be done with MS SQL Server and I have heard it can be done > with Oracle so I am wondering if there is a connection string that will work > with MySQL. Currently everything I try brings up a DSN setup screen and this > is something that I definitely do not want. > > Thanks for any help. > > Darrell > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL using OLEDB
Hi, Search if somebody has the OLEDB driver for MySQL, and then you will be able to do it. Bye and Good Luck! --- "Darrell A. Sullivan, II" <[EMAIL PROTECTED]> wrote: > Can anyone tell me if it is possible to connect to a > MySQL server running on > Linux from a Windows Visual Basic application > without setting up a DSN on > the Windows computer? > > I know this can be done with MS SQL Server and I > have heard it can be done > with Oracle so I am wondering if there is a > connection string that will work > with MySQL. Currently everything I try brings up a > DSN setup screen and this > is something that I definitely do not want. > > Thanks for any help. > > Darrell > > > - > 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 > __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.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: Connecting to a remote database file using IP address
You don't need samba you can do it from a command line... ...mysql -u user -h hostname or ip -p Sorry for the ... Thast is not part of the command just outexpress like to make things captial where they shouldn't be. Chuck on 3/23/02 10:02 AM, Paul Gilbert at [EMAIL PROTECTED] wrote: > Hi Egor ! > > My question should have been like this ? > > I am running Apache, MySql and PHP on a Linux server. > > What I want to do is to open a MySql database that > reside on a Windows2000 computer. I don't want to > use Samba for security reason. > > In other words, every thing run's on Linux but the > database itself is on the other box wich I can > access thru it's IP address. > > I am not sure to be clear enough > > Thanks > Paul Gilbert > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to a remote MySql server
Paul, Friday, March 22, 2002, 9:51:51 PM, you wrote: PG> I am running Apache on Linux and MySql database is running PG> on a windows200 server. PG> Is there a way to connect to that database using the IP address ? Yes, when you connect to the remote MySQL server you should specify host where mysql server is running. Note: you should set privileges to connect from your host. PG> Thanks for your help! PG> Paul -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to a remote MySql server
You have written the following: Hi! I am running Apache on Linux and MySql database is running on a windows200 server. Is there a way to connect to that database using the IP address ? Thanks for your help! Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: connecting to all databases using one odbc connection..PLEASE HELP
It won't let you since Windows ODBC only lets you create ONE DSN per DATABASE -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:11 PM To: MySql Subject: connecting to all databases using one odbc connection..PLEASE HELP I asked yesterday but got no responses...anyone have any ideas how I can use one odbc connection but have access to all databases on the MSSQL server??? Thanks, Eddie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to all databases using one odbc connection..PLEASE HELP
On Tuesday 05 March 2002 11:11 am, Edward Peloke wrote: > I asked yesterday but got no responses...anyone have any ideas how I can > use one odbc connection but have access to all databases on the MSSQL > server??? I have not tried this but have you considered using the use command? Or even perhaps specifying the database name along with the table name? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to mysql Server
Thanx all, I am new to this and still learning, when I installed Linux, I did not have to do anything to PHP however I did just get the mysql rpm and install without any special configuration, Does anyone have an idea of any article that will help me recompile my php with my apache. Thanx - Original Message - From: "Jeremy 'Circ' Charles" <[EMAIL PROTECTED]> To: "Oladejo, Tokunboh" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 25, 2002 3:21 PM Subject: Re: Connecting to mysql Server > On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote: > > Does anyone have an idea why I am getting an error "Fatal error: Call to > > undefined function: mysql_connect() in /var/www" > > That's the error you get if you try to call mysql_connect() but don't have > the MySQL support compiled in to the PHP module. Rebuild the module, > making sure that you have the MySQL support enabled. Watch the output > from the configure stage, and see the PHP installation docs for more info. > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to mysql Server
On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote: > Does anyone have an idea why I am getting an error "Fatal error: Call to > undefined function: mysql_connect() in /var/www" That's the error you get if you try to call mysql_connect() but don't have the MySQL support compiled in to the PHP module. Rebuild the module, making sure that you have the MySQL support enabled. Watch the output from the configure stage, and see the PHP installation docs for more info. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySql
Put double quotes around % so that foo@"%" On Sun, 6 Jan 2002 18:31:00 -0500, Christian J Hedemark wrote: >mysql> grant all privileges on *.* to foo@% identified by 'foobar' with >grant option; >ERROR 1064: You have an error in your SQL syntax near '% identified by >'foobar' with grant option' at line 1 >mysql> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySql
> GRANT ALL PRIVILEGES ON *.* TO tue@"%" IDENTIFIED BY 'apassword' WITH GRANT OPTION; Ah but that doesn't work this is what worries me because I have a book on mysql that uses syntax like this and it generates an error on my system. This is a Red Hat 7.2 system, stock with Red Hat distributed upgrades. For example: [root@crab root]# uname -a Linux crab.ocean.yonderway.com 2.4.9-13 #1 Tue Oct 30 19:32:27 EST 2001 i686 unknown [root@crab root]# rpm -q mysql mysql-3.23.41-1 [root@crab root]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 55 to server version: 3.23.41 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant all privileges on *.* to foo@% identified by 'foobar' with grant option; ERROR 1064: You have an error in your SQL syntax near '% identified by 'foobar' with grant option' at line 1 mysql> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySql
On Mon, 7 Jan 2002 00:03:20 +0100, Tue Hellstern wrote: >I cant connect to a MySql Database form a Windows PC, I get Host ... is >not allowed to connect to this MySQL server and in the MySql manual I >found the following solution but I dont know how to do it. I am an >novice in MySql. >If anyone can make tell me the commands I will be very happy. In order to correct this problem, you or an administrator must be able to log into mysql as root. Then it is only necessary to issue a GRANT PRIVILEGES query such as: GRANT ALL PRIVILEGES ON *.* TO tue@"%" IDENTIFIED BY 'apassword' WITH GRANT OPTION; The above would permit user "tue" to log in from any location (%) with all privileges including the ability to grant privileges to others. Regards, Doug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: connecting
> It simply won't connect. It just says 'Can't connect to local MySQL > server through socket '' (111)' > > I can connect via terminal so I know MySQL is (at least semi) correctly > setup. > > Any ideas? http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to MySQL from Oracle using MyODBC driver
it wuld be nice if mysql supported sub queries ie. select A.MESSAGEID from MESSAGEDATA as A where A.MESSAGEID in (select B.MESSAGEID from MESSAGES as B where B.SUBJECT='Invitation to join the hanky panky group') _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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: connecting to mysql from different computer
Good morning Kamal, From: <[EMAIL PROTECTED]> > More so will i need to open MySQL server on my local machine before running > MySQL client to connect to the remote machine e.g. No. The service (mysqld) is strictly assigned to managing the local database(s) and to serve access to those databases to whomever it sees fit. The question of who is seen as fit is determined by the GRANT statements used earlier. The client simply connects to a MySQL server someplace. That server might be local, or it might be on the other side of the planet. --- Rodney Broom Programmer: Desert.Net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
[EMAIL PROTECTED] writes: > More so will i need to open MySQL server on my local machine before running > MySQL client to connect to the remote machine e.g. A client is a client and a server is a server. The point of separating the two is that you can then run the client somewhere and and the server elsewhere. So no, you do not need to have mysqld running locally to connect to a remote server. An decent analogy would be that you do not need to have a web server running to surf the web. I'd recommend you not to run anything that you do not need. Each additional server or daemon is a potential security hole. This is certainly true for mysqld, where the default privileges are very permissive. //C - pissed off at procter & gamble for screwing up his shampoo. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
>I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: > >- Format: >grant all privileges on databaseName.tableName >to 'userName'@'hostName' >identified by 'somePassword'; > > >- Example: >grant all privileges on myDB.* >to 'clyde'@'coolPlace.org' >identified by 'secretPass'; > >Then you'll need to reload the access privileges. It can be done at the command line like this: > >% mysqladmin -u rootUserName reload > >Remember, you may need to add the -p switch and suply a password for this command. > >Is this enough info? One more important question, if these privileges are now granted, will it then be possible for me to connect from MySQL client at the local machine to MySQL server at the remote machine? More so will i need to open MySQL server on my local machine before running MySQL client to connect to the remote machine e.g. c:>mysql\bin\mysqld c:>mysql\bin mysql -h coolPlace.org -u clyde -psecretPass Or I will just run the MySQL client to connect to remote machine without neccessarily running MySQL server at the local machine c:>mysql\bin mysql -h coolPlace.org -u clyde -psecretPass Thanks for giving me relieve. -kamal. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
From: <[EMAIL PROTECTED]> > I have a similar problem... Just to be sure, it's helpful if you could send us the message that your getting when you see the connection problem, but this sounds like the same thing. > Can this sovle my sleeplessness problem? Probably. Anytime I can't sleep, I just look for some sound advice. If that doesn't work, then I like to try some warm milk and a couple of my wife's chocolate chip cookies. --- Rodney Broom Programmer: Desert.Net Spam Filter: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
At 03:23 PM 12/10/01 -0700, you wrote: >From: Dan <[EMAIL PROTECTED]> > >> I can connect... on the same computer >> ...different machine it won't work. I have a similar problem but let explain better may be i don't get what Dan was talking about. From my local computer i can use LOAD command to store values into tables on the same machine. Now I want to be able to do the samething on mysql server at the remote site if i can successful connected to Mysql server on the remote machine. Can this sovle my sleeplessness problem? if not is there any assist you can render to me. Any support will be highly appreciated. Thanks in anticipation for your reply. Best regards. Kamal >I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: > >- Format: >grant all privileges on databaseName.tableName >to 'userName'@'hostName' >identified by 'somePassword'; > > >- Example: >grant all privileges on myDB.* >to 'clyde'@'coolPlace.org' >identified by 'secretPass'; > >Then you'll need to reload the access privileges. It can be done at the command line like this: > >% mysqladmin -u rootUserName reload > >Remember, you may need to add the -p switch and suply a password for this command. > >Is this enough info? > >--- >Rodney Broom >Programmer: Desert.Net > > >Spam filter: sql database > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
From: Dan <[EMAIL PROTECTED]> > I can connect... on the same computer > ...different machine it won't work. I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: - Format: grant all privileges on databaseName.tableName to 'userName'@'hostName' identified by 'somePassword'; - Example: grant all privileges on myDB.* to 'clyde'@'coolPlace.org' identified by 'secretPass'; Then you'll need to reload the access privileges. It can be done at the command line like this: % mysqladmin -u rootUserName reload Remember, you may need to add the -p switch and suply a password for this command. Is this enough info? --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to mysql server in a remote site and using LOAD command
Make sure you have permissions to connect to the remote site from your current server or host. Permissions need to be set for that user to connect from your server host - Original Message - From: "Hamzat Kamal" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 03, 2001 8:27 AM Subject: Connecting to mysql server in a remote site and using LOAD command > Dear All, > > I have Mysql server installed at remote site which i need to connect to. > > I have tried this from my local computer but didn't work; > > c:\mysql\bin>mysql -h myhost -u myusername -pmypassword > > I will also like to use LOAD command to load a text file from my local > computer to the database on this mysql server at the remote site. > > I have been able to achieve both actions from my local machine. > > I am using win 98, Mysql 3.23 > > All supports to get these done will be appreciated. > > Thanks to you all. > > kamal. > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to a remote database.
Thanks for the help it seemed to have worked. But now I get a different error. I am getting to the server but I am getting error: >From Database server Found old style password for user 'webuser'. Ignoring user. (You may want to restart using --old-protocol) ** The web server is saying:: DBI->connect(database=cars;host=server1.domain.com) failed: Access denied for user2: 'server1.domain.com' (Using password: YES) at /www I have upgraded to DBI.pm to 1.18 on the web server am I missing something. Jason -Original Message- From: Bill Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 1:10 PM To: Jason Whitlow Cc: '[EMAIL PROTECTED]' Subject: Re: Connecting to a remote database. Jason Whitlow wrote: > Sorry for for the dumb question buuut. > > I have been connecting to a database on my localhost using perl's DBI.pm > > This is how I currently do it. > > use DBI; > $data = "databasename"; > $driver = "DBI:mysql"; > my $dbh = DBI->connect("$driver:database=$data", "username", "password") > or die "Can't connect"; > > How would I connect to the same database on a remote server. >From the top of 'man DBD::mysql': use DBI; $driver = "mysql"; $dsn = "DBI:$driver:database=$database;host=$hostname;port=$port"; You can also do $dbh= DBI->connect( "dbi:mysql:$db;host=$host", ...); b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to a remote database.
Jason Whitlow wrote: > Sorry for for the dumb question buuut. > > I have been connecting to a database on my localhost using perl's DBI.pm > > This is how I currently do it. > > use DBI; > $data = "databasename"; > $driver = "DBI:mysql"; > my $dbh = DBI->connect("$driver:database=$data", "username", "password") > or die "Can't connect"; > > How would I connect to the same database on a remote server. >From the top of 'man DBD::mysql': use DBI; $driver = "mysql"; $dsn = "DBI:$driver:database=$database;host=$hostname;port=$port"; You can also do $dbh= DBI->connect( "dbi:mysql:$db;host=$host", ...); b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting by knowing someone's "scrambled" password?
Hi! On Aug 10, Carsten H. Pedersen wrote: > > http://www.mysql.com/doc/U/s/User_names.html > > says: > > >>> > > MySQL encrypts passwords using a different algorithm than the one used > > during the Unix login process. See the descriptions of the PASSWORD() and > > ENCRYPT() functions in section 6.4.12 Miscellaneous Functions. Note > > that even if the password is stored 'scrambled', and knowing your > > 'scrambled' > > password is enough to be able to connect to the MySQL server! > > >>> > > > > How is that possible? Even if you do know someone's scrambled password, > > when you connect to the MySQL server pretending to be that user, it will > > ask you for their non-scrambled password. After you type it in, > > the server > > will scramble it and check that the scrambled value matches the scrambled > > value stored in the database -- but you can't intercept that part of the > > process and insert the "known scrambled" password to be checked. > > > > -Bennett > > The manual certainly *does* need a clean-up on this. > > --- > 4.3.6 Setting Up Passwords: > ...When the user jeffrey attempts to connect to the > server using this password, the mysql client encrypts > it with PASSWORD() and sends the result to the server. > The server compares the value in the user table... > --- > > Which would explain why knowing the encrypted password > is enough to gain access to the server (you would, of > course, need to write your own version of the mysql > where you skip the PASSWORD call). > > However, > > --- > 4.2.8 Access Control, Stage 1: Connection Verification > ...The encrypted password is then used when the client/server > is checking if the password is correct (This is done without > the encrypted password ever traveling over the connection.) ... > --- > > These two statements surely contradict each other. > > / Carsten > -- > Carsten H. Pedersen > keeper and maintainer of the bitbybit.dk MySQL FAQ > http://www.bitbybit.dk/mysqlfaq Thanks, for pointing this out. Of course, the second statement is correct - MySQL authentification protocol is designed to never send anything reusable (e.g. password) over the wire. We will fix the manual. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: connecting by knowing someone's "scrambled" password?
> http://www.mysql.com/doc/U/s/User_names.html > says: > >>> > MySQL encrypts passwords using a different algorithm than the one used > during the Unix login process. See the descriptions of the PASSWORD() and > ENCRYPT() functions in section 6.4.12 Miscellaneous Functions. Note > that even if the password is stored 'scrambled', and knowing your > 'scrambled' > password is enough to be able to connect to the MySQL server! > >>> > > How is that possible? Even if you do know someone's scrambled password, > when you connect to the MySQL server pretending to be that user, it will > ask you for their non-scrambled password. After you type it in, > the server > will scramble it and check that the scrambled value matches the scrambled > value stored in the database -- but you can't intercept that part of the > process and insert the "known scrambled" password to be checked. > > -Bennett The manual certainly *does* need a clean-up on this. --- 4.3.6 Setting Up Passwords: ...When the user jeffrey attempts to connect to the server using this password, the mysql client encrypts it with PASSWORD() and sends the result to the server. The server compares the value in the user table... --- Which would explain why knowing the encrypted password is enough to gain access to the server (you would, of course, need to write your own version of the mysql where you skip the PASSWORD call). However, --- 4.2.8 Access Control, Stage 1: Connection Verification ...The encrypted password is then used when the client/server is checking if the password is correct (This is done without the encrypted password ever traveling over the connection.) ... --- These two statements surely contradict each other. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: connecting by knowing someone's "scrambled" password?
> How is that possible? Even if you do know someone's scrambled password, > when you connect to the MySQL server pretending to be that user, it will > ask you for their non-scrambled password. After you type it in, > the server will scramble it and check that the scrambled value matches > the scrambled value stored in the database -- but you can't intercept > that part of the process and insert the "known scrambled" password to > be checked. It's called bruteforcing... knowing the scrambled password, you can encrypt every possible password and compare it to the scrambled password to find the original password. Either that or the scrambled password is encrypted by the client then sent for comparison, but I doubt it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting MySQL over a Novell network
>PC there communicates through Novell 4.11 server, some use >Windows protocol. I've used the same installation, and more, >one from Apache serverer PC can be connected alternatively to one >or to second network. In the first, it works, as I've mentioned earlier, >in the second the server sees himself but on one from other PC's. >Is here anybody, who can give my advise, in which direction should I go? >Any suggestions are greatly appreciated! >With best regards This isn't a MySQL issue.. Think you need to check the protocol running.. and check it's settings.. routing issues.. and more fun.. If you need to install TCP/IP on a Netware server you should checkout www.novell.com for packages and patches.. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql using tcp/ip
Richard Gibbs wrote: > sorry if this is the wrong list > > I am a beginner user of mysql, but a few pl I know are very active in > scripting using mirc, especially gaming using tcp/ip connections to game > servers to find out various details. > > I would like to know how/if I can connect to a mysql database using tcp/ip > as mirc allows connections of this type. > > if anyone has a few hints and/or webpages I can look at to get a good idea > of where to go with this it would help immensely. > > be warned, I am a beginner, but my friends are not so any help at all would > be appreciated. No problem about being beginner. We all be beginners sometime. About question: it is pretty senseless. mIRC is IRC client software for Wnidows as much I know. I do not care if has some kind of scripting made on it but there is still no relationship with MySQL database. Yes MySQL uses TCP/IP but you are trying to make something incompatible by idea.If you need database, forget about mIRC. If you need IRC then it is not related to database I believe. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql securely via network
James Gosnell wrote: > If I connect to mysql: > mysql -u username -p wherever.net > > is that encrypted at all? No and never will be default behaviour to encrypt communication as this reduces performance. > and if I make a network program via the C API, would that be encrypted > too? Thanks No. In MySQL 4.0 it will be standard feature to have SSL protected connections when asked to use them. Also there is a different tunneling solutions for them. Search for words "CIPE" or "SSL tunnel" with search engines and you get right to the point. Tõnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL w/VB
I am using a DLL called MYVBQL.dll which is also on the mysql web site and it works like a dream. Don't need no ODBC driver, and all that stuff. Similar to ADO but also quite different. Some bugs but if you stick to SQL statements to insert/update/delete info it works like a dream and is very fast. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > ]On Behalf > Of [EMAIL PROTECTED] > Sent: 29 June 2001 10:41 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Connecting to MySQL w/VB > > > Give MyODBC a try, its on the mysql.com site > and its given my no problems at all in vb. > > Sean > > -Original Message- > From: Robert Skinner [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 29, 2001 3:45 AM > To: [EMAIL PROTECTED] > Subject: Connecting to MySQL w/VB > > > I am trying to connect to MySQL using a connection string > using VB6. The > read part is great but I don't seem to be able to add > records. Can anyone > steer me in the right direction? > > [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 > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL w/VB
Give MyODBC a try, its on the mysql.com site and its given my no problems at all in vb. Sean -Original Message- From: Robert Skinner [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 3:45 AM To: [EMAIL PROTECTED] Subject: Connecting to MySQL w/VB I am trying to connect to MySQL using a connection string using VB6. The read part is great but I don't seem to be able to add records. Can anyone steer me in the right direction? [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