Trouble connecting to server

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

Thanks for the idea, but I did get the right IP address on it. No DHCP. Drew Burchett United Systems Software Ph:(270)527-3293 Fax: (270)527-3132 -Original Message- From: Barry Newton [mailto:[EMAIL PROTECTED] Sent: Monday, April 23, 2007 11:17 AM To: Drew Burchett Cc: mysql

Query Optimization

| varchar(50) | YES | | NULL| (indexed) | TURNAROUND| varchar(50) | YES | | NULL| (indexed) | SHAPE | varchar(50) | YES | | NULL| (indexed) Thanks, Drew

Crashed Again!

get this very undescriptive error: # Starting mysqld daemon with databases from /var/db/mysql STOPPING server from pid file /var/db/mysql/server312.web.vi.pid 070309 17:19:12 mysqld ended Helps a lot, doesn't it? Where do I begin with this? TIA, Drew - No need

Re: Crashed Again!

Never mind. I forgot this command: /usr/local/bin/mysql_install_db --user=mysql Drew2 Drew Jenkins [EMAIL PROTECTED] wrote: I built a new server at my server farm because the old one was corrupt. I had a hunch it had to do with the new 500 GB hard drive I bought. I told them to check it out

Problems w/ Grant Tables

password: YES) 2 mysql use authdaemon; Database changed mysql show tables; Empty set (0.02 sec) Is authdaemon the database that has the grant tables? What gives? How do I add users that I can use? TIA, Drew - The fish are biting. Get more visitors on your site using

Re: Problems w/ Grant Tables

Problem solved: /usr/local/bin/mysql_fix_privilege_tables2 Drew Jenkins [EMAIL PROTECTED] wrote: Hi; I rebuilt mysql and injected the database which had user mysqluser and a root user. Both got wiped out. It looks like the data is intact other than that. Look at this: mysql CREATE USER dev

Re: Can't Bind to Port

- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Saturday, March 3, 2007 5:00:26 AM Subject: Re: Can't Bind to Port Try the command: find / -name mysql 2/dev/null then you will find out if you have multiple

Re: Can't Bind to Port

