Graphical UI for MySQL

2002-04-16 Thread Kela Vesa
Greetings, I would like to ask you following question: Is there graphical user interface for managering MySQL database? I think command line-based interface is quite clumsy... Regards, Vesa Kela, Helsinki Finland -

Strarting another mysql deamon on the same server

2002-04-16 Thread vshlomit
Hi, I compile mysql-3.23.49. and I would like to run it first together with the old mysql. /usr/local/xxxmysqlxxx/bin/safe_mysqld --socket=/tmp/xxxmysqlxxx.sock --port=330 7 --user=myuser --pid-file=/usr/local/xxxmysqlxxx//var/mysqld.pid --datadir=/u sr/local/xxxmysqlxxx/var So I get the

min() bug

2002-04-16 Thread Artem V. Ryabov
Hello mysql, mysql create temporary table _234 select -20020412051754 as b; select min(b) from _234; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 +-+ | min(b) | +-+ | -20020412051744 |

SV: MySQL and stored procedures - v4.1 :(

2002-04-16 Thread Carsten Gehling
Fra: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sendt: 16. april 2002 09:52 MySQL AB wants to satisfy as many users as possible. That means there may be more than one language available for writing stored procedures. For example, many mainstream databases currently support both Java and a

Need help: Lost connection to MySQL server during query

2002-04-16 Thread Ksenia Prokhorovich
Hi All! Have any of you faced a similar problem and if so how did you fix it? Please, recommend me something. The code that I have written is : $sth = $dbh-prepare(SELECT * FROM MY_TABLE); $sth-execute || die $sth-errstr;

remote

2002-04-16 Thread Toni
dear all, i have installed mysql on redhat 7.2 and it's work well. then i try to open mysql client through another computer running win98 using this command: mysql -h 192.168.10.2 -u root and i get this as the result : ERROR 1130: Host '192.168.10.2' is not allowed to connect to this MySQL

Re: Graphical UI for MySQL

2002-04-16 Thread Victoria Reznichenko
Kela, Tuesday, April 16, 2002, 9:48:34 AM, you wrote: KV I would like to ask you following question: KV Is there graphical user interface for managering MySQL database? I think KV command line-based interface is quite clumsy... Take a look at:

Re: RE: Feature? (Not null and timestamps)

2002-04-16 Thread Victoria Reznichenko
Carl, Monday, April 15, 2002, 11:29:10 PM, you wrote: CM One of our developers pointed out something to me today and I can't explain. CM When we created a table with timestamp as one of the column types and not CM null the describe table command shows that nulls are allowed for the CM timestamp

Re: remote

2002-04-16 Thread Egor Egorov
Toni, Tuesday, April 17, 2001, 12:10:55 PM, you wrote: T i have installed mysql on redhat 7.2 and it's work well. then i try to open T mysql client through another computer running win98 using this command: T mysql -h 192.168.10.2 -u root T and i get this as the result : T ERROR 1130: Host

Re: Re: Signal 11 after flush privileges

2002-04-16 Thread Egor Egorov
Rafal, Monday, April 15, 2002, 6:38:55 PM, you wrote: Rafal, Monday, April 15, 2002, 4:54:23 PM, you wrote: RJ Version Mysql-Max-3.23.49a for Linux, binary distribution from www.mysql.com RJ After deleting some users from user table and invoking flush privileges, I got RJ Lost connection

User Define Function

2002-04-16 Thread Elteto Zoltan
Hi all, I need to create 2 user defined functions. lookup end reverse_lookup These functiouns are included in the udf_example2.cc source file. I have gcc version 2.96 2731 (Red Hat Linux 7.0) and mysql-3.23.49-pc-linux-gnu-i686 (Binary distribution) 1)step: Compiling the udf_example2.cc

Normalization and Retrieval

