Cannot SELECT TO OUTFILE

Hi, I have a user for doing a select-to-outfile, and I've granted both the file privilege and also (just for the table in question) the select privilege to that user. Trying it at the command-line gives me "Access denied..." which seems like it can't be the case having granted the correct privil

innodb_buffer_pool_size too large

Hi all. I'm testing configuration of InnoDB tables in MySQL database server. The documentation of MySQL says that a good configuration for innodb_buffer_pool_size (the buffer) is 80% of physical memory if the computer is a dedicated MySQL server. I have 1GB of memory, then I set innodb_buffer_poo

Creating a Foreign Key

Hi All I am currently using 3.23.49 Max on Win 2K. I just saw from the docs that this version supports foreign key...So i just thought of working on it... I just created two tables parent and child CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, pa

Re: innodb rollbacks

Walt, Jeremy, the undo logs (= rollback segments) in the tablespace generally take much less space than the inserted rows. Thus it is best just to look with SHOW TABLE STATUS what is the available free space. I think in Oracle rollback segments use a lot more space than in InnoDB. However, if th

Dumping in the right order (Innodb)

Hello, i have a problem with foreign key constrains. If i dump some tables (type = innodb) with mysqldump, i get a dump, which is in alphabetical order. The problem is now, if the first table has an foreign key to the second table, i will get an error, if i dump the dump into the database.

Re: about crash

Hongliu, what do you do mean with 'copying tables to another disk'? What did you do? Did you kill the mysqld server? What is the MySQL version and what OS? The assertion below means the rollback of a transaction is trying to free a database page which already is free. Thus the tablespace free sp

mysql++

Hi all, i want to know if i can work with mysql++ with both sql server and mySql thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

mysql-3.23.50

Hi all i have mysql-3.23.41 should i install 3.23.50? what are the differences between this versions? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Dumping in the right order (Innodb)

Soren, the SQL command SET FOREIGN_KEY_CHECKS=0 is in the TODO list of May 2002. It will probably be in 3.23.52. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.

Cannot SELECT TO OUTFILE

Hi, I have a user for doing a select-to-outfile, and I've granted both the file privilege and also (just for the table in question) the select privilege to that user. Trying it at the command-line gives me "Access denied..." which seems like it can't be the case having granted the correct privil

Re: Cannot SELECT TO OUTFILE

mysql-readers, Thursday, May 30, 2002, 10:38:14 AM, you wrote: mr> I have a user for doing a select-to-outfile, and I've granted both the mr> file privilege and also (just for the table in question) the select mr> privilege to that user. mr> Trying it at the command-line gives me "Access denied.

Re: timestamp

r, Thursday, May 30, 2002, 12:35:58 PM, you wrote: r> in a timestamp field, do I have to provide the values? r> eg r> create table ryan(t_imestamp timestamp(8), name varchar(30)); r> how do I insert? do I have to specify the value? if so how do I get the r> value to specify it? r> The man

Re: SQL Update Query with join

Joe, Wednesday, May 29, 2002, 1:28:42 AM, you wrote: JC> We have 3 tables: Users, List, and UsersList (a join table). How can I JC> write a correct update statement to update the STATE field in the Users JC> table for a certain List? For example, is the following UPDATE correct: JC> Update Us

Re: Re: Foreign Keys and NULL

