Hello,
I'm trying to learn mysql PHP. I recently set up the mysql server (with
the file: mysql-3.23.32-pc-linux-gnu-i686.tar.gz)
My problem is this: I either forgot the password, or neglected to set up any
user accounts.
The documentation says to do this:
./bin/mysqladmin -u root -p
In the manual
First off, have you tried the following ...
6.15 Causes of Access denied Errors
If you encounter Access denied errors when you try to connect to the MySQL
server, the list below indicates some courses of action you can take to
correct the problem:
After installing
Artem Koutchine writes:
Could you point me in the direction where i coudl find that
"Ken Manzel's info on FreeBSD 4.* patches."
I am having the same problem with 3.23.32 on 4.2-stable (dies
sporadically with sig 11).
Regards,
Artem
You can look at the archives of
I really miss a function to retrieve the free disk space on a MySQL server.
Previously this was not a problem since a ran PHP and MySQL on the same server, but
for performance reasons i split them.
However, there seems no function to get the free disk space automatically via MySQL,
so a
Hi!
Sorry for delay :-(
On Jan 24, Tibor Simko wrote:
Hello
I wrote:
After upgrading to 3.23.31, FULLTEXT selects give often "error -1
from table handler" for me. [...]
Sergei Golubchik [EMAIL PROTECTED] wrote:
Thanks for a bug report! This would be fixed in a nex release.
[EMAIL PROTECTED] writes:
I am a customer to a web designer that I have since cut relations with.He
left me high and dry and I am left to my own devices to ftp my web site to
another hosting co. Is there a driver exclusively for ftp work that you can
sell me; with step by step
Hi!
On Jan 26, Steven Roussey wrote:
Hi,
There was a bug in 3.23.31 (I think) with fultext indexes. Was this fixed in
3.23.32?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
Probably, yes.
I do remember some bugfixing between 3.23.31 and 3.23.32
and there were
Hi!
I am having this weird problem that MySQL just dies with
signal 11 several time per day when loads get just a bit
hight (the load is very low, about 1 q/s and on some
export ops it gets a bit high two time per 24 hours).
Any way, FreeBSD 4.2 is not RELASE but STABLE
which is cvsupped pretty
Ok I need help with this..
I have to values like
$dat1="2001-01-11";
$dat2="2001-02-12";
so and i have Mysql table with
IP | Size | Date|
--
213.32.44.11 | 3|2001-01-11-12|
--
213.32.44.11 |
Description:
if a column is defined as float(3,1) and your sql query
uses where in that particular column and the value has
decimals on it then you got empty set.
How-To-Repeat:
($:~) mysql stuff
Reading table information for completion of table and column names
You can
Don't you think this has nothing specific to MySQL? Maybe you
should read some books on SQL and the manual for MySQL?
SELECT * FROM
tablename
WHERE
datefield'2001-01-11' AND
datefied'2001-02-12'
Don;t ask how to correctly call the query in perl, read
perldoc DBI
perldoc DBD::mysql
I really miss a function to retrieve the free disk space on a MySQL server.
Previously this was not a problem since a ran PHP and MySQL on the same server, but
for performance reasons i split them.
However, there seems no function to get the free disk space automatically via MySQL,
so a
Thanks for your help, but i needed a
litle more help, I tried to do that and
it almost worked bu i still got this
error
gcc -O2 -g -o mysql1
mysql.c -L/usr/local/mysql/lib -lmysqlcl
ient -lnsl -lgthreads -lz -lcrypt -lsock
et -lm
Undefined first
referenced
symbol
I think that is the wrong answer ... Standard-SQL and ANSI-SQL require that
a column that is displayed
and has no grouping function applied to it MUST also appear in the GROUP
BY-clause!!!
Sir, every dialect of SQL has it's non-ANSI quirks. I've never heard
of Standard-SQL, but ANSI-SQL is
Hi-
I think you are getting tripped up by the same thing as I was when I
tried to install MySQL. When you are prompted "Enter password:", you do
NOT type the new password. You simply hit enter.
--Quentin
Subject:
Locked out of mySQL.
From:
"AJ Hawks" [EMAIL PROTECTED]
Date:
Sat, 27
Hello,
I'm trying to figure out the correct syntax for requesting
the database to
remove all records older than 14 days. The mysql query that
I am using (from within
php4) is:
//---update news so only last two weeks of news are
available---//
$sql2 = "delete from news where newsdate
I'm resending the e-mail again so it may be clearest...
First of all, before I forget it...
My MySQL is:
mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
I have a problem with mysql_fetch_row...
When I use it the system goes to 100% CPU usage and nothing else, I get
not rows...
The
Slight correction, for some reason the query below does NOT work on my
sample DB unless I quote the date values.
This should work now:
SELECT IP, Size, Date FROM your_table
WHERE Date BETWEEN '2001-02-01' AND '2001-05-01';
so and i have Mysql table with
IP | Size |
Can someone tell me how i can get(or
can someone send me) the strip command
for SCO Open Server 5.0.5?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Description:
I am connecting from Visual Basic 6 to Mysql via
ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
server. It says : [TCX][MYODBC]Can't
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Description:
I am connecting from Visual Basic 6 to Mysql via
ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
server. It says : [TCX][MYODBC]Can't
I have two mysql server with same tables
how can i synch. this tables
i'm mean if one table is updated second table is updated too !?
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Thanks for the help Kent and the rest of the list,
Would be grateful for some help interpreting some mysql system
variables. Just to recap on what I am trying to achieve, I want
to load as much of a very large key file (224704512
mykeyfile.MYI) into RAM to improve selects.
I did a "show
RTFM on Replication or do develop own methods!
SEARCH THE LIST (start from www.mysql.com Documention/Mail lists)
- Original Message -
From: "Alexei Sh." [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 27, 2001 8:20 PM
Subject: (+)Help
I have two mysql server with same
Greetings-
I have been experiencing an unusual issue with replication in 3.23.32. We
are using a dual-master setup on two FreeBSD4.2-STABLE machines. I am able
to initially set up the replication, and issue simple updates from one or
the other machine, but in certain circumstances we receive
Have you tried adding an index on id?
-Original Message-
From: taree [mailto:taree]On Behalf Of Manuel Capinha
Sent: January 27, 2001 12:10 PM
To: [EMAIL PROTECTED]
Subject: 3 million+ records problems.
Hi!
I've got a table with 3 million+ records. This table has only to
Yes, that was the first thing i tried. The id column is indexed.
Scott Gerhardt wrote:
Have you tried adding an index on id?
-Original Message-
From: taree [mailto:taree]On Behalf Of Manuel Capinha
Sent: January 27, 2001 12:10 PM
To: [EMAIL PROTECTED]
Subject: 3 million+
From a mysqldump:
#
# Table structure for table 'names'
#
CREATE TABLE names (
id int(10) unsigned DEFAULT '0' NOT NULL,
name varchar(80) DEFAULT '' NOT NULL,
KEY id (id)
);
The machine is an Intel Celeron 533Mhz, with 64 mb of RAM, with dual 10
GB EIDE hard drives (doing RAID), running
-Original Message-
From: Nazeem Y [mailto:[EMAIL PROTECTED]]
Sent: 27 January 2001 19:19
To: [EMAIL PROTECTED]
Subject: RAW Device support
Does MySQl syupport RAW devices ?
Thanks
You mean devices that can Read And Write?
Sure.
If you perhaps mean that it can address
That would be more like DB2 or Oracle which would be more than happy to
setup their own table space on a raw drive. They build their own file
system and tables on the drive. Its very efficient and why a lot of large
databases reside on DB2 or Oracle.
Curtis
On Sat, 27 Jan 2001, Sander Pilon
Adding another 192megs of ram or so would really boost performance.
When I increased the RAM on my PIII 450Mhz from 128 to 256Mb, performance
almost doubled for most queries on a 72k record table.
From a mysqldump:
#
# Table structure for table 'names'
#
CREATE TABLE names (
Interesting, how will MySQL benefit from using
-async
-noatime
options for filesystem it is keeping its data on
or from using SoftUpdates (for FreeBSD
in particular).
Anybody experimented?
Artem
- Original Message -
From: "Dan Nelson" [EMAIL PROTECTED]
To: "Nazeem Y" [EMAIL PROTECTED]
Hi,
It may sound strange, but the fact is that I'm needing to share data between
one M$SQL7 and the MySQL. It's one business envoirnment that is migrating
from one to the other, and in the meantime (until the new system does have
all the features developed) I may still need to query the data in
I just built from a src.rpm and installed 3.23.32 on an RedHat 7.0 box.
It installs with no errors and runs, but using the command line utility
"mysql" it does not show any of the databases (test, mysql, etc). The
databases are in the /var/lib/mysql directory, and I can create new
databases, they
Hi,
I failed to install mysql-3.23.30-gamma on bsdi4.2.
this is the err mesg I got:
Making all in myisam
make: don't know how to make mi_test_all. Stop
*** Error code 1
Pls help
Thanks.
-
Before posting, please check:
Sir, your DELETE statement runs fine on my computer. The problem
appears to be in your PHP code. Post the problem to a PHP group with
all the relevant lines, not just the two shown below.
Hello,
I'm trying to figure out the correct syntax for requesting
the database to
remove all records
On Sat, Jan 27, 2001 at 09:58:23AM -0600, Thomas Katsampes wrote:
Hello,
I'm trying to figure out the correct syntax for requesting
the database to
remove all records older than 14 days. The mysql query that
I am using (from within
php4) is:
//---update news so only last two weeks of
we are just getting started using mysql and want to develop an admin
password access section for our site using cold fusion mysql.
Is thier a site with examples of this type of thing ?
Thanks,
Byron
-
Before posting, please
In the last episode (Jan 27), Artem Koutchine said:
Interesting, how will MySQL benefit from using
-async
-noatime
options for filesystem it is keeping its data on or from using
SoftUpdates (for FreeBSD in particular).
Not much. Since you're constantly accessing the same small amount of
NuSphere offers a MySQL, PHP, Perl, Apache distribution that includes the
manual (and 3 O'Reilly books) in a printed format. For $79 you can't go
wrong
- Original Message -
From: "Pak Tse" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2001 8:10 PM
Subject: MySQL
Hello,
I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
module) on an Apache 1.3.12 (Linux).
Some SQL syntaxes that worked before don't anymore.
E.g.:
$query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
doesn't work:
Warning: Supplied argument is not a
* J.M. Roth [EMAIL PROTECTED] wrote on 28.01.01 02:05:
I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
module) on an Apache 1.3.12 (Linux).
...
$query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
doesn't work:
From your query I think you upgraded from a
"J.M. Roth" wrote:
Hello,
I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
module) on an Apache 1.3.12 (Linux).
Some SQL syntaxes that worked before don't anymore.
E.g.:
$query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
doesn't work:
Why gamma??? Go to www.mysql.com and download a stable version of
mysql-3.23.31. It's official now!
On Saturday 27 January 2001 16:11, CheongMeng wrote:
= Hi,
= I failed to install mysql-3.23.30-gamma on bsdi4.2.
= this is the err mesg I got:
= Making all in myisam
= make: don't know how to
I'm using version 3.23.25, and am having trouble setting up a temporary
table. I have the following permanent table already set up:
bill_pay
(pbid int (8) default '0' not null auto_increment,
billdesc varchar(20),
bpamount int(8),
pbdate date,
budgetid int(8),
primary key (pbid), unique id
Tor-Erik,
If 'I' was a language syntax interpreter, i'd see
"where not field like pattern" as
where (not(field) like pattern
and
"where field not like pattern" as
where (field !like pattern)
notice that not(field) probably returns 'False' so your first query is:
where False like pattern
How about
CREATE TEMPORARY TABLE tempbills SELECT billdesc, bpamount FROM bill_pay
Thanks,
James
NEBIS Tech.
http://www.nebis.com
-Original Message-
From: Matt Bailey [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 27, 2001 4:49 PM
To: [EMAIL PROTECTED]
Subject: Temporary tables
Hi again Bob,
I know it's not 'proper' database design and I should have
normalized the one-to-many relationships to multiple tables.
However, it was fast and gave me a result which worked quickly
(and up against a mad deadline).
I think you've just identified the most common use of the SET
DescripWell, for some reason after a table is being automatically repaired
by mysql , some thread will be a suspended state. Mysqladmin will report
a "waiting for table" in the state column of those threads. A look at
the .err file showed me a "Warning: Checking table:" message.
I waited a while
I recently upgraded to linux 7.0 which comes with mysql. Everytime that i try and
start the mysql server it starts up then stops. when I try the mysql -user command it
gives me a cant connect to mysql.sock error. any idea what is going wrong?
Anthony Ortega
(512)444-6238
6700 B. Deatonhill
I recently upgraded to linux 7.0 which comes with mysql. Everytime that i try and
start the mysql server it starts up then stops. when I try the mysql -user command it
gives me a cant connect to mysql.sock error. any idea what is going wrong?
Anthony Ortega
(512)444-6238
6700 B. Deatonhill
NuSphere announced Gemini a few months ago and there is a press release on
our website if you want to see the official details at:
http://www.nusphere.com/releases/103000.htm
Gemini is a project that NuSphere is doing to add a new table type to MySQL
that will provide ACID transactions,
NuSphere is cheaper, comes with a printed MySQL manual, and IMHO, installs
easier.
- Original Message -
From: "Frank J. Schmuck" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 24, 2001 6:45 AM
Subject: ArabiaSoft and NuSphere
Any comments on the packages from
Description:
When creating an index with multiple text fields, `where' clause
isn't handled correctly. If no index is present, "a = 'foo' and
b = 'bar'" does work well. However, if an index is present,
"a = 'foo'" and "a = 'foo' and b != 'bar'" work correctly, but
54 matches
Mail list logo