2002-04-16 Thread Xavier Prélat
I want to know what kind of normalization to use to solve and retrieve data for this SQL based application: Following descritpion is the way I can do it. I want to store data about contacts : - table Contacts(ID,Name,EMail) and data about list of users : - table Lists(IDList,

can't run configure because of no size for char type

2002-04-16 Thread ???
Description: I got a MySQL source distribution of 3.23.49 from www.mysql.com. Then I installed it in the following steps: (1)groupadd mysql (2)useradd -g mysql mysql (3)gunzip mysql-3.23.49.tar.gz | tar -xvf - (4)cd mysql-3.23.49 (5)./configure --prefix=/usr/local/mysql here,

Re: hello, i need help, about mysql MISSING charsets

2002-04-16 Thread Xuefer
i've report this bug to php, they said it's not bug of php but i've found the problem * ALL is ok for SERVER, problem issue only by CLIENT(libmysql.a) php-win-binary don't compile libmysql supporting GBK charset! neight other multibyte charset. also the one i compiled is linked with

RE: MySQL and stored procedures - v4.1 :(

2002-04-16 Thread Svensson, B.A.T. (HKG)
You've already stated your lack of belief in the reliability of deadlines, so what did you expect? If someone had responded with 4.1 will be done on 5/1/2002 you'd respond that the only way that would happen would be if it were horribly buggy or lacked critical features -- if you hold such a

OT: Relational Algebra Trees

2002-04-16 Thread David Ayliffe
Ok, Cards on the table, I have an assignment in soon and part of the deliverable is to design some relational algebra tree's based on some queries I have been given. This is one of the queries: SELECT id FROM Table1 WHERE id NOT IN (SELECT id FROM Table2); I have an idea that this query

Re: MySQL crashes is fulltext search on with some words.

2002-04-16 Thread Sergei Golubchik
Hi! On Apr 16, Erlend Hopso Stromsvik wrote: I'm not sure if this has been reported earlier, but my mysql-server goes down if I run a query with two 'match against' where one of them contains/matches the word 'think'... Can you create a repeatable test case for this ? Regards, Sergei --

uninstallin Linux

2002-04-16 Thread Paras Mukadam
Hello all, Can anyone tell me how to uninstall MySQL from Linux Mandrake 7.2 ? Regards, paras - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: uninstallin Linux

2002-04-16 Thread Jim Philips
How you uninstall depends on how you installed. Did you install the binary? an rpm? or compile the source and then install? If you installed by rpm, then all you need to do is: rpm -e mysql If you used some other method to install, then you can just delete all od the directories. But you

Too many connections

2002-04-16 Thread Eqab Almutairi
Hello, i have error : Too many connections . when i try to backup mydatabase , even if i want browse board how to fix this and is there limit for mysql connections? Thanks _ Join the world’s largest e-mail service with MSN

Re: Timestamp and Load Data command

2002-04-16 Thread Keith C. Ivey
On 15 Apr 2002, at 15:34, Carl McNamee wrote: We are attempting to put records into a table using the load data or mysqlimport commands. One quirk is with columns that include a timestamp type. When we import the records we get zeros in the timestamp column. How can we get the current

mysql windows history

2002-04-16 Thread Peter Gibbons-BU
How do I enable the mysql_history functions under a windows environment? thanks Peter This e-mail (and any attachments) is confidential and may contain personal views which are not the views of the BBC unless specifically stated. If you have received it in error, please delete it from your

Multiple this and Multiple that

2002-04-16 Thread Luc Foisy
Can I slave from two different remote servers on the same slave? If not, is running two mysql servers (slaves) on the same computer easy to setup or possible at all? Luc Foisy - Before posting, please check:

Re: Graphical UI for MySQL

2002-04-16 Thread Hisseine Dj.
Try mysqlgui, this is a tool that can give you the ability to do some admin. Hisseine - Original Message - From: Kela Vesa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 2:48 AM Subject: Graphical UI for MySQL Greetings, I would like to ask you following

Re: Problems with Make on 3.23.49 on Sun SPARC 20 with Solaris 2.6

2002-04-16 Thread Egor Egorov
Lee, Monday, April 15, 2002, 8:23:42 PM, you wrote: Leoen Attempted to compile this version on a SPARC 20 running Solaris 2.6. Leoen Installed GNU gcc 3.0.2 and make 2.76 specifically for this installation. Leoen Normally use the make from SUN and the C compiler from Sun SparcWorks.

Re: MySQLAdmin

2002-04-16 Thread Victoria Reznichenko
eq99083, Monday, April 15, 2002, 9:59:39 PM, you wrote: e Please, e can anyone tell me where is the source code for MySQLAdmin.exe for Win32? You can download the source distribution of MySQL for Windows and take a look at folder 'Client' ... e Thank you -- For technical support

Re: Timestamp and Load Data command

2002-04-16 Thread Victoria Reznichenko
Carl, Monday, April 15, 2002, 11:34:09 PM, you wrote: CM We are attempting to put records into a table using the load data or CM mysqlimport commands. One quirk is with columns that include a timestamp CM type. When we import the records we get zeros in the timestamp column. How CM can we get

Re: Sorting alphabetically using charsets other than Latin 1

2002-04-16 Thread Victoria Reznichenko
Monday, April 15, 2002, 10:40:06 PM, you wrote: m I have a table with text data in English in one column, same data in m Russian (cp1251) in another, and so on. I'd be happy to retrive that m data sorted alphabetically according to the *respected alphabets*. I m couldn't figure out how to

Re: Too many connections

2002-04-16 Thread Victoria Reznichenko
Eqab, Tuesday, April 16, 2002, 4:24:56 PM, you wrote: EA i have error : Too many connections . when i try to backup mydatabase , even EA if i want browse board how to fix this and is there limit for mysql EA connections? Yes, there is a limit that is determinated by max_connections variable.

Re: OT: Relational Algebra Trees

2002-04-16 Thread Victoria Reznichenko
David, Tuesday, April 16, 2002, 3:01:46 PM, you wrote: DA Cards on the table, I have an assignment in soon and part of the DA deliverable is to design some relational algebra tree's based on some DA queries I have been given. DA This is one of the queries: DA SELECT id DA FROM Table1 DA WHERE

Re: does mysql support multi table update?

2002-04-16 Thread Egor Egorov
bin, Tuesday, April 16, 2002, 12:40:56 AM, you wrote: bc does mysql latest version support multi tables update? bc Thanks a lot Nope. It will come later ... Look at: http://www.mysql.com/doc/T/O/TODO_future.html -- For technical support contracts, goto https://order.mysql.com/ This

Re: mysqld cannot start - Can't find file: './mysql/host.frm' (errno: 13)

2002-04-16 Thread Egor Egorov
magnus, Monday, April 15, 2002, 9:04:10 PM, you wrote: mllDescription: mll I installed the binary distribution (first time I am installing mysql ever) for Solaris 8 in a non-standard location (/data/mysql/3.23.47/SunOS_5.8) which is local on the server. I then mll moved the data

Show Tables Freezing a MySQL process

2002-04-16 Thread Lloyd Duhon
Hi Everyone. Here's a VERY unusualy problem. We are running a mod_perl application with MySQL. One of the functions in the program performs a SHOW TABLE command. This is performed with apparently great regularity within the program. It has begun locking a process up, at 100% CPU (All held by

FW: regarding mysql sever startup...

2002-04-16 Thread Chetan Lavti
-Original Message- From: Chetan Lavti Sent: Monday, April 15, 2002 10:01 AM To: [EMAIL PROTECTED] Subject: regarding mysql sever startup... hi, I am starting my Mysql Serevr like this.. cd /bin/sbin mysqld-max --user=root Is there any another method which doesn't require starting

Re: remote

2002-04-16 Thread George Pitcher
Toni, check your logs to make sure that the client is logging in with the ip address rather than a pseudo-address such as pc10-2.domain.com. I had this problem when one of my users was logging in. If that's the case, make sure that the logged-in name is the one in the MySQL db. HTH George

Re: Graphical UI for MySQL

2002-04-16 Thread BD
At 01:48 AM 4/16/2002, you wrote: Greetings, I would like to ask you following question: Is there graphical user interface for managering MySQL database? I think command line-based interface is quite clumsy... Regards, Vesa Kela, Helsinki Finland Kela, Try MySQLFront from

bug in file ibmysql_r/libmysql.c

2002-04-16 Thread xuefer
Description: enable-reads-from-master and repl-parse-query is mixed How-To-Repeat: . Fix: line 839: case 22: /* enable-reads-from-master */ options-rpl_parse = 1; break; case 23: /*

Re: error : Fatal error: Call to a member function on a non-object

2002-04-16 Thread ds
Hi, That's not a Mysql error, it's an error from the language you are using (i suppose it's PHP). You did not define $dbconn. You're mixing functional programming with object oriented programming (i think). Instead of $result=$dbconn-Execute(update info set . Try

Re: Graphical UI for MySQL

2002-04-16 Thread j.urban
If you know SQL, you might want to have a look at urSQL (http://www.urbanresearch.com/ursql). It's not a management tool per se, but more of a query tool... On Tue, 16 Apr 2002, BD wrote: At 01:48 AM 4/16/2002, you wrote: Greetings, I would like to ask you following question: Is there

Enterprise Manager (?)

2002-04-16 Thread Ioakim Spyros
Hi all, I'm looking for a tool like Enterprise Manager (I am talking about a Windows client) I downloaded MyCC and it looked a lot like it and hoped that it would work. Don't get me wrong it does work but with a couple of glitches. I don't know If those can be solved in MyCC or I didn't find

Re: bug in file ibmysql_r/libmysql.c

2002-04-16 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: Description: enable-reads-from-master and repl-parse-query is mixed How-To-Repeat: . Fix: line 839: case 22: /* enable-reads-from-master */ options-rpl_parse = 1; break;

RE: Enterprise Manager (?)

2002-04-16 Thread Johnny Withers
You should try MySQL Front http://anse.de/mysqlfront/ - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Ioakim Spyros [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 10:20 AM To: [EMAIL PROTECTED] Subject:

Re: remote

2002-04-16 Thread Gerald Clark
The only way I can see to get this message is if the client you are on when running mysql is 192.168.10.2 You should be using the IP address of the server you are connecting to, not the IP address of the client machine. George Pitcher wrote: Toni, check your logs to make sure that the client

newbie question.

2002-04-16 Thread Steve Bradwell
Hi everbody, Super newbie question here, How do I set up password protection on a single database. I am using MySQL with phpMyAdmin. Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php

MySQL security

2002-04-16 Thread Paras G. Mukadam
Hi, I'm working on security breaches in MySQL. Can someone guide me in this. To be precise can you tell me about some literature, some book which is easy to understand and also profound ! If anyone is working on that, I'll be more than happy to interact. Thanking you. Paras.

Re: MySQL dying suddenly

2002-04-16 Thread Rafal Jank
apparently an innocent query followed by an update. The binary package is statically linked ad it started happening after we started using InnoDB. The version is, actually, 3.23.49a-Max. Although I can't reproduce a better test case than this, I'm sure that you can check the binaries you

RE: MySQL security

2002-04-16 Thread David Ayliffe
Are MySQL really going to give you details of their past security 'issues'? Think about it. Try going underground and looking on some exploit sites. DA Hi, I'm working on security breaches in MySQL. Can someone guide me in this. To be precise can you tell me about some literature, some book

WHERE codition test

2002-04-16 Thread Svensson, B.A.T. (HKG)
Is this a documented behavior of MySQL(?): mysql create table test (a int); Query OK, 0 rows affected (0.03 sec) mysql insert into test values(0); Query OK, 1 row affected (0.00 sec) mysql insert into test values(0); Query OK, 1 row affected (0.00 sec) mysql insert into test values(1); Query

RE: MySQL security

2002-04-16 Thread nigel wood
On Tue, 16 Apr 2002, David Ayliffe wrote: Are MySQL really going to give you details of their past security 'issues'? Think about it. Try going underground and looking on some exploit sites. DA Hi, I'm working on security breaches in MySQL. Can someone guide me in this. To be

Re: WHERE codition test

2002-04-16 Thread Christopher Thompson
I'm not sure what you are asking. Everything is working correctly as far as I can see. On Tuesday 16 April 2002 10:19 am, Svensson, B.A.T. (HKG) wrote: Is this a documented behavior of MySQL(?): mysql create table test (a int); Query OK, 0 rows affected (0.03 sec) mysql insert into test

Re: gunk in mysqldump output

2002-04-16 Thread Bill Marrs
I don't have --no-disable-keys in my version of myqldump (Ver 8.21 Distrib 3.23.48). (-K doesn't seem to do anything, I assume it's the default). I actually wouldn't mind disabling keys for the load, but I don't understand how the /*!4 ... stuff is suppose to get used. Is this a

Re: newbie question.

2002-04-16 Thread Craig Ostrander
Hi Steve: That depends. Are you running the db server on your local machine? Or are you having it hosted somewhere and using PHPMyAdmin? In the second case, you will have to contact your hosting company to find out how they handle it. Some hosting companies severely restrict your access

Trouble Connecting With Non-Admin Account Via PHP

2002-04-16 Thread Zyxian
Hello. When trying to connect to a database through php using a user that has been granted all rights to the database I get the Can't connect to database error. If I use the Admin's name and password I have no trouble connecting through the php page. From a shell prompt I can connect to mysql

Re: MySQL and GCC

2002-04-16 Thread Trond Eivind Glomsrød
Barry Blatz [EMAIL PROTECTED] writes: I have a system here based on Red Hat's 7.2 distribution and I am wanting to get MySQL up and running. After browsing your web page it seems that I will have go to a different version of gcc. Not recommended, the most stable gcc-based compiler around

RE: newbie question.

2002-04-16 Thread Steve Bradwell
Ya I am running it on my local machine and I'm doing some development, I have some people here excited about mysql and they want to play with it so I granted them access through apache via ip address and created databases for them, however I really don't wan't them to be able to access my

RE: WHERE codition test

2002-04-16 Thread Svensson, B.A.T. (HKG)
Basically I am just curious, and I did perform some few small test. But, I was suspecting to get all rows when I did something like WHERE valid string, but had to write something like WHERE NOT valid string which feels a little bit upside down for me considering that integers apart from zero

Re: WHERE codition test

2002-04-16 Thread Christopher Thompson
mysql select x.a from test x where 1; 1 evaluates to be true, so this should select all rows. And it does. 5 rows in set (0.00 sec) mysql select * from test where 0; This evaluates to false, so this should not select any rows. And it does. Empty set (0.00 sec) mysql select x.a from test x

Extremely Large Numbers for MySQL column

2002-04-16 Thread Chris Stark
Hello, I have a question, and hopefully someone out there can help me out. I have a lot of really large numbers (or should I say small, large in size ) that I need to store in my MySQL database. Numbers like: 2.8E-50 or 0.049zeros028 Anyway, I need to store these

RE: WHERE codition test

2002-04-16 Thread Jon Frisby
String literals in a truth test such as you set up are coerced to integers. (A la C's 'atoi()' function.) The following returns all rows from a table: SELECT * FROM test WHERE '1'; // String becomes 1 SELECT * FROM test WHERE '1a'; // String becomes 1 SELECT * FROM

RE: WHERE codition test

2002-04-16 Thread Svensson, B.A.T. (HKG)
mysql select x.a from test x where 1; 1 evaluates to be true, so this should select all rows. And it does. 5 rows in set (0.00 sec) mysql select * from test where 0; This evaluates to false, so this should not select any rows. And it does. Empty set (0.00 sec) mysql select

Re: Enterprise Manager (?)

2002-04-16 Thread Hisseine Dj.
Hy Johnny, I try to install MySQL front on Window 2000. When I run it to connect to mysql server on Linux, I got an error saying this host (my client) cannot connect to the mysql server. It seems to be a configuration on the mysql server, any idea. Thanks, Hisseine - Original Message

Password handoff

2002-04-16 Thread BJ Phillips
Does anybody know how I would hand the password to this command line automatically? mysql -u root fastlane /home/fastlane/queries/daily_netcfr_query -=BJ=- - Before posting, please check: http://www.mysql.com/manual.php

RE: WHERE codition test

2002-04-16 Thread Keith C. Ivey
On 16 Apr 2002, at 10:58, Jon Frisby wrote: String literals in a truth test such as you set up are coerced to integers. (A la C's 'atoi()' function.) [snip] If you're used to weakly-typed languages, such as Perl this is fairly typical behavior although it does seem counterintuitive in the

Re: WHERE codition test

2002-04-16 Thread va ku
Hi, Don't you think you should use select * from test WHERE a=0 ; not select * from test where 0; Isn't the correct usage of WHERE -Original Message- From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:00 PM To: Mysql List; Christopher

RE: WHERE codition test

2002-04-16 Thread Jon Frisby
Neither I, it seams strange. This value has to be stored in some kind of pointer to an object or char * in the program it self. I would first assume that the content of the pointer is tested, but that cant be true since the content in this case is the number 65. You're assuming a very

RE: WHERE codition test

2002-04-16 Thread Jon Frisby
Doh. My bad. I was indeed thinking of integer context rather than boolean context. I was thinking of a Perl construct of the form: if(a + 0) { ... } I.E. forcing it to an integer context... -JF -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent:

mysql start produces can't connect thru /var/lib/mysql/mysql.sock

2002-04-16 Thread bbales
From: bruce To: [EMAIL PROTECTED] Subject: mysql start produces can't connect thru /var/lib/mysql/mysql.sock Description:Trying to run mysql-3.23.41 that came with RH7.2 following mysql.org documentation. files are not located as documented either for rpm or source install. 'mysql

RE: Password handoff

2002-04-16 Thread Gurhan Ozen
mysql -u user -pPASSWORD ... See: http://www.mysql.com/doc/m/y/mysql.html Notice that there is no space between -p and the password.. Gurhan -Original Message- From: BJ Phillips [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:05 PM To: Mysql Help Subject: Password handoff

RE: Password handoff

2002-04-16 Thread BJ Phillips
thanks all!! -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 11:27 AM To: BJ Phillips; Mysql Help Subject: RE: Password handoff mysql -u user -pPASSWORD ... See: http://www.mysql.com/doc/m/y/mysql.html Notice that there is no space between

can't init my database for innoDB in mysql

2002-04-16 Thread bin cai
Hi, currently i got one problem really need your help. I removed mysql3.23.41 version and install mysql 3.23.49. and it works fine with myisam table. Now i am trying to create innobd tables. so i edit my.cnf file like that( window 2000): [mysqld] basedir=F:/mysql #bind-address=129.128.207.59

Saving and re-using SQL statements

2002-04-16 Thread Neal Caidin
Hi All, I am a little more familiar with Oracle environments where I can save and get SQL statements that I formulate. How do I do this from within MySQL? I've tried editing my query, with vi, and then saving it using vi's w filename command, but I can't figure out how to restore the query. I

RE: WHERE codition test

2002-04-16 Thread Svensson, B.A.T. (HKG)
Don't you think you should use select * from test WHERE a=0 ; not select * from test where 0; Isn't the correct usage of WHERE Well, usually my queries could look like this: insert into #report (Line) select isnull(a.Object, '') + char(9) + isnull(c.ClusterId, '***no

RE: Saving and re-using SQL statements

2002-04-16 Thread Gurhan Ozen
Hi Neal, I am not clearly understanding your question , do you mean that you have some variables in your queries?? Normally you would just save your query in a file and either run it in the shell command line in batch mode with '' operator or would just call it in mysql shell with 'source'

Counting Distinct values - with a twist

2002-04-16 Thread Kevin Murphy
Hello. I have just spent the afternoon pouring over the mailing list archives and the manual trying to find a way to do this, but have come up pretty empty, so I decided it was time to ask the list. I have a database that our sales team uses to track their sales efforts. For the sake of

RE: Saving and re-using SQL statements

2002-04-16 Thread Neal Caidin
Hi Gurhan, Actually, the source command is what I was looking for. Thanks. I looked through the documentation but for some reason could not find it. - Neal Gurhan Ozen [EMAIL PROTECTED] on 04/16/2002 03:43:42 PM To: Neal Caidin [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject:

Re: Trouble Connecting With Non-Admin Account Via PHP

2002-04-16 Thread Zyxian
My problem is fixed. I only grant'ed user@localhost. What I needed, and have done, is grant'ed [EMAIL PROTECTED] Once I did that everything worked. Zyxian On Tue, 16 Apr 2002 09:38:19 -0700, Zyxian wrote: Hello. When trying to connect to a database through php using a user that has been

Re: MySQL dying suddenly

2002-04-16 Thread Sasha Pachev
On Monday 15 April 2002 02:39 pm, Leonardo Dias wrote: I received the message that made our MySQL die sometimes now. Our mysqld is the binary package available @ www.mysql.com. Version is 3.23.49a The error message is below. key_buffer_size=16773120 record_buffer=1019904

RE: win32 commands

2002-04-16 Thread Keith Kiedrowski
is the load data invalid only in the windows version of mySQL? Keith Kiedrowski Systems Administrator - The DiMarco Group Voice: 585.214.4787 - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Extremely Large Numbers for MySQL column

2002-04-16 Thread Keith C. Ivey
On 16 Apr 2002, at 13:25, Chris Stark wrote: SELECT * FROM results WHERE result_value 2.8E-50 Anyway, I cannot seem to find a column type that is large enough to store this kind of number. Have you tried DOUBLE PRECISION? It doesn't seem to be specified on the MySQL site, but Paul

Re: Counting Distinct values - with a twist SOLVED

2002-04-16 Thread Kevin Murphy
Sometimes, simpler is better. on 4/16/02 4:16 PM, Gurhan Ozen at [EMAIL PROTECTED] wrote: select ad_pubid, client_region, count(distinct ad_clientid) as Advertisers from ads, clients where ads.ad_clientid = clients.client_id group by ad_pubid, client_region; I think I was too busy

Installing....

2002-04-16 Thread Elteto Zoltan
Hi all, I tried to install mysql version 3.23.46 but when I do the make part I get an error message. On this server I have another mysql installed (version 3.23.46) and I thought that I will install one more because this worked fine before. The same error popped out:( Step one: CFLAGS=-O3

MySQL subtracting an hour from DATETIME types I insert?

2002-04-16 Thread Richard Bolen
I have a java application accessing MySQL via the mm.mysql type 4 jdbc driver. It appears that when I insert a record with a DATETIME type in it, it's subtracting an hour from the time. Does anyone know why this might be happening? Is it a timezone or daylight savings time issue? My server

RE: MySQL subtracting an hour from DATETIME types I insert?

2002-04-16 Thread Venu
Hi ! -Original Message- From: Richard Bolen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:25 PM To: MySQL Mailing List (E-mail) Subject: MySQL subtracting an hour from DATETIME types I insert? I have a java application accessing MySQL via the mm.mysql type 4

What's up with the mysql_read_default_group segfault bug?!

2002-04-16 Thread Christian Hammers
Hi That using mysql_read_default_group can produce segfaults is known since at least a month and there were two independend bug reports, one from me: http://listarchive.nextrieve.com/mysql//200203/msg01938.html Are there any patches available? Monty said something about 3.23.50 but although

Re: Enterprise Manager (?)

2002-04-16 Thread BD
At 10:20 AM 4/16/2002, you wrote: Hi all, I'm looking for a tool like Enterprise Manager (I am talking about a Windows client) I downloaded MyCC and it looked a lot like it and hoped that it would work. Don't get me wrong it does work but with a couple of glitches. I don't know If those can be

precision for double data type

2002-04-16 Thread Scott Tindal
Mysql version: 3.23.41 and 4.01 OS: NT4SP6a, W2KSP2 There is some inconsistency in how many significant digits mysql displays/returns for double values. For example, a value of 1.1790123350679011E22 is returned as 1.1790123350679e+022 (last 3 digits rounded, only 14 significant digits).

ORDER problem using international chars

2002-04-16 Thread Webmaster33
Hi! Anybody knows how can mysql ORDER BY international strings? I would need to do sortings for different languages. So locale definition should be changed within MySQL. (changing locale for the system is not solution, because I need to change more times for different languages) How it is

Alter (MyISAM) table while clients connected?

2002-04-16 Thread Daniel Kasak
Hi all. Can I alter a MySQL table (specifically a MyISAM) table while (MS Access) clients are connected? I want to add fields, not alter existing ones. Is this likely to cause corruption? Thanks! Dan -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney,

Re: Alter (MyISAM) table while clients connected?

2002-04-16 Thread Paul DuBois
At 10:55 +1000 4/17/02, Daniel Kasak wrote: Hi all. Can I alter a MySQL table (specifically a MyISAM) table while (MS Access) clients are connected? I want to add fields, not alter existing ones. Is this likely to cause corruption? Thanks! MySQL won't alter the table until it can get a write

access denied to root

2002-04-16 Thread root
Description: I just now installed MySQL latest version and I cannot acced the database, even though the MySQLd daemon is running. How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator:root Organization: MySQL support: [none | licence | email support |

access denied on use database, linux on PC

2002-04-16 Thread (Borus.Kung)
After I installed MySQL in linux on a PC, version mysql-3.23.49a-pc-linux- gnu-i686 I created a database named 'ps_db', as followed: mysql create database ps_db; Query OK, 1 row affected (0.00 sec) mysql grant all privileges on ps_db.* to ps_user; Query OK, 0 rows affected (0.00 sec) mysql

access denied on use database

2002-04-16 Thread (Borus.Kung)
Sorry, there was a typing mistake in the previous mail. After I installed MySQL in linux on a PC, version mysql-3.23.49a-pc-linux- gnu-i686 I created a database named 'ps_db', as followed: mysql create database ps_db; Query OK, 1 row affected (0.00 sec) mysql grant all privileges on ps_db.* to

Re: access denied on use database, linux on PC

2002-04-16 Thread Zyxian
Boris, You left off the host name when you issued your grant statement. It should have been like this: mysql grant all privileges on ps_db.* to ps_user@localhost; ormysql grant all privileges on ps_db.* to [EMAIL PROTECTED]; ormysql grant all privileges on ps_db.* to