Re: connection issue

2013-08-09 Thread Claudio Nanni
Hi, # mysql -P 5045 Add -h127.0.0.1 # mysql -P5045 -h127.0.0.1 Cheers -- Claudio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: connection issue

2012-12-25 Thread Tianyin Xu
Thanks, Doug. How did you figure out it's because of "open_files_limit"? Best, Tianyin On Sat, Dec 22, 2012 at 5:51 AM, Doug wrote: > sorry the problem has been resolved. > it's the reason of open_files_limit too small. > I increased it and the problem resolved. > > 2012/12/22 Doug : >> Hello, >

Re: connection issue

2012-12-22 Thread Doug
sorry the problem has been resolved. it's the reason of open_files_limit too small. I increased it and the problem resolved. 2012/12/22 Doug : > Hello, > > When connecting to mysql, sometime I got this error: > > # mysql -ucdn -h113.108.22x.xx -p > Enter password: > ERROR 2013 (HY000): Lost connec

Re: Connection Diagnostic Tool

2010-07-05 Thread Rob Wultsch
On Mon, Jul 5, 2010 at 3:55 PM, michel wrote: > > I have been trying to figure this one out, but I don't have the skill sets > here so I can use some help. > > I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so I > am still really off-the-mark. Is there a place on the net I

re: Connection Diagnostic Tool

2010-07-05 Thread michel
d how to run it? Thanks! - Original Message - From: "Michael Dykman" To: "michel" Sent: Saturday, July 03, 2010 11:37 PM Subject: Re: Connection Diagnostic Tool You are right.. Java never coonnects on that domain socket, it *always* used TCP. Check your credentials at

Re: Connection Diagnostic Tool

2010-07-03 Thread Michael Dykman
I use c3p0 to manage MySQL connections in my JVM stack and have for years in many installations, I have never had to do anything special. If I can connect to the server through the console at the command line of the client machine using the same credentials, then the stack will just work. Are you

Re: CONNECTION (SOCKET AND TCP/IP)

2009-10-27 Thread lists
Socket connections do not use tcp (meaning localhost) Remote hosts use tcpip Sent via BlackBerry from T-Mobile -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Connection failed!!

2008-08-25 Thread Micah Stevens
There's probably a password set. Look up how to reset a password: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html On 08/25/2008 03:25 AM, Matthew Stuart wrote: I have just loaded MySQL 5 and MySQL Front on to a new computer, and I am now getting a MySQL-Error which is: Con

Re: Connection Failed!!

2008-08-25 Thread EvLSnoopY
Have you tried setting the password with mysql admin? Example: mysqladmin -u Root yourpassword 'yournewpassword' - Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Connection Help - Stupid Question, sorry to bother.

2006-08-13 Thread Chris
Chris W wrote: By default MySQL uses port 3306 so you need to be sure that port is open on the server, and not blocked by a firewall. You also need to be sure the user you are trying to login as can login remotely. In the MySQL user data base, there is a column for host which is the host that

Re: Connection Help - Stupid Question, sorry to bother.

2006-08-12 Thread Chris W
By default MySQL uses port 3306 so you need to be sure that port is open on the server, and not blocked by a firewall. You also need to be sure the user you are trying to login as can login remotely. In the MySQL user data base, there is a column for host which is the host that user can login

Re: Connection Pooling

2006-05-09 Thread romyd misc
Has anyone implemented connection pooling in C# .NET? On 5/8/06, romyd misc <[EMAIL PROTECTED]> wrote: What i meant by implementing connection pooling i meant if i need to do any code changes other than changes in connection string. Thanks, Romy On 5/8/06, Tim Lucia <[EMAIL PROTECTED]> wro

RE: Connection Pooling

