Re: Set no root password
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 Valentin Tokyo/Japan 2003 6 14 14:53John Chang : 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? At 12:24 AM 6/14/2003 -0500, John Nichel wrote: John Chang wrote: I changes the password but it still doesn't work. This is the error I get when I try to connect to MySQL using phpmyadmin using a browser. What do I need to change? Thanks. Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) At 11:37 PM 6/13/2003 -0500, Paul DuBois wrote: At 0:10 -0400 6/14/03, John Chang wrote: How do I set no password for root? mysql -u root -p Enter password: (your current root password here) mysql SET PASSWORD = ''; mysql quit -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ If you changed it to have no root password, you need to edit the config.inc.php file in your phpmyadmin directory. Get rid of the password there. With that being said, why would you want an empty root password -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Big Mistake Need Help, can I undo an action I did?
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 just did?? Sorry, you'll need a backup. If your backup is not recent enough and you have a binary log (e.g. for replication), you can use that log to restore the database state. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
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 PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, 14 June, 2003 02:12 Subject: Re: Set no root password 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 Valentin Tokyo/Japan 2003 6 14 14:53John Chang : 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? At 12:24 AM 6/14/2003 -0500, John Nichel wrote: John Chang wrote: I changes the password but it still doesn't work. This is the error I get when I try to connect to MySQL using phpmyadmin using a browser. What do I need to change? Thanks. Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) At 11:37 PM 6/13/2003 -0500, Paul DuBois wrote: At 0:10 -0400 6/14/03, John Chang wrote: How do I set no password for root? mysql -u root -p Enter password: (your current root password here) mysql SET PASSWORD = ''; mysql quit -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ If you changed it to have no root password, you need to edit the config.inc.php file in your phpmyadmin directory. Get rid of the password there. With that being said, why would you want an empty root password -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.myd file weirdness
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? Thanks, Sebastian -- Sebastian Bergmann http://sebastian-bergmann.de/ http://phpOpenTracker.de/ http://www.professionelle-softwareentwicklung-mit-php5.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: underscore character?
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 21:08 Subject: underscore character? I'm getting an error with create table, appears that field names cannot have the underscore character. Is this correct? It would be quite fatal for us, as we need some sort of delimeter character, so we can group variables by instrument. You have an error in your SQL syntax near 'A2DEE1_RWO FLOAT(1), -- --Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
import weirdness
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 I missing so that the separated values are imported into separate table fields? Thanks for your help, Ben -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Setting root password
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 seems to be fine. I have deleted the anonymous user with the following commands : C:mysql\bin\mysql use mysql delete from user where User=''; quit C:mysql\bin\mysqladmin reload The problem is when I set the root password using the following command: C:mysql\bin\mysqladmin -u root password my_password Although this sets a password for the root user when I enter the following C:mysql\bin\mysqladmin -u root -p reload I am then prompted for a password, but when I enter it I receive the following error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' My PC is connected to a server and gets its IP address via DHCP. Is this part of the problem? Any advice would be greatly appreciated. John. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: import weirdness
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 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 I missing so that the separated values are imported into separate table fields? Thanks for your help, Ben -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting root password
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 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 seems to be fine. I have deleted the anonymous user with the following commands : C:mysql\bin\mysql use mysql delete from user where User=''; quit C:mysql\bin\mysqladmin reload The problem is when I set the root password using the following command: C:mysql\bin\mysqladmin -u root password my_password Although this sets a password for the root user when I enter the following C:mysql\bin\mysqladmin -u root -p reload I am then prompted for a password, but when I enter it I receive the following error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' My PC is connected to a server and gets its IP address via DHCP. Is this part of the problem? Any advice would be greatly appreciated. John. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting root password
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 status proc'. All seems to be fine. I have deleted the anonymous user with the following commands : C:mysql\bin\mysql use mysql delete from user where User=''; quit C:mysql\bin\mysqladmin reload The problem is when I set the root password using the following command: C:mysql\bin\mysqladmin -u root password my_password Although this sets a password for the root user when I enter the following C:mysql\bin\mysqladmin -u root -p reload I am then prompted for a password, but when I enter it I receive the following error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' In the mysql user table, is 127.0.0.1 listed as an allowed host? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql and clustering
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: Roberto Barbieri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 12, 2003 8:38 PM Subject: Re: mysql and clustering On Wed, Jun 11, 2003 at 12:21:17PM +0200, Roberto Barbieri wrote: They're completely different clustering solution. What, exactly, are you trying to acheive? LVS is primarily for load balancing and possibly fail-over. OpenMosix is a different beast entirely. Jeremy Thanks for the reply Jeremy. What i need to build are a mysql master server with two nodes both active at the same time. Perhaps MySQL's replication in a dual-master setup? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 9 days, processed 310,123,483 queries (378/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Compiling MySQL 5 Tree
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
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 database directory and start the server. You can also make dump of the database and then rectore tables to another database. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: underscore character?
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. --Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Impossible query??
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 product failed It's possible to do a query for print the history of one id?? Exemple mysql select * from mytable; +-+--+--+ | testId | connect | result | +-+--+--+ | 1 | 0| ok | | 2 | 0| nok | | 3 | 2| nok | | 4 | 3| nok | | 5 | 0| ok | | 6 | 4| nok | | 7 | 6| ok | | 8 | 0| ok | +-+--+--+ I want the history of testId=7 mysql ?? +-+--+--+ | testId | connect | result | +-+--+--+ | 7 | 6| ok | | 6 | 4| nok | | 4 | 3| nok | | 3 | 2| nok | | 2 | 0| ok | +-+--+--+ Thanks a lot! Max (trashman) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
installation problem from tarball
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]: Entering directory `/gaurav/mysql-3.23.54a/client' source='mysql.cc' object='mysql.o' libtool=no \ depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \ depmode=gcc3 /bin/sh ../depcomp \ g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I ..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c -o m ysql.o `test -f mysql.cc || echo './'`mysql.cc /bin/sh ../libtool --mode=link g++ -O3 -DDBUG_OFF -fno-implicit-templates -fn o-exceptions -fno-rtti -rdynamic -o mysql mysql.o readline.o sql_string.o com pletion_hash.o ../readline/libreadline.a -lncurses ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic - o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/lib readline.a -lncurses ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm - Wl,--rpath -Wl,/usr/local/lib/mysql mysql.o(.text+0x189c): In function `com_source(String*, char*)': : undefined reference to `errno' collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/gaurav/mysql-3.23.54a/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/gaurav/mysql-3.23.54a' make: *** [all] Error 2 [EMAIL PROTECTED] mysql-3.23.54a]# __ plz help __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
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 is, you want to remove the protection against unauthorized access. Next, you want to keep people from getting to it without a password. That is, you want protection against unauthorized access. I fail to understand what you're trying to achieve... At 12:24 AM 6/14/2003 -0500, John Nichel wrote: John Chang wrote: I changes the password but it still doesn't work. This is the error I get when I try to connect to MySQL using phpmyadmin using a browser. What do I need to change? Thanks. Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) At 11:37 PM 6/13/2003 -0500, Paul DuBois wrote: At 0:10 -0400 6/14/03, John Chang wrote: How do I set no password for root? mysql -u root -p Enter password: (your current root password here) mysql SET PASSWORD = ''; mysql quit -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ If you changed it to have no root password, you need to edit the config.inc.php file in your phpmyadmin directory. Get rid of the password there. With that being said, why would you want an empty root password -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
newbie q: creating a user
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.* to david identified by '...'; (I put the password instead of ...). Then I quit and tried: mysql -u david -p It prompted me for a password, but when I typed in the same password I had used in the grant command above, it was rejected. If I do: mysql -u david I get in fine (but oddly it does not prompt me for a password) but it then does not let me 'use remembrance'. I tried doing the grant again, this time using [EMAIL PROTECTED], but that didn't work either. In fact, it put '[EMAIL PROTECTED]' in the User column of the user table (I expected it to put 'david' in the User column and 'localhost' in the Host column). What am I doing wrong? This is 3.23.54a which was included in RedHat Linux 9. -- David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation problem from tarball
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 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]: Entering directory `/gaurav/mysql-3.23.54a/client' source='mysql.cc' object='mysql.o' libtool=no \ depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \ depmode=gcc3 /bin/sh ../depcomp \ g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I ..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c -o m ysql.o `test -f mysql.cc || echo './'`mysql.cc /bin/sh ../libtool --mode=link g++ -O3 -DDBUG_OFF -fno-implicit-templates -fn o-exceptions -fno-rtti -rdynamic -o mysql mysql.o readline.o sql_string.o com pletion_hash.o ../readline/libreadline.a -lncurses ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic - o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/lib readline.a -lncurses ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm - Wl,--rpath -Wl,/usr/local/lib/mysql mysql.o(.text+0x189c): In function `com_source(String*, char*)': : undefined reference to `errno' collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/gaurav/mysql-3.23.54a/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/gaurav/mysql-3.23.54a' make: *** [all] Error 2 [EMAIL PROTECTED] mysql-3.23.54a]# __ plz help __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: newbie q: creating a user
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 this way (as root): grant all on remembrance.* to david identified by '...'; (I put the password instead of ...). Then I quit and tried: mysql -u david -p It prompted me for a password, but when I typed in the same password I had used in the grant command above, it was rejected. If I do: mysql -u david I get in fine (but oddly it does not prompt me for a password) but it then does not let me 'use remembrance'. I tried doing the grant again, this time using [EMAIL PROTECTED], but that didn't work either. In fact, it put '[EMAIL PROTECTED]' in the User column of the user table (I expected it to put 'david' in the User column and 'localhost' in the Host column). 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. It will also go away if you delete the anonymous user accounts: % mysql -p -u root mysql Enter password: (root password here) mysql DELETE FROM user WHERE User = ''; mysql FLUSH PRIVILEGES; What am I doing wrong? This is 3.23.54a which was included in RedHat Linux 9. -- David -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: newbie q: creating a user
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! -- David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation problem from tarball
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 * * Written by: * Michael 'Monty' Widenius * Andi Gutmans [EMAIL PROTECTED] * Zeev Suraski [EMAIL PROTECTED] * Jani Tolonen [EMAIL PROTECTED] * **/ #include errno.h #include client_priv.h #include m_ctype.h #include my_dir.h #ifndef __GNU_LIBRARY__ #define __GNU_LIBRARY__ // Skip warnings in getopt.h #endif #include my_readline.h #include signal.h still i am getting the same error. plz help. --- Paul DuBois [EMAIL PROTECTED] wrote: 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 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]: Entering directory `/gaurav/mysql-3.23.54a/client' source='mysql.cc' object='mysql.o' libtool=no \ depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \ depmode=gcc3 /bin/sh ../depcomp \ g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I ..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c -o m ysql.o `test -f mysql.cc || echo './'`mysql.cc /bin/sh ../libtool --mode=link g++ -O3 -DDBUG_OFF -fno-implicit-templates -fn o-exceptions -fno-rtti -rdynamic -o mysql mysql.o readline.o sql_string.o com pletion_hash.o ../readline/libreadline.a -lncurses ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic - o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/lib readline.a -lncurses ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm - Wl,--rpath -Wl,/usr/local/lib/mysql mysql.o(.text+0x189c): In function `com_source(String*, char*)': : undefined reference to `errno' collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/gaurav/mysql-3.23.54a/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/gaurav/mysql-3.23.54a' make: *** [all] Error 2 [EMAIL PROTECTED] mysql-3.23.54a]# __ plz help __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
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? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
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 it. At 10:43 AM 6/14/2003 -0500, you wrote: 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 is, you want to remove the protection against unauthorized access. Next, you want to keep people from getting to it without a password. That is, you want protection against unauthorized access. I fail to understand what you're trying to achieve... At 12:24 AM 6/14/2003 -0500, John Nichel wrote: John Chang wrote: I changes the password but it still doesn't work. This is the error I get when I try to connect to MySQL using phpmyadmin using a browser. What do I need to change? Thanks. Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) At 11:37 PM 6/13/2003 -0500, Paul DuBois wrote: At 0:10 -0400 6/14/03, John Chang wrote: How do I set no password for root? mysql -u root -p Enter password: (your current root password here) mysql SET PASSWORD = ''; mysql quit -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ If you changed it to have no root password, you need to edit the config.inc.php file in your phpmyadmin directory. Get rid of the password there. With that being said, why would you want an empty root password -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/
Can't delete on cascade
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', `idStatusGeneral` int(2) NOT NULL default '0', `usuario` varchar(16) NOT NULL default '', `idProducto` int(11) NOT NULL default '0', `fechaEntrada` date NOT NULL default '-00-00', `observacion` varchar(255) default NULL, `tecnico` varchar(100) NOT NULL default '', `numSerie` varchar(20) NOT NULL default '', `idCausaCancelacion` int(4) NOT NULL default '0', PRIMARY KEY (`folio`,`idTipo`), KEY `IDX4018` (`idAlmacen`), KEY `IDX3309` (`idTipo`), KEY `IDX3938` (`idStatusGeneral`), KEY `IDX5631` (`usuario`), KEY `IDX5623` (`idProducto`), KEY `IDX1475` (`idCausaCancelacion`), FOREIGN KEY (`idCausaCancelacion`) REFERENCES `refacciones.CausaCancelacion` (`idCausaCancelacion`) ON DELETE CASCADE, FOREIGN KEY (`idTipo`) REFERENCES `refacciones.Tipo` (`idTipo`), FOREIGN KEY (`idAlmacen`) REFERENCES `refacciones.Almacen` (`idAlmacen`), FOREIGN KEY (`idStatusGeneral`) REFERENCES `refacciones.StatusGeneral` (`idStatusGeneral`), FOREIGN KEY (`usuario`) REFERENCES `refacciones.Empleado` (`usuario`), FOREIGN KEY (`idProducto`) REFERENCES `refacciones.Producto` (`idProducto`) ) TYPE=InnoDB COMMENT='Reparacion' RefaccionReparacion | CREATE TABLE `RefaccionReparacion` ( `folio` bigint(19) NOT NULL default '0', `idTipo` int(4) NOT NULL default '0', `idRefaccion` int(11) NOT NULL default '0', `cantidad` int(11) NOT NULL default '0', `cantidadSolicitada` int(11) NOT NULL default '0', PRIMARY KEY (`folio`,`idTipo`,`idRefaccion`), KEY `IDX2530` (`folio`), KEY `IDX3220` (`idTipo`), KEY `IDX4101` (`idRefaccion`), FOREIGN KEY (`folio`) REFERENCES `refacciones.Reparacion` (`folio`) ON DELETE CASCADE, FOREIGN KEY (`idTipo`) REFERENCES `refacciones.Tipo` (`idTipo`) ON DELETE CASCADE, FOREIGN KEY (`idRefaccion`) REFERENCES `refacciones.Refaccion` (`idRefaccion`) ON DELETE CASCADE ) TYPE=InnoDB COMMENT='Reparacion' In the child table, I have the on delete cascade, but it doesn't work comes out the next error: Cannot delete a parent row: a foreign key constraint fails Any ideas. Thnx in advanced. Greetings _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't delete on cascade
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 from https://order.mysql.com/ - Original Message - From: Miguel Perez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, June 15, 2003 12:27 AM Subject: Can't delete on cascade 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', `idStatusGeneral` int(2) NOT NULL default '0', `usuario` varchar(16) NOT NULL default '', `idProducto` int(11) NOT NULL default '0', `fechaEntrada` date NOT NULL default '-00-00', `observacion` varchar(255) default NULL, `tecnico` varchar(100) NOT NULL default '', `numSerie` varchar(20) NOT NULL default '', `idCausaCancelacion` int(4) NOT NULL default '0', PRIMARY KEY (`folio`,`idTipo`), KEY `IDX4018` (`idAlmacen`), KEY `IDX3309` (`idTipo`), KEY `IDX3938` (`idStatusGeneral`), KEY `IDX5631` (`usuario`), KEY `IDX5623` (`idProducto`), KEY `IDX1475` (`idCausaCancelacion`), FOREIGN KEY (`idCausaCancelacion`) REFERENCES `refacciones.CausaCancelacion` (`idCausaCancelacion`) ON DELETE CASCADE, FOREIGN KEY (`idTipo`) REFERENCES `refacciones.Tipo` (`idTipo`), FOREIGN KEY (`idAlmacen`) REFERENCES `refacciones.Almacen` (`idAlmacen`), FOREIGN KEY (`idStatusGeneral`) REFERENCES `refacciones.StatusGeneral` (`idStatusGeneral`), FOREIGN KEY (`usuario`) REFERENCES `refacciones.Empleado` (`usuario`), FOREIGN KEY (`idProducto`) REFERENCES `refacciones.Producto` (`idProducto`) ) TYPE=InnoDB COMMENT='Reparacion' RefaccionReparacion | CREATE TABLE `RefaccionReparacion` ( `folio` bigint(19) NOT NULL default '0', `idTipo` int(4) NOT NULL default '0', `idRefaccion` int(11) NOT NULL default '0', `cantidad` int(11) NOT NULL default '0', `cantidadSolicitada` int(11) NOT NULL default '0', PRIMARY KEY (`folio`,`idTipo`,`idRefaccion`), KEY `IDX2530` (`folio`), KEY `IDX3220` (`idTipo`), KEY `IDX4101` (`idRefaccion`), FOREIGN KEY (`folio`) REFERENCES `refacciones.Reparacion` (`folio`) ON DELETE CASCADE, FOREIGN KEY (`idTipo`) REFERENCES `refacciones.Tipo` (`idTipo`) ON DELETE CASCADE, FOREIGN KEY (`idRefaccion`) REFERENCES `refacciones.Refaccion` (`idRefaccion`) ON DELETE CASCADE ) TYPE=InnoDB COMMENT='Reparacion' In the child table, I have the on delete cascade, but it doesn't work comes out the next error: Cannot delete a parent row: a foreign key constraint fails Any ideas. Thnx in advanced. Greetings _ Charla con tus amigos en lnea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Impossible query??
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 | +-+--+--+ | 7 | 6| ok | | 6 | 4| nok | | 4 | 3| nok | | 3 | 2| nok | +-+--+--+ The history of testID 2 is implied by your table structure, such that you know testID 2 passed because it is the last connect value. The problem I see with this occurs when you have a repeating data set. A query for your next failure (after testID 7) will also return testID 7 and its history, as would be the case with the below data. Repairing this would require adding an additional parameter to the WHERE statement, probably using BETWEEN. +-+--+--+ | testId | connect | result | +-+--+--+ | 1 | 0| ok | | 2 | 0| nok | | 3 | 2| nok | | 4 | 3| nok | | 5 | 0| ok | | 6 | 4| nok | | 7 | 6| ok | | 8 | 0| ok | | 9 | 0| nok | | 10 | 9| nok | | 11 | 10 | ok | +-+--+--+ Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: trashMan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 14 June, 2003 11:28 Subject: Impossible query?? 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 product failed It's possible to do a query for print the history of one id?? Exemple mysql select * from mytable; +-+--+--+ | testId | connect | result | +-+--+--+ | 1 | 0| ok | | 2 | 0| nok | | 3 | 2| nok | | 4 | 3| nok | | 5 | 0| ok | | 6 | 4| nok | | 7 | 6| ok | | 8 | 0| ok | +-+--+--+ I want the history of testId=7 mysql ?? +-+--+--+ | testId | connect | result | +-+--+--+ | 7 | 6| ok | | 6 | 4| nok | | 4 | 3| nok | | 3 | 2| nok | | 2 | 0| ok | +-+--+--+ Thanks a lot! Max (trashman) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
selecting DISTINCT and COUNT in MySQL
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. I've made a query which reads: SELECT DISTINCT trEmail FROM db-name; This clearly selects all the distinct email addresses from my table, but I would like to put a count beside each of the distinct addresses to show how many times each link was clicked. For example, I'd like it to look something like the following: email address # sent [EMAIL PROTECTED] 12 Meaning that the email addresses '[EMAIL PROTECTED]' was clicked a total of 12 times. I'm thinking there should be a way to do this with a single SQL query ... although after most of the day of trying and searching google - I've come up with nothing but a headache. Any thoughts? Thanks -Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: selecting DISTINCT and COUNT in MySQL
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 PROTECTED] Subject: selecting DISTINCT and COUNT in MySQL 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. I've made a query which reads: SELECT DISTINCT trEmail FROM db-name; This clearly selects all the distinct email addresses from my table, but I would like to put a count beside each of the distinct addresses to show how many times each link was clicked. For example, I'd like it to look something like the following: email address # sent [EMAIL PROTECTED] 12 Meaning that the email addresses '[EMAIL PROTECTED]' was clicked a total of 12 times. I'm thinking there should be a way to do this with a single SQL query ... although after most of the day of trying and searching google - I've come up with nothing but a headache. Any thoughts? Thanks -Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
howto store files in mysql
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 how to do that or the url of the manuel which explains it. thanks joe baptista Joe Baptista - only at www.baptista.god The Americans, they always depend on a method what I call ... stupid, silly. All I ask is check yourself. Do not in fact repeat their lies. ... Muhammed Saeed al-Sahaf former Iraqi Information Minister -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Machine requirements
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 been running 3.23.nn for quite some time with no difficulties. I recently upgraded the machine to a K6II-500. I also have another machine running a Duron 1GHz along with DNS and Sendmail its also working quite nicely. Curtis blackrat said: I've just started using mySql. I'm an experience programmer with SQL based database, but know nothing about mySql. I'm setting up a single user database to be accessed with some Perl programs, with one main table, which will contain about 3 million lines. I'm running on an Athlon 1250 with 384meg ram, and finding the response time too slow. Just getting a count of the number of records by typing in an SQL query [not using Perl] takes over a minute, also when access is going on, I can't do anything else on them machine like access the web, it becomes too slow to be usable. Am I better setting up the database on another computer and accessing it through TCP/IP. I have available a spare machine which is a Celeron 450. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP, MySQL and Apache
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 out? The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and Apache 2.0.46. I have a page that is trying to connect to MySQL via PHP. The error is: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/ww3.polkmechanical.com/test/mysql_test.php on line 8 The code on line 8 is: $link = mysql_connect( localhost, user, password ) or die(mysql_error()); I can log on through mysql at a telnet prompt with the database, user and password. Ty... . When governments fear the people there is liberty. When the people fear the government there is tyranny. -Thomas Jefferson, third US president, architect and author (1743-1826) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP, MySQL and Apache
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 that makes since to me. Can someone point me in a direction as to where I can find this out? The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and Apache 2.0.46. I have a page that is trying to connect to MySQL via PHP. The error is: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/ww3.polkmechanical.com/test/mysql_test.php on line 8 The code on line 8 is: $link = mysql_connect( localhost, user, password ) or die(mysql_error()); I can log on through mysql at a telnet prompt with the database, user and password. Ty... . When governments fear the people there is liberty. When the people fear the government there is tyranny. -Thomas Jefferson, third US president, architect and author (1743-1826) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: soft real-time database
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 that you have a status flag for a row. Your app could reset the flag when it retrieves the row. record_status enum(0,1); $time = select now() from table; select * from table where record_status = 1; update records set status = 0 where timestamp_column $time; Curtis Chris Webster said: Curtis Maurand wrote: What's the client running on? Not the same machine as the server. Could either be a windows or linux box across ethernet. --Chris Curtis Maurand wrote: I'd write a perl script to pool the device and send the data to the database. Sorry for not being clearer. I can get the data into the database fine. Assuming new values or rows are added once per second, how would a client program go about polling the database to see when a new value was ready? Check # of rows for a column and when it's incremented grab the latest value? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: howto store files in mysql
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 mysql 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 how to do that or the url of the manuel which explains it. thanks joe baptista Joe Baptista - only at www.baptista.god The Americans, they always depend on a method what I call ... stupid, silly. All I ask is check yourself. Do not in fact repeat their lies. ... Muhammed Saeed al-Sahaf former Iraqi Information Minister -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
HELP!!! permissions not working!
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 * to someuser identified by 'somepass'; and it STILL won't even log into MySQL using the command line! I'm totally in the dark on this one. Any clues? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: PHP, MYSQL and persistant authentication
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 lets users bookmark pages without you having to handle that sort of thing. -Original Message- From: sgannon60 [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 5:08 PM To: [EMAIL PROTECTED] Subject: PHP, MYSQL and persistant authentication Hi, Does anyone know of a good tutorial on setting up a login page, and passing the login primary key to other pages so that other tables will be able to refernce the unique login thanks steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just a test
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]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question about INSERT vs UPDATE
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 MySQL 4 server, DELETEing a table and repopulating it with ~48k records via INSERT, I have come to the conclusion that, regardless of hardware, the delay will be too significant (on a test machine it ran about 25 seconds). What I am curious to know, is whether there is a significant increase if I switch my method of saving from a complete memory dump, to a partial memory dump. The overhaul involved would require a lot of code restructuring. The situation is this, approximately 10k of those 48k records are actually modified regularily. If I overhaul the code to indicate when a record needs to be updated, or inserted, and only call the appropriate action, is the performance going to be significantly better? Keeping in mind it would have to search the 48k records to UPDATE the 10k modified records, as well as potentially INSERT new records (very few if any). With 48k records, is updating 10k records faster than simply deleting and reinserting every record? Alternatively, is there any way speeding up the INSERT time can be achieved? First, I am using the default format, I believe is MyISAM. Second, I have used table locking to optimize writing before the table is deleted and repopulated, and unlocked after all records are inserted. Third, I am using multiple INSERT lists (of 1000 records inserted at a time). Whether the lists is with 100, or 1000, I get about the same results of 25 seconds. I realize the hardware I am using is not significantly powerful, but I think there is some optimization I could make. Can you preallocate a definite number of rows for a large insert operation? Any assistance would be appreciated, this project is flexible towards new ideas to make the dumping more efficient. The alternative has been considered to use a method of UPDATEing records immediately when changes are made in memory. Transaction overhead could become an issue however, with 10k+ records actively changing at any given time. With an UPDATE method, dumping frequently may actually reduce the time required for the process, since it would update fewer records. Anyone with some insight on this would be much appreciated if they could offer some ways to speed up the process. Thanks, -Shane