Connecting to MySQL Community Edition from Informatica Powercenter 9.5.1 running on AIX
Is it possible to MySQL Community Edition (as target) from Informatica Powercenter 9.5.1 running on AIX? If so, what is ODBC driver should we use?
Slow connecting to MySQL from Windows App
Hi, I am hoping someone here can help me. I have an Ubuntu 8.04 server that has worked FINE for months. The other day, the client rebooted it. They shut it down properly and then later started it up again. (The server was not experiencing any problems when they did it, there were other reasons). Ever since then, when I try to connect to the MySQL server it is running dead slow. As in 20-30 seconds to get a connect. By the way, I just tried it with MySQL Administrator and it has problems connecting as well so it is not the connector. The server is located internally on a gigabit network. Any assistance would be greatly appreciated... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Slow connecting to MySQL from Windows App
please follow my earlier suggestion and place long_query_time=NumberOfSecs min_examined_row_limit=MinNumberOfRowsToExamine in my.cnf or my.ini start mysqld --log-slow-queries[=file_name] documentation available at http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html Shalom Martin Gainty __ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de déni et de confidentialité This message is confidential. If you should not be the intended receiver, then we ask politely to report. Each unauthorized forwarding or manufacturing of a copy is inadmissible. This message serves only for the exchange of information and has no legal binding effect. Due to the easy manipulation of emails we cannot take responsibility over the the contents. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Date: Tue, 5 May 2009 08:43:51 -0400 From: gro...@bcconsultingservices.com To: mysql@lists.mysql.com Subject: Slow connecting to MySQL from Windows App Hi, I am hoping someone here can help me. I have an Ubuntu 8.04 server that has worked FINE for months. The other day, the client rebooted it. They shut it down properly and then later started it up again. (The server was not experiencing any problems when they did it, there were other reasons). Ever since then, when I try to connect to the MySQL server it is running dead slow. As in 20-30 seconds to get a connect. By the way, I just tried it with MySQL Administrator and it has problems connecting as well so it is not the connector. The server is located internally on a gigabit network. Any assistance would be greatly appreciated... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com _ Hotmail® goes with you. http://windowslive.com/Tutorial/Hotmail/Mobile?ocid=TXT_TAGLM_WL_HM_Tutorial_Mobile1_052009
Slowness connecting to MySQL
Please forgive the crossposting between the two groups. The problem I am having SEEMS to be a mysql and not a MyODBC problem but I cannot be sure so I am opening this question to both lists. If I have violated protocol in doing so, please accept my apologies. I have MySQL running under Ubuntu Server 8.04. The server is on a network and is used for a desktop application programmed with Visual FoxPro running on windows workstations. Everything worked PERFECTLY until just recently. Then the client had to reboot the server. There was nothing wrong with the server, he shut it down because he thought he would have to move the box. He did NOT move the box, as it turns out, and he turned the box back on. Ever since then, connecting to the box with the app has been S L O W. Like 10-20 seconds slow. Since nothing has changed, I cannot figure out what the heck is going on. This is a small application with fewer than 5 users. The box is used ONLY for mysql (and WebMin). Any ideas on how to debug this would be GREATLY appreciated. The VERSION variable returns 5.0.51a-3ubuntu5.4 Thank you in advance and my apologies again if I have violated protocol. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Slowness connecting to MySQL
It could be slow reverse DNS lookups. Make sure the hostname/IP of the client are in the server's host file. Or try connecting to the server using an IP address instead of hostname. Andrew -Original Message- From: Menachem Bazian [mailto:gro...@bcconsultingservices.com] Sent: 04 May 2009 16:07 To: myo...@lists.mysql.com; mysql@lists.mysql.com Subject: Slowness connecting to MySQL Please forgive the crossposting between the two groups. The problem I am having SEEMS to be a mysql and not a MyODBC problem but I cannot be sure so I am opening this question to both lists. If I have violated protocol in doing so, please accept my apologies. I have MySQL running under Ubuntu Server 8.04. The server is on a network and is used for a desktop application programmed with Visual FoxPro running on windows workstations. Everything worked PERFECTLY until just recently. Then the client had to reboot the server. There was nothing wrong with the server, he shut it down because he thought he would have to move the box. He did NOT move the box, as it turns out, and he turned the box back on. Ever since then, connecting to the box with the app has been S L O W. Like 10-20 seconds slow. Since nothing has changed, I cannot figure out what the heck is going on. This is a small application with fewer than 5 users. The box is used ONLY for mysql (and WebMin). Any ideas on how to debug this would be GREATLY appreciated. The VERSION variable returns 5.0.51a-3ubuntu5.4 Thank you in advance and my apologies again if I have violated protocol. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=andrew.braithwa...@lovefilm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Connecting to mysql 4.1 server with a 4.0 client
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 -- 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 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]
Problem connecting to MySQL 4.0.23 with MySQL Administrator 1.0.21 (Mac OS X)
Dear all, I have a MySQL 4.0.23 server running on an OpenBSD machine. When I try to connect to it with MySQL Administrator 1.0.21 from my Mac OS X machine, I get this error: Connection error Could not connect to MySQL instance at hostname. Error: unknown system variable 'sql_mode' (code 1193) I can connect with MySQL administrator 1.0.9 beta. I'm guessing the administrator 1.0.21 is explicitly asking for a 4.1 specific server variable and the 4.0 server doesn't understand it. Is there any way around this, or is there a fix planned? Thanks in advance Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
connecting to mysql 3.23.49 very slow
I don't know if it's the right list to post it but here it goes: We've been trying to connect to a 3.23.49 server with several libmysql.dll's We found out that the 3.23.x and the 4.0.x dll's connect very slow (20 seconds). And the 4.1.x dll's connect in like 2 seconds. Does anyone have a clue on why that happens? met vriendelijke groet/with regards, Bas J. Brey Multimedia Developer Magenta MultiMedia Tools B.V. Lasondersingel 56 7514 BS Enschede The Netherlands Tel +31 53 43 34 201 Visit us at www.MagentaMMT.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem connecting to MySQL 4.1.7 running on another machine
I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot connect remotely from a Mac OSX machine running Navicat or a Win XP machine running MySQL Admin. I can ping the machine with no problem and have opened the firewall for the 3306 port. The error I receive is: Could not connect to the specified instance. MySQL Error Number 2003 Can't connect to MySQL server on 192.168.0.11(10060) Thanks. Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem connecting to MySQL 4.1.7 running on another machine
Quoting Kevin Barry [EMAIL PROTECTED]: I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot connect remotely from a Mac OSX machine running Navicat or a Win XP machine running MySQL Admin. I can ping the machine with no problem and have opened the firewall for the 3306 port. The error I receive is: Could not connect to the specified instance. MySQL Error Number 2003 Can't connect to MySQL server on 192.168.0.11(10060) Thanks. Kevin Kevin! Did you add the appropriate entry to your hosts table? I'm not sure how to do it, but that's the idea Richard R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net Premium Quality Web Hosting http://hosting.xend.net rw AT xend.net Net Binder http://netbinder.net 310-943-6498 602-288-5340 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem connecting to MySQL 4.1.7 running on another machine
Kevin, Could be a few things causing problems. Lets look at the most obvious. First, make sure you can login locally as root. Second, MySQL authenticates based on user, password, and host. If you have a know user with the right password coming from an unknown host MySQL will bounce you. http://dev.mysql.com/doc/mysql/en/Connection_access.html In the MySQL database, there is a table named `user`. In that table is a list of authorized users to the database server. Check the table and make sure you're accounts are in their and you have the host set correctly. -- Execute this with a user that has read access to MySQL database. SELECT u.user, u.host FROM mysql.user u; If you see something like this, then you know user `Bigkevin` can only connect from the db-server's box. ++---+ | user | host | ++---+ | BigKevin | localhost | ++---+ If you see something like this, then you know user `BigKevin` can connect from _ANY_ machine. ++---+ | user | host | ++---+ | BigKevin | % | ++---+ Hope this helps some. Cheers, Adam Kevin Barry I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot connect remotely from a Mac OSX machine running Navicat or a Win XP machine running MySQL Admin. I can ping the machine with no problem and have opened the firewall for the 3306 port. The error I receive is: Could not connect to the specified instance. MySQL Error Number 2003 Can't connect to MySQL server on 192.168.0.11(10060) Thanks. Kevin Regards, Adam -- 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 config-win.h #include mysql.h #include stdio.h 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]
Connecting to MySQL using C API
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 config-win.h #include mysql.h #include stdio.h 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.
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 config-win.h #include mysql.h #include stdio.h 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: Problem connecting to MySQL server
Hello. See: http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html Schalk Neethling [EMAIL PROTECTED] wrote: Hey there I have upgraded the MySQL server on my Windows machine to 4.0.22 following the docs at: http://dev.mysql.com/doc/mysql/en/Windows_upgrading.html When I start the server using NET START MySQL the server starts with no problems and the following is written to my error log: 041108 14:24:28 InnoDB: Started MySQL: ready for connections. Version: '4.0.22-debug' socket: '' port: 3306 Source distribution When I stop the server using NET STOP MySQL the server stops without any problems and the following is written to the log: 041108 14:25:43 MySQL: Normal shutdown 041108 14:25:43 InnoDB: Starting shutdown... 041108 14:25:46 InnoDB: Shutdown completed 041108 14:25:46 MySQL: Shutdown Complete Now, here is the problem. When I have started the MySQL server and it is running I then go to c:\mysql\bin\ and execute the command: mysql The following message is then returned: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Any ideas why this is happening? Any help on pointers to where I may find more answers will be appreciated. Thanks! -- 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]
Problem connecting to MySQL server
Hey there I have upgraded the MySQL server on my Windows machine to 4.0.22 following the docs at: http://dev.mysql.com/doc/mysql/en/Windows_upgrading.html When I start the server using NET START MySQL the server starts with no problems and the following is written to my error log: 041108 14:24:28 InnoDB: Started MySQL: ready for connections. Version: '4.0.22-debug' socket: '' port: 3306 Source distribution When I stop the server using NET STOP MySQL the server stops without any problems and the following is written to the log: 041108 14:25:43 MySQL: Normal shutdown 041108 14:25:43 InnoDB: Starting shutdown... 041108 14:25:46 InnoDB: Shutdown completed 041108 14:25:46 MySQL: Shutdown Complete Now, here is the problem. When I have started the MySQL server and it is running I then go to c:\mysql\bin\ and execute the command: mysql The following message is then returned: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Any ideas why this is happening? Any help on pointers to where I may find more answers will be appreciated. Thanks! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error connecting to mysql db
G'Day All, When I try to connect to my mysql/php through Apache I get the following error: Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/taxes/db_mysql.php on line 99 Database error: pconnect(localhost:3306, root, $DBPassword) failed. MySQL Error: 0 () Session halted. Can someone please help me to determine what's wrong here. Thanks very much Ferg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error connecting to mysql db
This is usually one of two things... 1) MySQL is not running on that machine 2) Permissions for accessing the socket via PHP. More likely this first, but try both. Check you [HOST].err file to be sure. J.R. -Original Message- From: Ferguson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 11:57 AM To: [EMAIL PROTECTED] Subject: Error connecting to mysql db G'Day All, When I try to connect to my mysql/php through Apache I get the following error: Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/taxes/db_mysql.php on line 99 Database error: pconnect(localhost:3306, root, $DBPassword) failed. MySQL Error: 0 () Session halted. Can someone please help me to determine what's wrong here. Thanks very much Ferg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] smime.p7s Description: S/MIME cryptographic signature
RE: Error connecting to mysql db
J.R. Bullington replied but when I click on the message I get a popup box that says: Can't open this item. Your Digital ID name can not be found by the underlying security system. J.R. please send me another reply. Thanks -Original Message- From: Ferguson, Michael Sent: Monday, October 25, 2004 11:57 AM To: [EMAIL PROTECTED] Subject: Error connecting to mysql db G'Day All, When I try to connect to my mysql/php through Apache I get the following error: Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/taxes/db_mysql.php on line 99 Database error: pconnect(localhost:3306, root, $DBPassword) failed. MySQL Error: 0 () Session halted. Can someone please help me to determine what's wrong here. Thanks very much Ferg -- 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]
FW: Error connecting to mysql db
This is usually one of two things... 1) MySQL is not running on that machine 2) Permissions for accessing the socket via PHP. More likely this first, but try both. Check you [HOST].err file to be sure. J.R. -Original Message- From: Ferguson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 11:57 AM To: [EMAIL PROTECTED] Subject: Error connecting to mysql db G'Day All, When I try to connect to my mysql/php through Apache I get the following error: Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/taxes/db_mysql.php on line 99 Database error: pconnect(localhost:3306, root, $DBPassword) failed. MySQL Error: 0 () Session halted. Can someone please help me to determine what's wrong here. Thanks very much Ferg -- 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: Error connecting to mysql db
Thanks very much. I appreciate it. -Original Message- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 12:46 PM To: [EMAIL PROTECTED] Subject: FW: Error connecting to mysql db This is usually one of two things... 1) MySQL is not running on that machine 2) Permissions for accessing the socket via PHP. More likely this first, but try both. Check you [HOST].err file to be sure. J.R. -Original Message- From: Ferguson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 11:57 AM To: [EMAIL PROTECTED] Subject: Error connecting to mysql db G'Day All, When I try to connect to my mysql/php through Apache I get the following error: Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/taxes/db_mysql.php on line 99 Database error: pconnect(localhost:3306, root, $DBPassword) failed. MySQL Error: 0 () Session halted. Can someone please help me to determine what's wrong here. Thanks very much Ferg -- 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]
Connecting on MySQL Sockets Using Connector/J
Hello guys... I trying to connect on LOCAL MYSQL SOCKET in /kiko_SMS/kart/mysql.sock using Connector/J but the sintax of URL only accept HOSTNAMES... how connect on Local MySQL Sockets using Connector/J My system is a Debian Box 3.1 using kernel 2.6.7 and Java ;) Tnks.. MySQL,Query,helll - ++ Dyego Souza Dantas Leal ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 1647350 $ look into my eyes Phone : +55 041 2106-1212 look: cannot open my eyes Fax : +55 041 296 -6640 - Reply: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help With Remotely Connecting to MySQL Database
I need some help connecting to my database remotely, I would really appreciate any input. Setup: MySQL Server: OS: Linux - Debian MySQL version: 4.0.18 Internal IP: 192.168.1.101 Remote Access PC: OS: Windows XP MySQL: 4.0.20 Internal IP: 192.168.1.100 I am trying to connect from 192.168.1.100 to 192.168.1.101. The computers are connected via a Linksys router. I type the following line from a cmd prompt in Windows XP: mysql -h 192.168.1.101 -u user -p and get the following error: ERROR 2003: Can't connect to MySQL server on '192.168.1.101' (10061) Mysqld is running on the MySQL server. From the server I can localy access the database by typing: mysql -u user at the bash, without any problems. I have done the following for 'user' GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.1.100' WITH GRANT OPTIONS; This was successfully taken into the user table of the mysql db. (select * from user, shows the entry). I have also tried : GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTIONS; I am not sure where to go from here. I get a feeling there hosts.allow file in /etc/ on the linux machine may have something to do with it. I have addded the following in that file: mysqld : ALL : ALLOW mysqld-max : ALL : ALLOW I did not change the default port of 3306. I assume mysqld automatically opens up the port and begins listening for connections right? Thanks for any help!! Fred Aswad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help With Remotely Connecting to MySQL Database
Is each machine behind a firewall or are both machines behind the same firewall? If the firewalls are different you will need to connect to the firewall address and not the lan address. You will also need to ensure that Port 3306 is open in the firewall. -Original Message- From: Fred Aswad To: [EMAIL PROTECTED] Sent: 6/2/04 12:45 PM Subject: Help With Remotely Connecting to MySQL Database I need some help connecting to my database remotely, I would really appreciate any input. Setup: MySQL Server: OS: Linux - Debian MySQL version: 4.0.18 Internal IP: 192.168.1.101 Remote Access PC: OS: Windows XP MySQL: 4.0.20 Internal IP: 192.168.1.100 I am trying to connect from 192.168.1.100 to 192.168.1.101. The computers are connected via a Linksys router. I type the following line from a cmd prompt in Windows XP: mysql -h 192.168.1.101 -u user -p and get the following error: ERROR 2003: Can't connect to MySQL server on '192.168.1.101' (10061) Mysqld is running on the MySQL server. From the server I can localy access the database by typing: mysql -u user at the bash, without any problems. I have done the following for 'user' GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.1.100' WITH GRANT OPTIONS; This was successfully taken into the user table of the mysql db. (select * from user, shows the entry). I have also tried : GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTIONS; I am not sure where to go from here. I get a feeling there hosts.allow file in /etc/ on the linux machine may have something to do with it. I have addded the following in that file: mysqld : ALL : ALLOW mysqld-max : ALL : ALLOW I did not change the default port of 3306. I assume mysqld automatically opens up the port and begins listening for connections right? Thanks for any help!! Fred Aswad -- 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: Help With Remotely Connecting to MySQL Database
Fred Aswad wrote: I need some help connecting to my database remotely, I would really appreciate any input. Setup: MySQL Server: OS: Linux - Debian MySQL version: 4.0.18 Internal IP: 192.168.1.101 Remote Access PC: OS: Windows XP MySQL: 4.0.20 Internal IP: 192.168.1.100 I am trying to connect from 192.168.1.100 to 192.168.1.101. The computers are connected via a Linksys router. I type the following line from a cmd prompt in Windows XP: mysql -h 192.168.1.101 -u user -p You are asking for a password. and get the following error: ERROR 2003: Can't connect to MySQL server on '192.168.1.101' (10061) Mysqld is running on the MySQL server. From the server I can localy access the database by typing: mysql -u user at the bash, without any problems. I have done the following for 'user' GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.1.100' WITH GRANT OPTIONS; You forgot to set the password. You forgot identified by 'thepassword' This was successfully taken into the user table of the mysql db. (select * from user, shows the entry). I have also tried : GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTIONS; I am not sure where to go from here. I get a feeling there hosts.allow file in /etc/ on the linux machine may have something to do with it. I have addded the following in that file: mysqld : ALL : ALLOW mysqld-max : ALL : ALLOW I did not change the default port of 3306. I assume mysqld automatically opens up the port and begins listening for connections right? Thanks for any help!! Fred Aswad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connecting 2 MySQL databases: how?
Hi, I would like to make a connection between 2 databases in MySQL that are on the same server. 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. 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? I hope I was clear enough... Greetings, Bart -- 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: Problems connecting to MySql on WebSphere 5.1
Mark, Did you ever have any luck looking into this? I have found that if I explicitly set the user and password parameters for each database in WebSphere (rather than using a container managed JAAS authentication entry), I still get the error listed below, however the database connections will work. But it seems that their is a problem with connection pooling, whereby the connections become stale over time and cause an exception to be thrown next time they are accessed. None of this was a problem in 5.0, so I've also asked IBM if there is something they might have changed in the 5.1 upgrade. Tom --- Mark Matthews [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom O'Neil wrote: I've been running an application on WebSphere 5.0 (Linux) that uses the MySql Connector/J 3.10 to connect to a MySql-max 4.0.15 database (also on Linux). All was working fine, until I recently installed WebSphere 5.1. Now my datasources (configured exactly as before) no longer work - WebSphere seems unable to find them. When I start the server, I get the following error when my application starts: [2/19/04 16:04:40:481 EST] 3c6d95c5 DSConfigurati W DSRA0174W: Warning: GenericDataStoreHelper is being used. [2/19/04 16:04:40:891 EST] 3c6d95c5 ConnectionFac I J2CA0122I: Resource reference jdbc/staging could not be located, so default values of the following are used: [Resource-ref settings] res-auth: 1 (APPLICATION) res-isolation-level: 0 (TRANSACTION_NONE) res-sharing-scope:true (SHAREABLE) res-resolution-control: 999 (undefined) [Other attributes] isCMP1_x: false (not CMP1.x) isJMS: false (not JMS) Has anyone else had problems with WAS 5.1 access MySql datasources? Tom, Make sure you're using 'com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource' as the datasource implementation class that you plug into your WebSphere config...For some reason, no other classes (Driver or plain DataSource) seem to work in 5.1sp1 or newer. FYI, I just tested this yesterday in WS 6.0 preview, and it has the same issue. -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com Meet the MySQL Team! April 14-16, 2004 http://www.mysql.com/uc2004/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFANV/qtvXNTca6JD8RAnWcAKCD9n3If9DLMSJqOwc4ygbNpt+hsgCgmxQ4 Hd/VPa5IieQfH+Y/jnZfciM= =W/GZ -END PGP SIGNATURE- = -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problems connecting to MySQL with WLS
Since the connection pool needs to load the driver, putting the driver jar in WEB-INF is too late. One option is to put in the startWeblogic file and add it to the classpath there. Depending on the version of WLS there are various way to accomplish this. Best regards... - Answers to J2EE, Java, UML, Process, and Patterns! (http://groups.yahoo.com/group/bartssandbox) J2EE (http://www.cact.csupomona.edu/oncampus/programs/cert/j2ee/default.asp) Java (http://www.cact.csupomona.edu/oncampus/programs/cert/java/Default.asp) UML (http://www.cact.csupomona.edu/oncampus/programs/cert/uml/default.asp) eBuilt, Inc. (http://www.eBuilt.com) Date: Thu, 26 Feb 2004 18:40:57 +0100 To: [EMAIL PROTECTED] From: =?iso-8859-1?Q?=22Carl_Sch=E9le=2C_IT=2C_Posten=22?= [EMAIL PROTECTED] Subject: Problems connecting to MySQL with WLS Message-ID: [EMAIL PROTECTED] --_=_NextPart_001_01C3FC8F.B12822B3 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello! =20 I'm using a WLS server and MySQL. Where am I supposed to put the = mysql-connector-java-3.0.11-stable-bin.jar to make sure WLS will find = it? I've tried several places ie. under ttk and right under classes. = Still WLS doesn't find my mysql.jar file. It works when I'm compiling it = locally but when I'm trying to deploy it on the server everything goes = wrong. My hierarchy looks like this. =20 WEB-INF | classes | web | java | se | ttk | Test.class --_=_NextPart_001_01C3FC8F.B12822B3-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems connecting to MySQL with WLS
Hello! I'm using a WLS server and MySQL. Where am I supposed to put the mysql-connector-java-3.0.11-stable-bin.jar to make sure WLS will find it? I've tried several places ie. under ttk and right under classes. Still WLS doesn't find my mysql.jar file. It works when I'm compiling it locally but when I'm trying to deploy it on the server everything goes wrong. My hierarchy looks like this. WEB-INF | classes | web | java | se | ttk | Test.class
Problems connecting to MySql on WebSphere 5.1
I've been running an application on WebSphere 5.0 (Linux) that uses the MySql Connector/J 3.10 to connect to a MySql-max 4.0.15 database (also on Linux). All was working fine, until I recently installed WebSphere 5.1. Now my datasources (configured exactly as before) no longer work - WebSphere seems unable to find them. When I start the server, I get the following error when my application starts: [2/19/04 16:04:40:481 EST] 3c6d95c5 DSConfigurati W DSRA0174W: Warning: GenericDataStoreHelper is being used. [2/19/04 16:04:40:891 EST] 3c6d95c5 ConnectionFac I J2CA0122I: Resource reference jdbc/staging could not be located, so default values of the following are used: [Resource-ref settings] res-auth: 1 (APPLICATION) res-isolation-level: 0 (TRANSACTION_NONE) res-sharing-scope:true (SHAREABLE) res-resolution-control: 999 (undefined) [Other attributes] isCMP1_x: false (not CMP1.x) isJMS: false (not JMS) Has anyone else had problems with WAS 5.1 access MySql datasources? Tom [EMAIL PROTECTED] = -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems connecting to MySql on WebSphere 5.1
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom O'Neil wrote: I've been running an application on WebSphere 5.0 (Linux) that uses the MySql Connector/J 3.10 to connect to a MySql-max 4.0.15 database (also on Linux). All was working fine, until I recently installed WebSphere 5.1. Now my datasources (configured exactly as before) no longer work - WebSphere seems unable to find them. When I start the server, I get the following error when my application starts: [2/19/04 16:04:40:481 EST] 3c6d95c5 DSConfigurati W DSRA0174W: Warning: GenericDataStoreHelper is being used. [2/19/04 16:04:40:891 EST] 3c6d95c5 ConnectionFac I J2CA0122I: Resource reference jdbc/staging could not be located, so default values of the following are used: [Resource-ref settings] res-auth: 1 (APPLICATION) res-isolation-level: 0 (TRANSACTION_NONE) res-sharing-scope:true (SHAREABLE) res-resolution-control: 999 (undefined) [Other attributes] isCMP1_x: false (not CMP1.x) isJMS: false (not JMS) Has anyone else had problems with WAS 5.1 access MySql datasources? Tom, Make sure you're using 'com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource' as the datasource implementation class that you plug into your WebSphere config...For some reason, no other classes (Driver or plain DataSource) seem to work in 5.1sp1 or newer. FYI, I just tested this yesterday in WS 6.0 preview, and it has the same issue. -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com Meet the MySQL Team! April 14-16, 2004 http://www.mysql.com/uc2004/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFANV/qtvXNTca6JD8RAnWcAKCD9n3If9DLMSJqOwc4ygbNpt+hsgCgmxQ4 Hd/VPa5IieQfH+Y/jnZfciM= =W/GZ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems connecting to MySql on WebSphere 5.1
Mark, I am using the 'com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource' class, which worked fine in 5.0. I've done some further debugging and figured out a way to get the datasource to at least run. If I explicitly pass the user and password parameters (along with serverName, databaseName, and port), rather than use the JAAS authentication entry I created, I still get the same error as below, however the datasource does in fact work. If I try to use the JAAS entry, it actually connects to the server, which gives the following error: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) Passing the login as parameters gives me the error below, but my code can, in fact, access the datasource. [2/19/04 21:57:33:376 EST] 3c66be23 DSConfigurati W DSRA0174W: Warning: GenericDataStoreHelper is being used. [2/19/04 21:57:33:706 EST] 3c66be23 ConnectionFac I J2CA0122I: Resource reference jdbc/staging could not be located, so default values of the following are used: [Resource-ref settings] res-auth: 1 (APPLICATION) res-isolation-level: 0 (TRANSACTION_NONE) res-sharing-scope:true (SHAREABLE) res-resolution-control: 999 (undefined) [Other attributes] isCMP1_x: false (not CMP1.x) isJMS: false (not JMS) [2/19/04 21:57:34:287 EST] 3c66be23 WSRdbDataSour I DSRA8203I: Database product name : MySQL [2/19/04 21:57:34:287 EST] 3c66be23 WSRdbDataSour I DSRA8204I: Database product version : 4.0.15-max [2/19/04 21:57:34:287 EST] 3c66be23 WSRdbDataSour I DSRA8205I: JDBC driver name : MySQL-AB JDBC Driver [2/19/04 21:57:34:287 EST] 3c66be23 WSRdbDataSour I DSRA8206I: JDBC driver version : mysql-connector-java-3.0.10-stable ( $Date: 2004/01/13 21:56:18 $, $Revision: 1.27.2.33 $ ) Tom --- Mark Matthews [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom O'Neil wrote: I've been running an application on WebSphere 5.0 (Linux) that uses the MySql Connector/J 3.10 to connect to a MySql-max 4.0.15 database (also on Linux). All was working fine, until I recently installed WebSphere 5.1. Now my datasources (configured exactly as before) no longer work - WebSphere seems unable to find them. When I start the server, I get the following error when my application starts: [2/19/04 16:04:40:481 EST] 3c6d95c5 DSConfigurati W DSRA0174W: Warning: GenericDataStoreHelper is being used. [2/19/04 16:04:40:891 EST] 3c6d95c5 ConnectionFac I J2CA0122I: Resource reference jdbc/staging could not be located, so default values of the following are used: [Resource-ref settings] res-auth: 1 (APPLICATION) res-isolation-level: 0 (TRANSACTION_NONE) res-sharing-scope:true (SHAREABLE) res-resolution-control: 999 (undefined) [Other attributes] isCMP1_x: false (not CMP1.x) isJMS: false (not JMS) Has anyone else had problems with WAS 5.1 access MySql datasources? Tom, Make sure you're using 'com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource' as the datasource implementation class that you plug into your WebSphere config...For some reason, no other classes (Driver or plain DataSource) seem to work in 5.1sp1 or newer. FYI, I just tested this yesterday in WS 6.0 preview, and it has the same issue. -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com Meet the MySQL Team! April 14-16, 2004 http://www.mysql.com/uc2004/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFANV/qtvXNTca6JD8RAnWcAKCD9n3If9DLMSJqOwc4ygbNpt+hsgCgmxQ4 Hd/VPa5IieQfH+Y/jnZfciM= =W/GZ -END PGP SIGNATURE- = -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Addition to Last Post on Connecting to MYSQL
Also It keeps telling me that the host is not allowed to connect to the MySQL server, funny thing is the host that is trying to connect is the actual machine that MYSQL is on? Chris L. White Network Administrator Jr. Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED]
Problem Connecting To mysql server
Hi there ##ERROR 2013: Lost connection to MySQL server during query ## i get this error when i try to remotely connect to my mysql server, it has been working until i changed the server's ip and isp, when i re-change the mysql server to the old ip address (first isp), it's working again . when i do a netstat -atn in my mysql server, i get : tcp0 48 xxx.local.ip.xxx :3306 yyy.outsideserver.xxx:2886 FIN_WAIT1 a telnet to my server through the port 3306 goes well i'm under linux 8 and mysql 4.0.13 Does anybody knows how i can fix this ? ThanX LoT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem Connecting To Mysql Server
Hi there ##ERROR 2013: Lost connection to MySQL server during query ## I get this error when i try to remotely connect to my mysql server, it has been working until i changed the server's ip and isp, when i re-change the mysql server to the old ip address (first isp), it's working again . When i do a netstat -atn in my mysql server, i get : tcp 0 48 xxx.local.ip.xxx :3306 yyy.outsideserver.xxx:2886 FIN_WAIT1 A telnet to my server through the port 3306 goes well i'm under linux 8 and mysql 4.0.13 Does anybody knows how i can fix this ? Thanx a Lot -- 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.
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]
Problem in connecting to mysql from MSAccess 2000
Hi, I've set up a ODBC DSN to connect to Mysql. This DSN works fine with MS Excel. However, it returned the following error when I tried to link some Mysql tables from Access 2000: ODBC--call failed. [MySQL][ODBC 3.51 Driver][mysql-4.0.4-beta-max-nt]Access denied for user: '@my ip address here' to database 'tradingdata' (#1044). Any help would be much appreciated. Regards, Gilbert Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with Connecting remote MySQL (RH8.0)
Hi, I've been facing problem while trying to access remote MySQL database using PHP. It is working fine with the local database. I did in the following way: Created a user on the database with [EMAIL PROTECTED] identified by 'password'; Warning: Warning: Lost connection to MySQL server during query in /var/www/html/helpdesk/common/mysql.class.php on line 41 2013 : Lost connection to MySQL server during query System details: OS: RedHat 8.0 PHP version: 4.2.2 MySQL Version: 3.23.52 Please help me out. Thanks Regards Praveen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error connecting to mysql
I have a problem connection from a remote host this is the error I get ERROR 2013: Lost connection to MySQL server during query I am using redhat 8.0 and mysql3.23.54 please help thank you -- Antoine [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
problem connecting to mysql using myodbc 3.51.05
Hi, I am currently running mysql-3.23.52-3 on Linux 8.0 and myodbc 3.51.05 on win2000 machines respectively. Users and host IP has been setup on mysql, and innodb has been setup with as below. innodb_data_file_path = ibdata1:10M:autoextend set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 However, when I tried to test conection with myodbc, it prompts Lost connection to Mysql server during query In the error log, it shows mysqld process hanging, pid 2073 - killed 030203 12:42:55 mysqld restarted 030203 12:42:56 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 030203 12:42:56 InnoDB: Flushing modified pages from the buffer pool... 030203 12:42:56 InnoDB: Started /usr/libexec/mysqld: ready for connections Would anyone know what I have done wrong ?? Your help is very much appreciated. Sherman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connecting to MySQL thru SOCKS proxy
Hello, I am behind a SOCKS proxy. How do I connect to MySQL Server using MySQL C API? Thanks in advance, Karam __ 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
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
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: RE: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)
CZachary, Friday, November 08, 2002, 6:51:03 PM, you wrote: Cawdc I tried this. The error I received is: error: 'Access denied for user: Cawdc 'root@localhost' (Using password: NO)' Cawdc Is there another option? Does user 'root' have a password? If yes, you must use -p option to specify a password. -- 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
Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3. I am trying to connect to my Mysql DB via Apache and PHP, but I get the following error: Warning: MySQL Connection Failed: Access denied for user: 'root@jws-portald' (Using password: YES) in helloSql.php on line 3 Could not connect Is there a step I missed during the Mysql setup? Here is the code I used. ?php // Connecting, selecting database $link = mysql_connect(localhost, root, mypassword) or die(Could not connect); print Connected successfully; // Performing SQL query $query = SELECT now(); $result = mysql_query($query) or die(Query failed); // Printing results in HTML print table\n; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print \ttr\n; foreach ($line as $col_value) { print \t\ttd$col_value/td\n; } print \t/tr\n; } print /table\n; // Closing connection mysql_close($link); ? - 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: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)
mysqladmin -u root password setpassword ? and dont use root for normal access -Original Message- From: [EMAIL PROTECTED] [mailto:CZachary;wiley.com] Sent: Saturday, November 09, 2002 2:51 AM To: [EMAIL PROTECTED] Subject: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie) Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3. I am trying to connect to my Mysql DB via Apache and PHP, but I get the following error: Warning: MySQL Connection Failed: Access denied for user: 'root@jws-portald' (Using password: YES) in helloSql.php on line 3 Could not connect Is there a step I missed during the Mysql setup? Here is the code I used. ?php // Connecting, selecting database $link = mysql_connect(localhost, root, mypassword) or die(Could not connect); print Connected successfully; // Performing SQL query $query = SELECT now(); $result = mysql_query($query) or die(Query failed); // Printing results in HTML print table\n; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print \ttr\n; foreach ($line as $col_value) { print \t\ttd$col_value/td\n; } print \t/tr\n; } print /table\n; // Closing connection mysql_close($link); ? - 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: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)
I tried this. The error I received is: error: 'Access denied for user: 'root@localhost' (Using password: NO)' Is there another option? |-+ | | Dan Rossi | | | daniel@electrote| | | que.org | | || | | 11/08/2002 11:10 | | | AM | | || |-+ --| | | | To: [EMAIL PROTECTED], [EMAIL PROTECTED] | | cc: | | Subject: RE: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie) | --| mysqladmin -u root password setpassword ? and dont use root for normal access -Original Message- From: [EMAIL PROTECTED] [mailto:CZachary;wiley.com] Sent: Saturday, November 09, 2002 2:51 AM To: [EMAIL PROTECTED] Subject: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie) Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3. I am trying to connect to my Mysql DB via Apache and PHP, but I get the following error: Warning: MySQL Connection Failed: Access denied for user: 'root@jws-portald' (Using password: YES) in helloSql.php on line 3 Could not connect Is there a step I missed during the Mysql setup? Here is the code I used. ?php // Connecting, selecting database $link = mysql_connect(localhost, root, mypassword) or die(Could not connect); print Connected successfully; // Performing SQL query $query = SELECT now(); $result = mysql_query($query) or die(Query failed); // Printing results in HTML print table\n; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print \ttr\n; foreach ($line as $col_value) { print \t\ttd$col_value/td\n; } print \t/tr\n; } print /table\n; // Closing connection mysql_close($link); ? - 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: Error connecting to Mysql via Apache/PHP - Access Denied(Newbie)
On Fri, 2002-11-08 at 16:51, [EMAIL PROTECTED] wrote: I am trying to connect to my Mysql DB via Apache and PHP, but I get the following error: Warning: MySQL Connection Failed: Access denied for user: 'root@jws-portald' (Using password: YES) in helloSql.php on line 3 Could not connect Can you try to access a db as normal user? Or is there a reason you want to connect to the db as root? I use a MySQL user without password and I connect with a command like: $db = mysql_connect(localhost, M8ram, ); mysql_select_db(db_name,$db); Perhaps you have to check the 'case' of your username? HTH -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - 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: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)
Several things. Don't use root to connect remotely. Run mysqld as a userid on the server not root. You may need to grant on mysql database for more than localhost. Such as (Note this grants all privileges to all databases. See mysql docs for restricted access) GRANT * ON *.* TO 'userid' IDENTIFIED BY 'password'; GRANT * ON *.* TO 'userid@%' IDENTIFIED BY 'password'; GRANT * ON *.* TO 'userid@realhostname' IDENTIFIED BY 'password'; DONT FORGET TO - FLUSH PRIVILEGES; Also be sure the file /etc/hosts has this line 127.0.0.1 localhost Oh and I have to say this for the list- sql, query ~Kelly W. Black -Original Message- From: Mertens Bram [mailto:bram-mertens;linux.be] Sent: Friday, November 08, 2002 9:55 AM To: mysql mailing list Subject: Re: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie) On Fri, 2002-11-08 at 16:51, [EMAIL PROTECTED] wrote: I am trying to connect to my Mysql DB via Apache and PHP, but I get the following error: Warning: MySQL Connection Failed: Access denied for user: 'root@jws-portald' (Using password: YES) in helloSql.php on line 3 Could not connect Can you try to access a db as normal user? Or is there a reason you want to connect to the db as root? I use a MySQL user without password and I connect with a command like: $db = mysql_connect(localhost, M8ram, ); mysql_select_db(db_name,$db); Perhaps you have to check the 'case' of your username? HTH -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - 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
Error connecting to Mysql via Apache/PHP (Newbie)
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3. I am trying to connect to my Mysql DB via Apache and PHP, but I get the following error: Warning: Unknown MySQL Server Host '' (1) in helloSql.php on line 3 Warning: MySQL Connection Failed: Unknown MySQL Server Host '' (1) in helloSql.php on line 3 Could not connect Here is the code I used. ?php // Connecting, selecting database $link = mysql_connect(localhost, root, mypassword) or die(Could not connect); print Connected successfully; // Performing SQL query $query = SELECT now(); $result = mysql_query($query) or die(Query failed); // Printing results in HTML print table\n; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print \ttr\n; foreach ($line as $col_value) { print \t\ttd$col_value/td\n; } print \t/tr\n; } print /table\n; // Closing connection mysql_close($link); ? - 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: Error connecting to Mysql via Apache/PHP (Newbie)
Pada Thu, 7 Nov 2002 12:10:21 -0500 [EMAIL PROTECTED] menulis: Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3. I am trying to connect to my Mysql DB via Apache and PHP, but I get the following error: Warning: Unknown MySQL Server Host '' (1) in helloSql.php on line 3 Warning: MySQL Connection Failed: Unknown MySQL Server Host '' (1) in helloSql.php on line 3 Could not connect Here is the code I used. ?php // Connecting, selecting database $link = mysql_connect(localhost, root, mypassword) or die(Could not connect); print Connected successfully; is your mysqld running ? how to check ? run : shell# mysql -uroot -p is this the real code ? $link = mysql_connect(localhost, root, mypassword) if it is, so you should remove the sign, and looks like this : $link = mysql_connect(localhost, root, mypassword) -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.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
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
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 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.
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
Connecting to MySQL on Linux from a Windows machine.
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.
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.
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, 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.
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
connecting to mysql database from php...
hi all: i am attempting to connect to a mysql database from php, using the following syntax in the php: $dsn = mysql://webuser@localhost/doug ; $db = DB::connect( $dsn ) ; if ( DB::isError($db) ) { print $dsn.\n ; die( $db-getMessage().\n ) ; } i get this message: mysql://webuser@localhost/doug DB Error: no such database any suggestions would be greatly appreciated. -- regards, allen wayne best, esq your friendly neighborhood rambler owner my rambler will go from 0 to 105 Current date: 8:2:21::275:2002 For a holy stint, a moth of the cloth gave up his woolens for lint. - 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): - WebMethod() 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
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): - WebMethod() 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
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): - WebMethod() 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
Re: problem connecting to mysql with gui
samuel, Friday, August 16, 2002, 12:45:36 AM, you wrote: su please how can i set Sql command on connect to be able to connect to su mysql.i am a novice.i tried to enter /var/lib/mysql/mysql.sock but still su couldn't connect.help please. i have tried with both static and su semi-static files. Do you get Access denied error or Can't connect? Check Host name and port number. Ceck if your MySQL server is 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
problem connecting to mysql with gui
please how can i set Sql command on connect to be able to connect to mysql.i am a novice.i tried to enter /var/lib/mysql/mysql.sock but still couldn't connect.help please. i have tried with both static and semi-static files. thanks. - 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
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
Connecting to MySQL from an apache module using C API
Hello, I have problems with connecting to a mysql database. I use a global MYSQL handle in the module. The connection is created in module_child_init() function and closed in module_child_exit(). It seems, that the connection works only for the first request after apache has been restarted. After that there is no connection and no new connection will be created. What the module do is to read data from HEAP tables from MySQL in a handler function. Maybe is using global MYSQL handle not a good solution? Thanks for help. Robert Vetter Internet Application Developer Kontor23 GmbH Ottenser Hauptstrasse 56-62 22765 Hamburg Tel.: 040/380893-14 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connecting to mysql Server
Hi All, Does anyone have an idea why I am getting an error Fatal error: Call to undefined function: mysql_connect() in /var/www in this PHP function mysql_connect(localhost,root,password); Thanx All - 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 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
Connecting to MySql
Hi, 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. From the manual--- If you get the following error when you try to connect from a different host than the one on which the MySQL server is running, then there is no row in the user table that matches that host: Host ... is not allowed to connect to this MySQL server You can fix this by using the command-line tool mysql (on the server host!) to add a row tothe user, db, or host table for the user/hostname combination from which you are trying to connect and then execute mysqladmin flush-privileges. If you are not running MySQL Version 3.22 and you don't know the IP number or hostname of the machine from which you are connecting, you should put an entry with '%' as the Host column value in the user table and restart mysqld with the --log option on the server machine. After trying to connect from the client machine, the information in the MySQL log will indicate how you really did connect. (Then replace the '%' in the user table entry with the actual hostname that shows up in the log. Otherwise, you'll have a system that is insecure.) Another reason for this error on Linux is that you are using a binary MySQL version that is compiled with a different glibc version than the one you are using. In this case you should either upgrade your OS/glibc or download the source MySQL version and compile this yourself. A source RPM is normally trivial to compile and install, so this isn't a big problem. Regards Tue - 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 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
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
packets involved in connecting to mysql
I tried to connect to mysql on another machine, but can't get through: ERROR 2003: Can't conect to MySQL server on 'other host' (111) I think this is because the two machines are in different domains, and the packets are being blocked by a firewall. Anybody know what I need to enable in the firewall to let the packets go through? Also, will this same port/packet-type/whatever work for slaving one database to another to act as a backup server.? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connecting to MySQL from Oracle using MyODBC driver
Dear Sir or Madam, I am currently trying to connect an Oracle 8.1.7 database running on Windows NT 4.0 to a MySQL database running on Linux (not sure of the MySQL or Linux versions). When I try to select from a table I am getting the following error... ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_BeginT - rc = -1. Please refer to the log file for details. I know the ODBC connection works because I connected from another application to the MySQL database, so it has to be something to do with Oracle viewing MySQL. I know the Oracle ODBC connections out work because I am able to connect to Microsoft Access and SQL Server. I would appreciate any assistance you may have. Thanks, Steven Alfisi Programmer - Database Specialist Orchid BioSciences 303 College Road East Princeton, NJ 08540 (609) 750-2750 - 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
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
[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
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
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: [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
connecting to mysql from different computer
I can connect to mysql with Perl when I have the perl script on the same computer, but as soon as I move the perl script to a different machine it won't work. I replaced localhost with the IP address of the machine on which mysql is on, but that didn't work either. Does anyone have an example they could cut and past here for me. Thanks, Dan. - 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
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\binmysql -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
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\binmysql -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
RE: [PHP] Problem connecting to mysql via odbc
Mweb, Set your ODBCINI environment variable (and others) as per the HOWTO at www.iodbc.org. This HOWTO is for iODBC, but the concepts are the same for this error condition. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 12:02 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Problem connecting to mysql via odbc Hello, I have a page whoch should connect to a mysql database via odbc, on a RH 7.2 PC with the relevant rpm listed below. I know what to do when the db is reachable, but can't start: the instruction: $conn=odbc_connect(db9,,); just yelds this result: Warning: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in one.php on line 20 Warning: Supplied argument is not a valid ODBC-Link resource in one.php on line 22 THis is certainly something wrong with my odbc setup, but can't figure it out. I saw a thread couple of days ago about myodbc dsn creation, but can't relate it to my problem. Actually, I only have odbcinst, not the commands mentioned in that message. Any help is appreciated! Thanks, mweb RPM list php-ldap-4.0.6-7 unixODBC-devel-2.0.7-3 mod_auth_mysql-1.11-1 mysqlclient9-3.23.22-6 php-mysql-4.0.6-7 unixODBC-2.0.7-3 asp2php-0.75.17-1 php-imap-4.0.6-7 php-pgsql-4.0.6-7 mysql-3.23.41-1 MyODBC-2.50.37-2 mysql-server-3.23.41-1 php-manual-4.0.6-7 php-odbc-4.0.6-7 libodbc++-0.2.2pre4-12 php-4.0.6-7 mysql-devel-3.23.41-1 perl-DBD-MySQL-1.2216-4 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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
Problem connecting to mysql via odbc
Hello, I have a page whoch should connect to a mysql database via odbc, on a RH 7.2 PC with the relevant rpm listed below. I know what to do when the db is reachable, but can't start: the instruction: $conn=odbc_connect(db9,,); just yelds this result: Warning: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in one.php on line 20 Warning: Supplied argument is not a valid ODBC-Link resource in one.php on line 22 THis is certainly something wrong with my odbc setup, but can't figure it out. I saw a thread couple of days ago about myodbc dsn creation, but can't relate it to my problem. Actually, I only have odbcinst, not the commands mentioned in that message. Any help is appreciated! Thanks, mweb RPM list php-ldap-4.0.6-7 unixODBC-devel-2.0.7-3 mod_auth_mysql-1.11-1 mysqlclient9-3.23.22-6 php-mysql-4.0.6-7 unixODBC-2.0.7-3 asp2php-0.75.17-1 php-imap-4.0.6-7 php-pgsql-4.0.6-7 mysql-3.23.41-1 MyODBC-2.50.37-2 mysql-server-3.23.41-1 php-manual-4.0.6-7 php-odbc-4.0.6-7 libodbc++-0.2.2pre4-12 php-4.0.6-7 mysql-devel-3.23.41-1 perl-DBD-MySQL-1.2216-4 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connecting to mysql
i'd like to connect to mysql sgdb but not by a specific database, only the sgdb, using java to send the command show database and them afther that select a database listed and connect to that database. i tried jdbc:mysql://localhost:3306 i tried jdbc:mysql://localhost:3306/ but those have not worked. thanks. _ 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
error while connecting to mysql
hello I'm running a server mysql 3.23.44 on a debian potato I start my server with : mysqld -u mysql mysqld: ready for connections I configure my pass for root. when I connect to it with mysql -p it works but mysql -h p204.mde.emn.fr -p Enter password: ERROR 2013: Lost connection to MySQL server during query please help thanks Guillaume Membré - 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: Trouble connecting to MySQL server using MySQLGUI and VCC
Chris Johnson writes: The remote hosts you mention are not allowed to access the database. This is a permissions problem, in particular the value of hosts in one of the permissions tables. It sounds like they only allow connections from the localhost or their own network. ..chris - Original Message - From: Robert Anderson [EMAIL PROTECTED] I've been playing with MySQL and trying to get connected to my web-hosting company's MySQL server that they set up for me. In trying to use the MySQLGui and also the VCC, I get the error Host 'junior.dsl.neticus.com' is not allowed to connect to this MySQL server. And if I'm plugged in at work I get the same error with a different 'dsl.neticus.com' thing. I can telnet to the company and then use their 'mysql.pm' utility using the same parameters from the exact same workstation and locations. Any ideas? Thanks in advance, Rob Chris is of course right. If you want to skip the above problem, grant privileges to user@%, -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Trouble connecting to MySQL server using MySQLGUI and VCC
The remote hosts you mention are not allowed to access the database. This is a permissions problem, in particular the value of hosts in one of the permissions tables. It sounds like they only allow connections from the localhost or their own network. ..chris - Original Message - From: Robert Anderson [EMAIL PROTECTED] I've been playing with MySQL and trying to get connected to my web-hosting company's MySQL server that they set up for me. In trying to use the MySQLGui and also the VCC, I get the error Host 'junior.dsl.neticus.com' is not allowed to connect to this MySQL server. And if I'm plugged in at work I get the same error with a different 'dsl.neticus.com' thing. I can telnet to the company and then use their 'mysql.pm' utility using the same parameters from the exact same workstation and locations. Any ideas? Thanks in advance, Rob - 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