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
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 diagram generating

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

2011-04-12 Thread Martijn Tonies
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 Both _seem_ robust

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

2011-04-08 Thread Daevid Vincent
@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 wires between tables and all that glory). Am I wrong

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

2011-04-08 Thread Johan De Meersman
- Original Message - From: Daevid Vincent dae...@daevid.com 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

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 the actual

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

2011-04-07 Thread Jason Trebilcock
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 the actual columns? I am evaluating various

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

2011-04-07 Thread mos
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 of existing

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

2011-04-07 Thread Daevid Vincent
: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 twice and they've not replied either. Take a look

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

2011-04-07 Thread Daevid Vincent
@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 with it as well. But, another tool worth exploring nonetheless. On Thu

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

2011-04-07 Thread mos
. 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 connecting the actual

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
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 wrong: file descriptor 2

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(); ++ |

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 and TLS

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 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

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 now when I

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

RE: Connecting Remotely to MySQL Server

2010-06-07 Thread Qu, Gang
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 external world

Re: Connecting Remotely to MySQL Server

2010-06-07 Thread Andy
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 external

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

2009-08-12 Thread Johan De Meersman
. 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 same host via a port or socket Ah. I have found

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

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

2009-08-11 Thread Andrew Braithwaite
] 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 locally via

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

2009-08-11 Thread Gavin Towey
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 it's the same server

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: Slow connecting to MySQL from Windows App

2009-05-05 Thread Martin Gainty
...@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, the client rebooted it. They shut it down properly and then later

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

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: 04 May

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

2007-05-16 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 network

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

2007-05-16 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, $database);

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-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 = new

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

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=

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

Trouble connecting to server

2007-04-23 Thread Drew Burchett
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)527-3293 Fax: (270)527-3132

Re: Trouble connecting to server

2007-04-23 Thread Barry Newton
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 possible that the old IP

RE: Trouble connecting to server

2007-04-23 Thread Drew Burchett
@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 the machine was bad

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 General

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

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

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. sigh 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 messages

RE: Connecting from a remote computer

2007-01-18 Thread Jerry Schwartz
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 IIS server. sigh The remote connection seems

using SSL certificates when connecting to mysqld

2006-11-29 Thread Amit Dor-Shifer
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 to use these files. [mysql

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 for

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

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: 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 following

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 following

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

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

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 it

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 a standard

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

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

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

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

Connecting to queries into one

2006-02-27 Thread phpninja
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 cases

RE: Connecting to queries into one

2006-02-27 Thread Taiyo
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

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 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 cases

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

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

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

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

RE: error connecting to db.

2006-01-16 Thread Logan, David (SST - Adelaide)
: [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: $MySQLServer

RE: error connecting to db.

2006-01-16 Thread doug
- 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) _ Douglas

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 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:

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

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

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

RE: Need Help Connecting

2005-12-21 Thread Logan, David (SST - Adelaide)
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 following

Re: Need Help Connecting

2005-12-21 Thread Mark Phillips
:[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. 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

RE: Need Help Connecting

2005-12-21 Thread Logan, David (SST - Adelaide)
+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? Thanks

Re: Need Help Connecting

2005-12-21 Thread Mark Phillips
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? Thanks! Mark On Wednesday 21

RE: Need Help Connecting

2005-12-21 Thread Logan, David (SST - Adelaide)
+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 got: [EMAIL

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 trying connect via the ssh

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

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

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

Re: [Replication] Problem connecting to master

2005-08-29 Thread Gleb Paharenko
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': Error: 'Can't connect to MySQL server on 'alturo.vlugnet.org

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]

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

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 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 | +-+---+ |

[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

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 hostname. Error: unknown system variable 'sql_mode' (code 1193) I

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

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

Re: Problem connecting to 4.1 server

2005-05-16 Thread Nicholas Watmough
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 Windows Server 2003, which

Re: Error Connecting To Server From Client Machine-Linux

2005-05-13 Thread Mark Sargent
@lists.mysql.com 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 not allowed

Re: Error Connecting To Server From Client Machine-Linux

2005-05-09 Thread Alvaro Cobo
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 not allowed to connect

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: 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

Re: Problem connecting to 4.1 server

2005-05-06 Thread Gleb Paharenko
] 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 started with --old-password (to ensure back

  1   2   3   4   5   >