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
e script at system startup by > adding to the chkconfig list > > chkconfig --add mysql > chkconfig --level 345 mysql on > > For more information read > http://dev.mysql.com/doc/mysql/en/Automatic_start.html > > Good luck... > > Sam > > --- "Kirti

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

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

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

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 to

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 thru

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 i.e

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

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

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

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

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 mysql-3.

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 o

First question: a howto.

2002-09-11 Thread Brian . Duke
tables 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