Chris, Thursday, May 30, 2002, 1:58:54 AM, you wrote: >> CREATE TABLE parent(id INT NOT NULL, >> PRIMARY KEY (id)) TYPE=INNODB; >> >> CREATE TABLE child(id INT, parent_id INT, >> INDEX par_ind (parent_id), >> FOREIGN KEY (parent_id) REFERENCES parent(id) >>

Fwd: NDN: Cannot SELECT TO OUTFILE

So, why do I keep getting the following? What does it mean? Has my mail been delivered to the mailing list or not? This is a forwarded message From: Mailer-Daemon <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Thursday, May 30, 2002, 11:20:03 AM ===8<==Original message text==

Re[2]: Cannot SELECT TO OUTFILE

Egor, EE> Yeah, "Access denied" error means that user doesn't have necessary EE> permissions. Can you provide some more info? i.e. full error EE> message, how did you set up file_priv using GRANT statement or EE> updated privilege tables manually? What version MySQL client and EE> server do you u

Re: mysql-3.23.50

I think you'll find some usefull infos here : http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.2 3.x Just one thing : 3.23.50 tar.gz and rpm is little different because Mysql team used a newer gcc version ... Bye David - Original Message - From: "Inbal Ovadia" <

JDBC Transactions

Hi All, We are currently running a website which is running on Weblogic and Oracle DB.I just thought of porting it to JBoss and MySQL. Well..i am not sure how far does MySQL supports Transactions.. I am currently using 3.23.49 Max on Win 2K. Does this version of MySQL Supports transaction... -

Re: mysql-3.23.50

At 12:44 PM +0200 5/30/02, Inbal Ovadia wrote: >Hi all >i have mysql-3.23.41 >should i install 3.23.50? >what are the differences between this versions? http://www.mysql.com/doc/N/e/News-3.23.x.html -- ++ | Steve Edberg

Re: mysql-3.23.50

On Thu, 30 May 2002, Inbal Ovadia wrote: > i have mysql-3.23.41 > should i install 3.23.50? > what are the differences between this versions? some bugs fixed, possibly some others introduced :-(( check http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.x Thomas -- s

InnoDB and My ISAM Tables

Hi All First of all i would like to know the basic difference between Inno DB and My ISAM Table types.. I wanted mySQL to support AutoIncrement , Transactions,Foreign Key Constraints,Blob, Text etc...so as per the documents i thought of using a InnoDB Table... Currently i am using 3.23.49 Max o

Re: JDBC Transactions

Arul wrote: >Hi All, > >We are currently running a website which is running on Weblogic and Oracle >DB.I just thought of porting it to JBoss and MySQL. > >Well..i am not sure how far does MySQL supports Transactions.. >I am currently using 3.23.49 Max on Win 2K. > >Does this version of MySQL Supp

Re: JDBC Transactions

Thanx Mark But i am new to MySQL... First of all i would like to know the basic difference between Inno DB and My ISAM Table types.. I wanted mySQL to support AutoIncrement , Transactions,Foreign Key Constraints,Blob, Text etc...so as per the documents i thought of using a InnoDB Table... Curr

Running Multiple MySQL Servers on the Same Machine

Hi all, I want to run multiple mySQL servers on my machine. Can i do this on windows 2000 or just on Unix? because the manual talk about Unix. How can i do this on windows? thanks - Before posting, please check: http://www.m

Fw: JDBC Transactions

- Original Message - From: "Luca Lafranchi" <[EMAIL PROTECTED]> To: "Arul" <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 5:10 PM Subject: Re: JDBC Transactions > Hi Arul, this is not a direct answer to your question, only a note about > foreign keys and MySQL: if I'm right (please so

RE: Running Multiple MySQL Servers on the Same Machine

You have to look a bit more. There is lots about runing MySQL on windows. It also will not get the MS SQL worm that is about So just have a nother look it will be woth it. Simon PS start.. http://www.mysql.com/doc/W/i/Windows_installation.html -Original Message- From: Inbal

RE: mysql-3.23.50

On the MySQL download page, 3.23.50 is not available, only 3.23.49a. Is that the same thing? Rick -Original Message- From: David BORDAS [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 5:34 AM To: Inbal Ovadia Cc: [EMAIL PROTECTED] Subject: Re: mysql-3.23.50 I think you'll find

Re: mysql-3.23.50

Try http://www.mysql.com/downloads/mysql-3.23-pre.html Mehalick, Richard RE SITI-ITPSCA wrote: >On the MySQL download page, 3.23.50 is not available, only 3.23.49a. Is >that the same thing? > >Rick > > > -- -- \|/ __\|/ `@" / o

sql question

I have a table one with the following format: groupAgroupBgroupC ref1 ref2 ref1 ref2 ref3 ref2 ref4 ref2 ref1 another table two will have the full name for those ref. ref_id name ref1 actual_name1

Re: InnoDB and My ISAM Tables

Arul, do the equivalent of mysqladmin variables | grep 'inno' | less and check that innodb is up and running. Thomas -- sql, query On Thu, 30 May 2002, Arul wrote: > Hi All > > First of all i would like to know the basic difference between Inno DB and > My ISAM Table types.. > > I wanted

Time-out Error

Hi I am using mysql 3.2133b, Sun Solaris 2.6, JHTML and Apache. I have been getting Time-out requesting db connectionUnable to connect to database server where url was jdbc:z1MySQL://localhost:3306 error whenever the JHTML is initialized for the first time. It works fine when i click on the refre

Re: sql question

create table newTableOne select A.name as groupA, B.name as groupB, C.name as groupC from tableOne, tableTwo as A, tableTwo as B, tableTwo as C where tableOne.groupA = A.ref_id and tableOne.groupB = B.ref_id and tableOne.groupC = C.ref_id; Then re-add your indices and integrity constraints, doubl

Re: Extracting binary data from a row

All the numeric types are returned as strings. If you want to convert them to numbers, you need to use scanf or atod type functions. Michael Flora wrote: > Hello all, this is my first post to this list. I am relatively new to > MySQL, and my question might be a basic one. > > I have a table

INNODB / Foreign Keys / mysqldump

Hello all, I am testing MySql Max 4.0.1 alpha. I have configured innodb tablespace and created the two manual tables example. But when I try to do a mysqldump to re-create the tables on another DB or 'SHOW CREATE TABLE child', NO-FOREIGN key information is gathered on results. However 'SHOW

Re: innodb_buffer_pool_size too large

Hi Iago, This is really a freebsd related question and not MySQL. I believe that the archives contain some info. Anyway you need to build a custom kernel for freebsd see /usr/src/sys/i386/conf/LINT. look for this section: # Certain applications can grow to be larger than the 128M limit # that

mysql -u is not working for me today but was yesterday

I have read the documentation and I understand the grant and revoke but mysql -u is just not working for me. Yesterday I was able to do a mysql -u root and it would ask me for my password and I would enter the one that I created for root in my grant statement and it would let me in. But any othe

changing column name

Hi Can anyone plz give me the query for chaning the column name of an existing table(which does not affect the elements of that column). I hope there is a way to do that. Any help appreciated Thanx Anil - Before posting, ple

RE: changing column name

ALTER TABLE tablename CHANGE oldname newname VARCHAR(40) Simon -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 15:37 To: MySql Mail List Subject: changing column name Hi Can anyone plz give me the query for chaning the column name of an existing table

Trasfer SQL requests

Hello Is it possible to set up one mysql server *only* for listening on socket and transfer client requests to another one server through network connection ? Of course I mean return results too :-) -- Dimitry - Before posti

Binary File in DB vs. File in directory --looking for archived discussion

I'm trying to find any and all thoughts on whether to store files in the db (PDF's, word docs etc) or in the filesystem. If I do in the fs then there is tons of overhead because of new folders, each client having thier own folder(and subfolders) etc. And then htaccess'ing the dir's independentl

Re: Trasfer SQL requests

On Thu, May 30, 2002 at 05:53:03PM +0300, Dmitry Alyabyev wrote: > Is it possible to set up one mysql server *only* for listening on > socket and transfer client requests to another one server through > network connection ? Of course I mean return results too :-) It sounds like what you want can

Re: InnoDB and My ISAM Tables

Arul, Thursday, May 30, 2002, 2:05:52 PM, you wrote: A> First of all i would like to know the basic difference between Inno DB and A> My ISAM Table types.. Check the manual: http://www.mysql.com/doc/T/a/Table_types.html A> I wanted mySQL to support AutoIncrement , Transactions,Foreign Key

Re: mysql-3.23.50

Inbal, Thursday, May 30, 2002, 1:44:34 PM, you wrote: IO> i have mysql-3.23.41 IO> should i install 3.23.50? Since 3.23.41 there was fixed a lot of bugs and made a lot of changes. I suggest you to upgrade MySQL to a newer version, but there is only a pre-release of 3.23.50 existent, on which a n

Re: Re[2]: Cannot SELECT TO OUTFILE

mysql-readers, Thursday, May 30, 2002, 1:31:50 PM, you wrote: EE>> Yeah, "Access denied" error means that user doesn't have necessary EE>> permissions. Can you provide some more info? i.e. full error EE>> message, how did you set up file_priv using GRANT statement or EE>> updated privilege tables

Re: changing column name

Anil, Thursday, May 30, 2002, 5:36:32 PM, you wrote: AG> Can anyone plz give me the query for chaning the column name of an existing AG> table(which does not affect the elements of that column). AG> I hope there is a way to do that. Use ALTER TABLE to change column name: http://www.mysql.

Anyone know how to update SET datatypes

OK, I cannot find this sql query on the website or in any of my manuals. I have a table that contains a set datatype eg CREATE TABLE testjason ( ID int(11) NOT NULL auto_increment, SomeSetColumn set('a','b','c') NOT NULL default '', ) TYPE=MyISAM; I neet to perform an UPDATE on this ta

Response time problem with MYSQL

Hi, Can anyone help me on this: I have a MYSQL installed on a LINUX server. My problem is: The response time to a MYSQL request is sometimes very long (30s). I have the following logs in file mysqld.log: 020529 14:52:44 22 Connect atos@was02 on 22 Init DB pve 020529 14:52:48

Re: Trasfer SQL requests

Philip Mak wrote: > On Thu, May 30, 2002 at 05:53:03PM +0300, Dmitry Alyabyev wrote: >> Is it possible to set up one mysql server *only* for listening on >> socket and transfer client requests to another one server through >> network connection ? Of course I mean return results too :-) > > It so

