Cheers Dan. Exactly what I needed :)
Iain
Dan Trainor wrote:
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a
mysql 4.1 database. The er
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a mysql
4.1 database. The error message I get is
ERROR 1251: Client does not support authent
Have you tried my MySQL C API Site ?
I have posted some C API examples here.
http://www.geocities.com/jahan.geo
Aftab Jahan Subear
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
North Jatrabari
Dhaka 1204
Bangladesh
http://www.DhakaStockExchangeGame.com
Tel: +880-2-7519050
/*
Get customized T-S
At 21:20 + 11/14/04, premal mishra wrote:
I'm using MySQL version 4.0.20a on win98.
Compiler is Bloodshed Dev-C++ version 4.
My program compiles and links but gives a page fault error on running.
I'm linking the '\mysql\lib\opt\mysqlclient.lib' file.
Linker gives the warning >> ignoring duplic
See http://www.connectionstrings.com/
Regards,
Ulises
-Mensaje original-
De: Ratmil Torres [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles 6 de Agosto de 2003 07:11 AM
Para: [EMAIL PROTECTED]
Asunto: Connecting to MySQL from ASP
Hi. I am developing a web site using ASP. I need to connec
Depending on what driver of MySQL ODBC you are using.
The one below I use for v3.51:
strConnString = "drver={MySQL ODBC 3.51
Driver};server=SERVER_IP;database=DB_NAME;user=UID;password=PWD;OPTION=4
The one below I used in the past for v2.50:
strConnString =
"driver=MySQL;server=SERVER_IP;uid=UID;p
Your 'root' password was probably not set hence, you didn't need a password.
Bhavin.
- Original Message -
From: "Pikasz Gyorgy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 17, 2002 7:46 AM
Subject: Connecting to mysql
> I'm logged in to RedHat Linux as an user and
See this thread :
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128
- Original Message -
From: "Michael Gargiullo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 9:26 AM
Subject: connecting to mysql server from other machines
> I have a huge proble
Well, after much fussing around with RPM's and searching this list, I have
resolved my problem.
The clue was the discussion on this list regarding the glibc bug. I upgraded
to the 4.0.x RPM's that I got from the MySQL site and after I got all of the
dependency problems fixed I was able to start up
> Thank you, but at this point I am pretty sure that my problem is not a
> matter of entries in the user table. When I attempt to telnet
> into port 3306
> the connection is immediately dropped. I don't really know if
> any connection
> is actually established at all, it may be established and imme
ebmin tip, I'll give it a try. Doesn't solve all of my
problem, but it may help.
Thanks,
--Will
> -Original Message-
> From: STIBS [mailto:stibs-pi@;gmx.de]
> Sent: Friday, October 18, 2002 1:35 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
&
Will,
|||)So I still need some more ideas.
I have to learn your problem each time again when I setup a new machine every half a
year.
I try each time the following hostnames:
localhost (didn't work 4u)
127.0.0.1 (IP for localhost)
hostname (e.g. databaseserver.mydomain.com- what you called the
Thank you to both of you who responded to my question. I have checked both
of these issues and found that neither solve my situation.
1) I have (and had) both a 'will@localhost' and a 'will@"%"' entry in the
user table. Is there something else that has to be done to set up the host?
2) According
Hi,
It seems to me that you can't connect to MySQL from an other machine at
all. Did you start MySQL with the --skip-networking option? Try removing
that option from the start-up scripts.
\Olaf
Will Merrell wrote:
I cannot connect from my Windows machine to the MySQL database running on
the L
Will,
Do you have a user/host pair for the client in the user table within the
mysql database?? It's not good enough just to have a user, the host has
to be setup too.
> I cannot connect from my Windows machine to the MySQL database running
on
> the Linux server.
>
> I have tried several differ
ops, sorry jay,
i forgot this...
do you install mysql in your web server?
if you install it on your web server, so i think you should install the odbc
driver for mysql in your web server...
and after that u can use your asp script to make connection to your mysql
database
have a nice try :-
dear jay fields,
pls try this, hope this can help u...
dim objconn, objrs
set objconn = server.createobject("adodb.connection")
set objrs = server.createobject("adodb.recordset")
objconn.connectionstring="server=192.168.0.1;driver=MySQL;db=[database_name]
;uid=[user_name];pwd=[user_passwo
Tell me what you do
ADODB -> OLEDB driver for ODBC -> MyODBC -> MySQL
ADODB -> MyOLEDB -> MySQL
or anything else?
first case: check "don't promt on connect"
Did you create a data source? (First thing you don't need to do...)
But whatever you do with VB, MS ADODB and MySQL - you will need
Hi,
Search if somebody has the OLEDB driver for MySQL, and
then you will be able to do it.
Bye and Good Luck!
--- "Darrell A. Sullivan, II"
<[EMAIL PROTECTED]> wrote:
> Can anyone tell me if it is possible to connect to a
> MySQL server running on
> Linux from a Windows Visual Basic application
- Original Message -
From: "Jeremy 'Circ' Charles" <[EMAIL PROTECTED]>
To: "Oladejo, Tokunboh" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 3:21 PM
Subject: Re: Connecting to mysql Server
> On Mon, 25 Feb 200
On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote:
> Does anyone have an idea why I am getting an error "Fatal error: Call to
> undefined function: mysql_connect() in /var/www"
That's the error you get if you try to call mysql_connect() but don't have
the MySQL support compiled in to the PHP module.
Put double quotes around % so that foo@"%"
On Sun, 6 Jan 2002 18:31:00 -0500, Christian J Hedemark wrote:
>mysql> grant all privileges on *.* to foo@% identified by 'foobar' with
>grant option;
>ERROR 1064: You have an error in your SQL syntax near '% identified by
>'foobar' with grant option' a
> GRANT ALL PRIVILEGES ON *.* TO tue@"%" IDENTIFIED BY 'apassword' WITH
GRANT OPTION;
Ah but that doesn't work this is what worries me because I have a book
on mysql that uses syntax like this and it generates an error on my system.
This is a Red Hat 7.2 system, stock with Red Hat distribute
On Mon, 7 Jan 2002 00:03:20 +0100, Tue Hellstern wrote:
>I cant connect to a MySql Database form a Windows PC, I get Host ... is
>not allowed to connect to this MySQL server and in the MySql manual I
>found the following solution but I dont know how to do it. I am an
>novice in MySql.
>If anyo
it wuld be nice if mysql supported sub queries
ie.
select A.MESSAGEID from MESSAGEDATA as A where A.MESSAGEID
in (select B.MESSAGEID from MESSAGES as B where
B.SUBJECT='Invitation to join the hanky panky group')
_
Do You Yahoo!?
Get you
Good morning Kamal,
From: <[EMAIL PROTECTED]>
> More so will i need to open MySQL server on my local machine before running
> MySQL client to connect to the remote machine e.g.
No. The service (mysqld) is strictly assigned to managing the local database(s) and to
serve access to those databas
[EMAIL PROTECTED] writes:
> More so will i need to open MySQL server on my local machine before running
> MySQL client to connect to the remote machine e.g.
A client is a client and a server is a server. The point of separating
the two is that you can then run the client somewhere and and the
s
>I suspect that you need to add an entry at the MySQL host for the machine
that you are connecting from. This can be done with a GRANT statement:
>
>- Format:
>grant all privileges on databaseName.tableName
>to 'userName'@'hostName'
>identified by 'somePassword';
>
>
>- Example
From: <[EMAIL PROTECTED]>
> I have a similar problem...
Just to be sure, it's helpful if you could send us the message that your getting when
you see the connection problem, but this sounds like the same thing.
> Can this sovle my sleeplessness problem?
Probably. Anytime I can't sleep, I jus
At 03:23 PM 12/10/01 -0700, you wrote:
>From: Dan <[EMAIL PROTECTED]>
>
>> I can connect... on the same computer
>> ...different machine it won't work.
I have a similar problem but let explain better may be i don't get what Dan
was talking about. From my local computer i can use LOAD command to s
From: Dan <[EMAIL PROTECTED]>
> I can connect... on the same computer
> ...different machine it won't work.
I suspect that you need to add an entry at the MySQL host for the machine that you are
connecting from. This can be done with a GRANT statement:
- Format:
grant all privileges on
Make sure you have permissions to connect to the remote site from your
current server or host. Permissions need to be set for that user to connect
from your server host
- Original Message -
From: "Hamzat Kamal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 03, 2001 8:2
Richard Gibbs wrote:
> sorry if this is the wrong list
>
> I am a beginner user of mysql, but a few pl I know are very active in
> scripting using mirc, especially gaming using tcp/ip connections to game
> servers to find out various details.
>
> I would like to know how/if I can connect to a m
James Gosnell wrote:
> If I connect to mysql:
> mysql -u username -p wherever.net
>
> is that encrypted at all?
No and never will be default behaviour to encrypt communication as this reduces
performance.
> and if I make a network program via the C API, would that be encrypted
> too? T
ehalf
> Of [EMAIL PROTECTED]
> Sent: 29 June 2001 10:41
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Connecting to MySQL w/VB
>
>
> Give MyODBC a try, its on the mysql.com site
> and its given my no problems at all in vb.
>
> Sean
>
> -Origin
Give MyODBC a try, its on the mysql.com site
and its given my no problems at all in vb.
Sean
-Original Message-
From: Robert Skinner [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 3:45 AM
To: [EMAIL PROTECTED]
Subject: Connecting to MySQL w/VB
I am trying to connect to MySQL u
]>
Sent: Thursday, June 28, 2001 11:38 PM
Subject: Re: Connecting to MySQL w/VB
> - Original Message -
> From: "Jason Brunk" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 28, 2001 8:18 PM
> Subject: Re: Connecting to MySQL w/VB
- Original Message -
From: "Jason Brunk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 8:18 PM
Subject: Re: Connecting to MySQL w/VB
> i know i am definitly knew at this, but his permissions could be set more
or
> less for read on
gnore me if i am being an idiot.
Jason
- Original Message -
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 11:03 PM
Subject: Re: Connecting to MySQL w/VB
> - Original Message --
- Original Message -
From: "Robert Skinner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 7:44 PM
Subject: Connecting to MySQL w/VB
> I am trying to connect to MySQL using a connection string using VB6. The
> read part is great but I don't seem to be able to
> For connecting I have given the user as root and no password in the PERL
> scipt.
You NEED to provide the password otherwise you can't get any data out of
the database.. If you didn't entered a password for the mysql root user you
need to do it ASAP..
>Is there any way to connect
On 12 Apr 2001, at 16:03, josh kneedler wrote:
> i'm trying to connect to mysql using php so that i can do web based
> queries of my tables. i'm new at this so here are some questions:
> 1. is localhost just the ip of my server or is it also the path to
> where mysql is on my server?
Just the
Let me explain a little further.
- Original Message -
From: "josh kneedler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 13, 2001 7:03
Subject: connecting to mysql using php
> i'm trying to connect to mysql using php so that i can do web based
> queries of my tables. i
This is a real RTFM, but here we go:
On Thu, Apr 12, 2001 at 04:03:20PM -0700, josh kneedler wrote:
> i'm trying to connect to mysql using php so that i can do web based
> queries of my tables. i'm new at this so here are some questions:
> 1. is localhost just the ip of my server
Yes. Or just
for visual basic & mysql
http://www.avukatpro.com/mysql.html
- Original Message -
From: Dwight Mowbray <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 4:18 AM
Subject: Connecting to MySQL with Visual Basic
Hi.
Can anyone tell me how or refer me to any tuto
You can also use MyVbQL.dll ... take a look at
http://www.icarz.com/mysql/index.html
Eric
Rolf Hopkins wrote:
> Someone sent me some samples of various connection type (ADO, DAO, etc)
> about a month ago but I'll post off list.
>
> - Original Message -
> From: "Dwight Mowbray" <[EMAIL
Someone sent me some samples of various connection type (ADO, DAO, etc)
about a month ago but I'll post off list.
- Original Message -
From: "Dwight Mowbray" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 10:18
Subject: Connecting to MySQL with Visual Basic
H
47 matches
Mail list logo