Re: Connection speed

2003-11-06 Thread Daniel Kiss
ut it is still faster >> then from the local network. (Weird, isn't it?) >> >> >> Is there any chance to speed up the connection, because this is a >> critical issue to me. >> >> >> Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Connection speed

2003-11-06 Thread gerald_clark
the MySQL from the local network. It takes long time to connect from the internet as well, but it is still faster then from the local network. (Weird, isn't it?) Is there any chance to speed up the connection, because this is a critical issue to me. Thanks -- MySQL General Mailing Lis

Connection speed

2003-11-06 Thread Daniel Kiss
to connect from the internet as well, but it is still faster then from the local network. (Weird, isn't it?) Is there any chance to speed up the connection, because this is a critical issue to me. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Mysql Connection Problems

2003-11-04 Thread John
HI All I was wondering if anyone could tell me how to get around this problems Error: could not connect to the database. It's possible the database itself is just not working at the moment. The admin should also check that the database details have been correctly specified in config.php Database

Re: auto_increment with FOREIGN KEY UPDATE CASCADE courses Lost connection to MySQL server

2003-10-28 Thread Heikki Tuuri
ys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables [EMAIL PROTECTED]:~/mysql-4.0/client> mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.1

Re: auto_increment with FOREIGN KEY UPDATE CASCADE courses Lost connection to MySQL server

2003-10-28 Thread Victoria Reznichenko
vinita vigine MURUGIAH <[EMAIL PROTECTED]> wrote: > Hello, > I'm using ver 4.0.12, checked for bugs in ver > 4.0.12(http://bugs.mysql.com/search.php) but couldn't find this one. Thanks for report, but I wasn't able to repeat "Lost connection" error on

auto_increment with FOREIGN KEY UPDATE CASCADE courses Lost connection to MySQL server

2003-10-27 Thread vinita vigine MURUGIAH
| localMods | ++--+--+---+-+--+---+ | vi-3 | vim | 1.1 | 2003-10-28| www.test.com.au | NULL | NULL | ++--+--+---+-+--+---+ 1 row in set (0.00 sec) mysql>

Re: MYSQL Connection String error

2003-10-20 Thread gerald_clark
You need to grant privileges to 'root'@'127.0.0.1' because it is not the same thing as 'root'@'localhost'. Timotius Alfa wrote: Pls help me, I want to know if this connection string can be used for multi user, coz when I change "Server=local

MYSQL Connection String error

2003-10-19 Thread Timotius Alfa
Pls help me, I want to know if this connection string can be used for multi user, coz when I change "Server=localhost" with "server=127.0.0.1" it can not work. thanks Connect_Str = "Driver={MySQL ODBC 3.51 Driver};" & _ "SERVER=127.

RE: Connection Time Out

2003-10-15 Thread Uher, Jaroslav (E)
I have same problem ( ...timeouts.. variables are set >1000) - after 30 sec connection dies. This look like problem in client software 4.0.15 version (mysql, mysqlcheck,mysqldum...). When I used clients from 4.0.13 version, problem disapeared. (win distribution) Regards Jaroslav >-Or

Re: Connection Time Out

2003-10-14 Thread Randy Chrismon
Dathan Vance Pattishall wrote: Look at your wait_timeout and interactive_timeout settings. They may be set to a low value. If your connection sleeps for > these 2 vars mysql will disconnect you. - Dathan Vance Pattishall -->Subject: Connection Time Out --> --> -->Splain this

RE: Connection Time Out

2003-10-14 Thread Dathan Vance Pattishall
Look at your wait_timeout and interactive_timeout settings. They may be set to a low value. If your connection sleeps for > these 2 vars mysql will disconnect you. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40

Connection Time Out

2003-10-14 Thread Randy Chrismon
Splain this to me: I use my laptop to connect to the test-bed MySQL server residing on my desktop. Using this connection, I can do anything: load 200K lines, do complex (for me) queries, whatever. But, open a MySQL console connection _on the desktop_ where the MySQL server lives, I can't

"Lost connection to MySQL server during query" when try connect to MySQL

2003-10-12 Thread Heo, Jungsu
Hello, I got "Lost connection to MySQL server during query" from time to time when connecting to MySQL server. Using following PHP code, $this -> conn = mysql_connect( $host, $c_user,

Re: remote connection 4

2003-10-04 Thread Paul DuBois
At 22:55 +0200 10/4/03, Ms Carlsson wrote: when i try to connect to my mysql database from another machine i get a error like this %mysql -h domain.com -u tellus ERROR 2003: Can't connect to MySQL server on 'domain.com' (61) The port don't listen Apparently the MySQL server on domain.com is not r

remote connection 4

2003-10-04 Thread Ms Carlsson
when i try to connect to my mysql database from another machine i get a error like this %mysql -h domain.com -u tellus ERROR 2003: Can't connect to MySQL server on 'domain.com' (61) The port don't listen and this is disabled in my.cfg # #skip-networking whats wrong and how do i allow remote con

Re: Tomcat, Connection Pooling, and MySQL

2003-10-04 Thread Adam Hardy
o Dan Greene -Original Message- From: Steven Nakhla [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 9:42 AM To: MySQL Subject: Tomcat, Connection Pooling, and MySQL Has anyone managed to setup Tomcat to use MySQL for database connection pooling? I've found this docum

RE: Tomcat, Connection Pooling, and MySQL

2003-10-03 Thread Dan Greene
d the right one... Sorry that I'm being incredibly vague I set it up months ago Dan Greene > -Original Message- > From: Steven Nakhla [mailto:[EMAIL PROTECTED] > Sent: Friday, October 03, 2003 9:42 AM > To: MySQL > Subject: Tomcat, Connection Pooling, and MySQL >

Locked connection doesn't disconnect

2003-10-03 Thread Iago Sineiro
is called in Destroy event of main form in Delphi). But if the connection is locked by a query when I call the method Disconnect, the MySQL Server didn't disconnect the connection to the database. Any idea? Iago -- MySQL General Mailing List For list archives: http://lists.mys

Tomcat, Connection Pooling, and MySQL

2003-10-03 Thread Steven Nakhla
Has anyone managed to setup Tomcat to use MySQL for database connection pooling? I've found this document which gives information on it: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html However, when I try and run it I get messages about not being ab

Hung Threads and Connection Reset Error

2003-09-25 Thread Dan Symula
uot; error message. I got rid of this by changing the descriptors on the mac by typing (from shell) limit descriptors 2048. I also increased maxprocs by limit maxprocs 400. Open file issue went away... However, in its place I got a less nasty error, that did not knock over tomcat, "Connectio

RE: MySQL connection with PHP

2003-09-24 Thread Mike Klein
: and see what your configuration is. mike -Original Message- From: John Cole [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 10:44 AM To: [EMAIL PROTECTED] Subject: MySQL connection with PHP hello, i am learning PHP and MySQL recently, i use PHP to connect to MySQL server, h

Re: MySQL connection with PHP

2003-09-24 Thread Antony Dovgal
On Wed, 24 Sep 2003 18:44:06 +0100 (BST) John Cole <[EMAIL PROTECTED]> wrote: > "Fatal error: Call to undefined function: > mysql_connect() in /var/... on line 2" This error means, that you PHP was built without MySQL support. You need to add MySQL support or to ask your admin to do it. > PHP ver

MySQL connection with PHP

2003-09-24 Thread John Cole
hello, i am learning PHP and MySQL recently, i use PHP to connect to MySQL server, however, an error occur: "Fatal error: Call to undefined function: mysql_connect() in /var/... on line 2" Following is the PHP program: 1 "; 7 $result2 = mysql_list_tables($db_data[0]); 8 $num_rows2 = mysq

corrupt odbc connection in MS Access

2003-09-21 Thread Bob Ramsey
Has anyone seen something like this before: We have an Access database (about 9 megs in size) with linked tables in it. The machine DSN shows that the information for the connection is correct. But when you try to open the table in Access, a dialog pops up to connect to the mysql server and

Re: LOAD Fails on Lost Connection

2003-09-17 Thread Randy Chrismon
Egor Egorof said: > If I've got you right, you get "Lost connection" error when foreign key constraints is turn on? > Could you provide your table structure and some data for testing? Well, I designed the table with a foreign key constraint, then I disabled keys, tried to

Re: LOAD Fails on Lost Connection

2003-09-17 Thread Egor Egorov
; so, who knows? I will say, however, that if it > was a foreign key constraint issue, the error message sure was > mis-leading. If I've got you right, you get "Lost connection" error when foreign key constraints is turn on? Could you provide your table structure and some

Re: Connection and query on one line (newbie)

2003-09-16 Thread Kim Kohen
G'day Victoria > You can use mysql in a batch mode like: > mysql -e "LOAD_DATA_command_here" That's perfect, thanks. Exactly what I was looking for and now up and running. Cheers and thanks again kim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: LOAD Fails on Lost Connection

2003-09-16 Thread Randy Chrismon
I read the MysQL documentation re the Server Gone Away error but nothing there applied to my situation. On a whim, I re-created the table I was trying to import into but without the foreign key constraint (I had only disabled the foreign key constraint in the previous failed efforts). This time it

Re: Connection and query on one line (newbie)

2003-09-16 Thread Victoria Reznichenko
Kim Kohen <[EMAIL PROTECTED]> wrote: > > I'm trying to run a connection and query from one line (it will eventually > be called as part of a 'do shell script' Applescript on Mac OSX) > > The connection works fine: > /library/mysql/bin/mysql -uroot -ppass

Connection and query on one line (newbie)

2003-09-16 Thread Kim Kohen
G'day all I'm trying to run a connection and query from one line (it will eventually be called as part of a 'do shell script' Applescript on Mac OSX) The connection works fine: /library/mysql/bin/mysql -uroot -ppassword mydatabase And then I want to load a file using: load

Re: LOAD Fails on Lost Connection

2003-09-15 Thread Matt W
Hi Randy, See here: http://www.mysql.com/doc/en/Gone_away.html Maybe one of the queries in import_cash.sql is longer than max_allowed_packet? - Original Message - From: "Randy Chrismon" Sent: Monday, September 15, 2003 4:50 PM Subject: LOAD Fails on Lost Connection I

LOAD Fails on Lost Connection

2003-09-15 Thread Randy Chrismon
I've tried this several times: mysql> source c:/mysql/import_cash.sql with this error: ERROR 2013: Lost connection to MySQL server during query from the commandline, using: C:\mysql -u myname -pmy_password my_database < c:/mysql/import_cash.sql I get the same error. This happens

Re: connection error

2003-09-13 Thread Paul DuBois
created a user who can connect from anywhere as well as from localhost. I don't understand why this isn't working. Are you able to connect from the remote PC if you use the mysql client instead? Are you able to connect as this user when you try it from the server host? using mysql versi

Re: connection error

2003-09-13 Thread Fred van Engen
Robert, On Sat, Sep 13, 2003 at 08:08:48PM +1200, Robert Morgan wrote: > I have created a user grant all privileges on *.* to user@"%" > =>identified by ' pword' with grant option; > > and grant all privileges on *.* to [EMAI

connection error

2003-09-13 Thread Robert Morgan
well as from localhost. I don't understand why this isn't working. using mysql version 4.0.14 RH 9.0 DBtools pro on win2k Network connection is fine. Any help appreciated. Bob

RE: Unable to Create DB Connection

2003-09-10 Thread Scott D. Spiegler
Hi Dave, --- "Christensen, Dave" <[EMAIL PROTECTED]> wrote: > Did you set up a my.ini file in your Windows > directory? If so, what is in > the file? I found the problem about why I was not able to get my WinMySQLadmin tool to start the service. My my.ini contents are below this email the passwo

RE: Unable to Create DB Connection

2003-09-10 Thread Christensen, Dave
bject: RE: Unable to Create DB Connection Oh, right- I forgot to mention that. Part of the error message in trying to connect to the database said that it couldn't find the mysql.err file. I installed mySQL in C:\mysql but the error message from the DOS shell said it couldn't find the file: D

Re: Unable to Create DB Connection

2003-09-10 Thread Egor Egorov
created and contained appropriate information. But, > when I right-click with my mouse on the stop light > icon- to start the service- nothing happens. I tried > to ping the port that mySQL was supposed to be > listening at, and it said that the connection was > refused. > > So,

Re: Lost Connection to MySQL server during query

2003-09-09 Thread Matt W
PROTECTED]> Sent: Tuesday, September 09, 2003 10:36 AM Subject: Lost Connection to MySQL server during query > I have a script that is processing data from a single table and splitting it > into smaller normalized tables. > > > > The script takes anywhere between 5-10 minutes to co

Re: HELP PLEASE the weirdest error 2013 / connection ?

2003-09-09 Thread [EMAIL PROTECTED]
gt; To: <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 11:50 AM Subject: HELP PLEASE the weirdest error 2013 / connection ? > > Hi, > > this is the weirdest error I have ever encountered. > > We get an error 2013 lost connection when we try to connect via mysql to >

HELP PLEASE the weirdest error 2013 / connection ?

2003-09-09 Thread [EMAIL PROTECTED]
Hi, this is the weirdest error I have ever encountered. We get an error 2013 lost connection when we try to connect via mysql to another machine having mysql on it as well. The weird part is that when we change the IP address of the connecting machine to another service provider it works

RE: [PHP] Lost Connection to MySQL server during query

2003-09-09 Thread Donald Tyler
I am using mysql_connect. But I just changed it to mysql_pconnect and it did exactly the same thing. -Original Message- From: Marek Kilimajer [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 10:48 AM To: Donald Tyler Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Lost Connection to

Lost Connection to MySQL server during query

2003-09-09 Thread Donald Tyler
with subsequent runs (To see if it incorrectly creates duplicates of records etc), after a couple of minutes the script ends with an error message saying "Lost connection to MySQL server during query". During the first run, the script is mostly just chopping up the data and placing it

RE: Unable to Create DB Connection

2003-09-09 Thread Scott D. Spiegler
directory. > This file will contain information that should help > you get started. > > > > -Original Message- > From: Scott D. Spiegler > [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 09, 2003 6:59 AM > To: [EMAIL PROTECTED] > Subject: Unable to

RE: Unable to Create DB Connection

2003-09-09 Thread Christensen, Dave
PROTECTED] Subject: Unable to Create DB Connection Hi, I am using the binary distribution of mySQL for Windows-2000 and am not able to connect to the DBserver. I used the Setup executable to install the application. I verified that the my.ini file was created and contained appropriate inform

Unable to Create DB Connection

2003-09-09 Thread Scott D. Spiegler
light icon- to start the service- nothing happens. I tried to ping the port that mySQL was supposed to be listening at, and it said that the connection was refused. So, it seems like I have not done something properly. Any thoughts as to how to trouble shoot this problem? Thanks, Scott

RE: Unable to Create DB Connection

2003-09-08 Thread Matt
=>when I right-click with my mouse on the stop light =>icon- to start the service- nothing happens. I tried =>to ping the port that mySQL was supposed to be =>listening at, and it said that the connection was =>refused. => =>So, it seems like I have not done something properly.

Unable to Create DB Connection

2003-09-08 Thread Scott D. Spiegler
light icon- to start the service- nothing happens. I tried to ping the port that mySQL was supposed to be listening at, and it said that the connection was refused. So, it seems like I have not done something properly. Any thoughts as to how to trouble shoot this problem? Thanks, Scott

ODBC connection to MySQL problem

2003-09-04 Thread florence florence
Hi,

ODBC connection to MySQL problem

2003-09-04 Thread florence florence
Hi,

Re: CONNECTION

2003-09-03 Thread Victoria Reznichenko
Fabrice Trichard <[EMAIL PROTECTED]> wrote: > > I am using Linux 7.1 with MySql and client win98 .I have installed CC on win 98 and > after giving the info it needs to connect I get an error : > > 1/ if specified with username @ localhost [SQL-SERVER] ERROR 2003: Can't connect > to MySQL se

CONNECTION

2003-09-03 Thread Fabrice Trichard
I am using Linux 7.1 with MySql and client win98 .I have installed CC on win 98 and after giving the info it needs to connect I get an error : 1/ if specified with username @ localhost [SQL-SERVER] ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) 2/ if specified with usern

Re: Server to Server Connection

2003-08-19 Thread Rajesh Kumar
Thomas Deliduka unknowingly asked us: and then it ran the mysql_select_db which selected the wrong table. Please re-read, re-phrase. I have an uncomfortable feeling when people use the wrong function for the wrong purpose. I'm an idiot, I should have looked for this before. Think to think more.

Re: Server to Server Connection

2003-08-18 Thread Rajesh Kumar
Thomas Deliduka unknowingly asked us: Thank you for the code, when I did that (which I should have done, you're right) it worked fine. So, now I gotta find out where this is going wrong and why the same code is working in one place but not the other. While my connection function is only run

Re: Server to Server Connection

2003-08-18 Thread Thomas Deliduka
this: Thank you for the code, when I did that (which I should have done, you're right) it worked fine. So, now I gotta find out where this is going wrong and why the same code is working in one place but not the other. While my connection function is only run once (due to my debug code I know thi

Re: Server to Server Connection

2003-08-18 Thread Rajesh Kumar
Thomas Deliduka unknowingly asked us: Right, however, I am following the progression of 1,2,3. My code I pasted here showed that the connection function did the connect and select in the same function and in my debugging I did confirm that $db does equal my_database. I have also manually typed it

Re: Server to Server Connection

2003-08-18 Thread Thomas Deliduka
Right, however, I am following the progression of 1,2,3. My code I pasted here showed that the connection function did the connect and select in the same function and in my debugging I did confirm that $db does equal my_database. I have also manually typed it in and it still doesn't work. It

Re: Server to Server Connection

2003-08-18 Thread Primaria Falticeni SDU
base after connecting and before query.So follow the order: 1. connection with $conn = @mysql_connect($dh,$du,$dp); 2. selecting the database with mysql_select_db("my_database",$conn); 3. performing query $result=db_query($sql); If you get an error in this step, it's not a PHP/Web m

Re: Server to Server Connection

2003-08-18 Thread Primaria Falticeni SDU
the first not-working query. Add, also, the real names of the MySQL tables used in your lines. Iulian - Original Message - From: "Thomas Deliduka" <[EMAIL PROTECTED]> To: "m a b" <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 5:47 PM Subject: Re: Server to

Re: Server to Server Connection

2003-08-18 Thread Thomas Deliduka
68.1.% user1 all main privs are 'N' except for "File_priv" >> (internal SAN). >> >> db: >> %user11 my_database all main privs set to "Y" (select, >> insert,update, delete, create, drop, references, index,

Re: Server to Server Connection

2003-08-18 Thread Thomas Deliduka
; >> 192.168.1.% user1 all main privs are 'N' except for "File_priv" >> (internal SAN). >> >> db: >> % user11 my_database all main privs set to "Y" (select, >> insert,update, delete, create, drop,

Re: Server to Server Connection

2003-08-18 Thread Paul DuBois
, drop, references, index, alter) If I use the command-line interface from server 1 to server 2 it works perfectly fine. I'm using PHP connection to do code like: $conn = mysql_connect("192.168.1.2","user1","pass"); mysql_select_db("my_database",$con

Re: Server to Server Connection

2003-08-18 Thread Thomas Deliduka
tion that I wanted to pass was correctly passed. */ if ($config['pconn'] == 1) { $conn = @mysql_pconnect($dh,$du,$dp); } else { $conn = @mysql_connect($dh,$du,$dp); } if (!$conn) { echo "FATAL ERROR: No connection to database."; $error

Re: Server to Server Connection

2003-08-18 Thread Primaria Falticeni SDU
M Subject: Server to Server Connection > I have written this to the PHP-DB list and couldn't get any answers. I have > gone through all the documentation I could find. I have been everywhere and > cannot find an answer to this problem! Perhaps someone on this list can > lend

Server to Server Connection

2003-08-18 Thread Thomas Deliduka
, drop, references, index, alter) If I use the command-line interface from server 1 to server 2 it works perfectly fine. I'm using PHP connection to do code like: $conn = mysql_connect("192.168.1.2","user1","pass"); mysql_select_db("my_database",$con

connection

2003-08-14 Thread aaldrik groenewold
I just installed mysql 4.0 .There were many problems with upgrading from 3.23 to 4.0 so I deleted 3.23 and made a fresh start with 4.0. Everything works fine now but the only problem to connect to the server is via the /usr/local/mysql/bin directory. Is there a way to connect if I am root. thanks f

client ignores close of connection?

2003-08-14 Thread Pav Lucistnik
es on both machines, and my theory what's happening follows: Imagine long time open and idle connection. Mysql server decides to close this connection (13:55:06), it sends FIN to client. Client ACKs the FIN, but not send his FIN as in ordinary TCP connection close. Server closes the connection

Re: connection

2003-08-14 Thread O'K Web Design
ED]> Sent: August 6, 2003 7:12 PM Subject: connection > I just installed mysql 4.0 .There were many problems > with upgrading from 3.23 to 4.0 so I deleted 3.23 and > made a fresh start with 4.0. Everything works fine now > but the only problem to connect to the server is via > t

Re: connection

2003-08-07 Thread gerald_clark
You don't say what your problem is. aaldrik groenewold wrote: I just installed mysql 4.0 .There were many problems with upgrading from 3.23 to 4.0 so I deleted 3.23 and made a fresh start with 4.0. Everything works fine now but the only problem to connect to the server is via the /usr/local/mysql

Re: ERROR: Lost Connection ### RESOLVED

2003-08-02 Thread richardb
6824-1367 BORNAY Richard/Engr/STATS/ST [EMAIL PROTECTED] Domain02/08/2003 03:39 PM To: [EMAIL PROTECTED] cc: (bcc: BORNAY Richard/Engr/STATS/ST Group) Subject: ERROR: Lost Connection Hi List, Does anyone knows why this error message is displaying when I ran a cshell scrip

ERROR: Lost Connection

2003-08-02 Thread richardb
Hi List, Does anyone knows why this error message is displaying when I ran a cshell script which is using mysql and mysqlimport client commands? I encountered this after I upgrade from 4.0 gamma to 4.0.13. Error: Lost connection to MySQL server during query, when using table: SUMMARY Thanks

Connection priorisation in Mysql

2003-07-31 Thread John Clegg
Hi Environment: RedHat 7.2 MySQL: v 3.23.41 Connections: Perl DBI I have a question if there is any features in mysql 3 /4 to support connection priorisation. Currently we are running some update queries that squeeze all all other connections running on the database. Does any one have any

Win98 - Work-around to sudden lost connection to database

2003-07-24 Thread Al Caponi
Hi all, There is a limitation on Win98 when a client app using mm.mysql driver doing extensive queries to MySQL 3.23.x frequently encounters a connection lost error. Error msg is something like: 'java.lang.Exception: Cannot connect to MySQL server on localhost:3306. Is there a MySQL s

Re: Maximum of 254 prepared statements per connection

2003-07-22 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: >>Description: > > MySQL v4.1.0-alpha only allows a client to prepare a maximum of 254 > statements. On the 255th mysql_prepare() call, a failure is returned > with no information returned by mysql_error(). This occurs even if

Maximum of 254 prepared statements per connection

2003-07-21 Thread David . Tymon
lowing program highlights the problem. Just change the connection details to some database. It also assumes there is a table called dummy, created with "CREATE TABLE dummy ( a VARCHAR(1024) )" It was compiled using: gcc -o buggy buggy.c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclien

Server restarts on SSL connection

2003-07-20 Thread Adam Carmichael
few users from the mysql client: GRANT ALL ON *.* TO clearuser IDENTIFIED BY 'password'; GRANT ALL ON *.* TO ssluser IDENTIFIED BY 'password' REQUIRE SSL; FLUSH PRIVILEGES; I can connect to the server just fine with a normal connection using the clearuser username, however, whe

RE: * HELP * MySQL Connection Issue - Access Denied!!

2003-07-18 Thread Ryan Schefke
! -Original Message- From: Ryan Schefke [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 11:05 AM To: 'Jason k Larson' Subject: RE: * HELP * MySQL Connection Issue - Access Denied!! Hey Jason - Thanks a ton for your help! You're a lifesaver! When I use 'localhost&#x

Re: mysql connection error

2003-07-18 Thread Victoria Reznichenko
Victoria Reznichenko" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, July 17, 2003 2:36 PM > Subject: Re: mysql connection error > > > "zafar rizvi" <[EMAIL PROTECTED]> wrote: > > > hi > > > I am running one centrali

* HELP * MySQL Connection Issue - Access Denied!!

2003-07-17 Thread Ryan Schefke
phpMyAdmin 2.5.2-rc2. When I run 'http://samsever.sytes.net:8080/phpadmin/index.php' I get the following message: "Welcome to phpMyAdmin 2.5.2-rc2 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and passwo

Re: too many connection error driving me nutz, need advice

2003-07-17 Thread colbey
typically starts up 1 database connection and all scripts should use it.. (Correct way) This code had programmers using things like DBLibraries, DBIMPTOOL, PHPLIB Database objects, etc.. to make more connections for their scripts/includes.. Scenario: 1) script starts - 1 connection opened for

Re: too many connection error driving me nutz, need advice

2003-07-17 Thread Eben Goodman
This comment confuses me: I have seem some sites code that actually open multiple connections to the same database.. If I am using php's mysql_connect() function, then every time a query is run this function gets run. Wouldn't this mean that for every query a new "connection&qu

Re: too many connection error driving me nutz, need advice

2003-07-17 Thread colbey
DOh! i mean script_append part ;) .. basically it's a garbage collector.. On Thu, 17 Jul 2003 [EMAIL PROTECTED] wrote: > > Suggestion.. make a small script called closeall.php .. basically it has > some code to force closed the mysql connection opened (be sure to run a &

Re: too many connection error driving me nutz, need advice

2003-07-17 Thread colbey
Suggestion.. make a small script called closeall.php .. basically it has some code to force closed the mysql connection opened (be sure to run a close for all openened handles) I have seem some sites code that actually open multiple connections to the same database.. Add this file into php.ini

too many connection error driving me nutz, need advice

2003-07-17 Thread Eben Goodman
I run a site that gets a fair amount of traffic throughout the day. For days at a time the site runs smoothly, and then, at seemingly random intervals I get the mysql error "Too many connections". The only solution for this is to stop the mysql service and restart it. I changed the max_conne

Re: mysql connection error

2003-07-17 Thread Victoria Reznichenko
at. > > [EMAIL PROTECTED] root]# mysql -h 192.168.0.63 mysql > ERROR 2013: Lost connection to MySQL server during query > > Anybody has idea what's wrong and where is ? > I get no answer from searching on google with that error. What is the version of MySQL server? What OS d

RE: mysql connection error

2003-07-17 Thread Rudy Metzger
Also make sure that the port is not firewalled. Cheers /rudy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: donderdag 17 juli 2003 9:56 To: zafar rizvi Cc: [EMAIL PROTECTED] Subject: Re: mysql connection error Keep in mind you need 2 things to happen: A

Re: mysql connection error

2003-07-17 Thread colbey
isn't listening on the required interface there is no a way tcp/ip connection can be established... It is very possible that the application running on the same server is using mysql sockets to connect to the sql server instead of using tcp/ip... Start with ensuring the server is listing tcp/

Re: mysql connection error

2003-07-17 Thread zafar rizvi
hi No its not listening and giving same error ERROR 2013: Lost connection to MySQL server during query how can i allow a ip to connect mysql database from other system. plz explain me little (i have not yet idea to use mysql fully) Thanks ZafAr - Original Message - From: <[EM

mysql connection error

2003-07-16 Thread zafar rizvi
hi I am running one centralized mysql server, its runnig fine and conneded with localhost and his own ip very fine. But when i want to connect him from remote system or other lan system it give me errror like that. [EMAIL PROTECTED] root]# mysql -h 192.168.0.63 mysql ERROR 2013: Lost connection

Re: mysql connection error

2003-07-16 Thread colbey
> I am running one centralized mysql server, its runnig fine and conneded with > localhost and his own ip very fine. > But when i want to connect him from remote system or other lan system > it give me errror like that. > > [EMAIL PROTECTED] root]# mysql -h 192.168.0.63 mysql &g

RE: Connection problem!!! Windows to Linux

2003-07-16 Thread Rob A. Brahier
ps--I don't normally connect to MySQL through ODBC. -Rob -Original Message- From: Aric Cheah [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 3:36 AM To: [EMAIL PROTECTED] Subject: Connection problem!!! Windows to Linux Hi there: I need URGENT help about this .. I wrote a

RE: Connection problem!!! Windows to Linux

2003-07-16 Thread Rudy Metzger
If you manually updated the tables, use flush privileges to inform the DB server of your changes. Cheers /rudy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:23 To: [EMAIL PROTECTED] Subject: Re: Connection problem!!! Windows to Linux Aric

Re: Connection problem!!! Windows to Linux

2003-07-16 Thread Egor Egorov
Aric Cheah <[EMAIL PROTECTED]> wrote: > > I wrote a program application for windows which can add and delete data > from this application, it working fine with my own MySQL install on the > same windows OS.. Now I try to change the connection this dayabase to > the serve

Connection problem!!! Windows to Linux

2003-07-16 Thread Aric Cheah
Hi there: I need URGENT help about this .. I wrote a program application for windows which can add and delete data from this application, it working fine with my own MySQL install on the same windows OS.. Now I try to change the connection this dayabase to the server whihc runnign under

Lost connection to MySQL server during query

2003-07-15 Thread Keith Bussey
Hello all, After changing RAM and the ethernet card of my DB server, the problem of getting frequent: Database error (error code 102) Could not connect to database server (Lost connection to MySQL server during query) Still occurs ;/ I've tried to eliminate all factors (like multiple se

2013: Lost connection to MySQL server during query & ERROR 1129: Host 'webfrontend' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

2003-07-07 Thread Stefan Andersen
es running debian gnu/linux 2.4 linux kernels - alle software installed from debian packages. the web frontend are serving 1,4 mill dynamic pages / day (access file recording) the sql server says: Connection: majeskuel via TCP/IP Uptime: 3 hours 53

DSNless connection from ASP to Linux

2003-07-04 Thread Dietrich Speer
I am trying to to use a DSNless connection from an ASP script( on IIS5) to a MySQL db on Linux. I am trying this: strConnection=_ "driver={MySQL};server=192.168.33.124;uid=me;pwd=mypassword;database=MySQL;o ption=NUM" Set adoDataConn = Server.Cr

DSNless connection from ASP to Linux

2003-07-03 Thread Dietrich Speer
I am trying to to use a DSNless connection from an ASP script( on IIS5) to a MySQL db on Linux. I am trying this: strConnection=_ "driver={MySQL};server=192.168.33.124;uid=me;pwd=mypassword;database=MySQL;o ption=NUM" Set adoDataConn = Server.Cr

Re: ERROR 2013:Lost connection to MySQL server

2003-07-01 Thread Heikki Tuuri
3 1:10 AM Subject: Re: ERROR 2013:Lost connection to MySQL server > On Wed, Jul 02, 2003 at 12:55:38AM +0300, Heikki Tuuri wrote: > ... > > 4.0.13 has better diagnostics. Please upgrade to it if you are not using > > MySQL replication. > > Is there something wrong with

<    4   5   6   7   8   9   10   11   12   13   >