I have Linux box running Red Hat and 3.23. I install MySQL Contorl
Center and trying connect to the mysql on Linux box.
When I try to connect I receive the error message.
ERROR: HOST 'ip address' is not allowed to connect to this MySQL server.
What I'm doing wrong here?
TH
--
MySQL General Ma
Every new connection is considered a client. It's a bad idea to try to
do your own scheduling client side to try to defeat table locks
because MySQL can proceed with other clients as soon as the locks are
freed vs your application waiting for a complete result set to return
before proceeding
h. It will
also wait for the first SELECT to finish!"
So what constitutes a new client exactly? We use Perl and DBI to connect to MySQL.
Does this mean that everytime we connect to the DBase it is considered a new client?
If so , would some form of connection pooling/caching help reduc
;http://dev.mysql.com/doc/mysql/en/Password_hashing.html>.
Michael
Steve Grosz wrote:
I am trying to set up a ODBC connection from a Coldfusion server to
a MySql server, both running on Windows2003 Servers. I installed
the ODBC 3.51 driver on the Coldfusion server, and am trying to make
the connection.
When
7;m a little confused here.
Steve
Michael Stassen wrote:
See the manual <http://dev.mysql.com/doc/mysql/en/Password_hashing.html>.
Michael
Steve Grosz wrote:
I am trying to set up a ODBC connection from a Coldfusion server to a
MySql server, both running on Windows2003 Servers. I instal
to set up a ODBC connection from a Coldfusion server to a
MySql server, both running on Windows2003 Servers. I installed the
ODBC 3.51 driver on the Coldfusion server, and am trying to make the
connection.
When I go to set up the ODBC link and say 'test data source' I get a
message that say
See the manual <http://dev.mysql.com/doc/mysql/en/Password_hashing.html>.
Michael
Steve Grosz wrote:
I am trying to set up a ODBC connection from a Coldfusion server to a
MySql server, both running on Windows2003 Servers. I installed the ODBC
3.51 driver on the Coldfusion server, and am
I am trying to set up a ODBC connection from a Coldfusion server to a
MySql server, both running on Windows2003 Servers. I installed the ODBC
3.51 driver on the Coldfusion server, and am trying to make the connection.
When I go to set up the ODBC link and say 'test data source
trying to see if I can identify
the failure from the host end.
1) I have restarted safe_mysqld with the warning option "--warnings". I
can see the server.log shows aborted client errors, but not aborted
connection errors. How do I get the aborted connection errors to display
in the l
identify
the failure from the host end.
1) I have restarted safe_mysqld with the warning option "--warnings". I
can see the server.log shows aborted client errors, but not aborted
connection errors. How do I get the aborted connection errors to display
in the logs? ( see approx
I'm trying to import data in a sparsely populated table
from a text file. I've attempted this with mysqlimport
and the LOAD DATA command. In each case I get an
ERROR 2013: Lost connection to MySQL server during
query. My tables are InnoDB type and the database
is small. I'm runni
> Ok, I thought that I will be misunderstood...
>
> I'll try to explain this in example below:
>
> I have table
>
> CREATE TABLE `product_descriptions` (
> `id_product_description` mediumint(8) unsigned NOT NULL auto_increment,
> `id_product` mediumint(8) unsigned NOT NULL default '0',
>
> which user I was when was attempting to execute this php script through
> the browser, so I check my mysqld.log file and it claims I should be
> '[EMAIL PROTECTED]', so I setup this user in the mysql database.
>
> I tried adding
> $dbuser = 'nobody';
> $d
[snip]
$dbhost = 'localhost';
[/snip]
Try changing this to 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
EMAIL PROTECTED]', so I setup this user in the mysql database.
I tried adding
$dbuser = 'nobody';
$dbpass = '';
to the script but to no avail even though I can access through the
command prompt with with a password.
When I do a the results show a --port=3306 as
well
Hi Jeremy,
>> P.S2 I store data in one table which has no default collation set only
>> UTF-8 charset. In
>> this table I can have data in different collations.
> Every table does have a default collation either you specify it or it
> comes from the default collation for your database or the ser
> P.S2 I store data in one table which has no default collation set only
> UTF-8 charset. In
> this table I can have data in different collations.
Every table does have a default collation either you specify it or it
comes from the default collation for your database or the server
default. You n
ect succesfully:
C:\mysql\bin>mysqlc -u root -p
Enter password: *
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31368 to server version: 4.0.20a-nt
Type 'help' for help.
mysql> \q
Bye
Without -h, you connect via unix socket to the
tadmin
Enter password: *
ERROR 1130: Host 'netadmin.kptc.org.zw' is not allowed to connect to
this MySQL
server
But if I try it without the host parameter I connect succesfully:
C:\mysql\bin>mysqlc -u root -p
Enter password: *
Welcome to the MySQL monit
Hi,
I have a problem setting default collation for each connection. I have multilanguage
site and I don't want to add COLLATE statement to every SQL - I could set it once
during PHP startup and forget about it... But there's a problem.
I tried to do
SET names &#
See http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
You are interested in "interactive_timeout" and "wait_timeout"
system variables.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__
"Phillip Mangwiro" <[EMAIL PROTECTED]> wrote:
> I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this
> machine"), whenever I try to connect to MySQL server from any client by
> using its IP or "friendly" DNS name other than 127.0.0.1 or localhost.
> This has happened on three m
Hi,
I have a web application with servlets and jsp's. I use a connection pool to
optimize connections to database.
Usualy all works fine but sometimes, after a period of inactivity (30-50
minutes), connections are lossed. This only occurs if mysql and web server
are in different machine
I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this
machine"), whenever I try to connect to MySQL server from any client by
using its IP or "friendly" DNS name other than 127.0.0.1 or localhost.
This has happened on three machines so far, is there something I forgot to
enable/d
Marten Lehmann <[EMAIL PROTECTED]> wrote:
> Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client).
OKay, here's the problem - a self-built MySQL. Unfortunately, due to
some glibc bugs it's not really possible to build a stable MySQL
under linux using stock glibc...
And the pro
be a resolver problem? The error
messages says "lost connection _during_ query", this means that the
connection is already established, so obviously the resolver already did
it's job to find out the ip-address of the mysql-server. And anyway: I
used bind-address before and it worked. I j
Marten Lehmann <[EMAIL PROTECTED]> wrote:
> I'm experiencing a strange thing: When bind is running without
> "bind-address" everything works fine. But when I'm doing a "bind-address
> = ..." the clients get "Lost connection to MySQL server dur
Hello,
I'm experiencing a strange thing: When bind is running without
"bind-address" everything works fine. But when I'm doing a "bind-address
= ..." the clients get "Lost connection to MySQL server during query". I
don't understand this, because
Hi folks, Im dying here slowly. Can anyone tell me what an =
SqlState 08000 (connection exception) REALLY MEANS Is it as obvious =
as I think it is, Im NOT CONNECTED to MySQL, and if so, why not =
08003 (connection does not exist)...
I have a major problem, Im running Windows 2000
[EMAIL PROTECTED]
> Sent: 25 August 2004 19:28
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL Secure Connection(e.g. SSL) Question
>
>
> FYI, DBD::MySQL does support SSL. See
>
> http://search.cpan.org/~rudy/DBD-mysql-2.9004/lib/DBD/mysql.pm
>
> and search f
t;Joshua J. Kugler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 25, 2004 8:25 PM
Subject: Re: MySQL Secure Connection(e.g. SSL) Question
> Something else to check out is Stunnel. It creates SSL tunnels between
hosts
> without requiring logins (b
ay, August 24, 2004 11:12 AM
Subject: RE: MySQL Secure Connection(e.g. SSL) Question
> > I need to connect to a remote MySQL database from a PC using
> > SSL. I would
> > prefer to connect using perl DBD. Does anyone have a
> > suggestion how I can
> > accomplish
Something else to check out is Stunnel. It creates SSL tunnels between hosts
without requiring logins (basically port redirection). Also, MySQL has built
in SSL now, so you might want to look at that.
j- k-
On Wednesday 25 August 2004 08:10 am, [EMAIL PROTECTED] said something like:
>
Something else I have done in the past was to use Cygwin to create an SSH
session with the remote computer and use the remote computer's MySQL
client/tools.
If you are used to working in a "Terminal Server" session (I think they
now call it "Remote Desktop Connectivity") it will feel very famil
> I need to connect to a remote MySQL database from a PC using
> SSL. I would
> prefer to connect using perl DBD. Does anyone have a
> suggestion how I can
> accomplish this task or an alternative solution?
What about stunnel or ssh tunnels and then use DBD::mysql on top.
ISTR that DBD::mysql c
Does anyone know whether it is possible to override the MySQL connection
variables used in a PHP script? I use Plesk and want it to use a
database that is located on an external server, but I cannot edit the
variables as Plesk is closed source?
Joel Moss
HomepageUniverse.com
--
MySQL General
I need to connect to a remote MySQL database from a PC using SSL. I would
prefer to connect using perl DBD. Does anyone have a suggestion how I can
accomplish this task or an alternative solution?
Thank You
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
.
Is there a C based connection pooling thingamabob I can use, like mysql_pconnect, and
some
external demon of some kind to assist?
Thanks in advance for any help. I can find tons of stuff for perl/web based stuff,
but I need
it for C.
Thanks.
--
MySQL General Mailing List
For list
Paul,
Interesting: I just tested your DSN-Less connection info. (including
port 3307) from my web server to another machine running mysql and it
connected fine - but only the first time. I used the IP address for my
SERVER variable. Then I changed it to the FQDN and it failed with the
same
Hi
Try doing a "response.write conn" after you have made a connection with the
DSN
that should print out the connection string the DSN is using
i hope this help debug the problem
Nickolai
Paul Stearns wrote:
> Actually I can connect from the web server to the DB server using
DB server using DSN (the odbc tool
under windows). What I cannot do is connect from ASP in the same way.
I have a work around, but I still would like to determine what the problem is with a
DSNless connection.
The work around is to use a DSN entry and call it, for example;
conn.open &quo
othesis is that the odbc driver is confusing (or ignoring)either the ip
address or port # for the local mysql DB with what I want for the remote.
Paul
-Original Message-
From: Armando [EMAIL PROTECTED];]
Sent: 8/15/2004 11:35:44 PM
To: [EMAIL PROTECTED]
Subject: RE: ASP Connection to My
Actually I can connect from the web server to the DB server using DSN (the odbc tool
under windows). What I cannot do is connect from ASP in the same way.
I have a work around, but I still would like to determine what the problem is with a
DSNless connection.
The work around is to use a DSN
I telnet to port 3307 on the DB server from the web server I get the version, a
few characters of garbage and it disconnects.
Paul
-Original Message-
From: Paul Stearns [EMAIL PROTECTED];]
Sent: 8/15/2004 6:01:59 PM
To: [EMAIL PROTECTED]
Subject: ASP Connection to Mysql fails
I have an ASP
]
Subject: ASP Connection to Mysql fails
I have an ASP application running on a server with a mysql DB, everything works great.
I connect using localhost, no problems.
I have a second mysql DB on another server. I connect to it via the odbc Data Source
Administrator from the web server with no
I have an ASP application running on a server with a mysql DB, everything works great.
I connect using localhost, no problems.
I have a second mysql DB on another server. I connect to it via the odbc Data Source
Administrator from the web server with no problems.
When I try to connect from an A
Michael Stassen wrote:
What hardware and OS?
How did you get and install mysql? MySQL supplied binary? 3rd party
binary? Built from source? If the answer is not "MySQL supplied
binary", my first suggestion would be to try that to see if the problem
goes away.
Michael
That did end up being the
Michael Stassen wrote:
What hardware and OS?
Pentium II 300, 192 MB RAM, almost-brand-new 80GB hard drive, running Gentoo
Linux (kernel 2.4.25-gentoo).
How did you get and install mysql? MySQL supplied binary? 3rd party
binary? Built from source? If the answer is not "MySQL supplied
binary",
he "ERROR 2013: Lost connection to MySQL server during query" error.
This happens to me using both version 4.0.18 and 4.0.20 (I was running .20
and downgraded to .18 to see if that fixed the problem. It didn't, but I
haven't upgraded back to .20 again yet.)
So for instance, after star
and I
get the "ERROR 2013: Lost connection to MySQL server during query" error.
This happens to me using both version 4.0.18 and 4.0.20 (I was running .20
and downgraded to .18 to see if that fixed the problem. It didn't, but I
haven't upgraded back to .20 again yet.)
So for i
nt
> and accesses the database like that.
>
> What I'm wondering is if there is a cleaner and simpler way, for
> example to set up some sort of proxy server on host X that will
> establish a connection with the mysql database and then relay
> requests and responses ba
On 8 Aug 2004 at 20:04, Steve Leibel wrote:
> What I'm wondering is if there is a cleaner and simpler way, for
> example to set up some sort of proxy server on host X that will
> establish a connection with the mysql database and then relay
> requests and responses back and fo
impler way, for
example to set up some sort of proxy server on host X that will
establish a connection with the mysql database and then relay
requests and responses back and forth to my code on host Y.
Thanks for any suggestions or pointers. The code I write will be Perl
or Java. I can write and ru
On Monday 02 August 2004 22:34, James Weisensee wrote:
> What does your '/etc/hosts' file contain? Sounds like
> it may have the following entry:
>
> 127.0.0.1 localhost.localdomain
>
> change it to:
>
> 127.0.01localhost
Actually, it has
127.0.0.1 localhost.localdomain localhost
From mysql's point of view, localhost and 127.0.0.1 are not the same thing.
When you connect with
mysql -h localhost -u root -p
or simply
mysql -u root -p
(localhost is the default), you are connecting via unix socket, so the
user=root, host=localhost entry is used. When you connect with
What does your '/etc/hosts' file contain? Sounds like
it may have the following entry:
127.0.0.1 localhost.localdomain
change it to:
127.0.01localhost
or
Yes, add 'localhost.localdomain' to mysql.user
another option, Why not just SSH to 'daisy' and issue:
shell> mysql -u root -p
a
PROTECTED]>,<[EMAIL PROTECTED]>
Subject: Help understanding how the connection works
Date: Tue, 3 Aug 2004 02:10:56 +0100
Hi ppl,
Im trying to access to mysql server by telnet. When I do like telnet
localhost 3306 if I write something the error is Bad handshake. Well can
anyone tell me
Hi folks,
Now that I can connect to my MySQL server using the Unix sockets (e.g.
[EMAIL PROTECTED] ~] mysql -u root
I'm moving on to the next step - connecting via TCP/IP.
Since I don't have physical access to the box (well, I'm just too lazy to walk
down to the basement), I SSH into the box
Hi ppl,
Im trying to access to mysql server by telnet. When I do like telnet
localhost 3306 if I write something the error is Bad handshake. Well can
anyone tell me what info do I need to send to the server to establish a
connection with mysql server? So I can execute some queries?
with username/host/whatever>
>I believe this was because I was trying to connect to MySQL 4.1.x with
>a 4.0.x client. I don't know if that's your case as well.
>http://dev.mysql.com/doc/mysql/en/Old_client.html
>Wes
>On Jul 28, 2004, at 6:21 PM, Keith Thompson wrote
MAIL PROTECTED]
Sent: Thursday, 29 July, 2004 3:17 PM
To: [EMAIL PROTECTED]
Subject: connection time is slow
[Could not convert from 'ks_c_5601-1987']
Hello.
I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server.
When connect from Linux to Windows, or from Window
[Could not convert from 'ks_c_5601-1987']
Hello.
I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server.
When connect from Linux to Windows, or from Window to Linux connection time is
very slow.
( it takes about 6 seconds)
But Linux to Linux or Windows to Windows
su" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 29, 2004 11:14 AM
Subject: Re: connection time is slow
> Hello Jungsu,
>
> What are the tools you're using to connect? Any client applications?
>
>
> Fred.
>
> Heo, Jungsu wrote:
>
Hello Jungsu,
What are the tools you're using to connect? Any client applications?
Fred.
Heo, Jungsu wrote:
>Hello.
>
>I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server.
>
>When connect from Linux to Windows, or from Window to Linux connection t
Hello.
I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server.
When connect from Linux to Windows, or from Window to Linux connection time is very
slow.
( it takes about 6 seconds)
But Linux to Linux or Windows to Windows Fast.
Anybody has an Idea?
Thank you for advanced a
html
Wes
On Jul 28, 2004, at 6:21 PM, Keith Thompson wrote:
I have a mysql connection problem that I'm trying to understand.
The three servers and the version of mysql they are running (all under
Solaris9) are:
db1 - 4.0.16
db2 - 4.0.17
db3 - 4.1.3
All three systems have the same mysql u
I have a mysql connection problem that I'm trying to understand.
The three servers and the version of mysql they are running (all under
Solaris9) are:
db1 - 4.0.16
db2 - 4.0.17
db3 - 4.1.3
All three systems have the same mysql user and passwords setup. I'll
use the mythical user
PROTECTED] '
> Sent: 7/28/04 4:35 PM
> Subject: RE: connection problems
>
> Yes I have. The hostname of the box returned with 'hostname' is the
> fqdn and is in the format of blah.1.2.3.net.
>
> Drew
>
> On Wed, 2004-07-28 at 17:16, Victor Pendleton w
This is a local connection.
Thanks again!
Drew
On Wed, 2004-07-28 at 17:33, Victor Pendleton wrote:
> My apologies I was reading an ip address. Have you tried logging in from the
> server itself? Since this is the initial install I think root needs to log
> in from the
PM
Subject: RE: connection problems
Yes I have. The hostname of the box returned with 'hostname' is the
fqdn and is in the format of blah.1.2.3.net.
Drew
On Wed, 2004-07-28 at 17:16, Victor Pendleton wrote:
> Can you check the host name again? You have a five segment address.
>
> From: Andrew Hall
> To: [EMAIL PROTECTED]
> Sent: 7/28/04 3:55 PM
> Subject: connection problems
>
> Greetings,
>
> I have what I hope is an easy problem. I have installed mysql 4.0.20
> and when I execute mysqladmin to set the root password using the -h flag
>
Can you check the host name again? You have a five segment address.
-Original Message-
From: Andrew Hall
To: [EMAIL PROTECTED]
Sent: 7/28/04 3:55 PM
Subject: connection problems
Greetings,
I have what I hope is an easy problem. I have installed mysql 4.0.20
and when I execute
Greetings,
I have what I hope is an easy problem. I have installed mysql 4.0.20
and when I execute mysqladmin to set the root password using the -h flag
my hostname is truncated, and I get a connection refused message.
The hostname on this box is a fqdn like blah.1.2.3.net. My command line
is
> Hi All
> Could someone give me a clue or a snippet of PHP code I can test a romte
> connection to my MySQL DB for my website please?
Just take the one you're currently using and replace 'localhost' with
'someotherserver.com'
$cnx = mysql_connect(&#
Hi All
Could someone give me a clue or a snippet of PHP code I can test a romte
connection to my MySQL DB for my website please?
Thank you
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Victor Pendleton wrote:
What error messages are you receiving?
-Original Message-
From: Peter Bruggink
To: [EMAIL PROTECTED]
Sent: 7/16/04 3:19 AM
Subject: [CONNECTION PROBLEMS]
To have a better performence I have installed a new server running
solaris8 and mysql version 3.23.53. The
What error messages are you receiving?
-Original Message-
From: Peter Bruggink
To: [EMAIL PROTECTED]
Sent: 7/16/04 3:19 AM
Subject: [CONNECTION PROBLEMS]
To have a better performence I have installed a new server running
solaris8 and mysql version 3.23.53. The old server is running
To have a better performence I have installed a new server running
solaris8 and mysql version 3.23.53. The old server is running solaris 7
and mysql 3.23.48-max.
I also transferred the database to the new server and tried to connect
the database with mysql front. Everything worked fine.
Then I
Hello,
Is there any way to fix a connection of replication
from slave host when user on slave host noticed
that the connection of replication had been lost?
Now I have a following environment.
MySQL Master server <== replication ==> MySQL Slave server
Both server has
Turbo Linux
i'm trying to get a better understanding of how to implement persistent
connections with mysql in either perl/php
basically i'm trying to solve the issue of whether a web app has to
essentially perform a new mysql_connect on every page that's going to be
doing any database access.
using mysql_con
> I am running Debian sarge with MySQL 4.0.20. My problem is I can
> connect from localhost, but when I try to connect from other host this
> error comes up:
> ERROR 2013: Lost connection to MySQL server during query
Sorry I found the answer. I have ALL:ALL in hosts.deny
--
M
Hi,
I am running Debian sarge with MySQL 4.0.20. My problem is I can connect
from localhost, but when I try to connect from other host this error
comes up:
ERROR 2013: Lost connection to MySQL server during query
I tried from many clients, included MySQL 4.0 and MySQL 3.23, but they
all got same
Hi,
Add
skip-log-warnings
in your my.cnf. log-warnings seems to have been enabled by default since
4.0.19.
Regards,
Jocelyn
- Original Message -
From: "Don MacAskill" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 08, 2004 11:29 AM
Subject: Ab
I just switched from 4.0.18-max to 4.0.20-max on AMD64 and I'm getting
tons of these in my error log:
040708 2:24:12 Aborted connection 65531 to db: 'db' user: 'user' host:
`10.1.1.27' (Got an error reading communication packets)
When I switch back to 4.0.18-ma
db ("DATABASE");
> or die(mysql_error());
>
> which may tell you more - I suspect a permissions
> problem if it works on a
> local server
>
> If you are switching from a Windows machine to Linux
> remember to watch for
> case sensitivity problems.
OK, tha
m a Windows machine to Linux remember to watch for
case sensitivity problems.
HTH
Peter
> -Original Message-
> From: David Blomstrom [mailto:[EMAIL PROTECTED]
> Sent: 27 June 2004 20:49
> To: [EMAIL PROTECTED]
> Subject: Database Connection Questions
>
>
> I&
I'm previewing local pages with a database connection
that looks something like this:
@mysql_connect ("localhost" , "USERNAME" ,
"PASSWORD");
@mysql_select_db ("DATABASE");
I modified it for an online site and published it
online. But when I
Is the MySQL server running? What OS are you using?
-Original Message-
From: Angela Howley
To: [EMAIL PROTECTED]
Sent: 6/24/04 7:13 AM
Subject: connection error
Hi,
I have spent the last two days trying to configure PHP 4.3.7 & MySQL
4.0.20 - none of which is successful.
The err
Hi,
I have spent the last two days trying to configure PHP 4.3.7 & MySQL 4.0.20 - none of
which is successful.
The error I have on MySql is when I go to set the root password I am told
"connect to server at 'localhost' failed
error can't connect to MySql server on localhost 10061
check that
Hi,
I have installed mysql 4.0.18 on my debian box. I am
quite new to linux. mysql works fine with the command
line (mysql) and with apache/phpmyadmin too. But when
i try to connect from Windows or if i telnet from
Debian, i got:
Number of processes running now: 0
040622 21:27:33 mysqld restarte
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott D. Spiegler wrote:
> Hi,
>
> I tried doing what Rhino suggested by coping the jar
> file I downloaded to the jre\lib\ext folder where my
> jdk is installed. The only thing that was different on
> my system than what Rhino described is that my ha
Driver").newInstance();
}
catch(Exception e)
{
}
}
public DBConnector(String aDburl,String
aDbuser,String aDbpasswd)
{
this.dbuser=aDbuser;
this.dbpasswd=aDbpasswd;
this.dburl=aDburl;
}
public Connection getConnection () throws
SQLExcepti
"Rhino" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 16, 2004 6:14 PM
> Subject: Re: Why can't I make a connection?
>
>
>>
>> > 1. Have you installed a MySQL Java driver and is it
>> > accessible to the
>> > program?
>>
>> T
an benefit.
The rest of my reply is interspersed in your note
Rhino
- Original Message -
From: "Scott D. Spiegler" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Wednesday, June 16, 2004 6:14 PM
Subject: Re: Why can't I make a connect
Hi,
I am testing the following code that attempts to get a
DB connection, but I keep getting the following error:
database_test.DBConnector
SQLException: No suitable driver
SQLState: 08001
VendorError: 0
The code snippet is below. I know the DB I am trying
to connect to exists and that the
MySQL Version 3.23.52 on Red Hat Linux
Trying to establish an ODBC connection to the MySQL server from a windows 2000 server
and get the error:
"MySQL ODBC Driver ver 03.51.06"
"Lost Connection to MySQL server during query"
On the MySQL server, there is only one
Ok, it seems I fixed my problem before anybody was available to help me.
The error was due to bad code -- the program was trying to send multiple
queries through the same connection. Even though it was compiled as
"thread safe", you still have to find some way to prevent concurrent
Hi,
I am using the following code but not getting a
connection. :( Can someone tell me what I am doing
incorrectly?
Thanks, Scott
package database_test;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException
Hello all,
I'm getting the error message "2013 : Lost connection to MySQL server
during query" during inserts on a lightly-loaded mysql server. I also
noticed the following error in the error log...
Version: '4.0.20-standard-log' socket: '/tmp/mysql.sock'
Scott D. Spiegler said:
> I am trying to programatically connect to my DB, but I
> am not sure what the connection string should be. I am
> using this statement:
>
> conn =
>
> DriverManager.getConnection("jdbc:mysql://localhost/test?user=scott&password=cuatro"
601 - 700 of 1783 matches
Mail list logo
