Connecting to MySQL Community Edition from Informatica Powercenter 9.5.1 running on AIX

2013-10-02 Thread Saqib N Ali
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?

RE: Slow connecting to MySQL from Windows App

2009-05-05 Thread Martin Gainty
y 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,

Slow connecting to MySQL from Windows App

2009-05-05 Thread Menachem Bazian
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 reason

RE: Slowness connecting to MySQL

2009-05-04 Thread Andrew Braithwaite
4 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.

Slowness connecting to MySQL

2009-05-04 Thread Menachem Bazian
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

Re: Connecting to mysql 4.1 server with a 4.0 client

2006-07-13 Thread Iain Conochie
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 er

Re: Connecting to mysql 4.1 server with a 4.0 client

2006-07-13 Thread Dan Trainor
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 authent

Connecting to mysql 4.1 server with a 4.0 client

2006-07-13 Thread Iain Conochie
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 reque

Problem connecting to MySQL 4.0.23 with MySQL Administrator 1.0.21 (Mac OS X)

2005-06-14 Thread Jan Pieter Kunst
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 . Error: unknown system variable 'sql_mode' (code 1193) I can conn

connecting to mysql 3.23.49 very slow

2005-01-21 Thread B.Brey
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

Re: Connecting to MySQL using C API

2004-11-15 Thread Aftab Jahan Subedar
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-S

Re: Problem connecting to MySQL 4.1.7 running on another machine

2004-11-15 Thread Adam
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://

Re: Problem connecting to MySQL 4.1.7 running on another machine

2004-11-15 Thread Richard Whitney
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

Problem connecting to MySQL 4.1.7 running on another machine

2004-11-15 Thread 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

Re: Connecting to MySQL using C API

2004-11-14 Thread Paul DuBois
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 duplic

Connecting to MySQL using C API

2004-11-14 Thread premal mishra
I'm using MySQL version 4.0.20a on win98. Compiler is Bloodshed Dev-C++ version 4. My program compiles and links but gives a page fault error on running. I'm linking the '\mysql\lib\opt\mysqlclient.lib' file. Linker gives the warning >> ignoring duplicate section '.text' CODE: #include #include

Re: Problem connecting to MySQL server

2004-11-09 Thread Gleb Paharenko
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

Problem connecting to MySQL server

2004-11-08 Thread Schalk Neethling
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

RE: Error connecting to mysql db

2004-10-25 Thread Ferguson, Michael
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

FW: Error connecting to mysql db

2004-10-25 Thread J.R. Bullington
: 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/mysq

RE: Error connecting to mysql db

2004-10-25 Thread Ferguson, Michael
tober 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.so

RE: Error connecting to mysql db

2004-10-25 Thread J.R. Bullington
: 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/mysq

Error connecting to mysql db

2004-10-25 Thread Ferguson, Michael
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,

Re: Help With Remotely Connecting to MySQL Database

2004-06-02 Thread gerald_clark
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 f

RE: Help With Remotely Connecting to MySQL Database

2004-06-02 Thread Victor Pendleton
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

Help With Remotely Connecting to MySQL Database

2004-06-02 Thread Fred Aswad
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 t

Re: Problems connecting to MySql on WebSphere 5.1

2004-03-23 Thread Tom O'Neil
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

Problems connecting to MySQL with WLS

2004-02-26 Thread "Carl Schéle, IT, Posten"
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 locall

RE: Problems connecting to MySQL with WLS

2004-02-26 Thread Malani, Prakash
/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 > Me

Re: Problems connecting to MySql on WebSphere 5.1

2004-02-19 Thread Tom O'Neil
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", "data

Re: Problems connecting to MySql on WebSphere 5.1

2004-02-19 Thread Mark Matthews
-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 m

Problems connecting to MySql on WebSphere 5.1

2004-02-19 Thread Tom O'Neil
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 seem

Addition to Last Post on Connecting to MYSQL

2004-01-12 Thread Chris L. White
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

2003-09-04 Thread naoufal
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

Problem Connecting To mysql server

2003-09-04 Thread naoufal
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

Connecting to MySQL from ASP

2003-08-14 Thread Ratmil Torres
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

2003-08-14 Thread Cabanillas Dulanto, Ulises
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

RE: Connecting to MySQL from ASP

2003-08-06 Thread Bill J. Vallance
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 Ser

Problem in connecting to mysql from MSAccess 2000

2003-07-21 Thread Gilbert Wu
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: '@' to database 'trad

problem connecting to mysql using myodbc 3.51.05

2003-02-10 Thread Wong, Sherman
> >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 >

error connecting to mysql

2003-02-10 Thread Antoine
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]> -

Connecting to MySQL thru SOCKS proxy

2002-12-11 Thread Karam Chand
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 -

Re: Connecting to mysql

2002-12-01 Thread Bhavin Vyas
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 >

Connecting to mysql

2002-12-01 Thread Pikasz Gyorgy
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 pos

re: RE: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)

2002-11-11 Thread Egor Egorov
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

RE: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)

2002-11-08 Thread Black, Kelly W [PCS]
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

Re: Error connecting to Mysql via Apache/PHP - Access Denied(Newbie)

2002-11-08 Thread Mertens Bram
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" C

RE: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)

2002-11-08 Thread CZachary
| | cc: | | Subject: RE: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie) | >-

RE: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)

2002-11-08 Thread Dan Rossi
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

Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)

2002-11-08 Thread CZachary
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

Re: Error connecting to Mysql via Apache/PHP (Newbie)

2002-11-07 Thread Dicky Wahyu Purnomo
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: U

Error connecting to Mysql via Apache/PHP (Newbie)

2002-11-07 Thread CZachary
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 C

Re: connecting to mysql server from other machines