Replication Bug

This may perhaps be an old bug and already fixed entry in my.cnf replicate-do-db=qbslive Slave stopped replicating at some time ( not in logs ) I tried to start it back up and it would not budge so I checked the logs 020530 9:55:15 Slave: connected to master '[EMAIL PROTECTED]:3306', repli

MySQL Full-text search

Hi, We have two major concerns with the full-text search in MySQL. They appear to be simple problems that can be fixed. We are about to use MySQL in a big way, and we would like to license it, however these problems are a major obstacle that must be fixed (or at least understood). 1) Using the w

MySql vs Access

Hi all, How is MySql compare to Access database? I understand that Access database is fit for a small environment where you have 5 to 10 users. Can MySql handle larger environment like Oracle, Microsoft SQL or it is just like Access? _

=?ISO-8859-1?Q?RE: Binary File in DB vs. File in directory --looking for archived discussi=

on?= From: [EMAIL PROTECTED] MIME-Version: 1.0 Cc: Return-Path: [EMAIL PROTECTED] Originating-IP: 213.89.182.213 X-Priority: 3 X-Mailer: DCS.net Webmail ver. 0.1 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Why not use the best part from both !!! u

Re: please help me understand users & privileges

At 23:49 29/5/2002 -0400, Charles Brown wrote: Hi, >I removed the "user=" and "password=" entries from the my.ini >file, because I didn't like seeing a password exposed in plain text. >This seemed to have no effect on MySQL at all. What are those >entries for? Do I need them? What should they b

