varchar to char in table with several varchar's

2001-12-12 Thread Willem Bison
I have a table with several columns of type 'varchar'. How can I change all columns to fixed width char's ? Doing a 'alter' from varchar to char has no effect since the column is changed back to varchar. - Before posting, plea

Re: connecting to mysql from different computer

2001-12-12 Thread hamzatk
>I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: > >- Format: >grant all privileges on databaseName.tableName >to 'userName'@'hostName' >identified by 'somePassword'; > > >- Example

Re: MS Access and mysql databases

2001-12-12 Thread callis
Yes it is perfectly possible. I did that some months ago and it worked perfectly. I, however, had to install MyODBC on the windows box. There is a good tutorial I used at http://www.devshed.com/Server_Side/MySQL/ODBC/page1.html Its a good tutorial By W.J. Gilmore. Please take note of the deci

Re: connecting to mysql from different computer

2001-12-12 Thread Carl Troein
[EMAIL PROTECTED] writes: > More so will i need to open MySQL server on my local machine before running > MySQL client to connect to the remote machine e.g. A client is a client and a server is a server. The point of separating the two is that you can then run the client somewhere and and the s

Blocked MySQL.

2001-12-12 Thread robertix
When I try to do anything with MySQL, I always see "Ignoring query to other database" on my screen. When I type "status", the computer prints: "All updates ignored to this database". after "Current user". Could anybody help me ? Does anybody know how can I unblock MySQL ? robertix

RE: A News Group Perhaps.

2001-12-12 Thread Matthew Darcy
Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no

changing allowed number of connections

2001-12-12 Thread Jari Mäkelä
Hi, Where one can alter the number of connections going to MySQL? Jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reques

Re: [OT] A News Group Perhaps.