2006-05-08 Thread Tim Lucia
lto:[EMAIL PROTECTED] Sent: Monday, May 08, 2006 4:33 PM To: Tim Lucia Cc: mysql@lists.mysql.com Subject: Re: Connection Pooling What i meant by implementing connection pooling i meant if i need to do any code changes other than changes in connection string. Thanks, Romy On 5/8/06, Tim Lucia <[EM

Re: Connection Pooling

2006-05-08 Thread romyd misc
What i meant by implementing connection pooling i meant if i need to do any code changes other than changes in connection string. Thanks, Romy On 5/8/06, Tim Lucia <[EMAIL PROTECTED]> wrote: I don't hear "you need to implement connection pooling". Maybe, but I think you might still have err

Re: Connection Pooling

2006-05-08 Thread William R. Mussatto
romyd misc said: > Hi Everyone, > > I'm developing an application using C# .NET and mysql as database. It's a > multithreaded application, we open a mysql database connection at the very > beginning when the application is started and all the database requests > use > the same connection. But under

RE: Connection Pooling

2006-05-08 Thread Tim Lucia
I don't hear "you need to implement connection pooling". Maybe, but I think you might still have errors under load, as you approach the maximum connection count in the pool. Tim -Original Message- From: romyd misc [mailto:[EMAIL PROTECTED] Sent: Monday, May 08, 2006 2:37 PM To: mysql@l

Re: Connection Buffer

2006-03-22 Thread Kishore Jalleda
"wait_timeout" setting would leave the connection/thread open for the defined time even after the query has been executed.. Kishore Jalleda On 3/22/06, Cory at SkyVantage <[EMAIL PROTECTED]> wrote: > > Is there anything I can put into the my.cnf file to buffer connection > (leave it open) to

RE: Connection Buffer

2006-03-22 Thread fbsd_user
I think you are asking for mysql_pconnect("localhost","root") -Original Message- From: Cory at SkyVantage [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 22, 2006 2:20 PM To: MySQL-List Subject: Connection Buffer Is there anything I can put into the my.cnf file to buffer connection (le

Re: Connection problem after long idle periods

2006-02-10 Thread Mark Matthews
Michael Lai wrote: David Logan wrote: Michael Lai wrote: I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I can access the database from my JSPs with no problem except for one small issue. After a long delay (usually overnight), when someone first tries to access the da

Re: Connection problem after long idle periods

2006-02-09 Thread Michael Lai
David Logan wrote: Michael Lai wrote: I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I can access the database from my JSPs with no problem except for one small issue. After a long delay (usually overnight), when someone first tries to access the database, I would get

Re: Connection problem after long idle periods

2006-02-01 Thread David Logan
Michael Lai wrote: I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I can access the database from my JSPs with no problem except for one small issue. After a long delay (usually overnight), when someone first tries to access the database, I would get the following error:

Re: Connection Problem

2005-11-18 Thread Tripp Bishop
Michael, you hit the nail on the head. We added --skip-name-resolve and changed our connnection string to use the IP instead of FQDN and now things are working fine. It must have been something with our DNS/ISP since we changed nothing and that stuff is out of our control. The other thing was capt

Re: Connection Problem

2005-11-18 Thread Michael Stassen
Tripp Bishop wrote: Hello all, Suddenly in the last hour or so the connection speed between our webserver and database server has skyrocketed to the point that our site is no longer usable! Just trying to connection via the mysql client takes a long time. Once the connection is established, howe

RE: connection issue

2005-10-14 Thread Anil
Than you very much . It is working Anil DBA -Original Message- From: Dobromir Velev [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 8:58 PM To: mysql@lists.mysql.com Cc: Anil Subject: Re: connection issue When you connect without specifing the host, the mysql client will

Re: connection issue

2005-10-13 Thread Dobromir Velev
When you connect without specifing the host, the mysql client will try to connect using the mysql socket file (usually /tmp/mysql.sock or /var/lib/mysql/mysql.sock) and when you specify the IP address it will try to connect using a TCP connection to port 3306. My guess is the you have name loo

Re: Connection Failure

2005-09-17 Thread Darrell Cormier
On Saturday 17 September 2005 16:12, Michael Stassen wrote: > You are trying to connect to a 4.1 server with a 4.0 client. This is > explained in the manual > . > > Michael Thanks for the information. I guess the perl-DBD and perl-DBI are old.

Re: Connection Failure

2005-09-17 Thread Michael Stassen
You are trying to connect to a 4.1 server with a 4.0 client. This is explained in the manual . Michael Darrell Cormier wrote: I am confused as to why I am unable to connect to my MySQL DB 4.1.13 via DBI:DBD in PERL. This is on SuSE Pro 9.1,

Re: connection error from c application

2005-06-29 Thread Kristen G. Thorson
Your syslog8.txt file has two problems: 1. The first field, log_date, is in m/d/ format. It will not be converted by MySQL automatically. It needs to be in -mm-dd format. For this reason, all records will have the default value of '-00-00' for that field. 2. The primary key on

Re: connection error from c application

2005-06-29 Thread Elizabeth Bonifacio
Dear Guys, I have been stucked in loading file using "load data local infile" command. At first it is loading a null value on my first record followed with one record from my input file. The rest are ignored and i've been receiving lots of warnings. I tried converting the text file into a csv

Re: connection error from c application

2005-06-27 Thread Gleb Paharenko
Hello. Send an example of your file and your table's definition (use SHOW CREATE TABLE for this purpose). Please, next time send your replies to the list. > >Hope you're doing great today. Back to my question last week, I've >been encountering this problem of loading my file using the

Re: connection error from c application

2005-06-24 Thread Gleb Paharenko
Hello. What 'SHOW WARNINGS' reports? Elizabeth Bonifacio <[EMAIL PROTECTED]> wrote: > Dear Gleb, > > Thanks, i will try that as well, so far my program can access the > server now by using the old password. Now my problem is when i load > file, its only reading the first line and some

Re: connection error from c application

2005-06-24 Thread Elizabeth Bonifacio
Dear Gleb, Thanks, i will try that as well, so far my program can access the server now by using the old password. Now my problem is when i load file, its only reading the first line and some more insert a null record before the ist record. here is the result i get after loading the text file: my

Re: connection error from c application

2005-06-23 Thread Gleb Paharenko
Hello. I've compiled your code using libraries and includes from MySQL-4.1.6 (yes, my testing environment isn'tperfect :) and successfully connected to MySQL-4.1.10. Old passwords was off, so I used a 4.1. authorization protocol. Elizabeth Bonifacio <[EMAIL PROTECTED]> wrote: > Dear All

Re: connection error from c application

2005-06-23 Thread Kishore Jalleda
I guess this is a problem with the version of the C client Libraries that you are using, because of the way 4.1.x version of mysql stores the hash value of the password using the PASSWORD( ) function, so when you are giving the password embedded in the C code, may be the server does not match it wi

Re: Connection Issue with DBI::DBD::Mysql (more information)

2005-06-21 Thread TheRefUmp
Hi, My "bad". I forgot to explain that the IP address returned is NOT that of the machine where I'm running the program (the Linux server). That address is different from the one returned. Sorry for the confusion. George [EMAIL PROTECTED] wrote: >looking at this the ipnumber 192.168.2.1

Re: Connection Issue with DBI::DBD::Mysql

2005-06-21 Thread SGreen
[EMAIL PROTECTED] wrote on 06/21/2005 01:56:50 PM: > Hi everyone, > Trying to connect to a MySQL database from a Linux Server using PERL > to a Windows Machine with a MySQL database (5.0.6). I can connect > successfully on the windows box but cannot on the Linux server! I > ran a SQLTRACE (DBD)

Re: Connection problem

2005-05-24 Thread Warren Young
razat gupta wrote: But it gives an exception on the reach of 150 connections.It should allow us to create almost 500 connection. Use netstat on the server to find out how many connections are actually in use. You may find that your program is not properly closing down connnections, for inst

Re: Connection latency reduction attempt for load balancing mysql slaves.

2005-01-29 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin A. Burton wrote: > I'm experimenting with using ConnectorJ 3.1.7 to connect to MySQL slaves > to handle load balancing queries. > > The environment would either include a hardware loadbalancer or round > robin DNS (or static configuration). T

Re: Connection performance, suggestions?

2005-01-24 Thread Dan Nelson
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 workstatio

Re: Connection performance, suggestions?

2005-01-24 Thread Larry Lowry
- Original Message - From: "Donny Simonton" <[EMAIL PROTECTED]> To: "'Larry Lowry'" <[EMAIL PROTECTED]>; "'Peter J Milanese'" <[EMAIL PROTECTED]>; Sent: Saturday, January 22, 2005 7:34 PM Subject: RE: Connection performance, sugg

RE: Connection performance, suggestions?

2005-01-22 Thread Donny Simonton
: 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 the

Re: Connection performance, suggestions?

2005-01-22 Thread Larry Lowry
ssage - From: "Peter J Milanese" <[EMAIL PROTECTED]> To: "Larry Lowry" <[EMAIL PROTECTED]> Sent: Saturday, January 22, 2005 10:22 AM Subject: Re: Connection performance, suggestions? You are not simulating. Your scripting produces 100 linear connections. You a

Re: Connection performance, suggestions?

2005-01-21 Thread Larry Lowry
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" Sent: Friday, January 21, 2005 12

Re: Connection performance, suggestions?

2005-01-21 Thread Peter J Milanese
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 perfo

Re: connection problem with 4.1.7

2004-11-09 Thread P.V.Anthony
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 to ch

Re: Connection Errors

2004-10-06 Thread Dave Goodrich
Dave Goodrich wrote: [Previously posted to MySQL forum] Howdy the group, I have a cluster of email servers all using mysql for authentication. Using vpopmail and spamassassin, all auth requests, pop, delivery instructions, etc, go to mysql. Currently we process between 50k and 65k messages a day

Re: Connection Error

2004-09-28 Thread Michael Stassen
Phillip Mangwiro wrote: Egor Egorov wrote: "Phillip Mangwiro" <[EMAIL PROTECTED]> wrote: I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this machine"), whenever I try to connect to MySQL server from any client by using its IP or "friendly" DNS name other than 127.0.0.1 or local

Re: Connection Error

2004-09-28 Thread Phillip Mangwiro
Egor Egorov wrote: "Phillip Mangwiro" <[EMAIL PROTECTED]> wrote: I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this machine"), whenever I try to connect to MySQL server from any client by using its IP or "friendly" DNS name other than 127.0.0.1 or localhost. This has happen

Re: Connection Error

2004-09-24 Thread Egor Egorov
"Phillip Mangwiro" <[EMAIL PROTECTED]> wrote: > I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this > machine"), whenever I try to connect to MySQL server from any client by > using its IP or "friendly" DNS name other than 127.0.0.1 or localhost. > This has happened on three m

RE: connection time is slow

2004-07-29 Thread Gelu Gogancea
IMHO You have problems on the DNS server. _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION & SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Heo, Jungsu [mailto:[EMAIL P

Re: connection time is slow

2004-07-28 Thread Heo, Jungsu
su" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 29, 2004 11:14 AM Subject: Re: connection time is slow > Hello Jungsu, > > What are the tools you're using to connect? Any client applications? > > > Fred. > > Heo, Jungsu wrote: >

Re: connection time is slow

2004-07-28 Thread Frederick R. Doncillo
Hello Jungsu, What are the tools you're using to connect? Any client applications? Fred. Heo, Jungsu wrote: >Hello. > >I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server. > >When connect from Linux to Windows, or from Window to Linux connection time is very >slow. >( it take

RE: connection problems

2004-07-28 Thread Andrew Hall
PROTECTED] ' > Sent: 7/28/04 4:35 PM > Subject: RE: connection problems > > Yes I have. The hostname of the box returned with 'hostname' is the > fqdn and is in the format of blah.1.2.3.net. > > Drew > > On Wed, 2004-07-28 at 17:16, Victor Pendleton w

RE: connection problems

2004-07-28 Thread Andrew Hall
localhost. > > -Original Message- > From: Andrew Hall > To: Victor Pendleton > Cc: '[EMAIL PROTECTED] ' > Sent: 7/28/04 4:35 PM > Subject: RE: connection problems > > Yes I have. The hostname of the box returned with 'hostname' is the > fqdn and is in the

RE: connection problems

2004-07-28 Thread Victor Pendleton
PM Subject: RE: connection problems Yes I have. The hostname of the box returned with 'hostname' is the fqdn and is in the format of blah.1.2.3.net. Drew On Wed, 2004-07-28 at 17:16, Victor Pendleton wrote: > Can you check the host name again? You have a five segment address. >

RE: connection problems

2004-07-28 Thread Andrew Hall
Yes I have. The hostname of the box returned with 'hostname' is the fqdn and is in the format of blah.1.2.3.net. Drew On Wed, 2004-07-28 at 17:16, Victor Pendleton wrote: > Can you check the host name again? You have a five segment address. > > -Original Message- > From: Andrew Hall

RE: connection problems

2004-07-28 Thread Victor Pendleton
Can you check the host name again? You have a five segment address. -Original Message- From: Andrew Hall To: [EMAIL PROTECTED] Sent: 7/28/04 3:55 PM Subject: connection problems Greetings, I have what I hope is an easy problem. I have installed mysql 4.0.20 and when I execute mysqladmi

Re: [CONNECTION PROBLEMS]

2004-07-19 Thread Peter Bruggink
Victor Pendleton wrote: What error messages are you receiving? -Original Message- From: Peter Bruggink To: [EMAIL PROTECTED] Sent: 7/16/04 3:19 AM Subject: [CONNECTION PROBLEMS] To have a better performence I have installed a new server running solaris8 and mysql version 3.23.53. The old

RE: [CONNECTION PROBLEMS]

2004-07-16 Thread Victor Pendleton
What error messages are you receiving? -Original Message- From: Peter Bruggink To: [EMAIL PROTECTED] Sent: 7/16/04 3:19 AM Subject: [CONNECTION PROBLEMS] To have a better performence I have installed a new server running solaris8 and mysql version 3.23.53. The old server is running sol

RE: connection error

2004-06-24 Thread Victor Pendleton
Is the MySQL server running? What OS are you using? -Original Message- From: Angela Howley To: [EMAIL PROTECTED] Sent: 6/24/04 7:13 AM Subject: connection error Hi, I have spent the last two days trying to configure PHP 4.3.7 & MySQL 4.0.20 - none of which is successful. The error I ha

Re: Connection speed

2003-11-06 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 09:23:50AM -0700, Nihal wrote: > I think my mysql is resolving host names, and I would prefer it to not, > where do I set skip-name-resolve to prevent it? In the [mysqld] section of my.cnf. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTEC

RE: Connection speed

2003-11-06 Thread Nihal
I think my mysql is resolving host names, and I would prefer it to not, where do I set skip-name-resolve to prevent it? Thanks. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 8:43 AM To: Daniel Kiss Cc: [EMAIL PROTECTED] Subject: Re

Re: Connection speed

2003-11-06 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 02:37:05PM +, Daniel Kiss wrote: > It is definitely not a DNS problem. I use IP addresses. > Any other idea? Reverse DNS. The server is lookup up the client's name unless you've used skip-name-resolve. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yaho

Re: Connection speed

2003-11-06 Thread Brent Baisley
Try traceroute to make sure it's not a routing problem. Try netstat, or your platform's equivalent, to see if you are getting errors. You should do that on both the client and the server. Check how busy your server is, maybe there is something going on there. On Thursday, November 6, 2003, at 0

Re: Connection speed

2003-11-06 Thread Daniel Kiss
It is definitely not a DNS problem. I use IP addresses. Any other idea? Thanks > Sounds like a DNS problem to me. > > > Daniel Kiss wrote: > > >> Hi all, >> >> >> I have a MySQL 4.1 installed on a RedHat 9 machine with two >> interfaces. One of them connects to my local network and the >> other

Re: Connection speed

2003-11-06 Thread gerald_clark
Sounds like a DNS problem to me. Daniel Kiss wrote: Hi all, I have a MySQL 4.1 installed on a RedHat 9 machine with two interfaces. One of them connects to my local network and the other connects to the internet. My problem is that it takes very long time (5-10 seconds or more) to connect to th

RE: Connection Time Out

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

Re: Connection Time Out

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

RE: Connection Time Out

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

Re: Connection and query on one line (newbie)

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

Re: Connection and query on one line (newbie)

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

Re: connection error

2003-09-13 Thread Paul DuBois
At 8:08 PM +1200 9/13/03, Robert Morgan wrote: I have created a user grant all privileges on *.* to user@"%" =>identified by ' pword' with grant option; and grant all privileges on *.* to [EMAIL PROTECTED]

Re: connection error

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

Re: CONNECTION

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

Re: connection

2003-08-14 Thread O'K Web Design
Hi Sounds like you need to update your path in your shell profile. Check out the file dot file in your home directory and add the /usr/local/mysql/bin directory to it. Mike - Original Message - From: "aaldrik groenewold" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: August 6,

Re: connection

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

RE: Connection problem!!! Windows to Linux

2003-07-16 Thread Rob A. Brahier
Aric, Are you running the linux version of your database on a shared web host? Some web hosts prevent you from using % as a host identifier for security reasons. I would also check to see if the permissions were defined at the proper level (in other words, have you set up access prvis for

RE: Connection problem!!! Windows to Linux

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

Re: Connection problem!!! Windows to Linux

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

Re: Connection problems

2003-06-18 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John R Langan wrote: > Hi All, > I hope someone can help with this connection problem. [snip] > When attempting to connect from the PC on the intranet the trace gives > the following: > > java.lang.ClassNotFoundException: com.mysql.jdbc.Driverat >

RE: Connection String?

2003-03-14 Thread Barry C. Hawkins
; > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Friday, March 14, 2003 8:43 AM > To: Tamayo, Nelson > Cc: '[EMAIL PROTECTED]' > Subject: Re: Connection String? > > > Quoting "Tamayo, Nelson" <[EMAI

RE: Connection String?

2003-03-14 Thread Mike Hillyer
ECTED]' Subject: Re: Connection String? Quoting "Tamayo, Nelson" <[EMAIL PROTECTED]>: > I am trying to connect to MySQL without using a DSN entry, this is my > connection string > > DRIVER={MySQL ODBC 3.51 > Driver};SRVR=159.113.44.49;DB=csapps;UID=user;PWD=pas

Re: Connection String?

2003-03-14 Thread barry . hawkins
Quoting "Tamayo, Nelson" <[EMAIL PROTECTED]>: > I am trying to connect to MySQL without using a DSN entry, this is my > connection string > > DRIVER={MySQL ODBC 3.51 > Driver};SRVR=159.113.44.49;DB=csapps;UID=user;PWD=password > > The error I get is > > "Invalid connection string attribute" >

Re: Connection error

2003-03-10 Thread Paul DuBois
At 14:37 -0800 3/10/03, DuSTiN KRySaK wrote: Hi there - I'm truing to connect to a mysql server (redhat linux 8) with the mysqlcc GUI (through a SSH session), and for some reason when I try to connect I get the error: [localhost] ERROR 2002: Can't connect to local MySQL server through socket '/tmp/

Re: Connection ms access to mysql

2003-01-18 Thread Gelu Gogancea
G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "mc 02" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, Januar

Re: Connection ms access to mysql

2003-01-17 Thread mc 02
Hi Bob hall, I do apologize for being unclear in my previous message. To answer your question: >Does the MySQL server run on your FreeBSD system? Yes MySQL runs prefectly with my FreeBSD 4.6 system. > How are you trying to export your Jet tables? I assume that's what you mean when you refer

RE: Connection ms access to mysql

2003-01-17 Thread mc 02
Christensen, Dave There doesnt seem to be any error when performed exports, however i still cant see the tables in mysql. - Original Message - From: "Christensen, Dave" <[EMAIL PROTECTED]> Date: Fri, 17 Jan 2003 07:51:28 -0600 To: "'mc 02'" <[EM

Re: Connection ms access to mysql

2003-01-17 Thread Bob Hall
On Fri, Jan 17, 2003 at 03:15:05AM -0500, mc 02 wrote: > I've downloaded the necessary application MySQL 3.51 and myODBC for > freeBSD. On the XP side i only downloaded myODBC. I played around the > configuration but i still cant seem to export the files to my FreeBSD > box. > > What am i doing w

Re: Connection problems

2002-10-28 Thread Mark Matthews
Steven Nakhla wrote: I recently installed Red Hat 7.3 on a box, and have been having difficulty connecting to my MySQL server. I can connect locally. That is, on the same machine as the server. However, if I try and connect from a remote machine with the following command: mysql -h -p I get

Re: Connection

2002-10-25 Thread Jocelyn Fournier
Hi, After a little search, it seems to mean to "treat BIGINT as INT". Regards, Jocelyn - Original Message - From: "Arthur" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 4:59 PM Subject: Connection > Hello mysql, > > Often I've seen OPTION=16384 in a con

re: Connection to MySQL

2002-10-17 Thread Egor Egorov
Hello Steeve, Tuesday, October 15, 2002, 9:57:04 PM, you wrote: SG> We want to write a log of EVERY transaction made by the customer in a MySQL SG> database. Writing has to be very fast because customers are waiting for their SG> results. We want to add code using "MySQL C API" to the already

Re: Connection DB server by borland C++ Builder

2002-06-18 Thread Fredrick Bartlett
You can use the following component. It includes packages for Builder4 & Builder5 http://sourceforge.net/projects/zeoslib - Original Message - From: "Yuna Yuana" <[EMAIL PROTECTED]> To: "Egor Egorov" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 18, 2002 7:39 PM Subject

Re: Connection Problem

2002-05-27 Thread Mike(mickalo)Blezien
Will, In your $dbh connection handler, you need to change the host=localhost and database= to just localhost and the database name. $dbh = DBI->connect ("DBI:mysql:localhost;database_name", "**", "***", {PrintError => 0, RaiseError => 1}); >>On Fri, 24 May 2002 16:4

Re: Connection Failed.

2002-04-25 Thread Victoria Reznichenko
°í¼ø¹Î, Thursday, April 25, 2002, 7:08:32 AM, you wrote: °> I made program using mysql C api, And every two minute my program °> connects to mysql-server. But from time to time some error occur °> accidently. °> In the mysql.err file, this message was written. °> 020424 15:18:44 Aborted connec

RE: Connection Failed.

2002-04-24 Thread 고순민
ed-Hat Linux 7.2 now. -Original Message- From: Andrew Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 3:20 PM To: °í¼ø¹Î; [EMAIL PROTECTED] Subject: RE: Connection Failed. Have you run out of sockets ? Max connections ? Is the server there ? Is this the right socket ? Is

RE: Connection Failed.

2002-04-24 Thread Andrew Rich
Have you run out of sockets ? Max connections ? Is the server there ? Is this the right socket ? Is the socket locked up ? Andrew -Original Message- From: °í¼ø¹Î [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 April 2002 2:09 PM To: [EMAIL PROTECTED] Subject: Connection Failed. I made p

RE: Connection -- Can't open named pipe error

2002-04-11 Thread Land, Christopher
http://www.mysql.com/doc/W/i/Windows_vs_Unix.html Can't open named pipe error If you use a MySQL 3.22 version on NT with the newest mysql-clients you will get the following error: error 2017: can't open named pipe to host: . pipe... This is because the release version of MySQL uses named pipe

Re: connection with specific host failure

2002-02-25 Thread Jeremy Zawodny
On Mon, Feb 25, 2002 at 01:48:13PM +0100, Marek Wysmulek wrote: > (Hmmm. Zawodny Are you related with a polish family ? - I'm polish > too ;- My grandparents came to the United States from Poland sometime around 1910, I believe. I'm 100% Polish, but cannot speak the language. Glad

Re: connection with specific host failure

2002-02-25 Thread Marek Wysmulek
> > > Are you using the Debian mysql-server package? If so, then check out > > > your /etc/mysql/my.cnf file to see that networking is enabled. > > > > > > > It seems to be disabled BUT how to enabled it ? > > Remove the "skip-networking" entry. > Jeremi youre the best ;-)). Thanks a lot.

Re: connection with specific host failure

2002-02-25 Thread Jeremy Zawodny
On Mon, Feb 25, 2002 at 01:29:27PM +0100, Marek Wysmulek wrote: > > > > > > I can not connect from other host then localhost (literally - even > 127.0.0.1 > > > takes no effect) > > > > > > Iptables rules are wide accepting. > > > In host name there is name of the host, and in hosts IP is associat

  1   2   >