Re: Running Multiple MySQL Servers on the Same Machine

At 14:28 30/5/2002 +0200, Inbal Ovadia wrote: Hi, >Hi all, >I want to run multiple mySQL servers on my machine. >Can i do this on windows 2000 This will possible with the next release of 4.0.2 >or just on Unix? Regards, Miguel -- For technical support contracts, goto https://order.mysql.c

Re: MySQL Full-text search

On Thu, May 30, 2002 at 08:15:41AM -0700, Ryan Barber wrote: > 2) Why would these sample words have no match? > Cannot match against "when", "most", "like", "goes" Why are these > words not in the index? The file contains 1 million title records > and all of these words are in the file many times.

Re: Search and replace

Hello all, I am trying to change part of a field across several hundred rows, and am having difficulties. Here's the setup: I have rows with field values of "Rodregues0001" through "Rodregues0214". What I wish to do is change the "Rodregues" to "TampaBay" while leaving the number intact. Is ther

RE: MySql vs Access

[snip] How is MySql compare to Access database? I understand that Access database is fit for a small environment where you have 5 to 10 users. Can MySql handle larger environment like Oracle, Microsoft SQL or it is just like Access? [/snip] In my experience M$ Access really can only handle 2-3

Rows from STATUS differs from SELECT COUNT(*)

Hi all. I have two questions about InnoDB table type. 1) I execute command SHOW TABLE STATUS for a table and the value for column Rows is different from the result of SELECT COUNT(*) for that table. mysql> SHOW TABLE STATUS LIKE 'ALBARANCL'; +---++++-

