Re: FW: ezmlm response
Is this new syntax? It seems to be different from your book, Paul. Z On Friday, June 1, 2001, at 10:50 PM, Paul DuBois wrote: At 10:13 PM -0400 6/1/01, daddius wrote: hello everyone... I am very new to mysql and I needed some help creating 1 admin account for 4 computers. This is the error I keep getting. mysql grant all on *.* to admin@% identified by password; ERROR 1064: You have an error in your SQL syntax near '% identified by password' at line 1 mysql Put quotes around the % character: mysql grant all on *.* to admin@% identified by password; -- Paul DuBois, [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 mysql-unsubscribe- [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: Mac OS X
On Saturday, June 2, 2001, at 04:27 PM, Tommy Beavitt wrote: In response to a recent question I posted regarding installing MySQL/PHP/Apache on a G4 tibook I was recommended to get a copy of Mac OS X as this was condsidered to be the most stable and easily configurable option at my disposal. I am fairly well-versed in relational concepts but a bit slow at command-line interfaces. Steep learning curve ahead :) My alternatives are: installing the combo on LinuxPPC, using Windows98 (emulated) or getting an x86 computer just for running MySQL/PHP/Apache. Right now LinuxPPC is probably going to give you the fewest obscure issues. I'm typing this on X at the moment, and it's happily running MySQL 3.23.36 (yeah yeah, I'm lazy, sue me :), PHP 4.0.5, and Apache 1.3.20. It all seems to be getting along fine; granted this isn't a production server. I did have to jump through some hoops in order to get MySQL to compile; check the archives of the list. In X's defense, Apache *screams* on it, if you believe the benchmarks. (ObBrag: From Apache server status page: CPU Usage: u.07 s0 cu0 cs0 - 4.11e-5% CPU load) :) My purpose is to gain knowledge of the above setup in order to publish information to a virtual server I rent on which MySQL/PHP is supported. I come from a Filemaker Pro background. FMPro is a totally different beast than MySQL in that it's almost completely GUI-driven. MySQL has a GUI only if you use a third-party tool. However importing/exporting between the two shouldn't be difficult; export to csf or tab delimited to transfer between the two. When I looked on the web at examples of using MySQL with Mac OS X I wasn't particularly reassured. It seems that this is something of a minority interest and there are problems with compiling the application. This may change with Mac OS X Server 10.0. Of course, as Mac users, we're always fighting the lowest common denominator anyway. This doesn't mean it doesn't work, and work pretty darn well. Can anyone on this list reassure me that this is indeed the easiest way into the technology? Or should I bite the bullet and get torn into Linux? Although I am a support of the Open Source concept I don't mind paying Apple for the OS X license if it is going to get me up and running quickest. I am currently running Mac OS 9.1. If you're going to be sticking with PPC hardware you're not going to have an easy time finding help with just about everything, due to the average techie's bias against the Mac. LinuxPPC is a kind of middle ground; it's not quite the same as running Linux on x86 or Sparc, but it gets the job done. Thanks in advance. Tommy Beavitt - 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 mysql-unsubscribe- [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: Access DB
Perl works beautifully with MySQL, as do PHP and Java, and $SCRIPTING_LANGUAGE. Choose your poison. Z On Sunday, June 3, 2001, at 08:36 PM, Gary Bonham wrote: I've just joined this list as I'm considering using mysql. My databases are in Access format, and I don't wish to convert to SQL just yet (although long range plans are indeed to do just that), but I need to be able to read them in Perl CGI scripts, which is why the interest in mySQL. Is this a feasible thing? I'm currently using ASP to access, update, etc., my databases for a web site but need to be able to access them from Perl. If this isn't the right package, then can someone point me in the right direction? Gary - 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 mysql-unsubscribe- [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 PHP4
--with-mysql uses PHP's built-in MySQL libraries, while --with- mysql=/path/to/mysql will build it with the libraries of the MySQL installation already present. The version built into PHP4 seems to work ok for most things, but it's a bit behind in the point revs; which version it uses escapes me for the moment. Z On Thursday, May 24, 2001, at 01:59 PM, Scott Baker wrote: Do you need to specify a directory? I just did --with-mysql At 01:14 PM 5/24/2001 -0400, Bill Tangren wrote: When I compile PHP4 (4.04pl1) with the option --with-mysql=mysqldir... I get the error 'cannot find mysqlclient library under mysqldir' I did a search through the mysqsl (3.23.38) source code after I compiled it, and I don't find that library anywhere? What am I doing wrong? - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] You may be disappointed if you fail, but you are doomed if you don't try. - Beverly Sills - 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 mysql-unsubscribe- [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: My mySQL doesn't start...
Verify that mysqld is running with a ps ax from a Terminal prompt. Z On Thursday, May 24, 2001, at 06:24 PM, Victor Spång Arthursson wrote: Hi! I installed mySQL on my Mac OS X last week, but I never really tried it, though I know it was possible to start. But after having reinstalled Apache and PHP, it's not possible to start anymore... What happens when I type mysql in the terminal is: [localhost:~] victor% mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [localhost:~] victor% Is it anyone who can tell me how to fix this..? Thankful for answers, Victor Spång Arthursson, sweden - 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 mysql-unsubscribe- [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 the Macintosh
Hmm. One way might be to use MacPerl to generate tab delimited files that you could then use to create an Excel document, then mail merge into your Word doc. I could have sworn that there was some kind of ODBC setup with Mac Office, though.. Z On Monday, May 21, 2001, at 02:17 AM, Ray Smith wrote: Hi all, I would like to try and create a database that can be used for report/letter generation on both IBM and Macs, and eventually emails. I have success on the IBM simply using ODBC and Office, and was wondering how one would go about the same process on the Mac. The advantage of using Office was simply that templates already existed. I have had a look through the archives but only found references to FileMaker. Is this the only way to go on the Mac? Any suggestions? Ray. - Ray Smith Centre for Musculoskeletal Studies Department of Surgery University of Western Australia Royal Perth Hospital Medical Research Foundation Bldg Rear 50 Murray St, Perth, Western Australia, 6000 Ph: +61 8 9224 0307 Fax:+61 8 9224 0204 Email: [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 mysql-unsubscribe- [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: AIX segmentation fault with PHP, Apache and MySQL
Hmm. Can you be a bit more specific how you upgraded your Apache? Typically I've had good luck with building the new Apache first, then building PHP (using the new apxs that it installs). You are installing these modules as .so, correct? And building everything from source code? The only thing I can think of here is that your earlier Apache had a broken lib somewhere and the new installs are not replacing it.. Z On Sunday, May 20, 2001, at 10:15 PM, Dave Brooks, BCS Systems wrote: MySQL 3.23.38 made no difference Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem... Am about to upgrade MySQL to 3.23.38 to see if this changes things, but feel this is clutching at straws... Thanks, Dave On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - 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 mysql-unsubscribe- [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 mysql-unsubscribe- [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 mysql-unsubscribe- [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 mysql-unsubscribe- [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: AIX segmentation fault with PHP, Apache and MySQL
1.3.19 actually, Matt :) I'm running .19 on both my Linux machine and the G4. And as far as I can remember, PHP4.0.4pl1 worked ok on 1.3.14, I was doing that for a while. Z On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - 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 mysql-unsubscribe- [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 mysql-unsubscribe- [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 for Mac OS X
You can compile from source on OS X. I personally built 3.23.36 on 10.0 when it came out; right now it requires a couple of edits to the source code prior to compilation. The edit can be found here: http://www.mysql.com/doc/M/a/Mac_OS_X_Public_Data.html in the Comments section. Once you patch this it should build easily. However, right now the test suite does not work properly and once running, the mysqld cannot be stopped using mysqladmin or anything else short of a kill -KILL 'pid' . I'm told these problems are being worked on by people smarter than me :) Zach On Wednesday, May 16, 2001, at 08:36 AM, Robert Goeres wrote: I am looking for MySQL for Apple's Mac OS X (10.0.3). Up to now I have only found some old versions for Mac OS X Server or OS X Beta Any tips or hints? Regards Robert Goeres - 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 mysql-unsubscribe- [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: problem stopping mysqld
This is a known bug when running MySQL on Darwin / Mac OS X right now. Last I heard some listy was submitting a diff or a patch to the maintainers, but I haven't heard anything about it for a little while. Any news, folks? Works a treat on Darwin, otherwise. Zach On Tuesday, May 15, 2001, at 10:24 AM, EISSEN Charlie wrote: Hello, i'm running mysqld on darwin (mac os x client)...Start is good, but then i can't stop the server...i tried ./mysqladmin shutdown, ./mysqladmin -u root shutdown, but it doesn't work..any one can help??? mysql 3.23.37 Thank you, EISSEN Chalrie - 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 mysql-unsubscribe- [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