RE: Problem with GRANT...WITH GRANT OPTION
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] Sent: Wednesday, July 21, 2004 11:09 AM To: [EMAIL PROTECTED] Subject: RE: Problem with GRANT...WITH GRANT OPTION 'GRANT GRANT ON table_or_database_name ...' gave a syntax error. 'GRANT GRANT OPTION ON table_or_database_name ...' worked, but the result was as before, i.e. the new user still couldn't grant access to the table or database. Inspection of the grant tables showed the following: Table 'user' Field 'User': Value 'demouser' Field 'Grant_Priv': Value 'N' Table 'db' Field 'Db': Value 'test' Field 'User': Value 'demouser' Field 'Grant_Priv': Value 'Y' Do I have to set 'Grant_Priv' to 'Y' for 'demouser' in the 'user' table? Doesn't that give the user global GRANT privileges, rather than restricting them to the single database 'test'? Or do I have to give the user Read/Write privs. to the grant tables, and if so, what are the minimum privileges required? Regards, John R. Porter I.T. Services University of Strathclyde Faculty of Education 76 Southbrae Drive Glasgow G13 1PP e-mail: [EMAIL PROTECTED] Tel. 0141 950 3289 -Original Message- From: aman [mailto:[EMAIL PROTECTED] Sent: 21 July 2004 17:17 To: [EMAIL PROTECTED] Subject: RE: Problem with GRANT...WITH GRANT OPTION Also, if you have any doubts whether your changes took the right effect, check the mysql database on your server and check out the tables that store privileges assigned by your GRANT query. Aman Raheja http://www.techquotes.com On Wed, 2004-07-21 at 11:11, Martin Gainty wrote: John- GRANT privilege ON table_or_database_name TO [EMAIL PROTECTED] IDENTIFIED BY 'password' in this case you need to GRANT GRANT ON table_or_database_name TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Hope this helps, Martin Gainty SQL Consultant USA 001-617-852-7822 From: John R. Porter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Problem with GRANT...WITH GRANT OPTION Date: Wed, 21 Jul 2004 14:54:10 +0100 MIME-Version: 1.0 Received: from lists.mysql.com ([213.136.52.31]) by mc2-f16.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Wed, 21 Jul 2004 06:56:43 -0700 Received: (qmail 30011 invoked by uid 109); 21 Jul 2004 13:54:17 - Received: (qmail 29991 invoked from network); 21 Jul 2004 13:54:17 - Received: pass (lists.mysql.com: local policy) X-Message-Info: JGTYoYF78jHJ0WhRVXWZU4HTCZz6ybBU Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Archive: http://lists.mysql.com/mysql/169422 Delivered-To: mailing list [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.6604 (9.0.2911.0) In-Reply-To: [EMAIL PROTECTED] X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Strath-Information: Contact [EMAIL PROTECTED] for more information X-Strath-Scan: clean X-Strath-UBECheck: X-Virus-Checked: Checked Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 21 Jul 2004 13:56:43.0725 (UTC) FILETIME=[8E23FFD0:01C46F2A] I created a new user with a GRANT statement like: GRANT SELECT, INSERT, UPDATE, DELETE ON test.* TO 'demouser'@'localhost' IDENTIFIED BY 'testpwd' WITH GRANT OPTION If I then log in as 'demouser' I can execute SELECT etc. statements on the 'test' database, but if I try to create another user with access to 'test' using: GRANT Select ON test.* TO 'newuser'@'localhost' IDENTIFIED BY 'newpwd' I get: Error: 1044 - Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' Does 'demouser' have to be explicitly GRANTed access to the MySQL grant tables (user, db, host, tables_priv and columns_priv) before the user can be GRANTed GRANT privileges to any database or table? If so, what are the minimum privileges required? John R. Porter I.T. Services University of Strathclyde Faculty of Education 76 Southbrae Drive Glasgow G13 1PP e-mail: [EMAIL PROTECTED] Tel. 0141 950 3289 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL
RE: MySQL does not automatically start at BOOT time??
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 List: I have spent the entire weekend solving this problem without success. PLEASE HELP. After the last response from Paul, and MySQL not starting at BOOT time, I thought that I may have done something wrong. So I went ahead and did a fresh install of RH9 MySQL Source Distro with one difference. This time I installed mysql-4.0.18. I followed the installation script as noted below, still MySQL does not automatically re-start at BOOT time. For those who did not follow this posting; previously I have installed MySQL and followed the same installation script. Each time MySQL started at BOOT time. The only major difference is that in previous cases, I installed from the binaries this time I installed from source. I can start the MySQL by mysqld_safe. Paul had suggested looking into the MySQL error logs. Since I am new, I can't find where are error logs are kept. I have looked in /var/log /usr/local/mysql and have not found any error logs for MySQL. I sure need help!! Thanks. Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 6:44 PM To: Kirti S. Bajwa Subject: RE: MySQL does not automatically start at BOOT time?? Paul: Did what you said. Here is the response: % chkconfig --list mysql.server mysql.server 0:off 1:off 2:on 3:on 4:on 5:on 6:off That looks correct. If you did chkconfig mysql.server on, *and then restarted*, and the server still doesn't start automatically, check the MySQL error log to see if it has a clue. If it doesn't, I dunno. What next? Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 2:24 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: Re: MySQL does not automatically start at BOOT time?? At 14:08 -0400 5/8/04, Kirti S. Bajwa wrote: Hello List: I have been learning MySQL. I have installed tested MySQL server 3-4 times without problem. This time I used the an alpha-nightly snapshot and have run into problems. My current Installation: -- LINUX RH9 Source Installaion: mysql-5.0.1-alpha-nightly-20040504.tar.gz DUAL Pentium 1GHz CPU 1.5 GB Memory Installation Procedure: -- I follow the installation procedure is as described in MySQL documentation a doze of consulting MySQL by Paul DuBois book: % cd /usr/local % gunzip -dc mysql-5.0.1-alpha-nightly-20040504.tar.gz | tar xvf - % cd mysql-5.0.1-alpha-nightly-20040504 % ./configure -prefix=/usr/local/mysql % make % make install % scripts/mysql_install_db % chown -R mysqladm.mysqlgrp/usr/local/mysql/var % chown -R mysqladm.mysqlgrp/rad/var % chmod -R go-rwx /usr/local/mysql/var * It is a good idea to first see if the MySQL can be started: % /usr/local/mysql/bin/mysqld_safe -user=mysqladm % ps -aux | grep mysql There should be 4-5 lines showing how MySQL is running. Wonderful, MySQL is running. % reboot Setup to start MySQL automatically % cp /usr/local/mysql Version No/mysql.server /etc/init.d % cd /etc/init.d % chmod 500 mysql.server % chkconfig - -add mysql.server Try adding: chkconfig mysql.server on Then run this to see if it's been enabled for the appropriate runlevels: chkconfig --list mysql.server % reboot Check if MySQL is running: % ps -aux | grep mysql Problem: - Well, MySQL does not start automatically. -- - - -- As I said, I have used a similar installation script before without proble. This time, the only modifications made to the instalation script are: (1) Few hints from Paul DuBois book (2) Different version of MySQL. Can somebody point me to the problem? Is in the script I am using is missing something? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives:
RE: MySQL does not automatically start at BOOT time??
The build from scratch on a redhat machine is not 100% straight forward. I believe the S90mysqld link in the redhat /etc/rc.d/rc3.d/ looks specifically for the boot file in /etc/rc.d/init.d/mysqld in order to start. It's auto generated on a rpm but if you wanted to try subqueries which is only available in mysql4.1, redhat9 has no rpm built for that. That's why I needed to build from scratch. Some of the shortcuts are removed when I typed rpm -e to get rid of the old stuff. One of those files would be the my.cfg in the /etc. That's very annoying when you have a fine-tuned my.cfg and in a flash it's gone. The other file is the boot script in /etc/rc.d/init.d/ . That missing file had me stumped for a day or two. RH9 boot starts everything in the rc3.d or rc5.d with a good S (for start) in the appropriate folder a K file is used to kill the fill during that sequence. So is Kirti needed to Start the mysql server during boot and he was using a system that boots to a graphical login then he would need to do this. cd /etc/rc.d ln -s ../init.d/mysqld rc5.d/S90mysqld rm rc5.d/K15mysqld ../init.d/mysqld start Or for a command line booted machine. cd /etc/rc.d ln -s ../init.d/mysqld rc3.d/S90mysqld rm rc3.d/K15mysqld ../init.d/mysqld start Or to have it boot in all conditions. cd /etc/rc.d ln -s ../init.d/mysqld rc2.d/S90mysqld ln -s ../init.d/mysqld rc3.d/S90mysqld ln -s ../init.d/mysqld rc4.d/S90mysqld ln -s ../init.d/mysqld rc5.d/S90mysqld rm rc2.d/K15mysqld rm rc3.d/K15mysqld rm rc4.d/K15mysqld rm rc5.d/K15mysqld ../init.d/mysqld start This is just a RedHat thing. Good luck! You can do this. -Original Message- From: Sam [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 4:52 PM To: [EMAIL PROTECTED] Subject: RE: MySQL does not automatically start at BOOT time?? Kirti: I think you already did that as you said in you first msg about you installation steps. Setup to start MySQL automatically % cp /usr/local/mysql Version No/mysql.server /etc/init.d Did you get my prev msg where I suggested to check the previleges on your mysql. Usually I do it this way: 8) Change ownership of binaries to root and ownership of the data directory to the user that you will run mysqld as (in our case mysql): chown -R root . chown -R mysql var chgrp -R mysql . ( this is important too) 9) To start MySQL server automatically when you boot your machine, copy the mysql.server script to the `/etc/init.d' directory with the name mysql, and then make it executable cp support-files/mysql.server /etc/init.d/mysql chmod +x /etc/init.d/mysql 10) Activate to run the 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 S. Bajwa [EMAIL 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 PROTECTED] Subject: RE: MySQL does not automatically start at BOOT time?? 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 List: I have spent the entire weekend solving this problem without success. PLEASE HELP. After the last response from Paul, and MySQL not starting at BOOT time, I thought that I may have done something wrong. So I went ahead and did a fresh install of RH9 MySQL Source Distro with one difference. This time I installed mysql-4.0.18. I followed the installation script as noted below, still MySQL does not automatically re-start at BOOT time. For those who did not follow this posting; previously I have installed MySQL and followed the same installation script. Each time MySQL started at BOOT time. The only major difference is that in previous cases, I installed from the binaries this time I installed from source. I can start the MySQL by mysqld_safe. Paul had suggested looking into the MySQL error logs. Since I am new, I can't find where are error logs are kept. I have looked in /var/log /usr/local/mysql and have not found any error logs for MySQL. I sure need help!! Thanks. Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, May 08, 2004 6:44 PM To: Kirti S. Bajwa Subject: RE: MySQL does
A little Database construction help
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 an everyday drycleaner shop. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql database design.
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 an everyday drycleaner shop.
Field Name whitespace via MyODBC
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 my PHP scripts. I tried this: $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , `LERG_7_SHA.SHA INDICATOR` , `LERG_7_SHA.H ORG B TDM` FROM LERG_7_SHA WHERE ( LERG_7_SHA.SWITCH = \$npa\ AND `LERG_7_SHA.SHA INDICATOR` = \$nxx\ ) LIMIT 0, 30; And $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , \'LERG_7_SHA.SHA INDICATOR\' , \'LERG_7_SHA.H ORG B TDM\' ,\'LERG_7_SHA.H ORG C TDM\' , LERG_7_SHA.HOST , LERG_7_SHA.OCN , LERG_7_SHA.AOCN FROM LERG_7_SHA WHERE (LERG_7_SHA.SWITCH = \$npa\ AND \'LERG_7_SHA.SHA_INDICATOR\' = \$nxx\ ) LIMIT 0, 30; Both do not work. The query breaks down where the backticks are or tries to add the literal string of 'LERG_7_SHA.SHA INDICATOR' in the result data. I have tried with single quotes and double quotes. I can issue this command on the mysql command line and it does work. Can someone help me syntax this line correct? The script.php and the database are on the same FreeBSD machine. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Field Name whitespace via MyODBC
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 rename your fields/columns. If you are unable to rename them in mysql then you will probably need to rename them in your jet database with Access and re-import them. Your column names should be literals not wrapped in graves or quotes and should contain no whitespace. Whitespace is frequently used as a delimiter. I also avoid any characters other than alphanumeric and the occasional underscore character in field/column names . It helps avoid OS idiosyncrasies and simplifies naming conventions. I hope this helps. Pat... [EMAIL PROTECTED] CocoNet Corporation SW Florida's First ISP 825 SE 47th Terrace Cape Coral, FL 33904 - Original Message - From: Brian Duke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 2:50 AM Subject: Field Name whitespace via MyODBC 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 my PHP scripts. I tried this: $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , `LERG_7_SHA.SHA INDICATOR` , `LERG_7_SHA.H ORG B TDM` FROM LERG_7_SHA WHERE ( LERG_7_SHA.SWITCH = \$npa\ AND `LERG_7_SHA.SHA INDICATOR` = \$nxx\ ) LIMIT 0, 30; And $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , \'LERG_7_SHA.SHA INDICATOR\' , \'LERG_7_SHA.H ORG B TDM\' ,\'LERG_7_SHA.H ORG C TDM\' , LERG_7_SHA.HOST , LERG_7_SHA.OCN , LERG_7_SHA.AOCN FROM LERG_7_SHA WHERE (LERG_7_SHA.SWITCH = \$npa\ AND \'LERG_7_SHA.SHA_INDICATOR\' = \$nxx\ ) LIMIT 0, 30; Both do not work. The query breaks down where the backticks are or tries to add the literal string of 'LERG_7_SHA.SHA INDICATOR' in the result data. I have tried with single quotes and double quotes. I can issue this command on the mysql command line and it does work. Can someone help me syntax this line correct? The script.php and the database are on the same FreeBSD machine. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ?? .tcshrc On OS X ??
.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. /home/bsmythe/.tcshrc the file usually contains things like your $PATH variable or $PROMPT. Your best bet is to type env (on FreeBSD at least). That should give you a list of environment variables if you like the way your command line works now then I wouldn't change too many things. So you have a MAC. Look in your McManual to see where you set things like the type of command line prompt. Does it let you change the prompt from SHELL to SHELL_8:00AM:\ . The file you use to set this environment variable is the file you use to set the PATH. OS X 10 is claimed to be a kissing cousin to FreeBSD so I will make that assumption. First you will get stuck. But your system is like a 4wheeldrive and these lists are the wench to drag you out of places you ought not be. So add a good helping of persistence. You can do this. I'm an ex-truck driver. Good scrappy computers can be found for less than 50$ for an IBM PC. Load it up with FreeBSD. Buy a Good FreeBSD book Like FreeBSD Unleashed by Michael Urban and Brian Tiemann. Then just port down the Mysql rdbms. Use your Mac to administer the thing. SSH to the FreeBSD box from the Mac and get used to working roughly remote. You can do this. It's just going to take persistence on the command line. -Original Message- From: Lost Idols [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:46 PM To: [EMAIL PROTECTED] Subject: ?? .tcshrc On OS X ?? I had tips from some people here to install the complete MySQL from Server Logistics on my Mac OS X 10.2 and so I did (I also installed Apache 2 and PHP from them). Now I'm on Step one, but got stuck here. (I always get stuck while trying this MySQL). In the pdf-file that came along with the installation it says: shell echo $SHELL This will return the path to the shell you are using. In most cases it will return either /bin/tcsh (tcsh shell) or /bin/bash (bash shell). If you are using the tcsh shell, you will have to modify the file .tcshrc located within your home directory. If this file does not exist, then you will have to create a new one. After opening the file in your text editor, add the following line at the bottom of the file: setenv PATH $PATH:/Library/MySQL/bin Save the file. But when I try to find this .tcshrc file (whisch is the one showing up when I write that line in my Terminal. I can't find it (not by using Sherlock or when looking). I guess it should be in MyComputer / Library / MySQL / bin. But it isn't. So I wrote the line they explain in the end of the text above and try to save it as .tcshrc, but my computer tells me I can't use a name with a dot in the beginning. So I tried to take that away and then drop the file from the desktop to the bin folder, but then it tells m I'm not allowed to change that folder?! What am I supposed to do??? I'm really a newbie here... and it seems I'll always be... I've tried this sooo many times the last week now. I'm about to give up soon. :-( _ Hitta rätt köpare på MSN Köp Sälj http://www.msn.se/koposalj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login Problems
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. The problem began after I de-installed the 4.1 ALPHA versions of both the client and the server, removed the /var/db/mysql/ directory so the install would start afresh and installed the 4.0.6 Production release, again of both the client and the server. But after I did that users can now only connect if their passwords are null. As soon as a user sets a password they receive he following message: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I have tried reinstalling only to find the same problem. Can anyone please help with this as is it hindering the development of our new web site. Thank you in advance. Regards, Conor Quigley. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: CPU 100%
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] Subject: Re: CPU 100% If you find an answer, I would really like to hear about it. I have been working on this for months. No one seems to have a clear answer, although several people have reported curing it by either adding your server to c:\WINNT\system32\drivers\etc\hosts or setting the mysql service up to run logged in as a non-descript user. Neither solution affects either of my W2K or XP computers. The last response I got on the win32 list claims that the problem can go away and come back with no rhyme or reason. Peter Zuidema wrote: Hello all, We use MySQL 3.23.51 on a NT Server and a Win2000 Server. On the Win2000 server all works fine. But wen we install MySQl on the NT Server CPU Usage goes through 100% for a while (20-30 seconds). What could be the reason of this? And how can we fix it? Regards Peter Zuidema [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- == John R. Diehl, Jr. FSU Department of Computer Science == - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql and RedHat 7.3
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 numbers represent at what time does the system load that service in case some applications like syslog need to be operational before mysqld can be started. I usually set it for some number after S54inetd (xinetd) and before S85httpd. S79mysql works for me. -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:13 PM To: MYSQL-List (E-mail) Subject: Mysql and RedHat 7.3 When I installed Mysql ( whatever the current 3.x series is on RedHat 7.3, the service did not start when I restarted. If you have gnome installed, you can acess Service Configuration and set MySQL to start when system boots. Just information for those that may experience this. Luc Foisy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql and RedHat 7.3
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 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 numbers represent at what time does the system load that service in case some applications like syslog need to be operational before mysqld can be started. I usually set it for some number after S54inetd (xinetd) and before S85httpd. S79mysql works for me. -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:13 PM To: MYSQL-List (E-mail) Subject: Mysql and RedHat 7.3 When I installed Mysql ( whatever the current 3.x series is on RedHat 7.3, the service did not start when I restarted. If you have gnome installed, you can acess Service Configuration and set MySQL to start when system boots. Just information for those that may experience this. Luc Foisy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: OT Re: Mysql, PHP and a wrapper
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-7.3.4.rpm and php-mysql-4.1.2-7.3.4.rpm and finally everything works good. I noticed that sometime in the past I somehow installed an older version of php but a different version of php-mysql. Not sure how I did that. Usually linux is fairly goof proof when it comes to rpm's. shakes his head sometimes I'm my own worst wenzu. -Original Message- From: Danny Haworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:54 AM To: [EMAIL PROTECTED] Subject: OT Re: Mysql, PHP and a wrapper -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OT Filter: query , sql Hi Brian, | 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.23.49-3 database. | | If I use mysql_connect() only, I get Fatal error: Call to undefined | function: mysql_connect() in /var/www/html/admin.php on line 9 I had massive problems with the redhat php rpm's.. get the source from the php homepage and include the option '--with-mysql' in the './configure' arguments. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9kWukUKf+497XC3QRAhU6AJ0eK4hnb8ARkJ1QJHTLg24mN5nV2gCeJl4M Bbd+8gXfFtsDpu2HCu/DgjI= =ZBdO -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql, PHP and a wrapper
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.23.49-3 database. If I use mysql_connect() only, I get Fatal error: Call to undefined function: mysql_connect() in /var/www/html/admin.php on line 9 elseif I put on my script include_once(DB/mysql.php) I get Fatal error: Class db_common: Cannot inherit from undefined class pear in /usr/share/pear/DB/common.php on line 30 endif. :) can someone tell me how to preinclude /DB/* functions in my Zend engine so I do not have to include_once in every script. and if the php rpm needs to be installed how do I do that without breaking the install of mysql and apache. Brian.Dukemailto:[EMAIL PROTECTED] CTIP/TNT CFP IPSA Level(3) Communication (720) 888-7797 ==-=-=-=-=--==--==¬ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: HELP - MYSQL databases disappearing!
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 officially part and parcel of that user only. Next I would investigate where the server was installed. There are a number of directories that are auto deleted every time you reboot. Look for unusually large ~.tmp files. Like ~exp0023.tmp or perhaps File00452.tmp. If the server crashes and a program is up in memory windows has a nasty habit of spitting the file in memory immediately to the disk without giving you more than a small hint what the original name was. My suspicion is you won't find any of these. Here's a typical scenario... The server is set-up with a cleaning scheduler. Every night at midnight the system runs a virus check, a scandisk and a defrag then empties the temp files and reboots. The Mysql program is running at the same time. Mysql is using a section of memory that is also used by defrag. Microsoft sometimes lets programs share memory space but some programs (virus checkers and excel are the worst) fail to give the memory back. A good midnight query is run. It crashes. The program is dropped into the Temp bin as ~ql883.tmp the server runs the cleanup process and finds a huge tmp file it cannot put in the trash bin because of it's size (mysql server + query + tables trashbin size) therefore for your convenience Microsoft auto deletes the file. Then reboots. You might get a warning that the server cannot be found but that would be it. -Original Message- From: Mike Taffi [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 1:21 PM To: [EMAIL PROTECTED] Subject: HELP - MYSQL databases disappearing! Importance: High Does anyone know why a MYSQL database would just disappear and how I might prevent it from happening in the future? I run it on win2k advanced server. Much obliged, Mike Taffi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
First question: a howto.
I can't add a new user or I don't know the proper way to log into the server. I added a user; call him webley. Ran my sql statement to insert into the user and db tables. Granted all rights because I was unsure how many rights my cgi script would need. It does need to create new 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 if I am missing the big flick? Brian Duke CTIP/TNT CFP IPSA Level(3) Communication (720) 888-7797 ==-=-=-=-=--==--==¬ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php