2002-11-04 Thread Frederic Trudeau
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 mach

connecting to mysql server from other machines

2002-11-04 Thread Michael Gargiullo
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

RE: Connecting to MySQL on Linux from a Windows machine. -- Resolved !!

2002-10-19 Thread Will Merrell
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

RE: Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread Ed Carp
> 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 imme

RE: Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread Will Merrell
ebmin 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] &

RE: Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread STIBS
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

RE: Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread Will Merrell
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

Re: Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread Olaf van Zandwijk
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 L

Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread Will Merrell
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

RE: Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread Randy Witt
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 differ

connecting to mysql database from php...

2002-10-03 Thread Allen Wayne Best
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: mysq

Re: connecting to mysql via ODBC from asp.net

2002-09-29 Thread Ivan Paul
:-) 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 i

Re: connecting to mysql via ODBC from asp.net

2002-09-29 Thread Ivan Paul
----- 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 tr

connecting to mysql via ODBC from asp.net

2002-09-27 Thread Jay Fields
I've installed the windows version of mysql. I configured nothing. This is the code I'm trying to use to access mysql from an asp web service (in vb): - Public Function dbConnect() As String Dim connString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _

Re: problem connecting to mysql with gui

2002-08-16 Thread Egor Egorov
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 fil

problem connecting to mysql with gui

2002-08-15 Thread samuel umoette
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.

Re: Connecting to MySQL using OLEDB

2002-08-01 Thread Christoph Lütjen
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

Re: Connecting to MySQL using OLEDB

2002-08-01 Thread Francisco Reinaldo
Hi, Search if somebody has the OLEDB driver for MySQL, and then you will be able to do it. Bye and Good Luck! --- "Darrell A. Sullivan, II" <[EMAIL PROTECTED]> wrote: > Can anyone tell me if it is possible to connect to a > MySQL server running on > Linux from a Windows Visual Basic application

Connecting to MySQL using OLEDB

2002-07-31 Thread Darrell A. Sullivan, II
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 conne

Connecting to MySQL from an apache module using C API

2002-05-03 Thread Robert Vetter
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. A

Connecting to MySQL from an apache module using C API

2002-05-03 Thread Robert Vetter
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. A

Re: Connecting to mysql Server

2002-02-25 Thread Oladejo, Tokunboh
- 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 200

Re: Connecting to mysql Server

2002-02-25 Thread Jeremy 'Circ' Charles
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.

Connecting to mysql Server

2002-02-25 Thread Oladejo, Tokunboh
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 pos

Re: Connecting to MySql

2002-01-06 Thread Doug Thompson
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' a

Re: Connecting to MySql

2002-01-06 Thread Christian J Hedemark
> 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 distribute

Re: Connecting to MySql

2002-01-06 Thread Doug Thompson
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 don’t know how to do it. I am an >novice in MySql. >If anyo

Connecting to MySql

2002-01-06 Thread Tue Hellstern
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 don’t know how to do it. I am an novice in MySql. If anyone can make tell me the commands I will be very happy. >

packets involved in connecting to mysql

2001-12-18 Thread Barry Gold
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 fir

Re: Connecting to MySQL from Oracle using MyODBC driver

2001-12-13 Thread styb
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 you

Connecting to MySQL from Oracle using MyODBC driver

2001-12-13 Thread Alfisi, Steve
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 t

Re: connecting to mysql from different computer

2001-12-12 Thread Rodney Broom
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 databas

Re: connecting to mysql from different computer

2001-12-12 Thread Carl Troein
[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 s

Re: connecting to mysql from different computer

2001-12-12 Thread hamzatk
>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

Re: connecting to mysql from different computer

2001-12-11 Thread Rodney Broom
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 jus

Re: connecting to mysql from different computer

2001-12-11 Thread hamzatk
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 s

Re: connecting to mysql from different computer

2001-12-10 Thread Rodney Broom
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

connecting to mysql from different computer

2001-12-10 Thread Dan
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

Re: Connecting to mysql server in a remote site and using LOAD command

2001-12-04 Thread Phillip M.(Mike) Bishop
y, December 03, 2001 8:27 AM Subject: Connecting to mysql server in a remote site and using LOAD command > Dear All, > > I have Mysql server installed at remote site which i need to connect to. > > I have tried this from my local computer but didn't work; > > c:\mysql\bin&

Connecting to mysql server in a remote site and using LOAD command

2001-12-04 Thread Hamzat Kamal
Dear All, I have Mysql server installed at remote site which i need to connect to. I have tried this from my local computer but didn't work; c:\mysql\bin>mysql -h myhost -u myusername -pmypassword I will also like to use LOAD command to load a text file from my local computer to the database o

Connecting to mysql server in a remote site and using LOAD command

2001-12-03 Thread hamzatk
Dear All, I have Mysql server installed at remote site which i need to connect to. I have tried this from my local computer but didn't work; c:\mysql\bin>mysql -h myhost -u myusername -pmypassword I will also like to use LOAD command to load a text file from my local computer to the database o

RE: [PHP] Problem connecting to mysql via odbc

2001-11-30 Thread Andrew Hill
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,

Problem connecting to mysql via odbc

2001-11-29 Thread mweb
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 M

connecting to mysql

2001-11-24 Thread Ricardo Striquer Soares
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

error while connecting to mysql

2001-11-18 Thread guillaume Membré
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 s

Re: Trouble connecting to MySQL server using MySQLGUI and VCC

2001-09-01 Thread Sinisa Milivojevic
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

Re: Trouble connecting to MySQL server using MySQLGUI and VCC

2001-08-31 Thread Chris Johnson
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

Trouble connecting to MySQL server using MySQLGUI and VCC

2001-08-30 Thread Robert Anderson
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

  1   2   >