Where could I find speciffication of how MySQL client and server communicate?
It seems to
me there are two ways of communicating - over UNIX socket and over TCP/IP
connection. Lets
say I want to write my own MySQL client, where could I find info about what
UNIX socket
is, and how do TCP packets
Look at the source code of libmysql?
- Original Message -
From: Nikola Skoric [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, May 01, 2005 10:25 AM
Subject: mysql-mysqld connection
Where could I find speciffication of how MySQL client and server
communicate? It seems to
me
Dear All,
I have mysql installed on top of redhat 3.0 machines and I have created user
called root and assigned a password.
I have tried connecting to database locally by using
Mysql -h localhost -u root -p it connected
When I tried using host name it is not connecting and giving an error
Hi,
look at http://dev.mysql.com/doc/mysql/en/grant.html
and apply grant to root@'node1.example.com'.
Mathias
Selon bala [EMAIL PROTECTED]:
Dear All,
I have mysql installed on top of redhat 3.0 machines and I have created user
called root and assigned a password.
I have tried connecting to
Hello.
Add user 'root'@'node1.example.com'. See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
Dear All,
I have mysql installed on top of redhat 3.0 machines and I have created
user called root and assigned a password.
I have tried connecting to database locally by using
Daniel Kasak wrote:
Michael Gale wrote:
Hello,
Earlier today I tried to make some table alterations on a mysql server
(4.0.24) and kept on receiving this error:
ERROR 2013: Lost connection to MySQL server during query
I would login to the server, either through the socket or using the
IP
Hello,
Earlier today I tried to make some table alterations on a mysql server
(4.0.24) and kept on receiving this error:
ERROR 2013: Lost connection to MySQL server during query
I would login to the server, either through the socket or using the IP.
Then connect to a database and try
Michael Gale wrote:
Hello,
Earlier today I tried to make some table alterations on a mysql server
(4.0.24) and kept on receiving this error:
ERROR 2013: Lost connection to MySQL server during query
I would login to the server, either through the socket or using the
IP. Then connect
Hello.
It is not clear what do you mean. If you want to access remote tables
use Federated storage engine, but it is not production ready yet. See:
http://dev.mysql.com/doc/mysql/en/federated-storage-engine.html
sujata chaudhari [EMAIL PROTECTED] wrote:
hi,
can MySQL engine
hi,
can MySQL engine connect to databases in any other
database engine ???
i have read that this can be done but i was not
successful with it!! can u tell me how to connect to
such databases. i am trying it through c++ code and
also if the OS will effect that...
regards
sujata
Hello.
Analyzing the General Query Log could give such kind of information.
See:
http://dev.mysql.com/doc/mysql/en/query-log.html
Dilshad Ali [EMAIL PROTECTED] wrote:
Hi,
Is there a way to determine when was the last time a MySQL user
attempted to connect to the MySQL
Hi,
Is there a way to determine when was the last time a MySQL user
attempted to connect to the MySQL Database?
--
Thanks Regards,
Dilshad Ali
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have mysql version 4.0.15-nt in a server NT, I can
connecting with mysql localy, but when i try remote
connection the error is:
Error Number 2003 Can't connect to MySQL server on
'IP' (10060) .
I use mysql odbc 3.51
Is necesary the file my.cnf in c:\my.cnf
Regards
Gerardo Campos
:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 4:43 PM
To: mysql@lists.mysql.com
Subject: remote connection problem
I have mysql version 4.0.15-nt in a server NT, I can connecting with mysql
localy, but when i try remote connection the error is:
Error Number 2003 Can't connect to MySQL server
, are
you sure that your remote connection can see the NT server? This may be a
bigger problem, i.e. DNS or IP routing/access lists.
You may also want to check the hostname.err logs on the MySQL server to
see if there is a connection problem there.
J.R.
-Original Message-
From: gerardo
sec)
If the value is ON, you won't be allowed to make connections to the
server via TCP/IP.
On Tue, 2005-03-22 at 15:43 -0600, gerardo Villanueva wrote:
I have mysql version 4.0.15-nt in a server NT, I can
connecting with mysql localy, but when i try remote
connection the error is:
Error
Not necessary to change my.cnf, unless --skip-networking was specified.
Also assuming that you are using port 3306.
mysql show variables like 'port';
+---+---+
| Variable_name | Value |
+---+---+
| port | 3306 |
+---+---+
1 row in set
Hi,
I'm having a similar problem using the LOAD DATA. I get an intermittent error:
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
The command is:
LOAD DATA local infile 'pipefile' into table FACT_TABLE fields terminated by
'~' lines terminated by '\n';
I cannot
Hi;
I'm using Apache 2.0 + MySQL 4.1 + PHP 4.3.10 for a site. The
database server and web server are on different machines. I get this
Error lost connection DURING query when I try to access some of the web
Pages. I have been through this thread.
http://lists.mysql.com/mysql/181322
I tried
Mar 2005 Neharkar,Mukund wrote :
Hi;
I'm using Apache 2.0 + MySQL 4.1 + PHP 4.3.10 for a site. The
database server and web server are on different machines. I get this
Error lost connection DURING query when I try to access some of the web
Pages. I have been through this thread.
http
on what needs to be changed to avoid this error.
TIA!
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 183 to server version: 3.23.58-max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql LOAD DATA CONCURRENT LOCAL INFILE
'../data/mysql
connection to MySQL
server during query
that during part threw me, but it may just be the way ODBC states the
error?
mysql error log shows no errors for the time(s) that this happened,
other than a bunch of aborted connections - but that is because I
set wait_timeout pretty low to avoid
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 8:08 AM
To: Crouch, Luke H.
Cc: mysql@lists.mysql.com
Subject: Re: lost connection DURING query?
Crouch, Luke H. [EMAIL PROTECTED] wrote on 03/14/2005 09:34:02 AM:
This error message seems a bit
datasource connection,
and dispense with ODBC? I know it doesn't help the immediate problem, but
it would remove one less reliable link in the chain.
Terry
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log]Lost connection to MySQL
server during query
that during part threw me, but it may
I got the same error when my web server and mysql server were separate. And the
error was caused bcoz of too many unauthenticated users. The reason behind it
was that the reverse dns lookup for the webserver was failing. but as soon as i
added the web server to /etc/hosts, the error went off.
This error message seems a bit different than others I have gotten. it is from
a ColdFusion server that uses an ODBC driver...
ODBC Error Code = S1000 (General error)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log]Lost connection to MySQL server
during query
that during part threw me
Hi,
I am a new mysql user. I installed a MySQL, PHP and Apache on my
computer with Windows XP.
All my php scripts run fine unless I try to connect to mysql
?php
echo start here;
$a = mysql_connect(localhost, test, test);
echo $a;
echo stop here;
?
I don't get any response even error message
[snip]
I am a new mysql user. I installed a MySQL, PHP and Apache on my
computer with Windows XP.
All my php scripts run fine unless I try to connect to mysql
?php
echo start here;
$a = mysql_connect(localhost, test, test);
echo $a;
echo stop here;
?
I don't get any response even error
mysql_connect('localhost', 'my_user', 'my_pass')
or die(mysql_error()):
On Tue, 8 Mar 2005 11:28:47 -0600, Jay Blanchard
[EMAIL PROTECTED] wrote:
[snip]
I am a new mysql user. I installed a MySQL, PHP and Apache on my
computer with Windows XP.
All my php scripts run fine unless I try to
.
Currently its setup to open a single DB connection at initialization
and use that connection over and over... would it be better
or worse to
have it open/close a connection for each command in the way
a web app would?
There's a tradeoff here.
One connection is much more efficient. If you're
You can try SQLyog (www.webyog.com), it supports
3.23.x to 5.0.
Lightweight and very fast!
Karam
--- [EMAIL PROTECTED] wrote:
Good good.
On 24 Feb 2005, at 20:46,
[EMAIL PROTECTED] wrote:
BINGO!!!
Thanks Dan!
Kelly
Daniel Walker [EMAIL PROTECTED]
What version of MySQL
4:35 PM
Subject: Re: Change default character_set_client, connection, results
Hello.
Use MYSQL_SET_CHARSET_NAME option for mysql_options() function. See:
http://dev.mysql.com/doc/mysql/en/mysql-options.html
[snip]
Hello,
could someone tell me if it is possible to change default settings
PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, February 24, 2005 9:53 AM
Subject: Re: Change default character_set_client, connection, results
Gleb,
thanks for your response, but that doesn't help me much because I'm using
ADO components to connect to MySQL and not MySQL API functions.
Regards
Hello,
I have downloaded Toad for MySQL to give it a test run. MySQL 4.1.10 is
on Redhat AS 2.1 and Toad for MySQL is on Win XP. Everytime I attempt to
connect via Toad, I get the following error:
Unable to connect to the database.
Host 'XX.XX.XX.XX' is not allowed to connect to this MySQL
Good good.
On 24 Feb 2005, at 20:46, [EMAIL PROTECTED] wrote:
BINGO!!!
Thanks Dan!
Kelly
Daniel Walker [EMAIL PROTECTED]
What version of MySQL are you using? 4.1.1 uses an enhanced password
hashing system that isn't compatible with clients built for older
versions.
This page on
3.51. My applications are written in
C++ Builder and I don't want to send command SET NAMES 'cp1250' whenever
application opens connection.
Thanks in advance
Regards,
Dusan Pavlica
opens
connection.
Thanks in advance
[snip]
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
Hello.
queries will likely be spaced out by hours or days (idle disconnect?)
How long does it take to establish a new connection? If the time
is large enough, may be you should make a temporary connection and
close it after timeout. If you deside to use a persistent connection,
don't
) .. that
will take commands from users (!mybugs, !mybugs KEY !newbugs, !bug ID,
etc), do
SQL queries and of course dump formatted results back to the channel.
Currently its setup to open a single DB connection at initialization
and use that connection over and over... would it be better or worse to
have it open
results back to the channel.
Currently its setup to open a single DB connection at initialization
and use that connection over and over... would it be better or worse to
have it open/close a connection for each command in the way a web app
would?
Some things to keep in mind :)
- IRC server
but to this value (manually, as you
advised)
Again,
1. Connection to localhost still fails with message Can't connect to local
MySQL server through socket '' (111)
2. Connection to server's domain name fails too (!) with message Access
denied for user 'user'@'example.com' (using password: YES)
3
being
overwritten somewhere.
Cheers,
Denis Gerasimov wrote:
Didn't help me. MySQL socket does exist - /var/lib/mysql/mysql.sock (default
location).
mysqli.default_socket is NOT set to null but to this value (manually, as you
advised)
Again,
1. Connection to localhost still fails with message Can't
will happen if the connection exceed 100 connection?
(does mysql crash or display database unavailable error message
or it just queued the connection requests)
Usually you'll get a Too many connections error when you try to connect to the
mysqld server. See:
http://dev.mysql.com/doc/mysql/en
Hello,
This question was asked many times, but I can't find a good answer.
I am getting this error message while trying to connect to MySQL server (PHP
+ PEAR::DB_DataObject):
Can't connect to local MySQL server through socket '' (111)
(notice '' - is that right?)
Does anyone have any ideas
Denis Gerasimov wrote:
Hello,
This question was asked many times, but I can't find a good answer.
I am getting this error message while trying to connect to MySQL server (PHP
+ PEAR::DB_DataObject):
Can't connect to local MySQL server through socket '' (111)
(notice '' - is that right?)
Does
my my.ini contain
max_connections=100
this mean that simultaneous connection available is 100 connections,
my questions are:
1. is this value for one database or for overall mysql connections?
2. i'm unable to generate 100 connections, i don't have 100 workstations yet,
how do i test it?
3
Hello,
Is there any documentation where I can find a list of
all connection related error/error codes returned by
MySQL?
Regards,
Karam
__
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
--
MySQL General
Is there any documentation where I can find a list of
all connection related error/error codes returned by
MySQL?
OS error codes :
http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html
Server error messages :
http://dev.mysql.com/doc/mysql/en/error-handling.html
---
Tom
(to actually balance the load)
The major problem is that we run a LOT of small queries to generate our
pages so per-query latency is very important.
After benchmarking continual reconnect to my laptop running MySQL 4.1.9
and with our DB connection pool I'm noticing a 14x performance gap
it its
taking 3.173 ms. This doesn't sound like much but if you multiply that
by 1000x queries its significant and can seriously screw with total
throughput.
I've also tried removing any queries and JUST connection (without a
SELECT 1) test and it still takes 2.8ms.
Here's my JDBC
Ok I changed my connection string to use the IP of the mySql box
and added my workstation to the hosts file on the server. Same
problem. The tests ran at the same slow pace.
I am really curious, what was the logic of adding the workstation
ip to the hosts file on the server?
Larry Lowry
In the last episode (Jan 24), Larry Lowry said:
Ok I changed my connection string to use the IP of the mySql box and
added my workstation to the hosts file on the server. Same problem.
The tests ran at the same slow pace.
I am really curious, what was the logic of adding the workstation ip
method seems silly but to my boss it makes
sense. We have web sites that make these connections. They
are obviously stateless and each makes it's own connection.
Where it takes 22 seconds to connect to mySql 100 times I can
in the same loop execute a select statement and bring back a
700k binary
To: Peter J Milanese; mysql@lists.mysql.com
Subject: Re: Connection performance, suggestions?
Actually I was just trying to see why the same code to mySql is
so much slower than SQL Server. I tried the same code using the
data provider from CoreLabs and found the connections occur
4 times faster than
and
running mostly asp.net applications.
I have narrowed the problem down to the speed at which the database connections
open and close. The following code opens a mySql database 100 times.
This takes 21 to 23 seconds. I know I should only open the connection once
but this represents the asp
A single transaction logs into the db several times?
I assume its a browser based transaction, no?
Are you limiting connections (in my.conf)? Have you tuned the config, if
yes how so?
--Original Message--
From: Larry Lowry
To: mysql
Sent: Jan 21, 2005 12:49 PM
Subject: Connection
query_cache_size = 32M
query_cache_type = 1
read_buffer_size=2M
read_rnd_buffer_size=8M
skip-innodb
- Original Message -
From: Peter J Milanese [EMAIL PROTECTED]
To: Larry Lowry [EMAIL PROTECTED]; mysql mysql@lists.mysql.com
Sent: Friday, January 21, 2005 12:57 PM
Subject: Re: Connection
Hello,
I just installed MySQL 5.0.2 (on Debian Sarge) and started to do some
experimets with Stored Procedures.
I very often get the error Lost connection to MySQL server during query when
executing such a self created Procedure. Sometimes the same Precedure works
fine, sometimes it results
, so I have to connect to the =
database
over tcp.
=20
My question is: Is there any program that opens a connection to =
mysql,
and
that I could use to connect to the database using unixsocket using =
always
the same connection?
=20
Anyone have anyother ideia how I could
question is: Is there any program that opens a connection to mysql,
and
that I could use to connect to the database using unixsocket using always
the same connection?
Anyone have anyother ideia how I could speed up my connection phase?
Thanks everyone,
José Miguel Fernandes
--
MySQL
.
Here is some more light on my problem: I am trying to set up default
connection codepage for PHP scripts.
I've look through source code of mysql extention of php, and
hadn't found any php-side part of code where it was set client character set.
It takes place at the libmysqlclient side
Hello,
Is there any way to change default MySQL _connection_ codepage?
(e.g. by ini/cnf files setting, by startup parameters or some other way)
Please, do not suggest running
SET CHARACTER SET blah123
Thanks.
Best regards, Denis Gerasimov
Outsourcing Services Manager,
VEKOS, Ltd.
Hello.
Put default_character_set='blah123' in your [client] and [mysql]
sections of your config file.
Denis Gerasimov [EMAIL PROTECTED] wrote:
Hello,
Is there any way to change default MySQL _connection_ codepage?
(e.g. by ini/cnf files setting, by startup parameters or some
Hello,
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 21, 2004 1:29 PM
To: [EMAIL PROTECTED]
Subject: Re: Default connection codepage
Hello.
Put default_character_set='blah123' in your [client] and [mysql]
sections of your config
Of Shankar Unni
Sent: Saturday, December 11, 2004 3:18 AM
To: [EMAIL PROTECTED]
Subject: Re: Regarding Connection Context
[EMAIL PROTECTED] wrote:
CONTEXT USE Example:
Do *you* really understand what this feature is supposed to do? Can you
explain it to us in (low-level) detail?
No, MySQL
[EMAIL PROTECTED] wrote:
A runtime context, usually simply called a context, is a handle to a
an area in client memory which contains zero or more connections, zero
or more cursors, their inline options (such as MODE, HOLD_CURSOR,
RELEASE_CURSOR, SELECT_ERROR, and so on.) and other additional
, is that whenever I execute a long
query or something that returns big resultset, i get
an error -
Lost connection during query.
If I use direct connection - everythings fine.
Is this a known issue? Is this a bug with Putty?
Regards,
Karam
__
Do
- Original Message -
From: Karam Chand [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 10, 2004 1:08 PM
Subject: Lost connection during query when using SSH tunneling
Hello,
I have a MySQL database hosted with my ISP. They
provide direction as well as thru SSH
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 12:08 PM
To: [EMAIL PROTECTED]
Subject: Lost connection during query when using SSH tunneling
So I use Putty to create the SSH tunneler and then connecting
to the local port.
Now
,
Karam
--- Adams, Pat 006
[EMAIL PROTECTED] wrote:
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 12:08 PM
To: [EMAIL PROTECTED]
Subject: Lost connection during query when using
SSH tunneling
So I use Putty to create the SSH
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 2:17 PM
To: Adams, Pat 006; [EMAIL PROTECTED]
Subject: RE: Lost connection during query when using SSH tunneling
I am not sure of Putty as I am using plink.exe that is the
SSH tunneler
[EMAIL PROTECTED] wrote:
CONTEXT USE Example:
Do *you* really understand what this feature is supposed to do? Can you
explain it to us in (low-level) detail?
No, MySQL doesn't have a feature like this.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi ALL,
CONTEXT USE Example:
#include sqlca.h
#include ociextp.h
main()
{
sql_context ctx1;
char *usr1 = scott/tiger;
EXEC SQL CONTEXT ALLOCATE :ctx1; //Create Context
EXEC SQL CONTEXT USE :ctx1; // Use Context
EXEC SQL CONNECT :usr1;
EXEC SQL CONTEXT USE DEFAULT;
EXEC SQL INSERT INTO emp
I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs
correctly (it is a slave member of my domain). But if I try to connect from
a remote client with mysql administrator, I receive this error:
Could not connect to the specified instance
Mysql error number 1130
Host name is not
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Access_denied.html
Massimo Petrini [EMAIL PROTECTED] wrote:
I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs
correctly (it is a slave member of my domain). But if I try to connect from
a remote client with mysql
Hello All!
I have had mySQL 3.2 running on my server for about 2 years now without
incident. Recently upgraded to 4.1, and suddenly I'm getting the
following message from queries:
Lost connection to MySQL server during query
This is in response to a PHP script issuing a query to the mySQL
i have mysql server located in in machine that used Red Hat 8.0
and my mysql server version was 3.23.58. I am trying to connect
using my machine..And currently i used Red Hat Fedora...But when
i am trying to connect to mysql server i got this error
message.
ERROR 2013: Lost connection
message.
ERROR 2013: Lost connection to MySQL server during query
And i am also trying to killall my mysqld and start the mysql
server through mysql kernel
/usr/libexec/mysql -Sg --user=root
After that, when i tried to reconnect it, it's hang up
!.nothing to be done
Hi, all
I would like to know is there anyway where i can
connect to the mysql database without add the odbc dsn ?
which i want to direct access to the mysql
database.
i wish to create 1 dsn, and by using this dsn, i
able to access all database,
even able to create/delete the mysql
Hello.
For direct connection you may use MySQL APIs. See:
http://dev.mysql.com/doc/mysql/en/MySQL_APIs.html
Probably this link also will be helpful:
http://dev.mysql.com/doc/mysql/en/Without_DSN.html
Hi, all
I would like to know is there anyway where i can connect to the mysql
Yup, Thanks a lot.
This is exactly the solution what i want.
Thank you very much. :)
- Original Message -
From: Kardos Andrs [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 23, 2004 5:20 AM
Subject: Re: Direct connection to mysql database
You can use one DSN
, and I then call fclose() to close the socket.
The problem is that if I call this several times in a row quickly, the
database senses a connection error problem and refuses to connect until I
issue a flush hosts command.
Is there are more proper was to use fsockopen()/fclose() to simply ping
G'Day All,
I am going nuts trying to setup ODBC to my MySQL database. Help Please.
My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51, unzipped
it and am trying to configure it to connect to the database on a RedHat
ES box.
In the Add Data Source Name my DSN is closing Description
a new user just for your ODBC connection.(Use a GRANT
statement with all of the correct bells and whistles for your situation)
http://dev.mysql.com/doc/mysql/en/GRANT.html
GRANT SELECT on *.* to 'remoteuser'@'%'
Then reset the password to the OLD hashing style
UPDATE mysql.user set password
To: Ferguson, Michael
Cc: [EMAIL PROTECTED]
Subject: Re: ODBC connection
The MySQL ODBC driver v3.51 acts as a pre-4.1 MySQL client. That
means it does not use the new (v4.1+) password hashing.
http://dev.mysql.com/doc/mysql/en
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Access_denied_error.html
G'Day All,
I am going nuts trying to setup ODBC to my MySQL database. Help Please.
My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51, unzipped
it and am trying to configure it to connect to the
It is my Digital Signature. Sorry that it didn't come through.
J.R.
-Original Message-
From: Ferguson, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, November 12, 2004 11:19 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: ODBC connection
Thanks. I will give it a try. I
Thanks guys. I seem to have it working now. 'preciate it.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 12, 2004 11:05 AM
To: Ferguson, Michael
Cc: [EMAIL PROTECTED]
Subject: Re: ODBC connection
P.V.Anthony wrote:
Hi,
I am having an intermitten connection problem with MySQL 4.1.7 .
Here is the setup.
Intel P4 with HT
Fedora Core 1 kernel 2.4.27 smp
MySQL version 4.1.7 (RPM install from mysql.org)
Qmail with vpopmail using mysql (www.qmailtoaster.com)
Sometimes I cannot login to qmail
Hi,
I am having an intermitten connection problem with MySQL 4.1.7 .
Here is the setup.
Intel P4 with HT
Fedora Core 1 kernel 2.4.27 smp
MySQL version 4.1.7 (RPM install from mysql.org)
Qmail with vpopmail using mysql (www.qmailtoaster.com)
Sometimes I cannot login to qmail to check mail. Using
for the connection
MYSQL *link =3D mysql_init(NULL);
MYSQL *connectHandle =3D
mysql_real_connect(link,localhost,root,,test,0,NULL,0);
But this is not having the option for specifying the DSN or Driver.=0D
Please provide me the solution.
Thanks,
Narasimha
Hi,
Thank you for your reply.
After establishing a connection to the Database using ODBC API, can we
use the mysql API's like mysql_query() instead of using MyODBC API's.
Thanks in Advance.
Regards,
Narasimha
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent
by creating a common interface
on one side of a driver and mapping that interface to the specific
requirements of each database system within the driver itself.
If you want to make an ODBC connection (because you insist, for some
reason, that you must create and use a DSN) then you need to stay
Hi.
No.
[EMAIL PROTECTED] wrote:
Hi,
Thank you for your reply.=0D
After establishing a connection to the Database using ODBC API, can we
use the mysql API's like mysql_query() instead of using MyODBC API's.
Thanks in Advance.
Regards,
Narasimha
Hi,
I am having an intermitten connection problem with MySQL 4.1.7 .
Here is the setup.
Intel P4 with HT
Fedora Core 1 kernel 2.4.27 smp
MySQL version 4.1.7 (RPM install from mysql.org)
Qmail with vpopmail using mysql (www.qmailtoaster.com)
Sometimes I cannot login to qmail to check mail. Using
Hi,
When you have this problem, do the MySQL client applications work? Have you tried
logging in with the mysql client?
Kostas
-Ursprüngliche Nachricht-
Von: P.V.Anthony [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 6. November 2004 02:36
An: [EMAIL PROTECTED]
Betreff: connection
Hi,
I would like to know how to connect to the mysql database using a
DSN in mysql API's. I am using myodbc 3.51 driver.
Used the following API code for the connection
MYSQL *link = mysql_init(NULL);
MYSQL *connectHandle =
mysql_real_connect(link,localhost,root,,test,0,NULL,0
Hi.
See:
http://dev.mysql.com/doc/mysql/en/GRANT.html
http://dev.mysql.com/doc/mysql/en/Access_denied.html
http://dev.mysql.com/doc/mysql/en/Privilege_system.html
And may be something like this will help you:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip address' IDENTIFIED BY
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
. 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 reduce the lock delays
501 - 600 of 1704 matches
Mail list logo