Re: Anyone running Windows 2000?
On Tuesday 01 July 2003 9:39 pm, Ola Ogunneye wrote: > Is anyone out there running mysql with Apache and php on windows 2000? If > you are out there, please respond and hopefully you may be able to help me. > I see that most of the posts are geared towards unix/solaris. > > I am a newbie that needs help. > > Thanks yep apache 2 mysql 4 and php on 2000 server advanced edition. works fine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
groups, limits and counts.
I have a tabletheres a surprise month protocol port utime 06 tcp21 12 06 tcp21 13 05 udp 43 100232 05 udp 21 100245 what I would like to do is select by month and by protocol but within protocol limit to the top 5 by count of port. In other words,I want the 5 most common instances of port per instance of protocol per instance of month. is this actually possible with a single query (mysql 4.0)? I have tried vairious combinations of group by and order by but however I do it, limit n, seems to do just that...limit the results to n rows... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Automatically running SQL command through a batch file
On Wednesday 04 July 2001 21:37, Christopher Brown-Floyd wrote: > Is there a way to run a SQL command or create a database through a batch > file? jeez! for some one who is omniscient you don't know much read the friendly manual section 9.6 : Using mysql in batch-mode also check out mysqldump > If not, is there some kinda work around? I'm trying to make a batch > file that will create a skeleton database structure for deployment of a > website that I'm working on. > > TIA > -Chris > > > > - > 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: DBD::MySQL Help!!
If this was the binary install, I had the same problemso I compiled from source.problem went away. > Hi, > > Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- > I know this is prolly not the best list for this question, but its the only > related list im currently subscribed to... When I do the install it askes > me what db to test on and i put test, localhost for host, then i put root > as the test user and my root sql users pw for the password, it does some > stuff then it runs the make test and this is what happens... > > Any help?? > > > Running make test > PERL_DL_NONLAZY=1 > /usr/local/bin/perl -I../blib/arch -I../blib/lib > -I/usr/local/lib/perl5/5.6. 1/OpenBSD.i386-openbsd > -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); > $verbose=0; runtests @ARGV;' t/*.t > t/00base/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/00basedubious > Test returned status 1 (wstat 256, 0x100) > t/10dsnlist./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/10dsnlist.dubious > Test returned status 1 (wstat 256, 0x100) > t/20createdrop../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/20createdrop..dubious > Test returned status 1 (wstat 256, 0x100) > t/30insertfetch./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/30insertfetch.dubious > Test returned status 1 (wstat 256, 0x100) > t/40bindparam.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/40bindparam...dubious > Test returned status 1 (wstat 256, 0x100) > t/40blobs.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/40blobs...dubious > Test returned status 1 (wstat 256, 0x100) > t/40listfields../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/40listfields..dubious > Test returned status 1 (wstat 256, 0x100) > t/40nulls.../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/40nulls...dubious > Test returned status 1 (wstat 256, 0x100) > t/40numrows./usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/40numrows.dubious > Test returned status 1 (wstat 256, 0x100) > t/50chopblanks../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/50chopblanks..dubious > Test returned status 1 (wstat 256, 0x100) > t/50commit../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/50commit..dubious > Test returned status 1 (wstat 256, 0x100) > t/60leaks...skipped test on this platform > t/ak-dbd/usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/ak-dbddubious > Test returned status 1 (wstat 256, 0x100) > DIED. FAILED tests 1-90 > Failed 90/90 tests, 0.00% okay > t/dbdadmin../usr/libexec/ld.so: perl: libmysqlclient.so.6.0: No > such file or directory > t/dbdadmin..dubious > Test returned status 1 (wstat 256, 0x100) > DIED. FAILED tests 1-20 > Failed 20/20 tests, 0.00% okay > Failed Test Status Wstat Total Fail Failed List of Failed > --- >- > t/00base.t 1 256?? ?? % ?? > t/10dsnlist.t 1 256?? ?? % ?? > t/20createdrop.t 1 256?? ?? % ?? > t/30insertfetch.t 1 256?? ?? % ?? > t/40bindparam.t1 256?? ?? % ?? > t/40blobs.t1 256?? ?? % ?? > t/40listfields.t 1 256?? ?? % ?? > t/40nulls.t1 256?? ?? % ?? > t/40numrows.t 1 256?? ?? % ?? > t/50chopblanks.t 1 256?? ?? % ?? > t/50commit.t 1 256?? ?? % ?? > t/ak-dbd.t 1 25690 90 100.00% 1-90 > t/dbdadmin.t 1 25620 20 100.00% 1-20 > 1 test skipped. > Failed 13/14 test scripts, 7.14% okay. 110/110 subtests failed, 0.00% okay. > *** Error code 2 > > Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216/mysql (line 737 of > Makefile). > *** Error code 1 > > Stop in /root/.cpan/build/Msql-Mysql-modules-1.2216 (line 732 of Makefile). > /usr/bin/make test -- NOT OK > Running make install > make test had returned bad status, won't install without force > Running install for module DBD::mysql > Running make for J/JW/JWIED/Msql-Mysql-modules-1.2216.tar.gz > Is already unwrapped into directory > /root/.cpan/build/Msql-Mysql-modules-1.2216 > Has already been processed within this session > Running make te
Re: users and passwords...users and passwords...
/mysql/bin/mysql_setpermission can also be handy but if you do stuff manually don't forget to do a /mysql/bin/mysqladmin flush-privileges a bit of manual reading probably wouldn't go amiss either :-) On Monday 07 May 2001 07:54, Daniel Goldin \(E-mail\) wrote: > I've had similiatr problems setting passwords on my redhat box. > > Tried % mysql -p -u root mysql: > > Got error message: > > "Access denied for user root@localhost" (using password:YES) > > Help, please!!! > > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Sunday, May 06, 2001 6:36 PM > To: Simon Chan; mysql Mail List > Subject: Re: users and passwords...users and passwords... > > At 12:16 PM -0700 5/6/01, Simon Chan wrote: > >NEWBIE QUESTION > >Hello, > > > >Just installed mysql on a solaris2.7 sparc machine, but I don't seem > >to have permission to do > >anything! I add a user by typing > > > >useradd username > > That creates a UNIX user account, not a MySQL user account. They have > nothing > to do with each other. > > To create a MySQL user (and set the password), use the GRANT statement > in the mysql program: > > % mysql -p -u root mysql > > Then enter the MySQL root user password when prompted and execute your > GRANT statements. See the MySQL Reference Manual for GRANT syntax. > > >BUT HOW DO I SET THE PASSWORD? Someone suggested doing this: > > > >mysql>insert into user (host, user, password) values ('localhost', > >'myname' password('testpass'); > > > > > >But that doesn't work for me! It gives me the good ol' syntax error > >message. I've also tried > >this: > > > >mysql> insert into user (host, user, password) values ('localhost', > >'myname','testpass'); > > > > > >But that gives a message saying that no database selected. > > > >Help! - 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: create table with select syntax error problem
yep, spot on, also I didn't even need to specifically create the fields at all.the Select clause does it for me...thanks very much for the helpI can get on with the hard (for me) stuff now :-) On Thursday 17 May 2001 03:22, Rolf Hopkins wrote: > Original Message - > From: "Mark Rowlands" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, May 17, 2001 3:11 > Subject: create table with select syntax error problem > > > CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10) > > unsigned DEFAULT '0' NOT NULL,PRIMARY KEY (sajtid)) select > > log.sajtid,count(*) from log,sajter where log.sajtid=sajter.id and > > log.mon > > = > > > 5 group by log.sajtid; > > It would help to know what the error message is but for starters, you are > creating a column count int(10) and count is a reserved word as in > log.sajtid,count(*). > > > the create table on its own works, the select statement works, there is a > > similar example in the sql manual that works, but this doesnt :-(. Can > > antone > > > help a newbie? > > > > The actual problem, is to calculate the percentage number of records less > > than a value. So I want to create this temp table with the total count of > > records and then count the no of records that are less than x and link to > > this table to calculate the percentage. or am I barking up the wrong > > tree? > > > Mysql 3.22 and 3.23 for those interested but it has to work on both. > > > > - > > 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
create table with select syntax error problem
CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10) unsigned DEFAULT '0' NOT NULL,PRIMARY KEY (sajtid)) select log.sajtid,count(*) from log,sajter where log.sajtid=sajter.id and log.mon = 5 group by log.sajtid; the create table on its own works, the select statement works, there is a similar example in the sql manual that works, but this doesnt :-(. Can antone help a newbie? The actual problem, is to calculate the percentage number of records less than a value. So I want to create this temp table with the total count of records and then count the no of records that are less than x and link to this table to calculate the percentage. or am I barking up the wrong tree? Mysql 3.22 and 3.23 for those interested but it has to work on both. - 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: Can anyone help me.. for install on a Freebsd 4.2 box..
On Thursday 19 April 2001 21:54, Ken Menzel wrote: > cd /usr/ports/databases/mysql323-server > make > make install > reboot this aint windows ya know skip the reboot /sbin/ldconfig -m /usr/local/lib/mysql /usr/local/bin/safe_mysqld --user=mysql - 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: Perl MySQL Interface
let perl -MCPAN -e shell be your friend i /mysql/ will show you all the mysql stuff or i /dbi/ even On Thursday 12 April 2001 01:16, Chris Becker wrote: > go to perl.com - click CPAN and look for DBI and DBD, and look for docs on > how to install a perl module. You need to install DBI first, then DBD... > > hope this helps. > > > Chris Becker > MCSE MCDBA > === > Idysys > http://www.idysys.com > [EMAIL PROTECTED] > === > > -Original Message- > From: Brian Cassidy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 11, 2001 3:59 PM > To: [EMAIL PROTECTED] > Subject: Perl MySQL Interface > > > I have installed MySQL 3.23 on RedHat 7 using the rpms. > Installing the bench rpm gives "MySQL-DBI-perl-bin is needed > by MySQL-bench-3.23.36-1". I can't seem to locate any version > of this dbi which will install. I see that mysql.com has a perl dbd > module for MySQL but that is not an rpm. Is that what I need? > If so, how do I install it? > --- > Brian Cassidy [EMAIL PROTECTED] http://people.unb.ca/~bpc > > - > 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