Hi John,
You saved my day. Haven't laughed like this for long time ;-)
How do I set no password for root?
It worked!!. Thanks. Now how do I protect it so that not anyone who
points to it cannot get to it without putting in a username/password?
Thanks a lot really.
Best regards
Nils
Hi,
On Fri, Jun 13, 2003 at 02:08:33PM -0700, jack ma wrote:
I had updated a field for all the entries in a table
by mistake, I need to undo that step. I dont have the
database back up to an stisfactory level. Is there a
way in MySQL I can step one action back? or undo one
command that I
You saved my day. Haven't laughed like this for long time ;-)
Seriously. I wish I was drinking more earlier so as to fully appreciate this
one.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: John Chang [EMAIL
Recently I received a number of reports from users of my phpOpenTracker
software about the following MySQL error
Error: Can't open file: 'pot_visitors.MYD'. (errno: 145)
The error goes away after repairing the table in question.
Any idea how phpOpenTracker might trigger this?
The error is in FLOAT(1). Think about that for a moment. What's a float with
one-digit precision? It's an integer. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Chris Webster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003
Hello,
This is my first post to the list. I'm trying to import a text file
into a new database table. Items corresponding to the different fields
in the table are separated by commas. However, every time I try to
import the file, all entries are added to the first column in the
table. What am
Hi,
I have installed MySQL v4.0.13 on a Win2K machine. the installation
directory is C:\mysql
I've installed it as a service using 'mysqld-nt -install' and the service is
running.
I've checked to se that it is working using 'mysqlshow', 'mysqlshow mysql'
'mysqladmin version status proc'. All
Take a look at this section of the manual.
http://www.mysql.com/doc/en/LOAD_DATA.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Ben Miller [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 14 June, 2003 07:20
Subject: import weirdness
Try setting the user as [EMAIL PROTECTED]
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: John Utting [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 14 June, 2003 07:57
Subject: Setting root password
Hi,
I have installed MySQL v4.0.13 on a
John Utting wrote:
Hi,
I have installed MySQL v4.0.13 on a Win2K machine. the installation
directory is C:\mysql
I've installed it as a service using 'mysqld-nt -install' and the service is
running.
I've checked to se that it is working using 'mysqlshow', 'mysqlshow mysql'
'mysqladmin version
Yes but it can be done?
If i'm not wrong actually db replication is only supported
between secondary db or not?
There are documents which explains how to build a two
master replicated server?
Thanks so much!
Roberto
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To:
I need a correct configure.in file. That file from site cannot be compiled in cygwin.
Please help me.
Iulian
Wong Zach-CHZ013 [EMAIL PROTECTED] wrote:
1- Is there a command to rename an existing database ?
Nope.
2- If not, how does one create a new database from an existing database ?
could you show me the steps?
If your database doesn't have InnoDB table you can take down MySQL server, rename
Becoming Digital wrote:
The error is in FLOAT(1). Think about that for a moment. What's a float with
one-digit precision? It's an integer. :)
While I agree with your analysis the error was a missing comma. The
float(1), which I originally thought was array size of 1, appeared to
work fine.
Hi, sorry for my bad english.
I've a table where i store the result of a quality test.
If the test is passed then the result=ok and connect=0
If test fail then result=nok and, if it's the first test for the
product, connect=0
When i retest a failed product i've connect= previous testid of the
hello mysql users.
i have lately joined the wonderful world of mysql.
i downloaded tarball mysqla-3.23.54a.
./configure is not giving me any problem.
however on executing make to compile the source file i
am getting error
_
make[2]:
At 1:53 -0400 6/14/03, John Chang wrote:
It worked!!. Thanks. Now how do I protect it so that not anyone
who points to it cannot get to it without putting in a
username/password?
You seem to have an odd set of goals.
First, you want to remove the password from your MySQL root account.
That
This must be a very elementary question. I am a brand new user. I was able to set the root password and can connect as root with no problem. I created a database named remembrance. Where I got stuck was when I tried creating a user. I tried to do it this way (as root):
grant all on remembrance.*
What kind of system is this?
If you put this line near the top of client/mysql.cc (say, after the
line that includes signal.h), does the compile proceed?
#include errno.h
(I'm assuming that you have an errno.h somewhere on your system.)
At 8:43 -0700 6/14/03, Gaurav Kumar wrote:
hello mysql
At 11:51 -0400 6/14/03, David Shochat wrote:
This must be a very elementary question. I am a brand new user. I
was able to set the root password and can connect as root with no
problem. I created a database named remembrance. Where I got stuck
was when I tried creating a user. I tried to do it
Paul DuBois wrote:
This indicates that in the GRANT statement, you typed '[EMAIL PROTECTED]'
rather than 'david'@'localhost' (the username and hostname should be
quoted separately). Try it again with them quoted separately and the
problem should go away.
Worked like a charm. Thank you very much!
i am using red hat linux 9 on x86
i have copied that the errno.h file from /usr/include
and put #include errno.h at the top of the file
here it is what it looke like..
__
/* mysql command tool
* Commands compatible with mSQL by David J. Hughes
*
*
I think I have figured out what he wants:
He wants to set a root password (randomly) and then save it in
~root/.my.cnf so that the root user doesn't (apparently) need a password
to log into MySQL.
However, any other user trying to log in as root would need to know the
password.
Am I close?
Simply I didn't know where the password was located in myphpadmin. I
wanted it secure but I wanted to be able to get to the data with myphpadmin
too. But now I know where it is I put the password in. And now I want to
protect phpmyadmin so that only folks with a username/password can access
Hi every one does anyone know if there are bugs on the statement ON DELETE
CASCADE, cause I have 2 tables as follows:
Reparacion |CREATE TABLE `Reparacion` (
`folio` bigint(19) NOT NULL default '0',
`idTipo` int(4) NOT NULL default '0',
`idAlmacen` int(4) NOT NULL default '0',
Miguel,
if you are running MySQL-4.0.13, please use
SHOW INNODB STATUS
to look at a detailed error message of the latest foreign key error.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support
Your query seems relatively easy if you don't need the first test (in this case,
testID 2) explicitly printed.
mysql SELECT * FROM tests WHERE testID=7 AND connect0;
+-+--+--+
| testId | connect | result |
Hi,
I'm setting up a small tracking program for a site I'm working on -
basically it monitors all external web and email links that are clicked
from our site and stores them into a MySQL database.
Now I'm trying to extract the information from the database and display it
on screen with PHP.
Hi
SELECT
COUNT(DISTINCT trEmail ) as clicks
, trEmail FROM table
GROUP BY trEmail
ORDER BY clicks DESC
will probably give what you are looking for
Peter
-Original Message-
From: Tim Thorburn [mailto:[EMAIL PROTECTED]
Sent: 15 June 2003 00:14
To: [EMAIL
I need to store a file as mysql record. I assume I use the text variable
but have no idea how to read the file into the mysql record.
Please note I am not reading a file to a table - so not the LOAD DATA
INFILE function but a means of storeing the contents of a file as a
record. anyone know
methinks you have other troubles. i've been running MySQL on K6II-266 for
a long time and its been running fine serving up several databases with
multiple users. 512MB of RAM currently but it had only 128 until
recently. Its running Linux (RedHat 7.2). I recently switched to 4.03,
but it had
You need to recompile PHP against the 4.0.nn headers.
Curtis
Subscriptions said:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since
to me. Can someone point me in a direction as to where I can find this
actually, its worse. upon re-reading you need to compile in the mysql
drivers for mysql.
configure --with-mysql=path to mysql include files
Curtis
Subscriptions said:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything
If you have the sgi_fam, you could place a file in a directoy everytime
you add a row. the sgi_fam module would inform your app that there was a
change on the filesystem. When the notification is made, your app can
then get the new value from the database.
I believe that one user suggested
If you mean a file as in an image or other binary data, you need to use a BLOB
field.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Joe Baptista [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 14 June, 2003 19:57
Subject: howto store files in
I've been messing around making very simple web pages using PHP and connecting
to a MySQL database. I've tried using different users to connect and
different grants, but so far the ONLY user that can connect through these
pages is root, and we all know that isn't cool. I've done grant all on *
Use sessions in PHP (super simple, just call session_start() at the top
of every page i.e. like in an include file) and use
$_SESSION['loginname']
I would strongly recommend using mod_auth_mysql for your authentication.
It's easy and probably more secure than anything you can write ;-) Plus
it
I donĀ¹t seem to be getting any messages, this is just a test, mysql query
--
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com Fax: 313.557.5052
[EMAIL PROTECTED]
Hello,
I am new to the list, so pardon me if I am on the wrong one posting my question.
If so, please direct me to the right place.
My question is in regards to the efficiency of INSERT statements. I have gone over
some of the optimizations, and on a machine running the client and
39 matches
Mail list logo