How to fix errcode:13?

Hello every one: I have a problem modifying the structure of a table: ALTER TABLE t_logs CHANGE log_id log_id INT(11) NOT NULL AUTO_INCREMENT; ERROR 1: Can't create/write to file './intranet/#sql-484_285.frm' (Errcode: 13) I made sure that the rights on the MYI, MYD and frm file

Need help with query result

Hello Everyone, I haven't used SQL in a long time and I am having trouble designing the query to get the result I need. I have 1 select query that looks like this: SELECT WC.FIRST_NAME & ' ' & WC.LAST_NAME AS NAME, C.COMM_NO AS PHONE FROM WRK_CNTRCTR AS WC, WRK_COMM_NUMBER AS C WHERE WC.PERS_ID =

Re: How to fix errcode:13?

"LeTortorec, Jean-Louis" a écrit : > > Hello every one: > > I have a problem modifying the structure of a table: > ALTER TABLE t_logs CHANGE log_id log_id INT(11) NOT NULL > AUTO_INCREMENT; > ERROR 1: Can't create/write to file './intranet/#sql-484_285.frm' > (Errcode: 13) > >

Re: Rows from STATUS differs from SELECT COUNT(*)

On Thu, May 30, 2002 at 06:18:46PM +0200, Iago Sineiro wrote: > Hi all. > > I have two questions about InnoDB table type. > > 1) I execute command SHOW TABLE STATUS for a table and the value for column > Rows is different from the result of SELECT COUNT(*) for that table. > > mysql> SHOW TABLE

Re: MySQL Full-text search

Thanks Philip, I spent some time looking for that list, but obviously didn't look hard enuf. Ryan > > 2) Why would these sample words have no match? > > Cannot match against "when", "most", "like", "goes" Why are these > > words not in the index? The file contains 1 million title records > > an

Re: Eliminating downtime

How would you guarantee the success of the transaction? If it fails as a result of a hardware failure, then ultimately, the system as a whole has suffered a hardware failure. If it fails for any other reason, then it's an issue with software or bad data. Once those things are figured out, you p

Re: innodb rollbacks

On Thu, May 30, 2002 at 12:16:28PM +0300, Heikki Tuuri wrote: > > However, if there are lots of updates, and the user has a dangling > uncommitted consistent read to the database for a long time, then the size > of the undo logs may become significant also in InnoDB. I have to consider > adding t

Re: BDB wrapped transaction id's

On Thu, May 09, 2002 at 09:31:06AM +0100, Robert Cross wrote: > > BTW, a big "thank you" to whomever wrote "mysqlbinlog" as it saved the day! > (my database was well and truely broken) That's Sasha. He wrote most (all?) of the replication code in MySQL. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]

RE: mysql -u is not working for me today but was yesterday

I've sent similar questions to the list with no replies so here's the best I can do for you. I use debian so I dunno what's specific to it beyond the created user to start and stop the damon so; try mysqlaccess user host db to see what privileges you've got. u can restart msyql or safe_mysql

RE: changing column name

I believe that's modify. Check man page. Alter table yourtablename MODIFY yourfieldname varchar (25) (or whatever ) not null default 'no comment' -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 7:37 AM To: MySql Mail List Subject: changing col

Recall: Need help with query result

Memon, Michele would like to recall the message, "Need help with query result". - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

count...I think

Hey guys, I have a very simple question, I though I knew the answer but the MySql manual has confused me I have a simple select from a database of say...1k records...I use select id from myTable where sal>1000; Lets say this statement would normally return 132 records, but how do I kn

ADO recordset is not returning rows in ASP page

I have an active server page using an ADO recordset. When the SQL command is a join of two tables with a count/group by there are no records being returned (RS.EOF is true). code snippet: dbConn = "DSN=dbTestCases" sqlVar = "Select " & _ "TestCases.TestCaseId, Count(*)" & _ " from TestCaseProject

RE: count...I think

select count(*) from myTable where sal > 1000; Ryan Sander Web Developer [EMAIL PROTECTED] http://cantonrep.com > -- > From: [EMAIL PROTECTED] > Sent: Thursday, May 30, 2002 2:24 PM > To: [EMAIL PROTECTED] > Subject: count...I think > > > Hey guys, > I have a ver

Re: count...I think