- Original Message From: ed [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 10:24:54 AM Subject: Re: Can't Bind to Port be root/superuser; try it as find / -name mysql and then, (as in 2nd) send they instances of mysql that you do not want to /dev/null

Re: Can't Bind to Port

26- Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 10:53:45 AM Subject: Re: Can't Bind to Port kill off the first instance, the port will/should free up and then you can start your [second] instance. # ps wax

Re: Can't Bind to Port

- Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 11:25:37 AM Subject: Re: Can't Bind to Port I rebooted, then... server312# ps wax|grep mysqld server312# /usr/local/bin/mysqld_safe [1] 801 server312# Starting

Re: Can't Bind to Port

- Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 12:03:40 PM Subject: Re: Can't Bind to Port At this point, make certain that the mysql instance that you started (pid 801) is shut down properly, then probe

Re: Can't Bind to Port

- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Saturday, March 3, 2007 12:34:37 PM Subject: Re: Can't Bind to Port There is no need to be superuser to run find. But there can be problems if there is another

Re: Can't Bind to Port

- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 1:03:30 PM Subject: Re: Can't Bind to Port You are probably using another shell than bash or another sh variant. No, I'm using bash...the standard shell. Didn't

Re: Can't Bind to Port

- Original Message From: ed [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 1:06:16 PM Subject: Re: Can't Bind to Port None of those directories existed on my system. So I decided to try and find the ones to which you referred. The matches were inexact

Re: Can't Bind to Port

- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 1:39:14 PM Subject: Re: Can't Bind to Port Well, I don't know what you do with this one, Tommy. I just cut and pasted your command, but when I hit the up arrow

Re: Can't Bind to Port

20- Original Message From: ed [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 12:16:42 PM Subject: Re: Can't Bind to Port I figured it wouldn't hurt anything to change permissions on files, so I went ahead and changed all the permissions everywhere. I

Re: [MySQL] Re: Can't Bind to Port

the manual is poorly written in this instance. The comments at the bottom elucidated what to do: * log onto mysql * enter this command: SET GLOBAL max_allowed_packet=1000; Done! Thanks all! Drew Have a burning

Can't Bind to Port

to the port. There's no other MySQL running on the server, so why can't it connect to the port? This server isn't yet set up with an URL, so if it's reading from rc.conf or what have you, that could be tripping it up. Please advise. TIA, Drew

Re: Can't Bind to Port

- Original Message From: Borokov Smith [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, March 2, 2007 6:21:59 PM Subject: Re: Can't Bind to Port netstat -nlp | grep 3306 Option p requires a protocol. What protocol should I give it? Drew

Re: Can't Bind to Port

Oops. Forgot to add I passed it tcp as the protocol and it returned blank: # netstat -nlp tcp| grep 3306 # I presume that means nothing's listening on that port? If so, then why did nmap return mysql on that port? At any rate, what do? TIA, Drew

Re: Can't Bind to Port

26- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, March 2, 2007 7:32:16 PM Subject: Re: Can't Bind to Port server312# netstat -nlap tcp | grep 3306 tcp4 0 0 *.3306

subquery performance

I have a query with a subquery which does not throw an error, but does not return either. I've been testing the query using mysql Query Browser and the poor dolphin jumps only once a minute or so ;) I use MYSQL's excellent error documentation heavily so if the query doesn't throw an error,

Re: subquery performance

Thanks for the detailed feedback. I do not create the data so I can't modify it. Your illustration of the table is correct. I'll try to implement some of your feedback. Thanks On 9/25/06, Michael Stassen [EMAIL PROTECTED] wrote: Jeff Drew wrote: I have a query with a subquery which does

stuck on localhost authentication

I'm apologize for posting an apparently simple question, but I'm stuck. I'm trying to get my java application to connect to mysql on the same server. The server is redhat with mysql 5.1.11. I'd done this with mysql 4.x in the distant past. I add a user with the command: insert into user

Re: #1191 - Can't find FULLTEXT index matching the column list

. Thanks, Drew -- Be a Great Magician! Visit The Alchemist's Warehouse http://www.alchemistswarehouse.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

sporadic batch update problem

Sporadically, the last few entries of a batch are not written. I'm writing to a mysql database using JDBC. Here's a short version of my code. Does anyone have suggestions on possible causes or other diagnostics? class DatabaseWriter{ int writeCount=0; public DatabaseWriter(){

MySQL newsgroup proposal

ANNOUNCEMENT: A RFD (REQUEST FOR DISCUSSION) has been posted for the creation of a new Usenet newsgroup: comp.databases.mysql The proposal and related discussion can be read in the Usenet group news.groups ... feel free to weigh in and make any suggestions you may have. Message-ID:

optimal number of connections?

Our Java application has several threads that use JDBC to write to several tables. Currently, we use one JDBC connection. Would performance improve if we used a connection per table? Is a single connection bad for some reason? Since connection pooling is a hot topic, I'm wondering if we're

please help : linux version

Hello I need to download a version of mySql v4, but I don't know which one to download. The Server I'm going to load the built database on to is running: Linux 2.4.19C13_v As the server is mySql compatible they must already be running mySql on the system. So the catch is... My home terminal

changing the datadir on .rpm SuSE install?

Can the the datadir be changed with a .rpm install on SuSE? Our SA gave us a large partition on /export. We installed the .rpm and were running fine with the datadir set to the default /var/lib path. So I need to move the datadir to /export. Since we're just moving to Production, we do not

Re: SQL code sought to remove duplicates, using most recent date

,prog,startdt,MAX(stopdt) FROM test GROUP BY perid,prog,startdt or SELECT perid,prog,MIN(startdt),MAX(stopdt) FROM test GROUP BY perid,prog might do what you wnat -- Drew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

select, join, order assistance - simple

I have 2 tables similar to T1 --- ID | initial | T2 -- initial | full_name | I want output based on the T1.ID row which has a given ID=' X ' (If ID = 7 then pretend initial = initial3, as example) The first or

Mysql 3.32.53 Compile error

Hi has anyone seen a workaround for the following error: Thanks in advance, Drew. Environment: Solaris 9 u1 (Kernel: 112233-02) All GNU compilers tools installed. output as follows: gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR

sort_buffer size

tables: 207 Queries per second avg: 17.618 We have a sort_buffer of 32M! Is this to big? Does anyone have any recommendations of what size it should be? Drew. Andrew Toussaint Richardson-Shaw Pty Ltd [EMAIL PROTECTED

Error Number

Hi all, Why is it that some times in mySQL error logs the error number is reported as Zero? Is this a common error or does it have something to do with PHP. Drew Andrew Toussaint Richardson-Shaw Pty Ltd [EMAIL PROTECTED

Multiple CPU's

Multiple CPU's with FreeBSD 4.2 or 4.3? Thanks for your help in advance. Drew Andrew Toussaint Richardson-Shaw Pty Ltd [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Problem with MySQL Binary (mysql-3.23.32-unknown-freebsdelf4.2-i386)

ect I have FreeBSD4.1. How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator:Drew Toussaint Organization: Richardson Shaw PTY LTD MySQL support: none Synopsis: ?? Severity: non-critical Priority: low Category: mysql Class: sw-bug Release:

Error while trying to run binary mySQL on FreeBSD4.0

in advance. Drew Andrew Toussaint Richardson-Shaw Pty Ltd [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Efficient Select

AND table2.Group != 'Dedicated' You can see that I am trying to get the id's from the first table where the stoptime is 0 and they do NOT have an entry in table2 that says dedicated. There are multiple entries is table2 for each username... Any suggestions? Thanks Drew

RE: Efficient Select

AND t2.Group = 'Dedicated' AND t1.StopTime = 0 WHERE t2.id IS NULL; --Greg Johnson -Original Message- From: Drew [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 4:00 PM

Re: Why does query hang? [was: Why does 1st query take so long?

what does a 'show processlist' reveal? On 17 Jan 2001 00:08:23 +, John Stumbles wrote: On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote: On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote: I can't readily reproduce the first-time big difference scenario. OK, I can