On Fri, Apr 27, 2001 at 07:21:38PM -0700, Soren Ragsdale wrote:
>
> I purchase web space on www.phpwebhosting.com, which offers PHP and
> mySQL services in a shared server environment. Each user gets their
> own database, in which they can create their own tables. Today,
> someone is using a LOT
On Sat, Apr 28, 2001 at 08:47:11PM -0600, David Keeney wrote:
>
> I have a situation where a query should be using an index, running
> the query from the mysql terminal using the explain ... command
> indicates it will use the index, but the actual execution speed
> tells me the index is not bein
Hi,
I am trying to compile Apache with PHP4/MySQL support.
PHP4 compiles/installs fine, but when I compile Apache with PHP4/MySQL
support, I get an error when linking the MySQL shared library
libmysqlclient.a.
Here is the compile log, after that are the various compilation options.
*Snippet of A
i'm makin a search engine the table looks like this -
---
| number | name | keywords | description | url | rank |
---
query's are made to against keywords, and description which are a blob's.
Your question IS for this list, as far as it concerns
MySQL. I do understand it like this, and I think many
people think this way here. Many of us strated here
with 'stupid' questions. These lists are a great thing,
I think, it's like a bread for newbies, and a way to join
also advanced users.. an
As far as I know, 'update' is a reserved word
and you should quote it with reversed quotes
(you know they are on my keyboard near '1').
I hope it helps.
Daniel BI
> Hi,
>I'm useing mysql php and SSL on a colbalt raq, the problem I'm having
is
> that when ever I use the update query it does
just put the -p flag first :)
Daniel BI
=
Original message
Attempting to define an admin user that can connect from any host.
Host='%', user='admin', password=PASSWORD(xxx), all _priv values are 'Y'
when launching "./mysql -u admin -p mysql" and entering password, I get:
"./mysq
Sander Pilon writes:
> > Howdy,
> > ./ChangeLog
> >
> > Indeed, those don't appear to be in the tar archive.
> >
> > Any ideas?
>
> Do you need them?
>
> tar xfz mysql++.tar.gz
> cd mysql++-
> ./configure; make; make install
>
> Voila.
>
> And yes, the mysql online manual has b
Braxton Robbason writes:
> isn't this the expected behavior?
>
> (1008306000-988344000)/86400 = 231.04
>
> select mod(231.04,7);
> 0
>
> 231.04 mod 7 is .04, rounded down to 0. 7*33=231
>
> the mod function rounds the result - that's expected, right? Other than that
> I don't see what the prob
>
> It is fine and complete will all chapters and in all formats.
>
This page used to have lots of cool documentation...
http://www.mysql.com/documentation/mysql++/5_Class.html
-
Before posting, please check:
http://ww
Sander Pilon writes:
> >
> > It is fine and complete will all chapters and in all formats.
> >
>
> This page used to have lots of cool documentation...
>
> http://www.mysql.com/documentation/mysql++/5_Class.html
>
>
>
Yes, and there two versions of manual. One for on-line browsing and
th
The 5_Class.html file online is only a few lines and only describes the
manipulators, as opposed to the old 5_Class.html file distributed with
1.7.5 and the downloadable one, which is 300Kb and contains descriptions
of much, much more.
Manipulators is (the only) section 5.1 in the on-line versio
On Sun, Apr 29, 2001 at 02:45:06PM +0200, Sander Pilon wrote:
>
> The 5_Class.html file online is only a few lines and only describes
> the manipulators, as opposed to the old 5_Class.html file
> distributed with 1.7.5 and the downloadable one, which is 300Kb and
> contains descriptions of much, m
Sander Pilon writes:
> The 5_Class.html file online is only a few lines and only describes the
> manipulators, as opposed to the old 5_Class.html file distributed with
> 1.7.5 and the downloadable one, which is 300Kb and contains descriptions
> of much, much more.
>
> Manipulators is (the only)
Hi,
I would like to know how to measure how many MB of one particular
databases is taken in PHP command. I know I can always use the command of
du ... . But this command is not work under apache because the user and
group are nobody, while the user and group for mysql is mysql, also the
pe
Hello,
I am a Java developper, I use Mysql and TOmcat,
I want to know what SSL is?
Thanx
___
Do You Yahoo!? -- Pour faire vos courses sur le Net,
Yahoo! Shopping : http://fr.shopping.yahoo.com
-
On Sun, Apr 29, 2001 at 03:36:14PM +0200, Sofiane Sakhri wrote:
>
> I want to know what SSL is?
http://www.google.com/search?q=SSL
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
MySQL 3.23.29
I saw your mail on our WWW bug for MySQL++ manual.
Do you use MySQL++ at Yahoo! ??
Just curious ;o)
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMA
My insert query look like your
'INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);';
after the query I look into the table 'ordinit' and always looks fine: the value of
ID_ordine is really incremented.
But the following 'select LAST_INSERT_ID()' return zero :-((
It looks like a bug ?
Hi,
>Hello,
>I am a Java developper, I use Mysql and TOmcat,
>I want to know what SSL is?
>Thanx
SSL is Secure Socket Layer.
Is a technology to encrypt and decrypt message (HTML pages or other)
over Internet.
Best regards.
On Sun, Apr 29, 2001 at 04:44:10PM +0300, Sinisa Milivojevic wrote:
>
> I saw your mail on our WWW bug for MySQL++ manual.
>
> Do you use MySQL++ at Yahoo! ??
I believe so. The work I do is mostly in Perl. The person who
maintains all our charting code uses the C interface to MySQL. But
there's
>I am a Java developper, I use Mysql and TOmcat,
>
>I want to know what SSL is?
Nothing_to_do_with_mysql.
ssl=secure socket layer
More info? type ssl into the seach field of you favorite searchengine.
Bye,
B.
-
Before post
On Sun, Apr 29, 2001 at 03:38:07PM +0200, [EMAIL PROTECTED] wrote:
> My insert query look like your
> 'INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);';
> after the query I look into the table 'ordinit' and always looks fine: the value of
> ID_ordine is really incremented.
> But th
Hello, everybody!
Can MYSQL understand this (GROUPing BY FUNCTION(column))?
--
Best regards,
Igor mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the
The context is Active Server Pages application over IIS in NT server.
This code is in a file named DatiPrev.asp :
Open the connection using ODBC (I use MyODBC):
> set objConn = Server.CreateObject("adodb.connection")
> objConn.Open Application("Connection1_ConnectionString")
and this is the instru
Hi,
Does the function Unix_TimeStamp() work in MySQL under Windows NT? It
doesn't seem to work here in simple queries, such as this query:
Select Unix_TimeStamp();
Thanks
Noor
-
Before posting, please check:
http://www.mys
>MY PROBLEMS SO FAR
>All versions of MySQL I have tried so far have come in RPM format which I
>have rpm2targz to set up. Then I have
>gunzip/tar or tar xzf to unpack the archive. The archive unpacks in
>different folders to those that the scripts expect and
>this is a problem for a start. Also
Hi,
How do you keep MySQL password out of view of "visitors" when needed in PHP to access
the db. The password is in plain english in all the php files, and can be easily
downloaded by anyone.
Philippe
ex:
Hello,
Is there a windows mysql client to manage a distant
unix mysql server?
Thanx
Sofiane
___
Do You Yahoo!? -- Pour faire vos courses sur le Net,
Yahoo! Shopping : http://fr.shopping.yahoo.com
---
I have found the solution for my 'select LAST_INSERT_ID();' problem.
I must check the 'Change BIGINT columns to INT' option in the
ODBC entry options in my NT server and everything work fine.
Why this ?
This means that I never use BIGINT columns in my Database ?
Thanks.
Regards.
Thank you to those of you who have responded to my inquiry about
indexing.
Here is more complete information about the tables involved.
++
describe Tiger_main
Field TypeNullKey Default Extra
tlidvarchar(10) PRI
rdid
>How do you keep MySQL password out of view of "visitors" when needed in
>PHP to access the db. The password is in plain english in all the php
>files, and can be easily downloaded by anyone.
PHP is parsed so should show the password etc to the world. It's better to
use an include and put tha
Yes, try urSQL -- http://www.urbanresearch.com/ursql
There is also mysqlgui from
http://www.mysql.com/downloads/gui-clients.html and several more listed at
http://www.mysql.com/downloads/contrib.html#SEC569
On Sun, 29 Apr 2001, [iso-8859-1] Sofiane Sakhri wrote:
> Hello,
> Is there a windows my
Check out MySQLFront ... http://www.mysqlfront.de
- Original Message -
From: "Sofiane Sakhri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 10:11 AM
Subject: Is there mysql client under Windows?
> Hello,
> Is there a windows mysql client to manage a distant
>
That link is now:
http://www.urbanresearch.com/software/utils/urbsql/
- Original Message -
From: "j.urban" <[EMAIL PROTECTED]>
To: "Sofiane Sakhri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 9:43
Subject: Re: Is there mysql client under Windows?
> Yes,
The company I work for is MS SQL Server mad - they use it as the core for one
of their software products and pretty much all of their operation is based
around it - sad isn't it?! ;o)
Anyway, they now want a website with online ordering etc. and of course they
want it to be linked via MS-SQL to t
>Description:
When a ordinary users tries to analyze bin log using a remote host (-h
ip_address) mysql server daemons crahes.
>How-To-Repeat:
Just use mysqlbinlog to analyze a remote host binlog.
mysql -h ip_address -u user -p pass file
For instance (My environmen
Running mysql 3.23.22-beta on Redhat 7.0 w/apache and php4, and getting
the following error message:
/usr/libexec/mysqld: Can't create/write to file /var/run/mysql.pid
(Errcode: 13)
Tried to upgrade mysql to no avail, anyway, can connect locally on the
server terminal, but when try to connect o
Is there a simple way to prevent password trading on an apache system
using mod_auth_mysql? I've already got the module installed and
working. It would be nice if a directory of flat files could be
protected, without having any kind of SSI's, CGI's, etc.
anyone ... anyone?
--
[Joel-Gwy
On Wed, 25 Apr 2001, newsgroups wrote:
> Date: Wed, 25 Apr 2001 20:15:07 -0400
> From: newsgroups <[EMAIL PROTECTED]>
> To: MySQL-Group <[EMAIL PROTECTED]>
> Subject: File Not Found Error
>
> Sorry to be such an everything newbie. Perhaps this a unix error and not
> MySQL but a simple Describe
Hi,
I've site with heavy traffic, freebsd 4.2
php 4.0pl1, mysql 3.23.36.. ALL persistent connections.
I've nearly every second this error in the logfile:
10429 22:31:00 Aborted connection 2361 to db: 'alexv2' user: 'av2' host:
`localhost' (Got an error reading c
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>MySQL support: none
>Synopsis: configure fails: checking size of char... 0
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.2
On Sun, Apr 29, 2001 at 05:30:58PM +0200, Noor Dawod wrote:
>
> Does the function Unix_TimeStamp() work in MySQL under Windows NT?
> It doesn't seem to work here in simple queries, such as this query:
> Select Unix_TimeStamp();
What about
SELECT UNIX_TIMESTAMP(NOW())
?
--
Jeremy D. Zawodny,
Bom dia, Gustavo,
I am not in a position to comment nor to verify your warning. However, I am
pretty annoyed by the way you make it public to the world. Unless I missed
something here, but when someone discovers a security hole in any program,
it's common standard to contact the manufacturer imme
On Sun, Apr 29, 2001 at 03:12:51PM +, [EMAIL PROTECTED] wrote:
> >Description:
> When a ordinary users tries to analyze bin log using a remote host (-h
>ip_address) mysql server daemons crahes.
> >How-To-Repeat:
> Just use mysqlbinlog to analyze a remote host binlog.
> mysql
I disagree with you markus, and here is why..
1gustavo probably isn't the only person who has noticed this, so it's
fair to say it's already made the round amongst those who arent so nice.
2this _is_ the mysql list.
3this way, people can plan for such a problem and button things up
Hi,
Is there someone who incremented the max_connection
value to something above 100 (200) (300) on Freebsd 4.2?
I had problems with mysql on freebsd 4.0, hooked up
after some days without any good reason :).
Some people told me thread libraries on freebsd
Hi Chris,
You should not forget those users who depend greatly on the tech support
(patches) of the manufacturer. Given your expertise and knowledge you might
be able to protect yourself, but not everybody is (as a matter of fact even
Gustavo said he isn't). In addition, to make things worse, tod
Marc Bragg wrote:
> Running mysql 3.23.22-beta on Redhat 7.0 w/apache and php4, and getting
> the following error message:
>
> /usr/libexec/mysqld: Can't create/write to file /var/run/mysql.pid
> (Errcode: 13)
>
> Tried to upgrade mysql to no avail, anyway, can connect locally on the
> server
These points are all well considered, but the point is that I operate
under the assumption that the bad guys out there already have this
information, and that only legit people don't have it becuse they do not
operate in those circles. And yes, if you are operating a service on the
internet, you
how do you uninstall mySQL (v3.23.37) from a linux system?
thanks,
Justin Stern
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reque
Ok so here's the deal, I'm trying to check if mysql is working on my machine
so I open up the dos command prompt, type cd c:\mysql\bin and everything's
fine
then it try to create a test database by typing mysqladmin create testDB,
it try's to connect but it gives me an error message
"Can't con
On Sun, Apr 29, 2001 at 09:47:49PM -0400, [EMAIL PROTECTED] wrote:
>
> how do you uninstall mySQL (v3.23.37) from a linux system?
If using an RPM, do it the way you normally would with any RPM.
If using the source install, follow the instructions that is comes
with. See the INSTALL-SOURCE file.
Hi everyone,
I was wondering if anyone could help me/or has come across the following
problem:
It's to do with replication - Scenario:
We have a publisher/subscriber as the same server. Using MERGE replication
with 2 subscribers. The publisher database is our co-operate database with
many recor
On Mon, Apr 30, 2001 at 02:24:53PM +1200, Desmond Armstrong wrote:
> Hi everyone,
>
> I was wondering if anyone could help me/or has come across the following
> problem:
It appears to have nothing to do with MySQL, so you might try asking
in a more on-topic forum.
Jeremy
--
Jeremy D. Zawodny,
hello there,
I am currently using MS Access to develop reports and I am looking for a new avenue
to develop these reports. I have been looking into MySql and so far I am very
interested. my question is what are the limitation of MySql in comparison to MS
Access and how does one develop repo
MySQL does not have a built in report generator. I use the commercial
product Crystal Reports as my report generator. It is quite powerful,
buggy in early versions, but they seem to be getting better. Try here
http://www.crystaldecisions.com/products/crystalreports/
Regards,
Gary "SuperID" H
Did you install mysql as a service? If you did, the MySQL Monitor should
come up when you open a Command prompt and type: mysql {enter}
- Original Message -
From: "Rhasaun Campbell" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 8:47 PM
Subject: Newb
Hi,
I am trying to install MySQL 3.23.37 from the RPM distribution.. At the point where
the rpm installs the default tables it hangs:
[root@teaparty src]# rpm -i MySQL-3.23.37-1.i386.rpm
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv tab
Dear Sir,
I tried MySQL installation in RedHat 7.0 and get finally version
mysql-3.23.37.When I was installing
with 1st step run "./configure --prefix=/usr/local/mysql --with-charset=big5"
and got flowing message and can not continue .
error message
"checking for termcap functions library
I am running RedHat linux 7.1 and MySQL 3.23.37. I am trying to use
mysqlimport and am getting an error message "mysqlimport: Error: Can't get
STAT of /path/to/file/file (Errorcode: 13) , when using table: table_name".
I looked the error up in the on-line documentation and changed the UMASK and
On Mon, Apr 30, 2001 at 12:53:39PM +0800, §õZµØ wrote:
> Dear Sir,
>
> I tried MySQL installation in RedHat 7.0 and get finally version
> mysql-3.23.37.When I was installing with 1st step run "./configure
> --prefix=/usr/local/mysql --with-charset=big5" and got flowing
> message and can not c
Hello,
I just ran into some problems with the mysql setup on win2000. I
start mysql as a service. If you go into your control
panel->administrative tools->services, you can start mysql.
One more thing (if you didn't see it a couple days ago when I posted it):
If you have problems ins
which RPM should installed ?
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "§õZµØ" <[EMAIL PROTECTED]>
Cc: "MySQL°ÝÃD" <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 1:12 PM
Subject: Re: problem of MySQL Installation
> On Mon, Apr 30, 2001 at 12:53:39PM +0800,
On Mon, Apr 30, 2001 at 02:02:53PM +0800, ??? wrote:
> which RPM should installed ?
Not sure. I don't really use them. But I'm sure if you got into
whatever directory they are stored in and run something like:
ls *curses*
ls *termcap*
You'll find them pretty quickly, no?
Jeremy
--
Jeremy
Hi,
I would like to run a du command to find out how many bytes of each
databases is consuming under PHP+ Apache. But, the problem is I am not able
to count the bytes of the databases in MySQL, because the user and group is
set to MySQL. On the other hand, My Web server is running on user
If you're using gnorpm, you'll find ncurses will come under a library. It's
to do with C anyway, so you should be able to find it there somewhere.
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "???" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, April 30,
I am sending this again since the first time I sent it I wasn't entirely
signed in to the list.
> I am running RedHat linux 7.1 and MySQL 3.23.37. I am trying to use
> mysqlimport and am getting an error message "mysqlimport: Error: Can't get
> STAT of /path/to/file/file (Errorcode: 13) , when
Hi,
For show table status command in MySQL, which field is indicate the
table size? Or, Which command is to find out the database size.
Thanks in advance
mark
-
Before posting, please check:
http://www.mysql.com/man
I know Sasha has been involved with the email police for awhile. I gotta
tell ya, my opinion is negative. Sure, I understand the dynamics.
Unwanted emails are intrusive. They waste bandwidth. They squander
resources. Those type arguments, however, do not justify the intrusion
the security squad
Hi,
I have already posted this message but I got no reply I am really stuck
on this topic - if anybody knows anything help would be greatly
appreciated.
I have only just joined this list today any help would be greatly
appreciated.
I have implemented the new MERGE table feature as part of my new
71 matches
Mail list logo