In short, it would be "LIMIT 20,0" If I'm not mistaken. However, the db isn't going to kick out the string "The query returned 0-20 of 132 records" for you. Are you trying to do database pagination? Mulitple rows spread across multiple page views? If that's the case, PHPBuilder has an article

Re: innodb rollbacks

On Thu, May 30, 2002 at 10:43:58AM -0700, Jeremy Zawodny wrote: : Heikki, : : That reminds me of an InnoDB wish-list item I have. I like the level : of detail provided in the InnoDB monitor output. However, I'd really : like to be available via MySQL rather than just in the logs. That : will m

Re: innodb rollbacks

On Thu, May 30, 2002 at 02:30:07PM -0500, Philip Molter wrote: > On Thu, May 30, 2002 at 10:43:58AM -0700, Jeremy Zawodny wrote: > : Heikki, > : > : That reminds me of an InnoDB wish-list item I have. I like the level > : of detail provided in the InnoDB monitor output. However, I'd really > :

Re: MySql vs Access

At 10:25 AM 5/30/2002, you wrote: >Hi all, > >How is MySql compare to Access database? I understand that Access >database is fit for a small environment where you have 5 to 10 users. Can >MySql handle larger environment like Oracle, Microsoft SQL or it is just >like Access? Andy,

Re: Binary File in DB vs. File in directory --looking for archived discussion

On 30 May 2002, at 8:58, Dan Vande More wrote: > If I do in the fs then there is tons of overhead because of new > folders, each client having thier own folder(and subfolders) etc. > And then htaccess'ing the dir's independently along with the > overhead of keeping track of the htaccess files. T

Finding holes in autoinc sequences

I'm going to be tackling this problem in a few days and I wanted to bounce it off of a few MySQL heads first to see if it generates any ideas. (or sparks?) Here's is the problem. I have an auto-inc column and rows will get deleted from the table and of course it will create a hole in the seque

Re: count...I think

At 01:24 PM 5/30/2002, you wrote: >Hey guys, >I have a very simple question, I though I knew the answer but the MySql >manual has confused me > >I have a simple select from a database of say...1k records...I use > >select id from myTable where sal>1000; > >Lets say this statement would n

Bad optimization with ENUM ?

Hello, I have the following kind of table : CREATE TABLE route ( route_k BIGINT UNSIGNED NOT NULL, state ENUM('down', 'up') NOT NULL, [ ... other columns ...] PRIMARY KEY (route_k), KEY state (state) ) TYPE = MyISAM; --- Now here is the time taken by

Re: Finding holes in autoinc sequences

On Thu, May 30, 2002 at 03:17:53PM -0500, mos wrote: > I'm going to be tackling this problem in a few days and I wanted to bounce > it off of a few MySQL heads first to see if it generates any ideas. (or > sparks?) > > Here's is the problem. I have an auto-inc column and rows will get deleted

"%" not matching "localhost" ?

I have been trying to use the commandline mysql program, but I can't log in from the same machine: [root@linux01 rcv]# mysql -u jwgas -p Enter password: ERROR 1045: Access denied for user: 'jwgas@localhost' (Using password: YES) But if I specify an ip address, I can !? [root@linux01 rcv]# mysql

Recent Updates

Where/how can I access the most recently updated code for MySQL Max 4.x. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

what causes this error

mysqladmin: CREATE DATABASE failed; error: 'You have an error in your SQL syntax near 'whateverunamethedatabase' I can complete every function with msyqladmin except create and drop. What am I doing wrong. I've read all the docs online, sent similar emails with no response. This is not an acce

Re: Interesting datetime problem

Hi. I meant the system environment variable. I do not really believe that it causes the problem, because it shouldn't be able to shift by a whole day. But this is the only thing I know of which may influence time values. On second thought, I really think it isn't TZ, because that influences only

Re: Recent Updates

In the last episode (May 30), Anthony W. Marino said: > Where/how can I access the most recently updated code for MySQL Max > 4.x. http://www.mysql.com/doc/I/n/Installing_source_tree.html -- Dan Nelson [EMAIL PROTECTED] --

Re: first mysql table; syntax qustion

Hi. On Tue, May 28, 2002 at 04:32:20PM -0700, [EMAIL PROTECTED] wrote: > Thanks for the reply! Should I change the structure such that all > varchar fields are in the same table? I see no reason for this. It may make a (minor) speed difference, but you should only ever change your table layout