2001-12-12 Thread Tony Buckley
Hi Matt, I am sure this has been said before so my apologies if I bore! Most mail clients let you setup rules. For the mySQL list I automatically redirect all messages into a separate folder based on the [EMAIL PROTECTED] email address. This creates a fabulous resource that can be searched (ti

How to create clients option file !!!

2001-12-12 Thread hamzatk
Compliments, I was able to uccessful install MySQLGUI version 1.75 on my win 98 running MySQL server 3.23.43 -max-debug client version 3.23.3 alpha. I was also able to connect to the server. At the bottom of the window I saw one button with plus sign, when I do mouse over on it there is this pop

feature request: privileged connection quotas

2001-12-12 Thread Martin Waite
Hi, I'd like to be able to reserve some connections to the MySQL server for emergencies - eg. someone issued a slow query and locked out several hundred updates from several hundred other connections. Currently in this sort of situation, it is possible to completely run out of connections and

concurrent insert documentation clarification

2001-12-12 Thread Michael Griffith
The MySQL documentation says: "To ensure that the update log/binary log can be used to re-create the original tables, MySQL will not allow concurrent inserts during INSERT SELECT" Does this mean: A. An INSERT...SELECT cannot run if any other SELECT is running on the table OR B. An INSERT

Re: A News Group Perhaps.

2001-12-12 Thread Carl Troein
Tony Buckley writes: > I am not a great fan of Newsgroups - they get spammed too much and messages > get lost or archived. Some ISPs carry them, some don't. All too hit and > miss for a resource on which I rely and am very grateful for. I agree, but sadly enough the spam part is true for this

Re: Default 1 == Default 16777216 ?

2001-12-12 Thread Sinisa Milivojevic
Philip Molter writes: > On Mon, Dec 10, 2001 at 02:55:04PM -0700, Nathan wrote: > : Dave Burgess had a good suggestion; I suppose you could specify the default in >hex... > : (default = 0x1) - as long as this is NOT in quotes it will input the hex value 1. > > I compiled a 3.23.46 last night an

Re: Feature Requests

2001-12-12 Thread Sinisa Milivojevic
Mike Wexler writes: > > > Quentin Bennett wrote: > > > > > > Shell escape > > > > mysql> !rm /tmp/data.txt > > mysql> select col into outfile '/tmp/data.txt' from table; > > > > > > > > mysql> select col into local outfile '/tmp/data.txt' from table > > > > > > > > Would these options pr

Re: Default 1 == Default 16777216?

2001-12-12 Thread Sinisa Milivojevic
Philip Molter writes: > >Description: > > When I do this: > > mysql>create table test_default ( testint int not null default 1 ); > mysql>desc test_default; > > I get: > > +-+-+--+-+--+---+ > | Field | Type| Null | Key | Default | Extra | >

Re: [OT] A News Group Perhaps.

2001-12-12 Thread Etienne Marcotte
also screen what you don't need. I delete everything regarding installation. I don't have solaris and I don't have red hat so 80% of the install questions I can't help. You can set up pretty complex sorting rules. It might take a couple of weeks to set up, but once it's done you should receive on

LEFT JOIN trouble. Please help.

2001-12-12 Thread Ján Fedorek
Hi, I've got this problem: I have two tables and I want create third one with LEFT JOIN First table table1 containts field AA as a primary key (AA is NOT NULL). Second table table2 containts field AA as a primary key (AA is NOT NULL) too. Ex: CREATE TABLE a (PRIMARY KEY(AA)) SELECT table1.AA F

Re: ADV: Dear Future Millionaire:

2001-12-12 Thread Etienne Marcotte
How come this passed the spam filter? Which word it had that was on the "mandatory words" list ? There is no sql, query, database in the text... Etienne Bege John wrote: > > I'll make you a promise. READ THIS E-MAIL TO THE END! - follow what it says to the >letter and you will not worry whe

Re: ADV: Dear Future Millionaire: (very OT in a way)

2001-12-12 Thread Carl Troein
Etienne Marcotte writes: > How come this passed the spam filter? > > Which word it had that was on the "mandatory words" list ? EEek! Noo... but that can't be.. or...? Is the whole thing about the MySQL database just a hoax to get people to subscribe to this list so that the people at MySQ

Embedded MySQL server && the outside world

2001-12-12 Thread Marek Kustka
Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? OR is MySQL C API the only way to control it? Thanks, Marek - Before po

Re: [OT] A News Group Perhaps.

2001-12-12 Thread Kelly Firkins
I would vote in favor of using vbulletin (www.vbulletin.com) it's got forums for talk like this, web-based, and runs off of the MySQL server as a back-end. An example in action is vbulletin itself or community.installshield.com. Very slick indeed. Kelly FYI, I'm somewhat biased in favor of it

How to create clients option file !!!

2001-12-12 Thread Hamzat Kamal
Compliments, I was able to uccessful install MySQLGUI version 1.75 on my win 98 running MySQL server 3.23.43 -max-debug client version 3.23.3 alpha. I was also able to connect to the server. At the bottom of the window I saw one button with plus sign, when I do mouse over on it there is this p

Re: How to create clients option file !!!

2001-12-12 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > Compliments, > > I was able to uccessful install MySQLGUI version 1.75 on my win 98 running > MySQL server 3.23.43 -max-debug client version 3.23.3 alpha. > > I was also able to connect to the server. At the bottom of the window I saw > one button with plus sign, when

Re: Embedded MySQL server && the outside world

2001-12-12 Thread Sinisa Milivojevic
Marek Kustka writes: > Hi folks, > > does embedded server tcp-listen to the outside world i.e. it could > be used by another app or perhaps been accessed by the same app > using ODBC? > Nope. > OR > > is MySQL C API the only way to control it? > Yes, so far. But other API's could be built o

I must be mental but.

2001-12-12 Thread Matthew Darcy
I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld & This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change pass

Circular replication

2001-12-12 Thread Duncan Maitland
My questions concern a setup where a public server is running at our hosting company and a local office server is behind a firewall (connected to the net via a somewhat unreliable ADSL). The servers are configured in a circular master-slave relationship but only a limited number of tables in the

Re: Default 1 == Default 16777216?

2001-12-12 Thread Philip Molter
On Wed, Dec 12, 2001 at 02:35:15PM +0200, Sinisa Milivojevic wrote: : Philip Molter writes: : > >Description: : > : > When I do this: : > : > mysql>create table test_default ( testint int not null default 1 ); : > mysql>desc test_default; : > : > I get: : > : > +-+-+-

Re: find_in_set syntax

2001-12-12 Thread Etienne Marcotte
mysql> create table gd_records( -> id int unsigned auto_increment, -> res_skills set("skills1","skills2","skills3","skills4","skills5","skills6"), -> res_skills_ma set("skills_ma1","skills_ma2","skills_ma3","skills_ma4","skills_ma5","skills_ma6"), -> primary key(id)); Query OK, 0 r

Re: [OT] A News Group Perhaps.

2001-12-12 Thread Etienne Marcotte
Well that's called a forum and it's not at all like a mailing list :-) But yes there could be a forum, but there are already some on the net www.devshed.com have a mySQL part and a Perl part and a PHP part. Plus a forum requires servers, space, web hosting, DNS, maintenance, moderation, programmi

