3 7
5 9
5 3
4 9
then the answer is 2 5 3 7
Is there a way to write a stored procedure ( or another way ) in order to
get this connectivity ( get the path from id = 2 to id = 7 ) ?
Don't know if it makes things easier but we can stop searching if the depth
of connectivity is more than 5...
Thx,
Konstantin
Hello.
> I'm trying to initialize to a database
Does this mean that you're unable to connect to MySQL Server? What
error message does mysql command line client report ? You said you were
able to telnet to 3307 port - have you seen the MySQL protocol messages
(usually seems like a garbage
I'm trying to initialize to a database on another server from a mail server. I
can telnet to it but cannot initialize the database.
The account and user exists in the database and the paasword as I've tried it
from the mysql server.
Is there another test I can do to find out exactly what is caus
2005/11/8, prathima rao <[EMAIL PROTECTED]>:
> hai all , im using mysql 4 version
>
> we are trying to connect inter units thriugh VPN will my database work and
> how?
You just need to open the port 3306 on your firewall. No other step
should be requiered.
>
>
> p rao
>
>
> --
> MySQL General M
hai all , im using mysql 4 version
we are trying to connect inter units thriugh VPN will my database work and
how?
p rao
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
Hiu Yen Onn wrote:
> hi all,
>
> i have a mysql which only localhost can be logged in. if i have created
> an account [EMAIL PROTECTED], then, i cant login in as that host.
> mysql -u user -h mymach
hi all,
i have a mysql which only localhost can be logged in. if i have created
an account [EMAIL PROTECTED], then, i cant login in as that host.
mysql -u user -h mymachine.com -p
ERROR 2003 (HY000) Cant connect to the MySQL server on 'x.x.x.x' (111)
please advise. thanks
--
MySQL General Ma
Hi again,
This is intresting, the documentation indeed mentions that mysql_ping
indicates "Zero if the connection to the server is alive" and not that
"zero if the server is alive", as I *naturally expected* also, so it
is kind of tricky this one. I would expect the same behavior with Unix
socket
Hello.
I've found that mysql_ping doesn't work properly with TCP connection (in
your test case you put the hostname to "127.0.0.1"). My program was
working with "localhost" - connection through the Unix socket. You may
want to add you comments to my bug report at:
http://bugs.mysql.com/bug
I did some extensive testing and it looks like that only the first
mysql_ping () fails to reconnect or very possibly returns the wrong
result. I am currently using v4.1.14.
Regards,
Lefteris
Begin
MySQL is up and running
Restart MySQL and hit
Hi,
I have just tried your routine, I use something very similar, (I have changed
the "localhost" to 127.0.0.1 so it will not use the pipeline) but I am still
expiriencing the same exact problem, weather reconnect is set or not, the
error remains the same. That is what got me wondering in the fir
Hello.
In my opinion it depends on the value of reconnect flag (the part of
MYSQL structure). I've written a simple program which connects to MySQL
server,
waits a bit and executes mysql_ping. While it is waiting, MySQL server
is being restarted. If mysql.reconnect = 1, mysql_ping() returns
Hi,
Is mysql_ping () suppose to restore a db connection even after a db restart?
Thnx,
Lefteris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Seena Blace <[EMAIL PROTECTED]> wrote:
> I wanted to setup connectivity between mysql database and oracle database.I have one
> database in mysql from which all tables data I want to insert real time data into
> oracle database.How to connect mysql database with oracle database
would need to periodically poll the MySQL server for changes and
duplicate them into your Oracle server.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Seena Blace <[EMAIL PROTECTED]> wrote on 09/01/2004 12:30:12 PM:
> Hi,
>
> I wanted to setup connectivit
: Seena Blace; [EMAIL PROTECTED]
Sent: 9/1/04 11:30 AM
Subject: Re: Database connectivity
Hi,
I wanted to setup connectivity between mysql database and oracle
database.I have one database in mysql from which all tables data I
want to insert real time data into oracle database.How to connect
Hi,
I wanted to setup connectivity between mysql database and oracle database.I have one
database in mysql from which all tables data I want to insert real time data into
oracle database.How to connect mysql database with oracle database?
thanks
Hi,
I wanted to copy setup some procedure which pickup data from mysql and load into
oracle database.How to do this?
I would also like to know how to establish a connection between mysql and oracle
database?
thanks
-
Do you Yahoo!?
Win 1 of 4,00
Hi,
I have one mysql database and one oracle database.I want to fetch data from mysql db
to oracle db in realtime.How to do this?
I also wanted to tarnsfer 14 tables from one mysql database to Oracle how to do this?
thanks
-
Do you Yahoo!?
New and
Jim <[EMAIL PROTECTED]> wrote:
> I'm just wondering if anyone can tell me exactly what happens when one
> is using the mysql client on a remote server and the connection to that
> server (in this case over ssh) gets dropped.
if your ssh session suddenly closes, the only thing that happens is th
When a connection is dropped most read only queries will be immediatly
dropped, write queries such as your optimize table will continue until
they complete as not to corrupt any table data or leave anything
unfinished.
-Eric
On Mon, 28 Jun 2004 17:29:22 -0400, Jim <[EMAIL PROTECTED]> wrote:
>
>
Hi,
I'm just wondering if anyone can tell me exactly what happens when one
is using the mysql client on a remote server and the connection to that
server (in this case over ssh) gets dropped.
In this case, I was in the midst of a long OPTIMIZE TABLE. Stepped out
to get some coffee and the ssh
AIL PROTECTED]
Onderwerp: RE: [Mysql-discussions] SQL CONNECTIVITY
Remko,
is any parameters value do you want me change in php.ini file?
which package do you want to install from redhat pl?
Remko Lodder <[EMAIL PROTECTED]> wrote:
That would be good,
But installing php does not mean that mysq
Seena Blace
Verzonden: vrijdag 30 januari 2004 17:44
Aan: [EMAIL PROTECTED]
Onderwerp: RE: [Mysql-discussions] SQL CONNECTIVITY
I installed php.
what is linux9? =RED HAT 9
aCTUALLY i WANT TO develop smal webbased application.I was thinking
PHP,MYSQL,APACHE AND LINUX WOULD BE good,but any
libraries installed by MySQL, thus avoiding any conflicts.
Marc.
-Message d'origine-
De : Seena Blace [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 30 janvier 2004 17:44
À : [EMAIL PROTECTED]
Objet : RE: [Mysql-discussions] SQL CONNECTIVITY
I installed php.
what is linux9? =RED HAT 9
aCT
community for helping newcomers on the
hackerscene
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Seena Blace
Verzonden: vrijdag 30 januari 2004 17:44
Aan: [EMAIL PROTECTED]
Onderwerp: RE: [Mysql-discussions] SQL CONNECTIVITY
I installed php.
what is linux9? =RED HAT 9
[EMAIL PROTECTED] Seena Blace
Verzonden: vrijdag 30 januari 2004 17:12
Aan: [EMAIL PROTECTED]
Onderwerp: [Mysql-discussions] SQL CONNECTIVITY
Hi all,
I have been noticing following error message with PHP.
Fatal error: Call to undefined function: mysql_connect()
Let me know how to fix that.I have ins
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Seena Blace
Verzonden: vrijdag 30 januari 2004 17:12
Aan: [EMAIL PROTECTED]
Onderwerp: [Mysql-discussions] SQL CONNECTIVITY
Hi all,
I have been noticing following error message with PHP.
Fatal error: Call to undefined function: mysql_connect()
Let me
Hi all,
I have been noticing following error message with PHP.
Fatal error: Call to undefined function: mysql_connect()
Let me know how to fix that.I have installed linux9,apache 2.0, php.
thx -seena
-
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building t
i installed
1. MySQL 3.23---Production release(recommende),
2. Windows 95/98/NT/2000/XP 3.23.55 13.co3M,
3. Windows Source(zip) 3.23.55 13.2M
4. Control Center,
in my PC.
I created a testDB from Control Center, Added it and message shows as 'Connection
added successfully' but
its property
Can anyone plz help.
Is database connectivity between Mysql (Linux) and Visual C++ posible, which
has to be achived from a remote server.
How can I achive this functionality.
TIA
-
Before posting, please check:
http
Hello Group:
Please tell me, will MySQL work with a Paradox 9 client?
Regards,
David Hofer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archiv
Recently, something happened on my system that I'm not sure I could ever
explain. I'm curious if the expertise of the list might be able to help me
out. Please speak layman terms, as I'm forced to jump in this without
testing the waters...
I was working fine with MSAccess 97 to MySQL (ver 3.23.3
Well, you could have the Canadian admin add your pakistan IP
address/host to the "mysql" database in the "hosts" table, along with
the proper "user" and "db" I'm sure. Then you can use any 3rd party
mySQL client to connect and do whatever you want.
Something I just did recently is to install phpMy
Hi,
I have MySQL 3.23.36 on my web server somewhere in Canada, while I live
in Pakistan. I want to connetc to my database out there and use a query
to download all the data from that mysql db to my own mysql db.
I know myql uses 3306 as the port and when i try telnet on my own LAN
it works fine,
Dear Sir,
When Iam trying to connect remote mysql database Using JSP on LINUX Os it is
giving an error...
Remote system is Windows NT.
java.sql.SQLException: Communication link failure: Bad handshake
I loaded
1).MySQL-3.23.40-1.i386.rpm
2).MySQL-client-3.23.40-1.i386.rpm
files in to my syst
Dear Sir/madam,
we are able to connect Mysql database using JSP in Linux RedHat-6.2
OS (with out using user and password).
when we are trying to connect using user and password it was not able to
connect.
We wrote code like this
String DBUrl =
"jdbc:mysql://localhost:3306/database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
naveed abdul wrote:
|
|
| Dear Sir/madam,
| we are able to connect Mysql database using JSP in Linux RedHat-6.2
| OS (with out using user and password).
|when we are trying to connect using user and password it was not able
| to connect.
|
|
Dear Sir/madam,
we are able to connect Mysql database using JSP in Linux RedHat-6.2 OS
(with out using user and password).
when we are trying to connect using user and password it was not able to
connect.
We wrote code like this
String DBUrl =
"jdbc:mysql://localhost:3306/database
I am having problems connecting to the mysql databse from a Java application in
Windows 2K, I am using JDBC and have the mySQL odbc software installed. I am running
mysql from the command line prompt in Windows 2k. I fear I may be doing something
wrong, if anyone has a step by step solution, i
On Saturday 27 October 2001 10:10, shanmukha rao balla wrote:
> i had set proper classpath for jdbc drivers and my username ,
> password and database name,port no also correct. i am able to
> connect to mysql server using that username,password at COMMAND
> line. but while connecting to database
Hi friends,
i installed Mysql 3.23.36 in my Red Hat 7.1 system.
i am using "mm.mysql-2.0.6.1.jar" jdbc driver for connceting to my mysql database.
my program is:
import java.sql.*;
public class TestMysql
{
public static void main(String[] Args)
{
try {
confused... and waiting for additional suggestions.
Alexandre
-Original Message-
From: Venu A [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 7:22 PM
To: SIMONIN Alexandre
Subject: RE: *** HELP *** mySQL connectivity problems
As a small trial, is the server up and running
2001 6:46 PM
To: SIMONIN Alexandre; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Mysql. Com Java@Lists.
Subject: RE: *** HELP *** mySQL connectivity problems
Check the following link, which has the simple MyJDBC sample to connect to
MySQL server and to do some basic operations.
http://lists.mysql.com/cgi
> -Original Message-
> From: SIMONIN Alexandre [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 9:33 AM
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Subject: FW: *** HELP *** mySQL connectivity problems
>
>
>
>
> > -Original
> -Original Message-
> From: SIMONIN Alexandre
> Sent: Monday, July 30, 2001 2:41 PM
> To: '[EMAIL PROTECTED]'
> Subject: *** HELP *** mySQL connectivity problems
>
> Hi,
>
> I'm running mySQL 2.0.4 and Tomcat 4.0 on Cob
.
regards
shane
-Original Message-
From: Kalpesh Modha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 5:00 PM
To: 'raghavan'; [EMAIL PROTECTED]
Subject: RE: jdbc connectivity
Hello.
I have the same problem let me know if you find a solution. Mine is on
redhat 7.1
Hello.
I have the same problem let me know if you find a solution. Mine is on redhat 7.1
Thanks
Kal
-Original Message-
From: raghavan [SMTP:[EMAIL PROTECTED]]
Sent: 18 July 2001 06:47
To: [EMAIL PROTECTED]
Subject:jdbc connectivity
Hi,
I am trying to connect mysql
Hi,
I am trying to connect mysql database to java program, I am using
org.gjt.mm JDBC driver.
I have username and password in USER table and host is that "%" , connect
from anywhere.Driver is loading but
its saying "access denied,@uable" something like this
could anyone help me.
regards
ragha
I seem to have a connectivity problem that I'm having trouble diagnosing.
I have an internal network (192.168.0.*) with mysql running fine on machine
"A". The outside world can get to A fine, and ordinarily so can machine
Bhowever randomly and more often, I cannot log into
server to enable connectivity to the db server?
Should I be able to initiate the mysql client on the app server and
connect to the db server on the first box?
Is there a way to verify the connectivity independent of the app server
[EMAIL PROTECTED] writes:
> Hello Sir ,
> I have RedHat Linux7.0 . I install MySql-3.23.36 . By using C++ I am trying to
>coonect to database . I use C++ wrapper classes for the same which in build uses the
>Mysql++ API.I can compile and also link the programe.
> And when I run th
Hello Sir ,
I have RedHat Linux7.0 . I install MySql-3.23.36 . By using C++ I am trying to
coonect to database . I use C++ wrapper classes for the same which in build uses the
Mysql++ API.I can compile and also link the programe.
And when I run that programe if i give the command
Sanjeev Kabra wrote:
>
> Hi,
>
> I installed MyODBC and even configured it. MySQL db running on Solaris is
> running under the root user. While defining the DSN using MyODBC in the
> username I tried putting root user and the password for the same but I keep
> getting error "can't connect to MyS
-
From: Quentin Bennett <[EMAIL PROTECTED]>
To: 'Sanjeev Kabra' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 6:45 PM
Subject: RE: Connectivity to MySQL DB
> Hi,
>
> You don't need a special process - the MySQL ODBC driver talks directl
Hi,
You don't need a special process - the MySQL ODBC driver talks directly to
the mysqld already running on Solaris.
Regards
Quentin
-Original Message-
From: Sanjeev Kabra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 31 January 2001 11:58
To: [EMAIL PROTECTED]
Subject: Connectivi
Hi Everybody,
I have installed MySQL on Solaris and have even setup the connectivity using MyODBC on
windows. I would like to know what I have to execute on Solaris like listener process
for Oracle so that when I connect from windows environment I can connect to the
database running on
57 matches
Mail list logo
