Re: ENCODE algorithm
On Mon, 2002-06-03 at 04:58, Evgeny Chuykov wrote: What algorithm do ENCODE-DECODE functions use? This is noname algorithm with questionable security level. Use DES_ENCRYPT/DES_DECRYPT instead. This uses triple DES. Tõnu sql - 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: I need 50.000 inserts / second
On Fri, 2002-05-31 at 20:54, Cesar Mello - Axi wrote: Hello, You could maybe buffer the data in Your application and then run inserts later... like this. This is not a solution for me as the data acquisition can take hours without any break. Whatever you do, with any SQL you get stuck behind speed of parser. More commands means more waiting. Making one INSERT for two records instead of two INSERTs can speed up your stuff twice easily. This is general problem of SQL. Tõnu - 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: SSL
On Fri, 2002-05-31 at 17:52, Marcel wrote: Hi all, How is the best tool for acess Mysql By SSL protocol ? What do you need to do? MySQL C API has all neccessary stuff to use SSL and mysql command line tool can use it from 4.0.x versions. Tònu - 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: Replace strings
Rol wrote: Hallo all, A table containing some text needs to have some of the letters changed (eg. letter to be replaced with "auml;" ). Is there a way to use a replace function to search for such chararcters in a text and then replace it with the html tag? Yes of course and this function is called "REPLACE()". Check the manual :) Just HTML stuff you should handle yourself. Database does not need to know about HTML but replacing one string with another is common. -- MySQL Security Administrator __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 vs PostreSQL ??
tmb wrote: How does PostreSQL compair to MySQL ? I'm sure each has it's own advantages disadvantages. What are some of the major ones? Both are very good databases with free type licenses. There are advantages. dot. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 vs ....
"Ciprian A." wrote: I would need some reasons for choosing MySQL instead of Microsoft SQL. (beside the fact that MySQL is free). (not for me but for my boss). It may sound silly but trust me I really need these reasons. So please help me with this. The biggest reason to avoid Microsoft products when I choose platforms and tools for projects is missing freedom. I never know why but maybe I really like MSSQL but I have some reason to drop NT - I can't do this. MSSQL runs only on NT. In own projects I always try to keep myself free from any limits to be ready to migrate in case of emergency. Using MySQL is risk-free. If you do not like it, you have freedom to change most things to MSSQL easily anytime. When you use MSSQL you are stuck. This is my own view and I do not know what my company thinks. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 some help on how to use mysql with web site
Kyzen Computers wrote: I was wondering if someone can help me, I am new to the list and was looking for some help on how I can use mysql with my website to keep track of who comes in and giving them logins I have just read mysql and don't know anything PHP or CGI but if some one tells me how to incorporate the scripts in the website I would be grateful Look around in the net. I know for example http://www.phpbuilder.com can help you. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Help for mysql error
"J.C. Ting" wrote: I use Mysql for half year. At this moment, I encounter a big problem that I can not query any data from my server. The following is my configuration. Platform: Solaris 2.7 on Sun Ultra2 Mysql version: 3.22.29 Table Name: mailhead; mysql select * from mailhead where serial_no=90; ERROR 1030: Got error 134 from table handler mysql show variables; Table seems to be corrupted and should be fixed with isamck as documented in manual. Also I suggest to upgrade to latest 3.23.25 version. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 on redhat 7.0
Sanjeev Adhyapak wrote: We have installed redhat 7.0 server on one machine and want to run mysql server on that. The installation is default. After that only the root is allowed to connect to the server and if login as different user i am getting the error as error 111 connection refused. If anybody has started it then plese let me know. MySQL packages included with RH7 are broken. Take newer ones from RedHat updates or http://www.mysql.com. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Antwort: Webmin
Sunrise wrote: Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Yes and this is documented in manual. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 backup mySQL database?
Keneth wrote: "When I try to dump sql database it gives me some errors 1.Error 1045 mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045: Access denied for user: 'accp@localhost' (Using pass word: NO) " can you help? Please read the manual and list archive! Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Antwort: ReisserFS
Tim Bunce wrote: Only problem we know is that in our tests on ReiserFS is MySQL was 30% faster on writes :/ How does it compare to FreeBSD with "soft updates" enabled? Sorry, I use only linux and very rarely touch anything else. So this 30% was meant under linux. Sorry for confusion. I really do not know about *BSD. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Only changing part of a field...
Marcus Ouimet wrote: One quick question, I am trying just replace part of the entry ie: change: /image/covers/009.jpg to image/covers/09.jpg I have tried to update products set 'image/covers' where products_image like '/images/covers%'; but it seems to replace the whole field and not leave the trailing data. Ie it changes /image/covers/09.jpg to image/covers. Any ideas. Thanks in advance. update products set products_image=replace(products_image,'/images/covers','images/covers'); another possibility (and more proper I think) is to play with regexp-s. you can define beginning of line, pattern and so on. Read the manual about regexp examples. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Antwort: ReisserFS
[EMAIL PROTECTED] wrote: On 22.02.2001 16:22:13 Simon Windsor wrote: Has anyone user MySql on a ReisserFS file system ? HERE! No problems whatsoever - why should there be problems anyway? Only problem we know is that in our tests on ReiserFS is MySQL was 30% faster on writes :/ -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: ReisserFS
Peter Skipworth wrote: I'd heard that even in general use, some users had a noticeable increase in disk reads/writes under ReiserFS...it sounds like you haven't experienced this (?). I'm thinking about moving over to ReiserFS as well, shortly, and am looking for as much feedback from people using it as possible... Mileage may vary. We had in one test speed improvement of 30% on writes. But this depends :) -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Antwort: Re: Antwort: ReisserFS
[EMAIL PROTECTED] wrote: On 23.02.2001 10:29:21 ?iso-8859-1?Q?T=F5nu?= Samuel wrote: Only problem we know is that in our tests on ReiserFS is MySQL was 30% faster on writes :/ Hmm, so, I understand you right: You're saying that it's not a good idea to use MySQL on ReiserFS, as you may get a speed rush? *G* Well, it can pull off socks off of feet ;) But seriously, ReiserFS is only right choice for now. No doubt. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Secure connection with SSH
Andrea wrote: Depending on manual, i have information about conecting to a remote MySql from windows with SSH and there a site http://www.doc.ic.ac.uk/~ci2/ssh/ But this site is gone.. :( Where i can download a free ssh ? This is offtopic. Hint: download it from http://www.google.com -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Optimizing Queries
Jim Bayers wrote: I have a non-profit site that uses mysql. I need to optimize two queries so they won't put such a load on the mysql server. If I don't lighten the load, they've treatened to kick us off. Check the manual chaper about optimizations, especially about EXPLAIN command. This will help you on finding right indexes now and in future. Result vary on content (size) if tables, so it is not so easy to tell it from now. What columns are best to index? SELECT messages.ID as ID, title, text, user_id, username, email FROM messages,user WHERE messages.user_id=user.ID AND (parent_id=$ARGV[1] OR messages.ID=$ARGV[1]) ORDER BY messages.time" SELECT * FROM pc, links WHERE pc.ID = links.pc_id AND links.user_id = $id AND links.board_id = $ARGV[0] DROP TABLE IF EXISTS links; CREATE TABLE links ( board_id int(11) DEFAULT '0' NOT NULL, user_id int(11) DEFAULT '0' NOT NULL, pc_id int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (board_id,user_id,pc_id), KEY iboard (board_id), KEY iuser (user_id), KEY ipc (pc_id) ); DROP TABLE IF EXISTS messages; CREATE TABLE messages ( board_id int(11) DEFAULT '0' NOT NULL, user_id int(11) DEFAULT '0' NOT NULL, parent_id int(11) DEFAULT '0' NOT NULL, title varchar(30), text text, time int(11), ID int(11) DEFAULT '0' NOT NULL auto_increment, PRIMARY KEY (ID), KEY iboard (board_id), KEY iuser (user_id), KEY iparent (parent_id) ); DROP TABLE IF EXISTS pc; CREATE TABLE pc ( name varchar(15), picture varchar(15), text text, time int(11), ID int(11) DEFAULT '0' NOT NULL auto_increment, PRIMARY KEY (ID) ); DROP TABLE IF EXISTS user; CREATE TABLE user ( username varchar(15) DEFAULT '' NOT NULL, password varchar(15) DEFAULT '' NOT NULL, email varchar(30), junk tinyint(4), time int(11), ID int(11) DEFAULT '0' NOT NULL auto_increment, PRIMARY KEY (ID), KEY iusername (username), KEY ipassword (password) ); - 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 Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 failes at startup
Sascha Andres wrote: hi, on a suse 7.1 system my mysql fails on startup. it can't create a pid. how can i fix this ? sascha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Sorry it is FAQ and please follow instruction on bottom of EVERY message on this list. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 version
paul herigs wrote: I want to know something about MySQL versions we have a database working with version 4.0. can you tell me were I can download this version. On the internet I only can find version 5.0 and my database don't response on this version. Something is totally wrong. MySQL-4.0 is the newest in family and available to developers only. Last stable on is 3.23.32 (33?). There is no MySQL-5.0. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Performance Q
Rus wrote: Hi! Does MySQL open all tables in database when I select data from one table? No. But he will keep last x ones for faster access. My my.cnf file: [tonu@no tonu]$ cat /etc/my.cnf [mysqld] log-slow-queries=/var/log/mysql-slow-query.log set-variable = long_query_time=1 set-variable = key_buffer=16M set-variable = sort_buffer=1M set-variable = table_cache=128 --- Keep last 128 tables open set-variable = record_buffer=1M set-variable = net_buffer=16M [tonu@no tonu]$ Will it be faster to split db to number of smaller db associated with concrete PHP scripts? Depends. Usually you do not have so huge tables. If someone does, then one can read manual about MERGE type of tables. They are hiding that solution with many tables from you. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 DO I CAN DO THIS...
"MAN ..." wrote: HI THERE, I HAVE A PROBLEM WITH THE ETTIQUETES OF THE DATABASE, I MEAN HOW DO I CAN MAKE A SITE WHERE I CAN UPLOAD INFORMATION WITH A DATABASE, FOR EXAMPLE: IF I WANT A PAE WHERE SAYS "PUT YOUR NAME HERE" AND YOU HAVE TO PUT IT IN AN TEXTAREA HOW DO I MAKE THAT THAT NAME CAN GO TO MY DATABASE I TRIED PUTIN' THIS FORM NAME="AND HERE I PUT THE DATABASE'S NAME" METHOD="GET" ACTION="URL OF THE DATABASE" INPUT TYPE="" NAME="CAMP NAME"BRINPUT TYPE="SUBMIT" VALUE="UPLOAD" BUT I DIDNT GET THAT IT ONLY OFFERS ME TO DOWNLOAD THE DATABASE. HELP MEE Read the manual please. And also please buy new keyboard with working CapsLock key. Current keyboard annoys users. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Simple question
Joel Holtzman wrote: Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql, and create/edit tables. However, i always get an access denied error, saying I'm not allowed to connect to the mysql server. However, via telnet, I am fine. By default MySQL server allows only connections from localhost. This is prorably what you do: use telnet to login into unix box and then use mysql command line client there. If you try to connect from some other computer you of course SHOULD get access denied error. This is security. To allow this other computer to connect read the manual and especially about command "GRANT". -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Database/table encryption
msquared wrote: I'm working for a company that has a paranoid client, and the client wants their database to be 'secure'. By 'secure' they mean that even if someone gains root access on the server, the data in the database can't be compromised (obtained). I can think of a couple of ways to do this, but I don't know if they're practical. The first is to have MySQL store the tables and such in an encrypted fashion, at the file layer. Can anyone else offer any alternative suggestions, or some guidance? Most standard way is prorably having encrypted filesystems support in kernel (http://www.linuxi.org) and then having MySQL databases on it. I do not believe into too big security when intruder already have root but encryption will anyway help. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: explain select question
Dimitar Boiadjiev wrote: Hi all, I've been working on optimizing my query but no success. Concerning the type of query shown by "explain select", about join type "ALL" in the manual is written: "This is normally not good if the table is the first table not marked const, and usually very bad in all other cases." So, I added indexes on all columns involved in join but "explain select" still shows the same result. Am I missing something or this is inevitable and can't be optimized. Below are some snippets. +-+--++--+-+--+--+--+ | table | type | possible_keys | key | key_len | ref | rows | Extra| +-+--++--+-+--+--+--+ | firm| ALL | fikey,fiuserid | NULL |NULL | NULL | 11 | | | product | ALL | prfikey| NULL |NULL | NULL | 25 | range checked for each record (index map: 2) | | users | ALL | userid | NULL |NULL | NULL | 96 | range checked for each record (index map: 1) | +-+--++--+-+--+--+--+ 3 rows in set (0.00 sec) If there are so small quantity of rows in table then full scan is faster than using indexes. I do not remember exact amount but maybe it was 300 rows in table below what MySQL doesn't use indexes. Indexes get used if there are more rows in table. This is normal and feature and good :) -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: SECURITY issue in remote tcp/ip connecting?
Derek Sivers wrote: Any measures I could take (like SSH) to encrypt the transaction? Use CIPE tunnel. You can find it: http://sites.inka.de/sites/bigred/devel/cipe.html Is this anything like ipsec? http://www.openbsd.org/faq/faq13.html (I'm using OpenBSD.) Or, rather, could I use ipsec for this same thing as CIPE, too? From reading the two sites/descriptions, it sounds like the same thing. Yes, but CIPE have smaller footprint and seems easier to install. But this doesn't matter if you like IPSec in some reason. IPSec have own advantages by wider support. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 and Oracle
Jason Radley wrote: I am currently using php and mysql and I was wondering if you can take the data from a mysql database and move it to a oracle database? Thank you, mysqldump exports data from MySQL database and them Oracle should be able to import it. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: Setting Up Users!
Muhanad Mustafa wrote: Ok, i'm very new to Mysql. . The documentation is a little confusing for me to figure out so I thought this might help. I had created a database on my system called "customer15" I did this mysqlcreate database customer15 Now I want to setup a mysql username and password so this customer has rights to made modifcations to his database in telnet. He has a telnet username and password, but when he logs into the system, Mysql wont' let him in becasue his username and password is not created in mysql. I want the user customer15 to have rights to the database i created called "customer15" and ONLY rgihts to make ANY changes to that database like create tables, rows, and other stuff to manage his database. What commands do I need to use. . your help is appricated as I learn this field of database stuff. . . It sure isn't easy thats for sure. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Please check the manual! There are everything about this topic. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: databases size limitation #2
marko milovanovic wrote: uh! i already posted this message a while ago! could anyone please help me? i could find some informations about increasing the size of the databases, but not about limitations to their size. how would it be possible to set a limitation in the size of the databases at the creation time so that a user couldn-t build any databases greater than, say, 20 MB? i just couldn-t find this information anywhere! Everything is in manual. I have seen databases on MySQL in terabytes, and theoretical limit if much more away. But there are some limitations in operating systems, so check manual to suit your needs. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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