Re: Encryption of Data
Elizabeth Alderton schrieb am Mittwoch, 22. August 2001, 17:00:53: > If I do a SELECT query to bring data down to a PC (this is > being done through Delphi) how can I encrypt the data so that > it comes safely? > Equally when doing UPDATE and INSERT in the other direction I > would want to encrypt the data. Some people do it with ssh, and it seems to be quite complicated, so that it may be worthwhile to wait for 4.0. If you have only small sets of data, you may want to consider simple SSL protocol. This is what everybody does when collecting user data like addresses and credit card numbers. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - 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: Virtual Server?
Jason Brunk schrieb am Mittwoch, 22. August 2001, 19:45:58: > i read somewhere that you can setup virtual mysql servers, so > that users can actually have their own sql server to administer > with whatever databases they want to create, with out > interferring or even seeing other peoples databases. Does > anyone know how to do this? could you help me? I don't know, but nobody answers, so: I know that it has been discussed, and IIRC it is in the readme and manual and it isn't hard. You create a socket each and assign one to each server and a port ot listen to. But... it costs memory and maybe some more as you double things. This isnt't a good idea if you have 200 clients on a machine with a server for each. ISPs don't have a problem with this as each user has access to his database only. He knows the names of the other, but these are mostly the domain names, and he knows them from ther directory tree already. Same principle: you don't have access except to your own. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - 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: LAST_INSERT_ID()
Jari Mäkelä schrieb am Mittwoch, 22. August 2001, 14:57:06: > At 13:19 22.8.2001 +0200, you wrote: >>LAST_INSERT_ID() should return the last autoincrement value of >>the last insert > Yep it sure did, managed to get to machine and test it out. Total mess. > but; > $query = "SELECT LAST_INSERT_ID()"; > $result = mysql_query($query); > if ($result) { > $nrows = mysql_num_rows($result); > $row = mysql_fetch_row($result); > $lastID = $row[0]; > } > was a code sent to me and if it helps anyone there it is, do not know who > is the original author but this takes the Id from first insert in you put > it after it and then you can use the $lastID in following inserts, works fine. Why not use mysql_insert_id(); -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - 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: Mysql Installation
Jaitly, Rajiv (Contractor) schrieb am Dienstag, 21. August 2001, 10:14:33: > I installed the latest release of MYSQL on windows 2000 environment (non > networked). I would like to add the mysql server start up as a service at > system startup. Could anybody tell me how to do this. >From my readme: This distribution of MySQL includes the new winmysqladmin.exe by Miguel A. Solórzano. With this you can install MySQL as a service, start the service and monitor MySQL. This will also automaticly shut down MySQL on Win9x when the machine needs to be rebooted. Don't know if this applies to NT as well, but I should think so and you can find out immediately. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - 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: Looking for Info on
[EMAIL PROTECTED] schrieb am Dienstag, 21. August 2001, 21:07:24: > Also I am looking for and examples on building a MySQL Manager in Delphi as well. There is one out there already: http://mysqlfront.de See also http://anse.de/ -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - 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: Startin MySQL upon boot in Win2k
Mikkel Gravgaard schrieb am Mittwoch, 22. August 2001, 11:16:47: > Since I like my hard drive more tidy than my house, I've put MySQL in > C:\Program Files\MySQL. > This means that I currently have to start MySQL using a .bat file, since the > mysql-daemon won't find the MySQL-directory if I install it as a Service: > --- MySQL.bat --- > cd C:\Program Files\MySQL\bin > mysqld --basedir="C:\Program Files\MySQL" > -- > The .bat file is put in the Startup-folder, but this means that when Win2k > Professional has booted, I end up with a command-window on my desktop, which I'll > have to manually close. > Can anyone think of a bit more smooth way to get it all going? Excerpt from my Readme: - This version is configured to be installed in c:\mysql. You can however copy this anywhere as long as you don't change the directory structure. For example: mkdir d:\mysql xcopy c:\mysql\*.* d:\mysql mysqld should be able to automaticly find its files based on where mysqld is located. If you want to use files from some other place, you can tell mysqld to use some other directory with --basedir='path'. You can also create a c:\\my.cnf file that holds any default options for the MySQL server. - If you have problems installing mysqld as a service, try starting mysqld with the full path: 'C:\mysql\bin\mysqld --install'. If this doesn't work, you can get mysqld to start properly by fixing the path in the registry! -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - 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: LAST_INSERT_ID()
Jari Mäkelä schrieb am Mittwoch, 22. August 2001, 11:31:01: > Hi, > in the manual there is this LAST_INSERT_ID() and it is what I actually need > but there is some confusion over how to use it in many tables. > http://www.mysql.com/doc/O/D/ODBC_and_last_insert_id.html> > Or, if you are just going to insert the ID into another table, you can do > this: > INSERT INTO foo (auto,text) VALUES(NULL,'text'); > INSERT INTO foo2 (id,text) VALUES(LAST_INSERT_ID(),'text'); > http://www.mysql.com/doc/O/D/ODBC_and_last_insert_id.html> > I have database where most of the data is entered at once to multiple > tables and the linking reference is the ID of the main table. Would this > command just take the first ID and use it in other tables or would it take > it from the new id of the other tables? > What I mean is, would this code use the ID of first insert in all inserts ? > INSERT INTO foo (auto,text) VALUES(NULL,'text'); > INSERT INTO foo2 (id,auto1,text) VALUES(0,LAST_INSERT_ID(),'text'); > INSERT INTO foo3 (id2,auto2,text) VALUES(0,LAST_INSERT_ID(),'text'); > or would it take the first last_insert_id() from first line and second from > second line? I don't have the time to test it, but I would think that LAST_INSERT_ID() should return the last autoincrement value of the last insert, so if you have autoincrement columns to all your tables, you won't get what you want or rather run into big trouble :-( You play safe if you stuff the first number you are interested in into a variable of your program and use this one for all subsequent inserts. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - 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: How to get all of mysql error message
½ÉÃ溸 schrieb am Mittwoch, 22. August 2001, 11:50:05: > Hi. > I examined mysql/Docs/mysqld_error.txt. > But this file has error information from errno 1000 to 1175. > I want to know all of error numbers and messages I can see when programming > mysql access code. >From the shell, use perror number, i.e. perror 127 gives Record-file is crashed -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - 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: Setup own DB for each user?
Ulv Michel schrieb am Mittwoch, 22. August 2001, 11:53:01: > Hi all, > I am running a webhosting server using SuSE 7.2 /mysql 3.23 /php 4. We are > hosting a small amount of virtual servers, allowing our customers to user > php and mysql. My problem is that every user sees every other users > databases. Is there a way to setup mysql so that every local user has his > own empty database? Please tell me how this has to be set up. I don't think this can be done. Please correct me if I'm wrong. ISPs don't have trouble with it as this info doesn't lead somewhere. Users cannot access databases of other users unless set up this way, they only have names. The names usually correspond to the subdirs of those users, and every user can see these as well using telnet or ftp. So what's the point? -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - 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