Root pass
Hi all, Yet another 3am night and I still can't get my MySql to work. I installed MySql on a cobalt Raq 4 server running Linux. I can telnet into the mysql directory, but can not seem to change the root pass. I've searched every place except the one that as the answer to my question. What am I doing wrong. Below is the session if you can help. [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 16 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql show databases - ; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.00 sec) mysql use test; Database changed mysql use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql bin/mysqld -Skip-grant - USE mysql; ERROR 1064: You have an error in your SQL syntax near 'bin/mysqld -Skip-grant USE mysql' at line 1 Thanks in advance for any help. :) Shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Root pass
Hi Not sure here, but you have logged in as 'admin' on the system. Unless you su to root mysql will use the same user. try either [admin admin]$ su -l to log in to the system as root and then 'mysql -p' to log into mysql or stay as admin but log into mysql as root, under mysql [admin admin]$ mysql -u root -p The clue is in the line ERROR 1044: Access denied for user: '@localhost' to database 'mysql' which would read 'root@localhost' if you were logged in as root HTH, if not come back to me Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]] Sent: 30 June 2002 08:14 To: [EMAIL PROTECTED] Subject: Root pass Hi all, Yet another 3am night and I still can't get my MySql to work. I installed MySql on a cobalt Raq 4 server running Linux. I can telnet into the mysql directory, but can not seem to change the root pass. I've searched every place except the one that as the answer to my question. What am I doing wrong. Below is the session if you can help. [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 16 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql show databases - ; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.00 sec) mysql use test; Database changed mysql use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql bin/mysqld -Skip-grant - USE mysql; ERROR 1064: You have an error in your SQL syntax near 'bin/mysqld -Skip-grant USE mysql' at line 1 Thanks in advance for any help. :) Shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A newbie is having troubles starting mysqld on a new installation of version 4.01
Description: I think that when I installed mysql, I ran out of room on the /var file system How-To-Repeat: bash-2.05$ /usr/sbin/mysqld --datadir=/home/mysql InnoDB: Error: data file ./ibdata1 is of different size InnoDB: than specified in the .cnf file! InnoDB: Could not open data files 020630 1:55:08 Can't init databases bash-2.05$ ls /home/mysql angel.err ibdata1 mysql mysql.sock test bash-2.05$ ls /home/mysql_safe --datadir=/home/mysql ls: unrecognized option `--datadir=/home/mysql' Try `ls --help' for more information. bash-2.05$ /usr/bin/mysql_safe --datadir=/home/mysql bash: /usr/bin/mysql_safe: No such file or directory bash-2.05$ /usr/bin/mysqld_safe --datadir=/home/mysql Starting mysqld daemon with databases from /home/mysql 020630 01:56:20 mysqld ended bash-2.05$ Fix: The installation RPM should test that the filesystems have enough free space before beginning. Is there a switch to the RPM to force placement of the database on a different file system? Submitter-Id: [EMAIL PROTECTED] Originator:MySQL server Organization: MySQL support: none Synopsis: mysqld won't start after installation Severity: non-critical Priority: low Category: mysql Class: change-request Release: mysql-4.0.1-alpha (Official MySQL RPM) Environment: Linux angel 2.4.7-10 #1 Thu Sep 6 17:21:28 EDT 2001 i586 unknown bash-2.05$ df -hl FilesystemSize Used Avail Use% Mounted on /dev/hda4 2.8G 1.6G 1.0G 60% / /dev/hda1 11M 2.7M 8.1M 25% /boot none 19M 0 18M 0% /dev/shm /dev/hda3 95M 70M 20M 78% /var /dev/hdb1 18G 13G 5.4G 70% /home /dev/cdrom595M 596M 0 100% /mnt/cdrom bash-2.05$ rpm -q redhat-release redhat-release-7.2-1 System: Linux angel 2.4.7-10 #1 Thu Sep 6 17:21:28 EDT 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Dec 16 2001 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 5716491 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load problems with 3.23.51
On Sat, Jun 29, 2002 at 10:47:47PM -0700, Steven Roussey wrote: Tomorrow I'll try doing my own compile with gcc3.1. Note the other guy that had the same problem that went away after he compiled it himself: Even gcc 2.95.3 or .4 will work well based on what I've seen. We can still sustain 1,000 qps during busy times with my custom-built binary. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 31 days, processed 675,953,685 queries (249/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Max_data_length question...
Hello, While looking at SHOW TABLE STATUS, I noticed that all my dynamic tables seem to have a Max_data_length of 4,294,967,295 bytes. Is this true - that any dynamic tables are limited to 4GB in size? My fixed tables do not show this problem, and report that their Max_data_length is 4+ billion records times their record length (as expected). I'm using mysql version 3.23.41 on Red Hat Linux 7.2. Thanks, -Hank __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Root pass
Hi shawn, You have probably have % in the user and host of the user table, so mysql client let you in without a username. To be able to use mysql database, you have to login as the root user. Just type, mysql -u root -p and see if you can login in that way. Besides, you have to restart mysqld from your unix shell prompt, you can't do it inside the mysql client .. I hope this helps, Gurhan - Original Message - From: Page Works Web Solutions [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 3:14 AM Subject: Root pass Hi all, Yet another 3am night and I still can't get my MySql to work. I installed MySql on a cobalt Raq 4 server running Linux. I can telnet into the mysql directory, but can not seem to change the root pass. I've searched every place except the one that as the answer to my question. What am I doing wrong. Below is the session if you can help. [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 16 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql show databases - ; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.00 sec) mysql use test; Database changed mysql use mysql; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql bin/mysqld -Skip-grant - USE mysql; ERROR 1064: You have an error in your SQL syntax near 'bin/mysqld -Skip-grant USE mysql' at line 1 Thanks in advance for any help. :) Shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Soliciting best approach for storing passwords . . .
Folk, I need some input on how best to store username/password combinations online. My preference would be to store a one-way encrypted value, but that is not possible in this situation. The constraint is that we have to make provision for giving the user's password back to the user after a forgot my password link has been clicked. (Oh, a secondary input would be on the best way to accomplish the password return to the user grin /.) Normally, I store passwords as a one-way hash, then encrypt input to see if it matches, but I can't do that this time: I have to store a clear text or decryptable value. I've seen several approaches to this, but don't see any clear 'best practice'. Right now I'm leaning toward a multiple table design, but I have no real idea if this is a better model than a single table design. I'd really appreciate input from some of you who have wrestled with this problem before. If it matters, the development box is Win2K/IIS5, PHP 4.0.5, MySQL 3.23.32, and the implementation box is *nix/Apache 1.3.22, PHP 4.1.1, MySQL 3.23.47. I'd appreciate any suggestions for a best resolution. Thanks. Make a good day . . . . . . barn ~ If you're not confused, you're not paying attention ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql List bug?
Mysql list serve manager, Could this be a bug in the mysql listserv. Tedd Richards tried to unsubscribe and I am getting the confirmation e-mail to confirm that I really want to un-subscribe, when, I haven't emailed an unsubscribe request in the frist place. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 8:04 AM Subject: confirm unsubscribe from [EMAIL PROTECTED] Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please send an empty reply to this address: Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. I haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, [EMAIL PROTECTED] receives messages with return path: mysql-return-number[EMAIL PROTECTED] Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 25046 invoked from network); 29 Jun 2002 15:04:54 - Received: from mtiwmhc22.worldnet.att.net (204.127.131.47) by www.mysql.com with SMTP; 29 Jun 2002 15:04:54 - Received: from dell866 ([12.77.147.176]) by mtiwmhc22.worldnet.att.net (InterMail vM.4.01.03.27 201-229-121-127-20010626) with ESMTP id 20020629151310.JATW20395.mtiwmhc22.worldnet.att.net@dell866 for [EMAIL PROTECTED]; Sat, 29 Jun 2002 15:13:10 + Message-ID: 01ee01c21f7f$84589260$1300a8c0@dell866 From: Teddy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Date: Sat, 29 Jun 2002 11:13:22 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_01EB_01C21F5D.FB47C700 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 This is a multi-part message in MIME format. --=_NextPart_000_01EB_01C21F5D.FB47C700 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable --=_NextPart_000_01EB_01C21F5D.FB47C700 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Diso-8859-1 META content=3DMSHTML 5.50.4522.1800 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_01EB_01C21F5D.FB47C700-- - Before posting, please check:
RE: Load problems with 3.23.51
Results of Michael Bacarella's request (too big for dist list, so only Michael and Michael/Monty got the full reply, this is shortened for the list so a possible light bulb can go off): 3.23.51: ps -eo pid,tt,user,fname,tmout,f,wchan PID TT USER COMMAND TMOUT F WCHAN 1 ?root init - 100 do_select 2 ?root keventd - 040 context_thread 3 ?root ksoftirq - 040 ksoftirqd 4 ?root ksoftirq - 040 - 5 ?root kswapd - 040 kswapd 6 ?root bdflush - 040 bdflush 7 ?root kupdated - 040 kupdate 8 ?root mdrecove - 040 md_thread 17 ?root kjournal - 040 end 92 ?root khubd- 040 end 192 ?root kjournal - 040 end 193 ?root kjournal - 040 end 685 ?root syslogd - 040 do_select 690 ?root klogd- 140 do_syslog 710 ?rpc portmap - 140 do_poll 738 ?rpcuser rpc.stat - 140 do_select 923 ?root xinetd - 140 do_select 963 ?root sendmail - 140 do_select 994 ?root crond- 040 nanosleep 1044 ?xfs xfs - 140 do_select 1080 ?daemon atd - 040 nanosleep 1112 ?root miniserv - 040 do_select 1117 tty2 root mingetty - 100 read_chan 1118 tty3 root mingetty - 100 read_chan 1119 tty4 root mingetty - 100 read_chan 1120 tty5 root mingetty - 100 read_chan 1121 tty6 root mingetty - 100 read_chan 1285 tty1 root mingetty - 100 read_chan 14125 ?root sshd - 140 do_select 409 ?root php - 000 inet_wait_for_connect 9097 ?root sshd - 140 - 9099 pts/0root bash - 100 wait4 9164 pts/0root safe_mys - 100 wait4 9192 pts/0mysqlmysqld - 100 - 9194 pts/0mysqlmysqld - 040 do_poll 9195 pts/0mysqlmysqld - 040 rt_sigsuspend 9196 pts/0mysqlmysqld - 040 - 9197 pts/0mysqlmysqld - 040 rt_sigsuspend 9198 pts/0mysqlmysqld - 040 rt_sigsuspend 9199 pts/0mysqlmysqld - 040 - 9200 pts/0mysqlmysqld - 040 - 9201 pts/0mysqlmysqld - 040 - 9202 pts/0mysqlmysqld - 040 - 9203 pts/0mysqlmysqld - 040 - 9204 pts/0mysqlmysqld - 040 rt_sigsuspend 9205 pts/0mysqlmysqld - 040 - 9206 pts/0mysqlmysqld - 040 - 9207 pts/0mysqlmysqld - 040 - 9208 pts/0mysqlmysqld - 040 rt_sigsuspend 9209 pts/0mysqlmysqld - 040 rt_sigsuspend 9210 pts/0mysqlmysqld - 040 - 9211 pts/0mysqlmysqld - 040 unix_stream_data_wait 9212 pts/0mysqlmysqld - 040 - 9213 pts/0mysqlmysqld - 040 - 9214 pts/0mysqlmysqld - 040 - 9215 pts/0mysqlmysqld - 040 tcp_data_wait 9216 pts/0mysqlmysqld - 040 - 9217 pts/0mysqlmysqld - 040 - 9218 pts/0mysqlmysqld - 040 rt_sigsuspend 9219 pts/0mysqlmysqld - 040 - 9220 pts/0mysqlmysqld - 040 - 9221 pts/0mysqlmysqld - 040 - 9222 pts/0mysqlmysqld - 040 - 9223 pts/0mysqlmysqld - 040 - 9224 pts/0mysqlmysqld - 040 - 9225 pts/0mysqlmysqld - 040 - 9226 pts/0mysqlmysqld - 040 - 9227 pts/0mysqlmysqld - 040 - 9228 pts/0mysqlmysqld - 040 - 9229 pts/0mysqlmysqld - 040 - 9230 pts/0mysqlmysqld - 040 - 9231 pts/0mysqlmysqld - 040 - 9232 pts/0mysqlmysqld - 040 - 9233 pts/0mysqlmysqld - 040 - 9234 pts/0mysqlmysqld - 040 - 9235 pts/0mysqlmysqld - 040 - 9236 pts/0mysqlmysqld - 040 - 9237 pts/0mysqlmysqld - 040 - 9238 pts/0mysqlmysqld - 040 - 9239 pts/0mysqlmysqld - 040 - 9240 pts/0mysqlmysqld - 040 - 9241 pts/0mysqlmysqld - 040 - 9242 pts/0mysqlmysqld - 040 - 9243 pts/0mysqlmysqld - 040 - 9244 pts/0mysqlmysqld - 040 - 9245 pts/0mysqlmysqld - 040 - 9247 pts/0mysqlmysqld - 040 - 9248 pts/0mysqlmysqld - 040 - 9249 pts/0mysqlmysqld - 040 - 9250 pts/0mysqlmysqld - 040 tcp_data_wait 9251 pts/0mysqlmysqld - 040 tcp_data_wait 9252 pts/0mysqlmysqld - 040 - 9254 pts/0mysqlmysqld - 040 - 9255 pts/0mysqlmysqld - 040 - 9256 pts/0mysqlmysqld - 040 - 9258 pts/0mysqlmysqld - 040 - 9259 pts/0
Re: Max_data_length question...
The default at table creation is 4GB. You can change the default vaule via an ALTER TABLE. You will need to alter AVG_ROW_LENGTH and MAX_ROWS. MAX_DATA_LENGTH is the product of the two. http://www.mysql.com/doc/T/a/Table_size.html Regards, Bhavin. - Original Message - From: Henry Hank [EMAIL PROTECTED] To: mysql mailing list [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 7:05 AM Subject: Max_data_length question... Hello, While looking at SHOW TABLE STATUS, I noticed that all my dynamic tables seem to have a Max_data_length of 4,294,967,295 bytes. Is this true - that any dynamic tables are limited to 4GB in size? My fixed tables do not show this problem, and report that their Max_data_length is 4+ billion records times their record length (as expected). I'm using mysql version 3.23.41 on Red Hat Linux 7.2. Thanks, -Hank __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need you expertise
Hi again, first of all thx for the precious help given to me. Well it seems i have problems again. Everytime i try to access mysql it returns: ERROR 1045: Access denied for user:'hasv@localhost' (Using password: NO) How can i put it to work? Any clue? I'm new to this so i apollogize if this is a very basci thing. Thxs in advance Hugo Veiga - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL - Fulltext search
Hi! I have a table called 'candidate_skill' id (autoincrement) candidateID (link to candidate), skill (tinytext) Query: SELECT * FROM candidate_skill WHERE candidateID='2' Result: 134 | 2 | Powerpoint 223 | 2 | PHP 313 | 2 | Lotus Notes Is it possible to do a fulltext search. I want to search for skills. Something like this: +php +powerpoint ...and then get a list of all candidates that have php and powerpoint as a skill. Is there a way to do this? Best regards /Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
storing various files in mysql
I need to store small files in mySql. Some are binary and some are not, can they be stored the same way ? eg: Read them in as binary and store them in a blob ? I can't figure out how to store binary data in mySql using ADODB, c# ? I read in the binary data as a byte array. I then convert that to a string and insert it into mySql in the normal fashion. mySql complains about this ? can anyone help ? thanks Craig - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Soliciting best approach for storing passwords . . .
Barn. I asked the same question couple of weeks ago and all the answers I got pointed to one way encryption. Actually, I had the same need that you, but understood that it was better to reset the password when a Forgot password was made, send it to the user and ask them to change the password at the next login. I suppose you have the same problem that I had... few users who would get angry if such thing is asked to do. But then I realize that if I used a very common words list to generate random passwords, they might even learn that password without changing it. After all the responses I've get regarding this issue, I never got the answer to how do a two way encrypting so, if this doesn't help you... -Original Message- From: databarn [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 10:36 AM To: MySQL Subject: Soliciting best approach for storing passwords . . . Folk, I need some input on how best to store username/password combinations online. My preference would be to store a one-way encrypted value, but that is not possible in this situation. The constraint is that we have to make provision for giving the user's password back to the user after a forgot my password link has been clicked. (Oh, a secondary input would be on the best way to accomplish the password return to the user grin /.) Normally, I store passwords as a one-way hash, then encrypt input to see if it matches, but I can't do that this time: I have to store a clear text or decryptable value. I've seen several approaches to this, but don't see any clear 'best practice'. Right now I'm leaning toward a multiple table design, but I have no real idea if this is a better model than a single table design. I'd really appreciate input from some of you who have wrestled with this problem before. If it matters, the development box is Win2K/IIS5, PHP 4.0.5, MySQL 3.23.32, and the implementation box is *nix/Apache 1.3.22, PHP 4.1.1, MySQL 3.23.47. I'd appreciate any suggestions for a best resolution. Thanks. Make a good day . . . . . . barn ~ If you're not confused, you're not paying attention ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need you expertise
you will need to give it the password flag and then type in the password when prompted for one. mysql -u hasv -p Regards, Bhavin. - Original Message - From: Hugo Veiga [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 9:54 AM Subject: need you expertise Hi again, first of all thx for the precious help given to me. Well it seems i have problems again. Everytime i try to access mysql it returns: ERROR 1045: Access denied for user:'hasv@localhost' (Using password: NO) How can i put it to work? Any clue? I'm new to this so i apollogize if this is a very basci thing. Thxs in advance Hugo Veiga - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Soliciting best approach for storing passwords . . .
Hi Just to throw another thought in If you do change the password and send it to them, you have to allow for the fact that their email could have changed - left work, service provider went bust etc etc, or somebody could just enter their email for a joke 8*} and get their password reset. I have seen systems where old and new passwords work until you confirm the new one, which is a halfway house, but more programming. The fact is that security is difficult, not technically, but from a human perspective. People are a security risk and educating users in proper security is the best answer, though a lost cause sometimes :) regarding two way encryption see http://www.mysql.com/doc/M/i/Miscellaneous_functions.html and ENCODE(str,pass_str) BFN Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: César Aracena [mailto:[EMAIL PROTECTED]] Sent: 30 June 2002 21:42 To: 'databarn'; 'MySQL' Subject: RE: Soliciting best approach for storing passwords . . . Barn. I asked the same question couple of weeks ago and all the answers I got pointed to one way encryption. Actually, I had the same need that you, but understood that it was better to reset the password when a Forgot password was made, send it to the user and ask them to change the password at the next login. I suppose you have the same problem that I had... few users who would get angry if such thing is asked to do. But then I realize that if I used a very common words list to generate random passwords, they might even learn that password without changing it. After all the responses I've get regarding this issue, I never got the answer to how do a two way encrypting so, if this doesn't help you... -Original Message- From: databarn [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 10:36 AM To: MySQL Subject: Soliciting best approach for storing passwords . . . Folk, I need some input on how best to store username/password combinations online. My preference would be to store a one-way encrypted value, but that is not possible in this situation. The constraint is that we have to make provision for giving the user's password back to the user after a forgot my password link has been clicked. (Oh, a secondary input would be on the best way to accomplish the password return to the user grin /.) Normally, I store passwords as a one-way hash, then encrypt input to see if it matches, but I can't do that this time: I have to store a clear text or decryptable value. I've seen several approaches to this, but don't see any clear 'best practice'. Right now I'm leaning toward a multiple table design, but I have no real idea if this is a better model than a single table design. I'd really appreciate input from some of you who have wrestled with this problem before. If it matters, the development box is Win2K/IIS5, PHP 4.0.5, MySQL 3.23.32, and the implementation box is *nix/Apache 1.3.22, PHP 4.1.1, MySQL 3.23.47. I'd appreciate any suggestions for a best resolution. Thanks. Make a good day . . . . . . barn ~ If you're not confused, you're not paying attention ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
high level: enabling transactions in mysql-max with WebLogic TX datasource?
One thing that I find a little confusing is the notion of transactional behavior in mySQL. I read that it's possible to enable transactions in mySQL-max, however, it's never really been clear to me exactly what I'm supposed to do, or whether I have to do anything. If I'm using a transactional datasource in WebLogic, on top of mySQL, I need to make sure mySQL supports that transactional behavior. Is there a section of the mySQL documentation, or some other documentation, which explains these issues clearly? -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
text formatting
hello, I have a web from that allows a user to submit a resume in text format. How do i make mysql respect the formatting of the text document so that it is pulled from the database as it was inserted? right now everything comes back as one paragraph. thanks, blue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need you expertise
Hi, If you are sure that the user hasv exists in mysql, then either type mysql -u hasv -p so that the mysql client will prompt you for a password, or in your home directory, create my.cnf file and type [client] password=yourpassword Gurhan - Original Message - From: Hugo Veiga [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 12:54 PM Subject: need you expertise Hi again, first of all thx for the precious help given to me. Well it seems i have problems again. Everytime i try to access mysql it returns: ERROR 1045: Access denied for user:'hasv@localhost' (Using password: NO) How can i put it to work? Any clue? I'm new to this so i apollogize if this is a very basci thing. Thxs in advance Hugo Veiga - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: text formatting
This should be handled before the data is even inserted into mysql. Have your scripting language that you use in the form handle this to have the resume formatted in the way you'd like and then have it insert the data into mysql. Gurhan - Original Message - From: Blue Presley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 5:34 PM Subject: text formatting hello, I have a web from that allows a user to submit a resume in text format. How do i make mysql respect the formatting of the text document so that it is pulled from the database as it was inserted? right now everything comes back as one paragraph. thanks, blue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Soliciting best approach for storing passwords . . .
Thanks, César, But this is not an option that is negotiable for me. The client mandate is very clear, and the reason behind it has a strong business case from their standpoint. I'm not about to get them to change their minds . . . they and I have been over this way too many times already. Make a good day . . . . . . barn ~ It is my ambition to say in ten sentences what others say in a whole book. - Friedrich Nietzsche ~ (sql, query) I asked the same question couple of weeks ago and all the answers I got pointed to one way encryption. Actually, I had the same need that you, but understood that it was better to reset the password when a Forgot password was made, send it to the user and ask them to change the password at the next login. . . . After all the responses I've get regarding this issue, I never got the answer to how do a two way encrypting so, if this doesn't help you... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: text formatting
I'm using (and new to) PHP. any suggestions as to what functions, if any exist, that would be appropriate for pre-formatting? thx, blue - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Blue Presley [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 6:02 PM Subject: Re: text formatting This should be handled before the data is even inserted into mysql. Have your scripting language that you use in the form handle this to have the resume formatted in the way you'd like and then have it insert the data into mysql. Gurhan - Original Message - From: Blue Presley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 5:34 PM Subject: text formatting hello, I have a web from that allows a user to submit a resume in text format. How do i make mysql respect the formatting of the text document so that it is pulled from the database as it was inserted? right now everything comes back as one paragraph. thanks, blue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Soliciting best approach for storing passwords . . .
Thanks, Peter, Yeah, I had looked at ENCODE()/DECODE() and ABS_ENCRYPT()/ABS_DECRYPT() as possible tools, as well as some inherent PHP functionality. My real question is more about database design than about the mechanics of encryption. But I do appreciate the feedback. Make a good day . . . . . . barn ~ Save a tree. Eat a beaver. ~ (sql, query) regarding two way encryption see http://www.mysql.com/doc/M/i/Miscellaneous_functions.html and ENCODE(str,pass_str) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: text formatting
I haven't seen the rest of the thread, but form data looses all formatting. Line breaks will remain but HTML ignores them look at nl2br() to convert them to br HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Blue Presley [mailto:[EMAIL PROTECTED]] Sent: 30 June 2002 23:31 To: [EMAIL PROTECTED] Subject: Re: text formatting I'm using (and new to) PHP. any suggestions as to what functions, if any exist, that would be appropriate for pre-formatting? thx, blue - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Blue Presley [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 6:02 PM Subject: Re: text formatting This should be handled before the data is even inserted into mysql. Have your scripting language that you use in the form handle this to have the resume formatted in the way you'd like and then have it insert the data into mysql. Gurhan - Original Message - From: Blue Presley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 5:34 PM Subject: text formatting hello, I have a web from that allows a user to submit a resume in text format. How do i make mysql respect the formatting of the text document so that it is pulled from the database as it was inserted? right now everything comes back as one paragraph. thanks, blue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: text formatting
Hi, Yes there are number of functions you can use in php. I don't know what you really want to do, i assume that you want the resumes viewed over the web, in that case you can use nl2br() function to indicate a new line.. Take a look at the following pages: http://www.php.net/manual/en/ref.strings.php http://www.php.net/manual/en/ref.regex.php Gurhan - Original Message - From: Blue Presley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 6:31 PM Subject: Re: text formatting I'm using (and new to) PHP. any suggestions as to what functions, if any exist, that would be appropriate for pre-formatting? thx, blue - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Blue Presley [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 6:02 PM Subject: Re: text formatting This should be handled before the data is even inserted into mysql. Have your scripting language that you use in the form handle this to have the resume formatted in the way you'd like and then have it insert the data into mysql. Gurhan - Original Message - From: Blue Presley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 5:34 PM Subject: text formatting hello, I have a web from that allows a user to submit a resume in text format. How do i make mysql respect the formatting of the text document so that it is pulled from the database as it was inserted? right now everything comes back as one paragraph. thanks, blue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: text formatting
Hi Try eregreplace(tab, 4 spaces) Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Blue Presley [mailto:[EMAIL PROTECTED]] Sent: 01 July 2002 02:33 To: [EMAIL PROTECTED] Subject: Re: text formatting Thanks guys, nl2br works perfectly for preserving my new lines! I've checked over the php string function list and am still experimenting with some options. However, do you know of any function that will preserve tabs and spacing (used for centering text, etc) in case your wondering, i'm letting people submit their resumes to a mysql database. it has to be in text format so that they can be properly searched. if anyone knows of a better way to do this (ie, using .pdf files) and still enabling them to be searched, plz let me know. thx blue - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Blue Presley [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 7:35 PM Subject: Re: text formatting Hi, Yes there are number of functions you can use in php. I don't know what you really want to do, i assume that you want the resumes viewed over the web, in that case you can use nl2br() function to indicate a new line.. Take a look at the following pages: http://www.php.net/manual/en/ref.strings.php http://www.php.net/manual/en/ref.regex.php Gurhan - Original Message - From: Blue Presley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 6:31 PM Subject: Re: text formatting I'm using (and new to) PHP. any suggestions as to what functions, if any exist, that would be appropriate for pre-formatting? thx, blue - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Blue Presley [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 6:02 PM Subject: Re: text formatting This should be handled before the data is even inserted into mysql. Have your scripting language that you use in the form handle this to have the resume formatted in the way you'd like and then have it insert the data into mysql. Gurhan - Original Message - From: Blue Presley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 5:34 PM Subject: text formatting hello, I have a web from that allows a user to submit a resume in text format. How do i make mysql respect the formatting of the text document so that it is pulled from the database as it was inserted? right now everything comes back as one paragraph. thanks, blue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the