user permissions in linux

2001-12-12 Thread Faizal Mangera
Hi, I'm new to both MySQL and LINUX, however still managed to kind of get them up and running. I installed MySQL whilst I was logged in as ROOT. Now I can only run it when I log is as ROOT. How do change permissions of the other users so they can also run MySQL or create a new user which will

Re: Each user have only see databases they have access too

2001-12-12 Thread Kelly Firkins
I believe that phpmyAdmin uses the "show databases" syntax to see what is available. To prevent it from seeing any db which the user is not authorized, set the safe_show_database = 1 in the my.ini file (or my.cnf). This will prevent show databases from returning a list of all dbs available. ke

Re: connecting to mysql from different computer

2001-12-12 Thread Rodney Broom
Good morning Kamal, From: <[EMAIL PROTECTED]> > More so will i need to open MySQL server on my local machine before running > MySQL client to connect to the remote machine e.g. No. The service (mysqld) is strictly assigned to managing the local database(s) and to serve access to those databas

RE: [OT] A News Group Perhaps.

2001-12-12 Thread Christopher Schreiber
Actually I setup a vBulletin forum for MySQL over at www.mysqlforums.com and I am the moderator of the MySQL and Server Configuration forums over at www.vbulletin.com/forum/ I've been keeping an archive of the mailing lists, mainly for my own purposes to search through old questions and answers f

Re: Anti-SPAM (was: A News Group Perhaps)

2001-12-12 Thread Thrill
On Wed, 2001-12-12 at 06:49, Carl Troein wrote: > Tony Buckley writes: >> I am not a great fan of Newsgroups - they get spammed too much and messages >> get lost or archived. Some ISPs carry them, some don't. All too hit and >> miss for a resource on which I rely and am very grateful for. > I

To many processes, 100% CPU usage...HELP

2001-12-12 Thread Charlie Romero
We just upgraded a box (RH 7.2) to current Apache, PHP, and MySQL. We used the MySQL binary for 3.23.46. On the old box which was nearly identical we were running 3.23.43 (I think). The old box didn't have any problems w/ MySQL but this box is having problems. The only real thing that changed wa

[OT] RE: ADV: Dear Future Millionaire: (very OT in a way)

2001-12-12 Thread Rick Emery
The problem is that you all are close-minded. Here, somebody as taken the time to offer you an opportunity to make millions from the internet, and you insult him. INGRATES...all of you...INGRATES I, for plan to avail myself of this fine opportunity. In a year, I'll be basking on the beaches o

Re: changing allowed number of connections

2001-12-12 Thread William R. Mussatto
On Wed, 12 Dec 2001, Jari =?iso-8859-1?Q?M=E4kel=E4?= wrote: > Date: Wed, 12 Dec 2001 13:25:09 +0200 > From: Jari =?iso-8859-1?Q?M=E4kel=E4?= <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: changing allowed number of connections > > Hi, > > Where one can alter the number of connections g

