Re: Set no root password

2003-06-14 Thread Nils Valentin
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

Re: Big Mistake Need Help, can I undo an action I did?

2003-06-14 Thread Fred van Engen
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

Re: Set no root password

2003-06-14 Thread Becoming Digital
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

.myd file weirdness

2003-06-14 Thread Sebastian Bergmann
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?

Re: underscore character?

2003-06-14 Thread Becoming Digital
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

import weirdness

2003-06-14 Thread Ben Miller
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

Setting root password

2003-06-14 Thread John Utting
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

Re: import weirdness

2003-06-14 Thread Becoming Digital
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

Re: Setting root password

2003-06-14 Thread Becoming Digital
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

Re: Setting root password

2003-06-14 Thread John Nichel
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

Re: mysql and clustering

2003-06-14 Thread Roberto Barbieri
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:

Compiling MySQL 5 Tree

2003-06-14 Thread Primaria Falticeni
I need a correct configure.in file. That file from site cannot be compiled in cygwin. Please help me. Iulian

Re: Rename/Create Database from Existing Database

2003-06-14 Thread Victoria Reznichenko
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

Re: underscore character?

2003-06-14 Thread Chris Webster
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.

Impossible query??

2003-06-14 Thread trashMan
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

installation problem from tarball

2003-06-14 Thread Gaurav Kumar
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]:

Re: Set no root password

2003-06-14 Thread Paul DuBois
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

newbie q: creating a user

2003-06-14 Thread David Shochat
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.*

Re: installation problem from tarball

2003-06-14 Thread Paul DuBois
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

Re: newbie q: creating a user

2003-06-14 Thread Paul DuBois
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

Re: newbie q: creating a user

2003-06-14 Thread David Shochat
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!

Re: installation problem from tarball

2003-06-14 Thread Gaurav Kumar
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 * *

Re: Set no root password

2003-06-14 Thread Michael T. Babcock
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?

Re: Set no root password

2003-06-14 Thread John Chang
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

Can't delete on cascade

2003-06-14 Thread Miguel Perez
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',

Re: Can't delete on cascade

2003-06-14 Thread Heikki Tuuri
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

Re: Impossible query??

2003-06-14 Thread Becoming Digital
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 |

selecting DISTINCT and COUNT in MySQL

2003-06-14 Thread Tim Thorburn
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.

RE: selecting DISTINCT and COUNT in MySQL

2003-06-14 Thread Peter Lovatt
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

howto store files in mysql

2003-06-14 Thread Joe Baptista
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

Re: Machine requirements

2003-06-14 Thread Curtis Maurand
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

Re: PHP, MySQL and Apache

2003-06-14 Thread Curtis Maurand
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

Re: PHP, MySQL and Apache

2003-06-14 Thread Curtis Maurand
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

Re: soft real-time database

2003-06-14 Thread Curtis Maurand
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

Re: howto store files in mysql

2003-06-14 Thread Becoming Digital
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

HELP!!! permissions not working!

2003-06-14 Thread Timothy Waters
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 *

RE: PHP, MYSQL and persistant authentication

2003-06-14 Thread Daevid Vincent
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

Just a test

2003-06-14 Thread Scott Haneda
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]

Question about INSERT vs UPDATE

2003-06-14 Thread Shane Bryldt
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