RE: Problem with GRANT...WITH GRANT OPTION

2004-07-21 Thread Brian Duke
I'm new so this may be whacked but here goes: Isn't the grant statement tailed with the grant option? i.e. GRANT ALL ON table_or_database_name to 'somebody'@'localhost' WITH GRANT OPTION; Somebody verify that please. -Original Message- From: John R. Porter [mailto:[EMAIL PROTECTED]

RE: MySQL does not automatically start at BOOT time??

2004-05-09 Thread Brian Duke
I know that feeling. perhaps I can help. do you have an /etc/rc.d/init.d/mysqld file? -Original Message- From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 3:29 PM To: '[EMAIL PROTECTED]' Subject: RE: MySQL does not automatically start at BOOT time?? Hello

RE: MySQL does not automatically start at BOOT time??

2004-05-09 Thread Brian Duke
PROTECTED] wrote: Brian: No. From where I copy this file from? Is it stright copy or something else? You might be my savior!! Thanks. Kirti -Original Message- From: Brian Duke [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 5:44 PM To: 'Kirti S. Bajwa'; [EMAIL

A little Database construction help

2004-01-21 Thread Brian Duke
I need a little help in constructing an order tracking database. We've decided to use MySQL mostly because it's the best supported database out in the wild. Does anyone have an example of an order tracking datamap? A link to a site with the basic flowchart would be a great help. The application is

MySql database design.

2004-01-21 Thread Brian Duke
I need a little help in constructing an order tracking database. We've decided to use MySQL mostly because it's the best supported database out in the wild. Does anyone have an example of an order tracking datamap? A link to a site with the basic flowchart would be a great help. The application is

Field Name whitespace via MyODBC

2003-12-11 Thread Brian Duke
On the windows machine I have Acess2003. I installed the MyODBC to push the data into the FreeBSD MySQL server. The connection worked like a dream. Kudos to the MyODBC team. The table that the connection created included field names that have spaces in the name. I'm trying to access the data

RE: Field Name whitespace via MyODBC

2003-12-11 Thread Brian Duke
I can just alter table to rename the fields right? -Original Message- From: Patrick Sherrill [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 5:27 AM To: Brian Duke; [EMAIL PROTECTED] Subject: Re: Field Name whitespace via MyODBC Brian, I think you are going to need

RE: ?? .tcshrc On OS X ??

2003-12-09 Thread Brian Duke
.tcshrc is the config file for your settings on the environment variables for your session of tcsh. When your looking for $SHELL your looking for the command line interpretor. FreeBSD can use most any of them. bash, csh, ksh,, sh, tcsh, etc. Usually the .rc file is found in your home directory

RE: Login Problems

2003-12-08 Thread Brian Duke
Have you flushed priv's recently? -Original Message- From: Schrodinger [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:02 PM To: MySQL General Lists Subject: Login Problems Hello, I am experiencing a strange problem with a MySQL server on a FreeBSD machine here in college.

RE: CPU 100%

2002-09-27 Thread Brian . Duke
Don't have a fix but look at the swap file size. May need to increase that. A further note MS Access on NT run 100%,...100% of the time. -Original Message- From: John R. Diehl, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:05 PM To: Peter Zuidema; [EMAIL PROTECTED]

RE: Mysql and RedHat 7.3

2002-09-27 Thread Brian . Duke
Redhat...Linux systems: running Xwindows login at runlevel5 cd /etc/rc.d/init.d/rc5.d/ search for mysqld mv ./K74mysqld ./S78mysqld The K denotes Kill The S denotes Start If you run you system at a different run level like 3 then go to /rc5.d/ directory and change the file name there. The

RE: Mysql and RedHat 7.3

2002-09-27 Thread Brian . Duke
Oops correction: If you run you system at a different run level like 3 then go to /rc3.d/ directory and change the file name there. -Original Message- From: Duke, Brian Sent: Friday, September 27, 2002 3:45 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Mysql and RedHat 7.3

RE: OT Re: Mysql, PHP and a wrapper

2002-09-25 Thread Brian . Duke
whew, I found it. I looked at my installed rpm's ('rpm -q php') found the install php 4.1.2-7.3.4. Tried to remove ('php -e php*.rpm') got multiple dependent errors. That when I noticed I had about 6 rpm's had installed 6 different flavors of php. I uninstalled all and reinstalled just

Mysql, PHP and a wrapper

2002-09-24 Thread Brian . Duke
stat-box201 -*message began on php mailing list...no answer. Forwarding to mysql list 13:55-9-24 I'm running apache-1.3.23-14 on a redhat 7.3 system. I have installed the php-rpm and the php_mysql.rpm from Redhat. installed php-4.1.2-7.3.4 and php-mysql-4.1.2-7.3.4. Cannot connect to my

RE: HELP - MYSQL databases disappearing!

2002-09-17 Thread Brian . Duke
Is your win2k server networked? does it have multiple users? I would first check the various profiles to ensure it was not moved to a different profile. Next I would ask did the administrator install the server? if another username installed the server even with admin rights that server is now

First question: a howto.

2002-09-11 Thread Brian . Duke
and populate data. when I try to log in as that user, mysql -u webley -p icesql I get the prompt for a password but after entering I get access denied. The icesql is in the db table and webley does have rights in the db table for that database. Can someone tell me if I am missing the big flick? Brian Duke