NOT NULL field accepting NULL

2001-12-12 Thread sreedhar
Hi All, In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What might be the problem. please let me know. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Question

2001-12-12 Thread Ivo Dvorak
Hi, I am quite new with MySQL and I have a question. How can I easily make a copy of a mysql database locally stored on a server where I have all admin rights etc. I did not find such a utility/command in the standard MySQL manual nor in admin utilities I use. I use currently the mysqldump utili

Mysql in NFS

2001-12-12 Thread Shen, Lei (CIT)
Hi! Dose anyone has a experience to building mysql database in network files system? and php? can you get me some information? thank you -Original Message- From: Marek Kustka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 8:23 AM To: [EMAIL PROTECTED] Subject: Embedded MyS

RE: user permissions in linux

2001-12-12 Thread Rick Emery
Check out the GRANTS section in the MYSQL manual -Original Message- From: Faizal Mangera [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 9:38 AM To: [EMAIL PROTECTED] Subject: user permissions in linux Hi, I'm new to both MySQL and LINUX, however still managed to kind of

Re: Each user have only see databases they have access too

2001-12-12 Thread Mike(mickalo)Blezien
Which group(s) would this go under in the my.cnf ?? >On Wed, 12 Dec 2001 07:27:54 -0600, "Kelly Firkins" <[EMAIL PROTECTED]> >wrote: >>I believe that phpmyAdmin uses the "show databases" syntax to see what is >>available. To prevent it from seeing any db which the user is not >>authorized

Re: Circular replication

2001-12-12 Thread Brent Cowgill
even/odd is a little limiting, what happens down the road when another site needs to be added. A better method might be to use a unique session ID for each client site in combination with a generated sequence ID see the white paper at:http://www.ambysoft.com/persistenceLayer.html in particular

Re: NOT NULL field accepting NULL

2001-12-12 Thread Paul DuBois
At 7:12 PM +0530 12/12/01, sreedhar wrote: >Hi All, > >In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What >might be the >problem. please let me know. > >regards, >sreedhar That's not enough information. Let's see the CREATE TABLE statement, a sample INSERT statement, and t

Re: NOT NULL field accepting NULL

2001-12-12 Thread sherzodR
No, it's not accepting NULL if it was declared as NOT NULL. It's just accepting an empty sting ( "" ). CREATE TABLE test (t VARCHAR(10) NOT NULL); INSERT INTO test SET t = NULL; INSERT INTO test SET t = ''; First insert will tell you what you're waiting for. And the second one will do what you

Re: varchar to char in table with several varchar's

2001-12-12 Thread Paul DuBois
At 9:32 AM +0100 12/12/01, Willem Bison wrote: >I have a table with several columns of type 'varchar'. How can I change all >columns to fixed width char's ? Doing a 'alter' from varchar to char has no >effect since the column is changed back to varchar. You have to change them all at ones in the

my.cnf settings

2001-12-12 Thread Mike(mickalo)Blezien
Which group(s) would the following options be put under to enable in the my.cnf. safe_show_database skip_show_database Thx's mysql sql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thu

RE: Mysql in NFS

2001-12-12 Thread Matthew Darcy
I have done oracle on NFS and it is not really the best option due to NFS locking. ie a poor network or if the NFS server drops, or the NIS/NIS+ (assuming you are using automount maps) dies this will hold your development/production up no end. Also oracle's table locking (not sure if mysql has th

Re: Question

2001-12-12 Thread Mysql List
How about going to the dir where the mysql database is then just cp * /backupsqldatabase And just the other way when you want to restore then use fix database. Thats what I have done and it seems to work fine. > Hi, > > I am quite new with MySQL and I have a question. How can I easily make a > c

Problem with bk://work.mysql.com ?

2001-12-12 Thread Fournier Jocelyn [Presence-PC]
Hi, When I try to do a "bk pull", I have the following unexpected message : >bk pull bk://work.mysql.com:7001: No route to host What's wrong ? Best Regards, Jocelyn Fournier Presence-PC - Before posting, please check: ht

tunning up my sql

2001-12-12 Thread Hernan Del Boca
Hello, im wondering if anybody can tell me how can i tune up my sql so that can run smoothly... if there is any packet i should install... i have a debian linux in a pentium 3 800 mhz with 256. thanks Hernan - Before posting,

Select with multiple records

2001-12-12 Thread Lindstrom Greg - glinds
Greetings- I have a MySQL database with a table (job_table) containing information concerning jobs I run. Among the fields on the table are job_id (varchar(10)), and timestamp (a timestamp). As I run jobs, I add an entry to the table with the job_id, timestamp, and associated information, so the

Re: Nested Inner Joins

2001-12-12 Thread Bob Hall
On Tue, Dec 11, 2001 at 07:34:11PM -0800, Kendra L Knudtzon wrote: > I am having problems with this nested inner join statement: > > SELECT tblMethodType.MethodType, tblMethodParm.MethodName, > tblParm.ParmName, tblParm.Label, tblParm.Value, tblParm.Unit, tblParm.Tip > FROM tblMethodType INNER JO

Re: find_in_set syntax

2001-12-12 Thread Wiliam Stephens
At 17:40 11/12/01, you wrote: >Can you provide your table description? > >You have two set colums? One called res_skills and one called >res_skills_ma ? Yeah, Both are SET columns. Wil - Before posting, please check: http:/

matching an option from SET list

2001-12-12 Thread Wiliam Stephens
Hello I've got a problem selecting values that match an option from a SET column. My two columns are set up as follows: res_places SET('North','West','South') res_places_re SET('Aber','Cardiff','Bangor') And I'm currently using the following MySQL query: SELE

Re: Mysql in NFS

2001-12-12 Thread Shakeel Sorathia
For mysql, if your datafiles will not fit in ram, I would highly recommend not putting it on nfs. Mysql doesn't have any data caching, so every query will have to go thru the network to get the data. if, however, you do have enough ram on the machine to store all the datafiles in memory, the

Re: Select with multiple records

2001-12-12 Thread rc
can't you select the latest timestamp? On Wed, 12 Dec 2001, Lindstrom Greg - glinds wrote: > Greetings- > > I have a MySQL database with a table (job_table) containing information > concerning jobs I run. Among the fields on the table are job_id > (varchar(10)), and timestamp (a timestamp). As

FW: Embedded Server Binary

2001-12-12 Thread sscroggin
> -Original Message- > From: Scroggin, Steve > Sent: Tuesday, December 11, 2001 8:47 AM > To: '[EMAIL PROTECTED]' > Cc: Firemon Support > Subject: Embedded Server Binary > > MySQL Representative: > > Your website states that downloading the binary is better than com

High load problem with 3.23.45

2001-12-12 Thread Arndt Jenssen
Maybe some coding/mysql master out there knows an answer to this tricky problem... We've recently migrated all our mysql servers from 3.23.42 to 3.23.45 without any problems except for one server. That linux server shows after startup of mysql after 1 or 2 minutes an exceptionally high load an

mysql questions

2001-12-12 Thread Cedric Tardif
Hi all, 2 littles questions. 1. How can i log all connection attempt to the mysql database without logging all the query in the mysql database ? 2. It is possible to prevent user to the 'show database' command, i know they can't use it depending on the right granted but it will be pleasent to

Problem with ODBC and BLOB

2001-12-12 Thread P.Agenbag
HI I installed MyODBC on an NT server to connect via the internet to my Linux box that runs mysql3.23. I have already populated tables in a db that I am trying to link to the NT server via ODBC, but I am getting errors when trying to do this. The table is created with an id field ( BIGINT (255)

RE: Anti-SPAM (was: A News Group Perhaps)

2001-12-12 Thread Quentin Bennett
Hi, The TurboPower new groups (news://news.turbopower.com) seem to work fine, with little spam. Because they host the news groups themselves, there is no problem with them not being hosted by a particular ISP. It would be really nice to have a new group, but the ground has been covered so many t

multiple select with single command.

2001-12-12 Thread Nissim Lugasy
Are there plans for mysql to have the capabilities to execute single sql statement with nested SELECT . or Is there a way around this for the time being? Thanks - Before posting, please check: http://www.mysql.com/manual

Maximum Entries MySQL Can Hande

2001-12-12 Thread Envex Developments
Hello there, Wondering if anyone could help with a problem. I'm upgrading a customer's server from a text based version of our program, to a MySQL based. There are 2 databases, DB1 and DB2, which contain 5 and 4 tables respectively. The upgrade script I am running simply adds information to 3

Re: High load problem with 3.23.45

2001-12-12 Thread Fournier Jocelyn [Presence-PC]
Hi, I have a similar load problem when I start MySQL-4.0 and there is high number of apache process requesting MySQL connection. I had to shutdown and restart apache otherwise the load often goes up to 200 and more (!!). (there are more than 250 visitors always connected to the server, so it gene

lib error?

2001-12-12 Thread Takacs Istvan
Hi I'd like to compile the new PHP 4.1.0, but it always stops at the libmysqlclient.a with these error messages: /usr/lib/mysql/libmysqlclient.a(dbug.o): In function `_db_unlock_file': dbug.o(.text+0xaf4): multiple definition of `_db_unlock_file' /usr/lib/mysql/libmysqlclient.a(ctype-tis620.o)(

Bi-Directional Replications on MySQL

2001-12-12 Thread Pedro de la Lastra
Hello all, I'm moving from ASP to PHP & MSSQL to Mysql, but I have some doubt. It is possible in MySQL Bi-Directional Replications? If it's, then I need to find some documentation about it. Where can I find it? TIA Pedro --

Re: Select with multiple records

2001-12-12 Thread DL Neil
Greg, > I have a MySQL database with a table (job_table) containing information > concerning jobs I run. Among the fields on the table are job_id > (varchar(10)), and timestamp (a timestamp). As I run jobs, I add an entry > to the table with the job_id, timestamp, and associated information, so

mysql log?

2001-12-12 Thread Takacs Istvan
Hi How can I set up our mysql server to write its logs into a log file? Thanks in advance! Regards Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.my

Re: Problem with bk://work.mysql.com ?

2001-12-12 Thread Matt Wagner
Fournier Jocelyn [Presence-PC] writes: > Hi, > > When I try to do a "bk pull", I have the following unexpected message : > > >bk pull > bk://work.mysql.com:7001: No route to host > > What's wrong ? Hi, It should be fixed now. We were doing an internet connection upgrade (from 10mb to 100mb).

Feature request

2001-12-12 Thread Colin Faber
Hi, I've got a feature request which I don't think should be all that hard to implement (if not already) With in the mysql fulltext search system if your search words exist in more than 50% of the records; it is ignored. How about having mysql return either an error or set something that can b

Re: feature request: privileged connection quotas

2001-12-12 Thread Benjamin Pflugmann
Hi. MySQL already reserves one connection to users with the process privilege. So assure that common clients don't have the process privilege and you connect with one that has it and you are done. This is documented here (found no other place): http://www.mysql.com/doc/T/o/Too_many_connections.h

Re: Problem with bk://work.mysql.com ?

2001-12-12 Thread Fournier Jocelyn [Presence-PC]
Hi, Take a look here : http://www.mysql.com/doc/I/n/Installing_source_tree.html Best Regards, Jocelyn Fournier - Original Message - From: "Alexander Skwar" <[EMAIL PROTECTED]> To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 12,

MySQL can not tell differences among some of the Chinese characters

2001-12-12 Thread Alex Shi
Hello, There's a problem with mysql query, which I would like to report to all of you. I'm not sure if it can be taken as a "bug" though. Suppose we have a very simple table with only three or four fields. Let's say the table is "employee", and one of the fields is "name" in varchar or char ty

MySQL / ODBC BLOB problems

2001-12-12 Thread P.Agenbag
HI I installed MyODBC on an NT server to connect via the internet to my Linux box that runs mysql3.23. I have already populated tables in a db that I am trying to link to the NT server via ODBC, but I am getting errors when trying to do this. The table is created with an id field ( BIGINT (255)

RE: I must be mental but.

2001-12-12 Thread Matthew Darcy
I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld & This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change pas

Re: Feature request

2001-12-12 Thread Sergei Golubchik
Hi! On Dec 12, Colin Faber wrote: > Hi, > > I've got a feature request which I don't think should be all that hard > to implement (if not already) > > With in the mysql fulltext search system if your search words exist in > more than 50% of the records; it is ignored. > > How about having mys

No Database Encryption

2001-12-12 Thread James McLaughlin
The new programmer for our company is not using the dataType "password" or any encryption what so ever for our user accounts (accounts that our customers use for getting into our system) in our database. Instead he is using the VarChar dataType. Can someone explain to me how I can exploit this

check table

2001-12-12 Thread rc
is there a way to instruct check table to check all tables without listing each table in the sql statement? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Why MySQL GUI download don't work?

2001-12-12 Thread Alex Shi
I tried to download MySQL GUI from these links: http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip and http://www.mysql.com/Downloads/mysqlgui/mysqlgui-linux-static-1.7.5-1.tar.gz But all these don't work. Alex - Original Message - From: "Matthew Darcy" <[EMAIL P

RE: I must be mental but.

2001-12-12 Thread Mike Grabski
There shouldn't be a space after -p , also don't forget to put the user in there, unless you are using the default user (usually "root", although i've noticed on win32 it seems to be 'ODBC') ex: if your password is "test", the command would be mysqladmin -u -ptest newpassword By all means, cor

Re: No Database Encryption

2001-12-12 Thread tc lewis
it's not all that dangerous. it just means that you can read your users' passwords. anyone who can read that db table can become any of your users. password fields are just another safeguard against a "just in case someone gets read access to this" scenario. they also serve to provide more pr

Re: No Database Encryption

2001-12-12 Thread Dan Nelson
In the last episode (Dec 12), James McLaughlin said: > The new programmer for our company is not using the dataType > "password" or any encryption what so ever for our user accounts > (accounts that our customers use for getting into our system) in our > database. > > Instead he is using the VarC

4 G table limit?

2001-12-12 Thread Tim Wood
Hi 3 months ago starting using mysql to archive a live news feed that our company is paying for. Being a lazy unit, I am putting all the document bodies into one table. After 3 months, that table has grown to 2G - so its a natural enough assumption to assume that in another 3, it will grow to

Re: Circular replication

2001-12-12 Thread David Turner
Just tell your boss that if you ever have turnover the former employee will be able to log into all the customers' accounts and do whatever he wants. Dave On Thu, Dec 13, 2001 at 03:29:41AM +1100, Duncan Maitland wrote: > My questions concern a setup where a public server is running at our > host

Re: 4 G table limit?

2001-12-12 Thread Dan Nelson
In the last episode (Dec 13), Tim Wood said: > As mentioned above, I'm a lazy unit, so if possible would like to > avoid restructuring the DB to spread the document body table across > >1 table (thus enabling > 4 G of doc bodies), so am looking for some > easier way to do it (eg upgrading mysql, o

Re: No Database Encryption

2001-12-12 Thread Doug Thompson
Yes. 1. Read the manual sections concerning setting up new accounts with special emphasis on passwords. 2. When you thoroughly understand those matters, take the issue to the system administrator and/or management. hth, Doug Only two things are infinite, the universe and human stupidity, an

Password encryption

2001-12-12 Thread ST Ooi
How can I encrypt password in database and how can I retrieve the encrypted password? Thanks ST Ooi Malaysia - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "James McLaughlin" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, December 13, 2001 7:06 AM Subject:

Re: Mysql in NFS

2001-12-12 Thread js
As always with these things, horses for courses. In my situation, I have a mysql server mounted off a netapp, It is the backend for a website serving 10m+ page impressions per month. I wanted to put the data on a netapp for easy backup ( I can shutdown the server do a snapshot and bring it bac

Re: Password encryption

2001-12-12 Thread tc lewis
you can use the password() mysql function to crypt it. you cannot retrieve the encrypted password -- only compare input (password() the input) against the saved encrypted password. if the resulting text matches, the password is good. if not, the authentication in your application should fail.

Re: concurrent insert documentation clarification

2001-12-12 Thread Benjamin Pflugmann
Hi. On Wed, Dec 12, 2001 at 04:32:27AM -0700, [EMAIL PROTECTED] wrote: > The MySQL documentation says: > > "To ensure that the update log/binary log can be used to re-create the > original tables, MySQL will not allow concurrent inserts during INSERT > SELECT" > > Does this mean: Normally

RE: No Database Encryption

2001-12-12 Thread Duncan Maitland
> It's only dangerous if a customer can trick your web frontend > into displaying the output of "SELECT * FROM USERS", for > example. If the frontend only uses hardcoded queries, or > quotes every user-supplied parameter, there's no problem. In > fact, you need the password in plaintext to s

Re: matching an option from SET list

2001-12-12 Thread Benjamin Pflugmann
Hi. On Wed, Dec 12, 2001 at 02:39:07PM +, [EMAIL PROTECTED] wrote: > Hello > > I've got a problem selecting values that match an option from a SET column. > > My two columns are set up as follows: > > res_places SET('North','West','South') > res_places_re SET('Aber

Re: 4 G table limit?

2001-12-12 Thread Tim Wood
> In the last episode (Dec 13), Tim Wood said: > > Does anyone out there know of any > > - future plans by the mysql development crew to increase table size > > limits by eg using their own custom filesystem type? > > You mean the MyISAM RAID table extension, or the Innodb tablespace > format?

Re: Password encryption

2001-12-12 Thread sherzodR
When you're insering a new password: INSERT INTO user SET password=PASSWORD('secret'); But you can't retrieve the original password. If a user forgets/looses his/her password, just reset a password with something else, and send him/her that new password And when you want to check an inputted p

Re: Each user have only see databases they have access too

2001-12-12 Thread Kelly
My apologies, I was writing that from work, without immediate access to a box running mysql. I tried it just now and have been having problems attempting to put it into a config file. So far, I've only been able to get it to work by passing --safe-show-database to the service as it starts. If/when

Re: Each user have only see databases they have access too

2001-12-12 Thread Mike(mickalo)Blezien
Kelly, If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, this will give you the same results at start up [mysqld] skip-show-database This will then disable any user from viewing other databases they do not have access too. >On Wed, 12 Dec 2001 19:35:29 -0600, "Kell

Re: Each user have only see databases they have access too

2001-12-12 Thread Kelly
I guess I gave up too quickly. Thanks for the info. :) Kelly - Original Message - From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> To: "Kelly" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 12, 2001 7:35 PM Subject: Re: Each user have only see databases they have

Re: mysql questions

2001-12-12 Thread Kelly
Taken from an email from Mike(mickalo)Blezien <[EMAIL PROTECTED]> >If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, >this will give you the same results at start up >[mysqld] >skip-show-database >This will then disable any user from viewing other databases they do not

Fw: Each user have only see databases they have access too

2001-12-12 Thread Kelly
> I guess I gave up too quickly. Thanks for the info. :) > > Kelly > > - Original Message - > From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> > To: "Kelly" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Wednesday, December 12, 2001 7:35 PM > Subject: Re: Each user have only see da

  1   2   >