Connecting to MySQL Community Edition from Informatica Powercenter 9.5.1 running on AIX

2013-10-02 Thread Saqib N Ali
Is it possible to MySQL Community Edition (as target) from Informatica Powercenter 9.5.1 running on AIX? If so, what is ODBC driver should we use?

How do I get more pages in mySQL Workbench?? WAS: Any table visualization tools with wires connecting the actual columns?

2011-05-03 Thread Daevid Vincent
ade 4 pages for me. Anyone know how to get more pages added? From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Friday, April 01, 2011 4:27 PM To: mysql@lists.mysql.com Subject: Any table visualization tools with wires connecting the actual columns? I am evaluating various tools for diagra

Re: Any table visualization tools with wires connecting the actual columns?

2011-04-12 Thread Martijn Tonies
ools with wires connecting the actual columns? I am evaluating various tools for diagram generating of existing databases on some smaller databases (9 tables or so) first. The two I've tried so far are these: http://dev.mysql.com/downloads/workbench/ http://www.sqlmaestro.com/download/#mysql

Re: Any table visualization tools with wires connecting the actual columns?

2011-04-08 Thread Johan De Meersman
- Original Message - > From: "Daevid Vincent" > > It only seems to do the lines for InnoDB tables, not MyISAM... I > mean, it not only won't auto-connect them, it won't even allow ME to connect > them. :( Probably because it wants to adhere to the engine capabilities, and MyISAM doesn't

RE: Any table visualization tools with wires connecting the actual columns?

2011-04-08 Thread Daevid Vincent
8:50 PM > To: mysql@lists.mysql.com > Subject: RE: Any table visualization tools with wires connecting the actual > columns? > > At 05:36 PM 4/7/2011, Daevid Vincent wrote: > >I am a paid subscriber to SQLYog -- I love that tool, but AFAIK it > >doesn't do diagrams (with wire

RE: Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread mos
igner. Take a look at the screen shots. http://www.webyog.com/en/screenshots.php Mike > -Original Message- > From: mos [mailto:mo...@fastmail.fm] > Sent: Thursday, April 07, 2011 1:36 PM > To: mysql@lists.mysql.com > Subject: Re: Any table visualization tools with wires c

RE: Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread Daevid Vincent
Sent: Thursday, April 07, 2011 12:38 PM > To: mysql@lists.mysql.com > Subject: Re: Any table visualization tools with wires connecting the actual > columns? > > Toad for MySQL can do the diagramming piece...but, it looks and feels like > you might have some of the same frustrations wit

RE: Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread Daevid Vincent
sday, April 07, 2011 1:36 PM > To: mysql@lists.mysql.com > Subject: Re: Any table visualization tools with wires connecting the actual > columns? > > At 02:17 PM 4/7/2011, Daevid Vincent wrote: > >Does anyone have any suggestions on this? I've written to SQL Maestro > >t

Re: Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread mos
ponsive to emails and forum posts. Mike From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Friday, April 01, 2011 4:27 PM To: mysql@lists.mysql.com Subject: Any table visualization tools with wires connecting the actual columns? I am evaluating various tools for diagram generating o

Re: Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread Jason Trebilcock
written to SQL Maestro twice > and they've not replied either. > > > > From: Daevid Vincent [mailto:dae...@daevid.com] > Sent: Friday, April 01, 2011 4:27 PM > To: mysql@lists.mysql.com > Subject: Any table visualization tools with wires connecting the actual >

Any table visualization tools with wires connecting the actual columns?

2011-04-07 Thread Daevid Vincent
Does anyone have any suggestions on this? I've written to SQL Maestro twice and they've not replied either. From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Friday, April 01, 2011 4:27 PM To: mysql@lists.mysql.com Subject: Any table visualization tools with wires connecting

Any table visualization tools with wires connecting the actual columns?

2011-04-01 Thread Daevid Vincent
I am evaluating various tools for diagram generating of existing databases on some smaller databases (9 tables or so) first. The two I've tried so far are these: http://dev.mysql.com/downloads/workbench/ http://www.sqlmaestro.com/download/#mysql Both _seem_ robust and cosmetically polished, but

Re: Problems Connecting with SSL

2011-02-25 Thread Joerg Bruehe
Hi! Martin Gainty wrote: > [[...]] > > joerg ..any thoughts on this matter?? Sorry - none. I never dealt with the inner workings of the SSL library. Just seeing file descriptor 2 (standard error) used for socket operations makes me assume *very* strongly that something went wrong well before t

Re: Problems Connecting with SSL

2011-02-25 Thread Tim Gustafson
> perhaps a misconfiguration on the failing client .. > can you go to successful client, enable DEBUG level > debugging and log the connection and then go to the > failing client..enable DEBUG level debugging and log > the connection to the failing client this would determine > deltas between the

Re: Problems Connecting with SSL

2011-02-25 Thread Tim Gustafson
> Interesting that you can request advice from finland vs > calling from redwood shores CA for technical advice > > first take a look at: > http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html > > once you've determined the algorithm you will want to implement > take a look at SSL 1,2,3 a

Re: Problems Connecting with SSL

2011-02-25 Thread Tim Gustafson
> Sorry, but I have to start with a negative remark: > Why, oh why, don't you mention the version number you > are using? I hope it is some roughly current 5.1, but > I'd rather like you to tell it. Doh! Right you are! Sorry, that was totally my bad. mysql> select version(); ++ | ve

Re: Problems Connecting with SSL

2011-02-25 Thread Joerg Bruehe
le and all of which are > generally accessible from remote clients over SSL. > > However, one of my FreeBSD mySQL clients is having problems connecting to any > of the servers. Running mySQL under truss reports the following: > Looking at this output tells something went terribly

Problems Connecting with SSL

2011-02-24 Thread Tim Gustafson
I have three mySQL server, all of which are SSL-enable and all of which are generally accessible from remote clients over SSL. However, one of my FreeBSD mySQL clients is having problems connecting to any of the servers. Running mySQL under truss reports the following

RE: Connecting Remotely to MySQL Server

2010-06-08 Thread Qu, Gang
: Monday, June 07, 2010 5:58 PM To: Qu, Gang Cc: mysql@lists.mysql.com Subject: Re: Connecting Remotely to MySQL Server OK so I managed to open 3306. Now when I connect using 127.0.0.1 from the intranet box it works, but when I connect using it's IP it's still the same situation :( And

Re: Connecting Remotely to MySQL Server

2010-06-07 Thread Andy
rom: listan...@gmail.com [mailto:listan...@gmail.com] > Sent: Monday, June 07, 2010 3:37 PM > To: mysql@lists.mysql.com > Subject: Connecting Remotely to MySQL Server > > Hello all, > > New to MySQL and still exploring. I have MySQL installed on one of the > boxes > on the in

RE: Connecting Remotely to MySQL Server

2010-06-07 Thread Qu, Gang
2010 3:37 PM To: mysql@lists.mysql.com Subject: Connecting Remotely to MySQL Server Hello all, New to MySQL and still exploring. I have MySQL installed on one of the boxes on the intranet (on which I am not the root) and am trying to connect to it remotely via a box (that can be see from the

Connecting Remotely to MySQL Server

2010-06-07 Thread listan...@gmail.com
Hello all, New to MySQL and still exploring. I have MySQL installed on one of the boxes on the intranet (on which I am not the root) and am trying to connect to it remotely via a box (that can be see from the "external world"). Unfortunately it does not seem to be working. Here's what I did from t

Re: Replication - connecting a slave to a master on the same host via a port or socket

2009-08-12 Thread Johan De Meersman
nnections. > > Regards, > Gavin Towey > > -Original Message- > From: Andrew Braithwaite [mailto:andrew.braithwa...@lovefilm.com] > Sent: Tuesday, August 11, 2009 8:38 AM > To: mysql@lists.mysql.com > Subject: RE: Replication - connecting a slave to a master on the

RE: Replication - connecting a slave to a master on the same host via a port or socket

2009-08-11 Thread Gavin Towey
2009 8:38 AM To: mysql@lists.mysql.com Subject: RE: Replication - connecting a slave to a master on the same host via a port or socket Ah. I have found that if you use 'localhost' to connect, you cannot specify a port, it silently fails... You can connect using a hostname (even though

RE: Replication - connecting a slave to a master on the same host via a port or socket

2009-08-11 Thread Andrew Braithwaite
..@lovefilm.com] Sent: 11 August 2009 16:12 To: mysql@lists.mysql.com Subject: Replication - connecting a slave to a master on the same host via a port or socket Hi, I have 2 mysql instances running on a server on different ports with different datadirs and different .sock files. I can connect

Replication - connecting a slave to a master on the same host via a port or socket

2009-08-11 Thread Andrew Braithwaite
Hi, I have 2 mysql instances running on a server on different ports with different datadirs and different .sock files. I can connect locally via the sock with the -S flag to mysql but I cannot connect locally via port (-P flag). Does anyone know if there is a way to configure a mysql slave to us

RE: Slow connecting to MySQL from Windows App

2009-05-05 Thread Martin Gainty
y 2009 08:43:51 -0400 > From: gro...@bcconsultingservices.com > To: mysql@lists.mysql.com > Subject: Slow connecting to MySQL from Windows App > > Hi, > > I am hoping someone here can help me. I have an Ubuntu 8.04 server that > has worked FINE for months. The other day,

Slow connecting to MySQL from Windows App

2009-05-05 Thread Menachem Bazian
reasons). Ever since then, when I try to connect to the MySQL server it is running dead slow. As in 20-30 seconds to get a connect. By the way, I just tried it with MySQL Administrator and it has problems connecting as well so it is not the connector. The server is located internally on a gigabit

RE: Slowness connecting to MySQL

2009-05-04 Thread Andrew Braithwaite
It could be slow reverse DNS lookups. Make sure the hostname/IP of the client are in the server's host file. Or try connecting to the server using an IP address instead of hostname. Andrew -Original Message- From: Menachem Bazian [mailto:gro...@bcconsultingservices.com] Sent: 0

Slowness connecting to MySQL

2009-05-04 Thread Menachem Bazian
because he thought he would have to move the box. He did NOT move the box, as it turns out, and he turned the box back on. Ever since then, connecting to the box with the app has been S L O W. Like 10-20 seconds slow. Since nothing has changed, I cannot figure out what the heck is going on. This

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread John Comerford
Hi Sebastian, That was it alright. I commented out the socket lines from mysql.ini (restarted it) and changed my php command to: $mysqli = new mysqli(".", $username,$password, $database); and all seems to be working fine now. Thanks again for your help, much appreciated. Regards, John

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread Sebastian Mendel
John Comerford schrieb: > Hi Sebastian, > > I did read somewhere that sockets was not valid for windows, and > '/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have > tried the following commands: > > $mysqli = new mysqli(".", $username,$password, $database); > or > $mysqli =

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread John Comerford
Hi Sebastian, I did read somewhere that sockets was not valid for windows, and '/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have tried the following commands: $mysqli = new mysqli(".", $username,$password, $database); or $mysqli = new mysqli(".", $username,$password, $

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-15 Thread Sebastian Mendel
John Comerford schrieb: > Thanks Sebastian, that did the trick. > The full command I use is: > $mysqli = new mysqli(".", $username,$password, > $database,null,"/tmp/mysql.sock"); there is no need for the socket, their are no sockets on windows $mysqli = new mysqli('.', $username, $password, $dat

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-15 Thread John Comerford
Thanks Sebastian, that did the trick. The full command I use is: $mysqli = new mysqli(".", $username,$password, $database,null,"/tmp/mysql.sock"); Regards, JC Sebastian Mendel wrote: John Comerford schrieb: Hi Folks, I have a database running on Window XP, that I want to disable netwo

Re: Newbie Question connecting with windows named pipes

2007-05-15 Thread Sebastian Mendel
John Comerford schrieb: > Hi Folks, > > I have a database running on Window XP, that I want to disable network > connections to and enable 'named pipes'. I am running MySQL 5.0.27 > and my.ini looks like... > > [...] > > I can connect to the DB using the GUI tools if I set my pipe name to > '

Newbie Question connecting with windows named pipes

2007-05-15 Thread John Comerford
Hi Folks, I have a database running on Window XP, that I want to disable network connections to and enable 'named pipes'. I am running MySQL 5.0.27 and my.ini looks like... [client] #password= your_password port= 3306 socket= /tmp/mysql.sock [mysqld] #port= 33

RE: Trouble connecting to server

2007-04-23 Thread Drew Burchett
ysql@lists.mysql.com Subject: Re: Trouble connecting to server At 11:36 AM 4/23/2007, Drew Burchett wrote: >I have a mysql v 5.0 server running on Suse Linux 10.1. It has been >running steadily and properly for several months now. However, when I >came in this morning, my network card in th

Re: Trouble connecting to server

2007-04-23 Thread Barry Newton
x27;s as far as it goes. I've restarted the machine several times in vain hopes that it might kickstart something. I've also tried connecting from other machines, which seems to work perfectly. Any suggestions on how to proceed troubleshooting this? Reconfigured the network. . .Is it

Trouble connecting to server

2007-04-23 Thread Drew Burchett
the machine several times in vain hopes that it might kickstart something. I've also tried connecting from other machines, which seems to work perfectly. Any suggestions on how to proceed troubleshooting this? Thanks, Drew Burchett United Systems & Software Ph:(270)

RE: Connecting from a remote computer

2007-01-18 Thread Jerry Schwartz
; From: Kay C. Tien [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 18, 2007 4:32 PM > To: Chris White > Cc: mysql@lists.mysql.com > Subject: Re: Connecting from a remote computer > > I got it working perfectly on a Linux server, but my boss wants this > on a Windows I

Re: Connecting from a remote computer

2007-01-18 Thread Kay C. Tien
I got it working perfectly on a Linux server, but my boss wants this on a Windows IIS server. The remote connection seems to be working now but I have another problem now... the page is not doing anything - doesn't seem to be connecting to the database, but I got no error mes

Re: Connecting from a remote computer

2007-01-18 Thread Chris White
Just to toss something else in here. A lot of times you have a server that you can connect to by ssh, but because of firewalls, can't access mysql through. If you can, however, connect to the database through ssh, you can do port forwarding. In *nix systems it should be something like this:

Re: Connecting from a remote computer

2007-01-18 Thread Nuno Vaz Oliveira
Hi All, This is a dump and simple question but I can't seem to get it to work. How do I enable a user to be able to connect from a remost host using MySQL Administrator? I added "%" but once signed in, I still can't access the user panel in the administrator. Thanks. Kay I don't know if I can

Connecting from a remote computer

2007-01-18 Thread Kay C. Tien
Hi All, This is a dump and simple question but I can't seem to get it to work. How do I enable a user to be able to connect from a remost host using MySQL Administrator? I added "%" but once signed in, I still can't access the user panel in the administrator. Thanks. Kay -- MySQL Genera

using SSL certificates when connecting to mysqld

2006-11-29 Thread Amit Dor-Shifer
scenario I'll be specifying relates to connecting a mysql client console to mysqld with SSL. 1. I've created the necessary certificates, as mentioned in http://dev.mysql.com/doc/refman/4.1/en/secure-create-certs.html. 2. I've configured [mysql] and [mysqld] appropriatly t

Re: Connecting mySQL to ColdfusionMX7

2006-08-30 Thread Tim
Ruth divulged the following in an email dated 8/30/2006 11:58 AM : > All, > > I am having difficulties getting the Coldfusion Administrator to establish a > database connection to a database called "accounting" that I created using > the command line utility. Any help would be very appreciated!!

Re: Connecting mySQL to ColdfusionMX7

2006-08-30 Thread Chris
Ruth wrote: All, I am having difficulties getting the Coldfusion Administrator to establish a database connection to a database called "accounting" that I created using the command line utility. Any help would be very appreciated This is the error that CF is throwing: "Connection verific

Connecting mySQL to ColdfusionMX7

2006-08-30 Thread Ruth
All, I am having difficulties getting the Coldfusion Administrator to establish a database connection to a database called "accounting" that I created using the command line utility. Any help would be very appreciated This is the error that CF is throwing: "Connection verification failed f

Re: Problems connecting using "-h hostname" with new installation

2006-08-07 Thread Daniel da Veiga
On 8/6/06, Ro BGCT <[EMAIL PROTECTED]> wrote: Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the foll

Re: Problems connecting using "-h hostname" with new installation

2006-08-07 Thread obed
On 8/6/06, Ro BGCT <[EMAIL PROTECTED]> wrote: Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the foll

Problems connecting using "-h hostname" with new installation

2006-08-06 Thread Ro BGCT
Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the following message: "ERROR 1130 (0): Host '75.1

Re: connecting to the embedded server

2006-07-19 Thread Frank
Jim Winstead wrote: > On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote: >> Dear all, >> >> is it a desired feature that the embedded version of the client library >> still tries to create a network connection when I pass a hostname into >> connect? > > Yes, the embedded version also acts as

Re: connecting to the embedded server

2006-07-19 Thread Jim Winstead
On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote: > Dear all, > > is it a desired feature that the embedded version of the client library > still tries to create a network connection when I pass a hostname into > connect? Yes, the embedded version also acts as a standard MySQL client. > Is

connecting to the embedded server

2006-07-19 Thread Frank
Dear all, is it a desired feature that the embedded version of the client library still tries to create a network connection when I pass a hostname into connect? Is it possible to influence this behaviour, so that the API just ignores settings like the hostname and the port and always connects t

Re: Connecting to mysql 4.1 server with a 4.0 client

2006-07-13 Thread Iain Conochie
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

Re: Connecting to mysql 4.1 server with a 4.0 client

2006-07-13 Thread Dan Trainor
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

Connecting to mysql 4.1 server with a 4.0 client

2006-07-13 Thread Iain Conochie
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 authentication protocol reque

Re: Connecting to queries into one

2006-02-27 Thread Peter Brawley
Courtney, >SELECT consumers.id FROM consumers >WHERE date_of_birth = ? AND consumer.id = >(SELECT consumer_id FROM cases WHERE last_name = ? >AND full_first_name = ? ) >Is there a way to form the above statement in MYSQL? Something like this would be faster ... SELECT co.id FROM c

RE: Connecting to queries into one

2006-02-27 Thread John McCaskey
:31 AM To: mysql@lists.mysql.com Subject: Connecting to queries into one MY GOAL To collect any consumers.id WHERE date of birth, last name and first name matches what was entered by the user. The trick is that date of birth lives in the consumer

RE: Connecting to queries into one

2006-02-27 Thread Taiyo
, February 27, 2006 1:31 PM To: mysql@lists.mysql.com Subject: Connecting to queries into one MY GOAL To collect any consumers.id WHERE date of birth, last name and first name matches what was entered by the user. The trick is that date of birth lives in

Connecting to queries into one

2006-02-27 Thread phpninja
:31 AM To: mysql@lists.mysql.com Subject: Connecting to queries into one MY GOAL To collect any consumers.id WHERE date of birth, last name and first name matches what was entered by the user. The trick is that date of birth lives in the consumer table and last name and first name lives in the

Connecting to queries into one

2006-02-27 Thread Courtney Braafhart
MY GOAL To collect any consumers.id WHERE date of birth, last name and first name matches what was entered by the user. The trick is that date of birth lives in the consumer table and last name and first name lives in the cases table (which can be joined to consumers b

Re: Trouble connecting to 5.0.18

2006-02-07 Thread Brandon Ooi
oh i forgot to mention, the new passwords are stored in the database already. you need to reset the password with the OLD_PASSWORD() function. they detail that in the documentation b Brandon Ooi wrote: this refers to a new password scheme used in mysql 4.1 and above. see here to fix this...

Re: Trouble connecting to 5.0.18

2006-02-07 Thread Brandon Ooi
this refers to a new password scheme used in mysql 4.1 and above. see here to fix this... http://dev.mysql.com/doc/refman/5.0/en/old-client.html b John Hoover wrote: I've been running MySQL 4.0.20 on Mac OS 10.3.5 for some months and had been working on a custom client. It was working well

Trouble connecting to 5.0.18

2006-02-07 Thread John Hoover
I've been running MySQL 4.0.20 on Mac OS 10.3.5 for some months and had been working on a custom client. It was working well until I upgraded by computer to 10.4.3 and MySQL to 5.0.18. My client can not longer connect - I get an error message: "Client does not support authentication protocol req

Re: error connecting to db.

2006-01-16 Thread Ligaya Turmelle
remove the @ - it surpresses the errors. set your error_reporting to E_ALL and find out the DB error message with mysql_error. error_reporting(E_ALL); $SvrConn = mysql_connect($MySQLServer, $MySQLUser, $MySQLPassword); if(!$SvrConn) { echo 'Failure to connect! Error message returned: '.mysql

RE: error connecting to db.

2006-01-16 Thread Logan, David (SST - Adelaide)
PROTECTED] Sent: Tuesday, 17 January 2006 2:55 PM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: RE: error connecting to db. Thanks for the link I am glad the site has added manuals for multiple versions. I think I have access and db privileges set properly. I can (in effect

RE: error connecting to db.

2006-01-16 Thread doug
com/doc/ page. > > Regards > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 17 January 2006 1:07 PM > To: mysql@lists.mysql.com > Subject: error connecting to db. > > I have a php application that connects with MySQL using: &g

RE: error connecting to db.

2006-01-16 Thread Logan, David (SST - Adelaide)
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 17 January 2006 1:07 PM To: mysql@lists.mysql.com Subject: error connecting to db. I have a php application that connects with MySQL using: $SvrConn = @mysql_connect($MySQLServer, $MySQLUser, $MySQLPassword) where: $M

error connecting to db.

2006-01-16 Thread doug
I have a php application that connects with MySQL using: $SvrConn = @mysql_connect($MySQLServer, $MySQLUser, $MySQLPassword) where: $MySQLServer='127.0.0.1' $MySQLUser='dbuser' MySQLPassword='dbpasswd' and I can login using the above values. However connect fails: mysql> sele

Re: Need Help Connecting

2005-12-22 Thread Mark Phillips
Here are the results of alias and type [EMAIL PROTECTED]:~$ alias alias ls='ls --color=auto' [EMAIL PROTECTED]:~$ type mysql mysql is /usr/bin/mysql And for the emily account: [EMAIL PROTECTED]:/home/mark$ alias alias ls='ls --color=auto' [EMAIL PROTECTED]:/home/mark$ type mysql mysql is /usr/

Re: Need Help Connecting

2005-12-22 Thread Michael Stassen
Mark Phillips wrote: David, This is what I got: [EMAIL PROTECTED]:~$ aliases bash: aliases: command not found Your shell is bash, so the correct command is `alias`. [EMAIL PROTECTED]:~$ which mysql /usr/bin/mysql Since you are using bash, it's a better idea to use `type` instead of `which

RE: Need Help Connecting

2005-12-21 Thread Logan, David (SST - Adelaide)
273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Mark Phillips [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 December 2005 5:36 PM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: Re: Need Help Connecting David, This is what I go

Re: Need Help Connecting

2005-12-21 Thread Mark Phillips
HP Managed Services > 148 Frome Street, > Adelaide 5000 > Australia > > +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -Original Message- > From: Mark Phillips [mailto:[EMAIL PROTECTED] > Sent: Thursday, 22 December 200

RE: Need Help Connecting

2005-12-21 Thread Logan, David (SST - Adelaide)
Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Mark Phillips [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 December 2005 5:21 PM To: mysql@lists.mysql.com Cc: Logan, David (SST - Adelaide) Subject: Re: Need Help Connecting David, How do I do that? T

Re: Need Help Connecting

2005-12-21 Thread Mark Phillips
+61 8 8408 4259 - Fax > > > -Original Message- > From: Mark Phillips [mailto:[EMAIL PROTECTED] > Sent: Thursday, 22 December 2005 5:02 PM > To: MYSQL List > Subject: Need Help Connecting > > I have the following setup - mysql 4.0.24 running on Debian Linux > stable

RE: Need Help Connecting

2005-12-21 Thread Logan, David (SST - Adelaide)
148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Mark Phillips [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 December 2005 5:02 PM To: MYSQL List Subject: Need Help Connecting I have the foll

Need Help Connecting

2005-12-21 Thread Mark Phillips
I have the following setup - mysql 4.0.24 running on Debian Linux stable. I set up a user 'mark' with a password. When I log into my Linux box as user 'mark', I cannot connect to mysql - I get this funny error message: [EMAIL PROTECTED]:~$ mysql -h localhost -u mark -p mysql: unknown option '--u

Re: ssh connecting with a mysql client I get: ERROR 2013

2005-10-21 Thread Ugo Bellavance
Gleb Paharenko wrote: Hello. Can you connect using the mysql command line client program? "leegold" <[EMAIL PROTECTED]> wrote: ssh connecting with a mysql client gui I get: ERROR 2013 Lost connection to MySQL server during query I'm using mysqlyog and tryin

Re: Connecting using MyODBC

2005-09-05 Thread Gleb Paharenko
Hello. I'm not familiar with this subject, however, have you been at: http://dev.mysql.com/doc/mysql/en/howto-cf.html http://dev.mysql.com/doc/mysql/en/programs-known-to-work-with-myodbc.html http://dev.mysql.com/doc/mysql/en/myodbc-tested-applications.html http://www.ma

Connecting using MyODBC

2005-09-02 Thread Ryan Stille
I am trying to connect to MySQL from within ColdFusion on a linux box. ColdFusion (version 5) came with a Merant driver, but it is too old to support transactions. I've downloaded libmyodbc_mysql.so (MyODBC 2.5) and also libmyodbc3.so (MyODBC 3.5) and could not get either of these to work. But I'

Re: [Replication] Problem connecting to master

2005-08-31 Thread Jan Roehrich
> If nothing helps, trace files could spill the light on your problem. many thanks for your help. With tracing I found the problem. Like almost every time it was just a typing error :-( Regards Jan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: [Replication] Problem connecting to master

2005-08-30 Thread Gleb Paharenko
Hello. If nothing helps, trace files could spill the light on your problem. See: http://dev.mysql.com/doc/mysql/en/making-trace-files.html Jan Roehrich <[EMAIL PROTECTED]> wrote: >> --skip-networking can be specified as the command line option. Use: >> show variables like 'skip_ne

Re: [Replication] Problem connecting to master

2005-08-29 Thread Nuno Pereira
Jan Roehrich wrote: --skip-networking can be specified as the command line option. Use: show variables like 'skip_networking'; to check if it is enabled. mysql> show variables like 'skip_networking'; +-+---+ | Variable_name | Value | +-+---+ | skip_ne

Re: [Replication] Problem connecting to master

2005-08-29 Thread Jan Roehrich
> --skip-networking can be specified as the command line option. Use: > show variables like 'skip_networking'; > to check if it is enabled. mysql> show variables like 'skip_networking'; +-+---+ | Variable_name | Value | +-+---+ | skip_networking | OFF

Re: [Replication] Problem connecting to master

2005-08-29 Thread Gleb Paharenko
Hello. > Could not see skip-networking anywhere. --skip-networking can be specified as the command line option. Use: show variables like 'skip_networking'; to check if it is enabled. Jan Roehrich <[EMAIL PROTECTED]> wrote: >> Please send your configuration files for master and s

Re: [Replication] Problem connecting to master

2005-08-29 Thread Jan Roehrich
> Please send your configuration files for master and slave. Check that > > you don't have skip-networking in your slave's configuration file. Master: -- [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-bin=bin-log server-id=1 [mysql.server] user=m

Re: [Replication] Problem connecting to master

2005-08-29 Thread Gleb Paharenko
ting up replication in the mysqld documentation > (http://dev.mysql.com/doc/mysql/en/replication-howto.html). > > But there are some error messages on the salve: > 050828 13:22:58 [ERROR] Slave I/O thread: error connecting to master > '[EMAIL PROTECTED]:3306

[Replication] Problem connecting to master

2005-08-28 Thread Jan Roehrich
I have a strange problem setting up replication. I followed each step of setting up replication in the mysqld documentation (http://dev.mysql.com/doc/mysql/en/replication-howto.html). But there are some error messages on the salve: 050828 13:22:58 [ERROR] Slave I/O thread: error connecting to

Problem connecting to MySQL 4.0.23 with MySQL Administrator 1.0.21 (Mac OS X)

2005-06-14 Thread Jan Pieter Kunst
Dear all, I have a MySQL 4.0.23 server running on an OpenBSD machine. When I try to connect to it with MySQL Administrator 1.0.21 from my Mac OS X machine, I get this error: Connection error Could not connect to MySQL instance at . Error: unknown system variable 'sql_mode' (code 1193) I can conn

Re: Problem connecting to 4.1 server

2005-05-23 Thread Gleb Paharenko
Hello. You may compile MySQL from source by yourself with enabled debugging, if an official binaries don't include it. See: http://dev.mysql.com/doc/mysql/en/windows-source-build.html I suggest you to forward your message to win32 list: http://lists.mysql.com/win32 Nicholas

Re: Problem connecting to 4.1 server

2005-05-22 Thread Nicholas Watmough
Hi, I read the suggested section, but I'm not sure whether I can actually do any debugging with the pre-compiled Windows MySQL server. Is it possible to turn on debugging with the pre-compiled binaries on Windows? I'm also not sure what the difference is between libmysql.lib and mysqlclient.

Re: Problem connecting to 4.1 server

2005-05-19 Thread Gleb Paharenko
Hello. You may switch to the debug version of libmysqlclient and research the problem. See: http://dev.mysql.com/doc/mysql/en/debugging-client.html > Yes, the mysql.exe is the same version - I installed version 4.1.10 of > the server (and binaries) from the Windows executab

Re: Problem connecting to 4.1 server

2005-05-16 Thread Nicholas Watmough
ml Nicholas Watmough <[EMAIL PROTECTED]> wrote: I am have trouble connecting to the MySQL server 4.1 using the API, though I have no trouble connecting using the same parameters from the command line mysql.exe. I'm using server version 4.1.10 on Wind

Re: Error Connecting To Server From Client Machine-Linux

2005-05-13 Thread Mark Sargent
t;[EMAIL PROTECTED]> To: Sent: Sunday, May 08, 2005 9:33 AM Subject: Error Connecting To Server From Client Machine-Linux Hi All, can ping the server from the client. Am seeing the attempted phpmyadmin connection from the client via the firewall alert. But, get an error saying that the client is

Re: Error Connecting To Server From Client Machine-Linux

2005-05-09 Thread Alvaro Cobo
gt; To: Sent: Sunday, May 08, 2005 9:33 AM Subject: Error Connecting To Server From Client Machine-Linux > Hi All, > > can ping the server from the client. Am seeing the attempted phpmyadmin > connection from the client via the firewall alert. But, get an error > saying that th

Re: Error Connecting To Server From Client Machine-Linux

2005-05-08 Thread Andy Pieters
Hi Mark You should know that users and passwords are specific to the host where they are being used. For instance, if your root password on the server is mypass, and use it to connect to the mysql server, then it will get accepted. Now if you use a mysql client on another machine to connect to

Error Connecting To Server From Client Machine-Linux

2005-05-08 Thread Mark Sargent
Hi All, can ping the server from the client. Am seeing the attempted phpmyadmin connection from the client via the firewall alert. But, get an error saying that the client is not allowed to connect to the mysql server. I'm guessing it's a setting in conf.inc.php..? $cfg['Servers'][$i]['host'] =

Re: Problem connecting to 4.1 server

2005-05-06 Thread Gleb Paharenko
ROTECTED]> wrote: > I am have trouble connecting to the MySQL server 4.1 using the API, > though I have no trouble connecting using the same parameters from the > command line mysql.exe. > > I'm using server version 4.1.10 on Windows Server 2003, which was > star

  1   2   3   4   5   >