Re: first mysql table; syntax qustion

Hi. On Tue, May 28, 2002 at 06:51:11PM -0400, [EMAIL PROTECTED] wrote: > How do you reference a column name in another table to avoid repeating the > values? I am not sure if I understand you correctly, but I assume you mean this: Given the following table layout (it's a simplification in that

[BUG] Excess Privileges required for SELECT INTO OUTFILE

Hi, (FYI: "mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386)") After extensive testing, I have found that: - (a) [SIDE ISSUE] Logged-in as a user (using password) and modifying privileges in another MySQL (root) session, even with "flush privileges", the privileges do not

RE: Finding holes in autoinc sequences

A simple and fast way to find the gaps is to use a self LEFT JOIN, such as: select a.id from seq a left join seq b on a.id + 1 = b.id where b.id is null; The result set will show any row in seq where there was no record with ID one greater than that record's value. You'll get back the last row,

Re: what causes this error

Justin, The error message states that you have a syntax error in the CREATE DATABASE statement. This is probably just a typo, but the only way for us to diagnose the problem is for you to post the exact statement that gives you the error. -myk justin cunningham wrote: >mysqladmin: CREATE

RE: what causes this error

mysqladmin create test2 mysqladmin: CREATE DATABASE failed; error: 'You have an error in your SQL syntax near '`test2`' at line 1' -Original Message- From: Myk Melez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 2:59 PM To: [EMAIL PROTECTED] Cc: mysql Subject: Re: what causes t

C library vs PHP connection

I have a program prototyped in PHP that works fine, but when I convert it to C using libmysqlclient the program fails inside the mysqlclient library with a segmentation fault on a particular query. It fails on two different platforms (Linux and Mac OS X). The database I'm using is very simple

Re: C library vs PHP connection

You forgot to include your C code. :) Adam Hooper [EMAIL PROTECTED] On Thu, 30 May 2002 15:59:31 -0700 Bill Rausch <[EMAIL PROTECTED]> wrote: > I have a program prototyped in PHP that works fine, but when I > convert it to C using libmysqlclient the program fails inside the > mysqlclient lib

MySQL-4.0.1-2: Bug in LOAD DATA and SOURCE statements?

Hi! I suspect that there might be a bug in the LOAD DATA and SOURCE statements of MySQL-4.0.1-2 (alpha), but since I'm not 100% sure, I am sending this to the list and maybe someone else migt be able to reproduce... My configuration: RedHat Linux 7.3 on i686 MySQL-4.0.1-2 server+client MySQL bu

Re: what causes this error

Hi. This works fine for me. What is the output of mysqladmin -V mysqladmin version ? Bye, Benjamin. On Thu, May 30, 2002 at 03:09:11PM -0700, [EMAIL PROTECTED] wrote: > mysqladmin create test2 > mysqladmin: CREATE DATABASE failed; error: 'You have an error in your > SQL syntax near

RE: what causes this error

exactly.mysqladmin -V mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686 this and every other command in mysqladmin work except for create and drop. dunno why. I'd like to get on to building databases instead of permissions over and over. I ssh into the box. User/pass are sa

Installation fail for mysql 3.23.49 on sun solaris 2.8

Hi professional, I got the following error when I install mysql 3.23.49 binary on sun solaris 2.8: ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or directory Killed Installation of grant tables failed! Could you tell me where I can get this library libz.so.1 installed? Than

Re: [BUG] Excess Privileges required for SELECT INTO OUTFILE

Hello. On Thu, May 30, 2002 at 10:52:46PM +0100, [EMAIL PROTECTED] wrote: > Hi, > > (FYI: "mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386)") 3.23.36 is a bit outdated by now (more than a year old) and there have been several bug fixes regarding GRANT/REVOKE since then. So you may c

Re: Trasfer SQL requests

Hi. On Thu, May 30, 2002 at 06:15:07PM +0300, [EMAIL PROTECTED] wrote: > Philip Mak wrote: > > It sounds like what you want can be accomplished by a simple "port > > forwarder" program (search for that phrase on Google) which listens on > > one TCP/IP port and forwards the results to another TCP/

  1   2   >