Re: confirm unsubscribe to mysql@lists.mysql.com
On Wednesday 18 July 2007 19:35, [EMAIL PROTECTED] wrote: To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please click on the following link: http://lists.mysql.com/u/mysql/469e6b8e57586622/kneel.pardoe=virgin.net This confirmation serves two purposes. First, it verifies that we are able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. We haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, [EMAIL PROTECTED] receives messages with return path: mysql-return-number[EMAIL PROTECTED] --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: For help and a description of available commands, send a message to: [EMAIL PROTECTED] To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, just send a message to the address in the ``List-Unsubscribe'' header of any list message. If you haven't changed addresses since subscribing, you can also send a message to: [EMAIL PROTECTED] or for the digest to: [EMAIL PROTECTED] For addition or removal of addresses, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete the transaction. If you need to get in touch with the human owner of this list, please send a message to: [EMAIL PROTECTED] Please include a FORWARDED list message with ALL HEADERS intact to make it easier to help you. --- Enclosed is a copy of the request I received. Received: (qmail 5346 invoked by uid 509); 18 Jul 2007 19:35:41 - X-Spam-Status: No, hits=3.3 required=5.0 tests=ALL_TRUSTED,DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,EMPTY_MESSAGE,MISSI NG_SUBJECT X-Spam-Check-By: lists.mysql.com Received-SPF: neutral (lists.mysql.com: local policy) Received: from smtpout0164.sc1.he.tucows.com (HELO n064.sc1.he.tucows.com) (64.97.136.164) by lists.mysql.com (qpsmtpd/0.32) with ESMTP; Wed, 18 Jul 2007 21:35:41 +0200 Received: from [192.168.0.2] (86.27.58.103) by n064.sc1.he.tucows.com (7.2.069.1) (authenticated as [EMAIL PROTECTED]) id 466CB1C8002D774E for [EMAIL PROTECTED]; Wed, 18 Jul 2007 19:35:28 + From: neal [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Wed, 18 Jul 2007 20:33:11 + User-Agent: KMail/1.9.5 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: [EMAIL PROTECTED] X-Cxn-Txn: 15407466,10424283 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question about using select...where f in (xxx)
I have a quick SQL question that I hope someone can answer, I have two tables Events { e_id int(11), e_name varchar(200) }; Bookings { customer varchar(200), event_list varchar(200) }; Event_list is a string of comma separated values, eg 1,2,4 where the number corresponds to Events.e_id Sample data: Events { {1,'one'}, {2,'two'}, {3,'three'} } Booking { {'john','1,3'} , {'jane','2,3'} } I would like some query that will return 2 rows John, 'one, three' Jane, 'two,three' Is this possible ? I inherited the schema and the data, so I would prefer not having to refactor anything, unless I have to. Thanks in Advance, Neal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
importing after mysqldump --xml
Is there any (easy) way to import the data created by using mysqldump -xml ? I'd like to use the xml feature to export from machine A, massage the data, import into machine B XML works well for my application's needs in terms of massaging the data. Thanks, Neal Katz
problem with mysqldump, ustf8 with mysql 4.1
I need to backup a mysql 4.1 database with UTF8 characters using InnoDB and then restore the backup on another machine I tried the following (same machine - Windows XP) mysqldump.exe -u root stp2 city d1.sql# backup stp2.city mysql.exe -u root t1 d1.sql # restore to t1.city The UTF8 data in city.City is garbage after the transfer , it is valid Thai language characters in the original. CREATE TABLE `city` ( `city_id` int(11) NOT NULL default '0', `City` varchar(25) NOT NULL default '', `EngCity` varchar(25) NOT NULL default '', PRIMARY KEY (`city_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Any help would be appreciated, Neal Katz
using create table with show fields
I would like to do something like Create table xyz as show fields from test.abc; Or maybe Select Field from (show fields from test.abc); Is this possible ?, can I treat the execution of 'show fields' as a select statement Thanks, Neal Katz
Missing mysql.sock file
Hello, I must have installed mysql incorrectly because my suse 8.0 server does not have a mysql.sock file at all. I installed mysql 3.23.48 from rpm packages I installed server bench client Max navigator shared and the required perl bench What happened. Can anyone email me a socket file? Thx -- Best Rgds Graham Neal Cozy MK-IV S/N: 874 http://www.cozybuilders.org/ http://www.cozyaircraft.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Netware vs Linux
Hi, We are currently running MySQL on RedHat Linux with great success. However, we are upgrading our Netware servers to Netware 6. I know MySQL ports to Netware 6, but I am wondering how MySQL actually runs on Netware 6. Is there anyone out there running MySQL on Netware 6? If so, how's going? Is it stable? How does stack up against Linux? Would you recommend switching from Linux to Netware? Any Responses would be great. Thanks in advance, Neal Dawson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trigger
Is there an equivilent to a trigger in mySQL? I need to build a cache mechanism for a website and I thought I'd use MySQL for persistance. The problem is that I need it to schedule a cleanup task every 24 hours - to remove old cache records. MS SQL Server provides a trigger for scheduling such tasks - I am looking for the functional analog on MySQL. Thanks. Neal Cabage - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL logs on Linux
Could someone tell me where the logs are written to by default, for a 3.23 install of MySQL on Linux? I looked in /usr/share/mysql/english and each directory leading up to it, but I didn't see anything resembling a log file. Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multi-table select (not a join)
How do you select from two tables, without joining those tables? I just want the results of one table slapped on the end of the results from another table because I don't want the overheard of running two seperate queries. For instance: Lets say that I have these two tables (and thur values): Foo Bar a1 b1 a3b3 c3 a2 a2 a4 b4 c4 I would like a table (resultset) returned something like this. Of course it would need an additional field to specify which table the values came from: a1 b1foo a2 b2foo a3 b3 c3 bar a4 b4 c4 bar Anyone know how to do a query like this? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: multi-table select (not a join)
Oh man! Yeah, you're right. That's exactly what I want but apparently it wasn't implemented until v4??!?!?! What did people do prior to version 4 when needing to query multiple tables? Just endure the overhead of multiple connections to the database? Thanks. Neal -Original Message- From: Herman Verkade [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 12:14 AM To: 'neal' Subject: RE: multi-table select (not a join) You want to do a UNION. See: http://www.mysql.com/doc/en/UNION.html Regards, Herman Verkade -Original Message- From: neal [mailto:[EMAIL PROTECTED]] Sent: 23 September 2002 07:57 To: mySQL Subject: multi-table select (not a join) How do you select from two tables, without joining those tables? I just want the results of one table slapped on the end of the results from another table because I don't want the overheard of running two seperate queries. For instance: Lets say that I have these two tables (and thur values): Foo Bar a1 b1 a3 b3 c3 a2 a2 a4 b4 c4 I would like a table (resultset) returned something like this. Of course it would need an additional field to specify which table the values came from: a1 b1foo a2 b2foo a3 b3 c3 bar a4 b4 c4 bar Anyone know how to do a query like this? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: multi-table select (not a join)
Thanks for the suggestion but this would actually create a new table, correct (the first statement that is)? I just want a resultset with these values, without writing to disk. On another note, yeah youre right not a different connection object, but I presume I would need to run two seperate queries and recieve back two seperate resultsets. Neal -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 9:21 AM To: neal; mySQL Subject: RE: multi-table select (not a join) At 0:23 -0700 9/23/02, neal wrote: Oh man! Yeah, you're right. That's exactly what I want but apparently it wasn't implemented until v4??!?!?! Right. What did people do prior to version 4 when needing to query multiple tables? Just endure the overhead of multiple connections to the database? Not sure why you'd need multiple *connections*. You can use multiple *queries*, for example like this: CREATE TABLE tmp SELECT ... FROM t1 ... INSERT INTO tmp SELECT ... FROM t2 ... INSERT INTO tmp SELECT ... FROM t3 ... At the end of this, tmp will be the same as if you'd done UNION. More precisely, as if you'd done UNION ALL, because duplicates won't be removed. To remove them, use SELECT DISTINCT when retriving from tmp. Thanks. Neal -Original Message- From: Herman Verkade [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 12:14 AM To: 'neal' Subject: RE: multi-table select (not a join) You want to do a UNION. See: http://www.mysql.com/doc/en/UNION.html Regards, Herman Verkade -Original Message- From: neal [mailto:[EMAIL PROTECTED]] Sent: 23 September 2002 07:57 To: mySQL Subject: multi-table select (not a join) How do you select from two tables, without joining those tables? I just want the results of one table slapped on the end of the results from another table because I don't want the overheard of running two seperate queries. For instance: Lets say that I have these two tables (and thur values): Foo Bar a1 b1 a3b3 c3 a2 a2 a4 b4 c4 I would like a table (resultset) returned something like this. Of course it would need an additional field to specify which table the values came from: a1 b1foo a2 b2foo a3 b3 c3 bar a4 b4 c4 bar Anyone know how to do a query like this? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: multi-table select (not a join)
I just presume that this will add alot of overhead to the query. The reason I wanted to be able to do something like a union rather than seperate queries is because of overhead. I dunno ... am I wrong? Is it not that bad? Also, I tried the query you suggested ... can you really do this(?): insert into tmp select userId from iteneraries I was getting an error 'near insert into'. It seems you're trying to execute a subquery within a query ... can MySQL do this? Thanks. Neal -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 10:09 AM To: neal; mySQL Subject: RE: multi-table select (not a join) At 9:55 -0700 9/23/02, neal wrote: Thanks for the suggestion but this would actually create a new table, correct (the first statement that is)? I just want a resultset with these values, without writing to disk. Then you must upgrade to 4.x so that you have UNION support. Either that, or write a client program that issues multiple SELECT statements and buffers the results in memory. What's your objection to creating the new table? Just delete it when you're done with it. On another note, yeah youre right not a different connection object, but I presume I would need to run two seperate queries and recieve back two seperate resultsets. Neal -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 9:21 AM To: neal; mySQL Subject: RE: multi-table select (not a join) At 0:23 -0700 9/23/02, neal wrote: Oh man! Yeah, you're right. That's exactly what I want but apparently it wasn't implemented until v4??!?!?! Right. What did people do prior to version 4 when needing to query multiple tables? Just endure the overhead of multiple connections to the database? Not sure why you'd need multiple *connections*. You can use multiple *queries*, for example like this: CREATE TABLE tmp SELECT ... FROM t1 ... INSERT INTO tmp SELECT ... FROM t2 ... INSERT INTO tmp SELECT ... FROM t3 ... At the end of this, tmp will be the same as if you'd done UNION. More precisely, as if you'd done UNION ALL, because duplicates won't be removed. To remove them, use SELECT DISTINCT when retriving from tmp. Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
determine value of auto-increment field after adding record - @ runtime
I have a table that will auto increment it's PK field upon adding a new record. I would like obtain that auto-increment value immedicately after the add of that record so that I may reference it within another table ... sort of an informal PK/FK relationship. In SQLServer I believe I recall there was a function something like @@ID to retrieve this value ... could be written directly into your SQL. What sort of function exists in mySQL for this purpose? Thanks. NEal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
date field - default value = current date
Is there a wat to have mySQL auto fill in the current date into my dateCreated field? In SQLServer I would simply specify the getDate() method as a default value. I presume I would use the analogous MySQL function curDate() but it does not appear to work for me. Any suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
tinyInt(7) - not limited to 7 digits???
If Tomcat is installed and pointing to JDK1.3 but one wants to point instead to JDK1.4, is there an easy way to do this? If so, I'm not finding it. Seems like one would need to completely uninstall and reinstall tomcat??? Thanks. Neal [sql,query] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Gui admin clients - security concern?
I had a conversation with my ISP wherein I was told that using a GUI admin tool such as MySQLGUi or MySQL Front is a security concern, but that a tool like phpAdminSQL (??) is better becaise they can lock it down. Is this true? Wouldn't they have the same security issues unless phpAdmin was on an SSL or something? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
primary/foreign key contraints
Sorry for the MySQL newbie question ... but are there not primary/foreign key constraints in MySQL 3? I can't imagine that this is right. Perhaps I'm just overlooking something Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Remote admin app?
What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI? Other? What's most popular and why? Thanks! Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: synopsis of the problem (one line)
Does anyone have any preference regarding the use of Connector/J version 2+ or version 3? I am confused after reading the mySQL website as to whether some of the following features are new as of version 2 or version 3 of the driver: 1. 50-100% faster than previous version. 2. Supports prepared statement. These factors plus any positive/negative experience would be valuable in making a decision as to which version of the driver to use. Any thoughts? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connector/J - which version
Does anyone have a preference on whether to use V2 or v3(beta) of Connector/J? I read on the mySQL site that there are some new features that seemed significnat (support of prepared statements, and 50-100% faster) ...but I couldn't tell if these were new as of v2 or v3. There might also be other important new features to consider. Does anyone have any recommendations? FYI - I'm woriking with Tomcat 4.0.3 and will be doing conn pooling via JNDI on tomcat. Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JDBC - Access denied (using password: yes)
Does anyone know why I would recieve this error, when attmepting to connect to mySQL via JDBC(driver=Connector/J 3.0 beta) I can connect if I provide no password (even if the account specifies a pwd)? I can connect correctly using MySQL Front ... but JDBC is giving me this error. javax.servlet.ServletException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JDBC - Access denied (using password: yes)
Thanks for the response. I am using this (where 'bob' is both the uid and the pwd value): Connection myConn = DriverManager.getConnection(jdbc:mysql:///test?user=bobpassword=bob); That does not work. Dispite having specified a password of 'bob', this DOES work: Connection myConn = DriverManager.getConnection(jdbc:mysql:///test?user=bobpassword=); That's the wierd part. I'll try explicitly naming localhost but I think that is implied(?). Cheers. Neal -Original Message- From: suresh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 7:50 PM To: neal Subject: Re: JDBC - Access denied (using password: yes) Are you using Connection con = DriverManager.getConnection(jdbc:mysql://localhost/database_name?user=root ) ; If not try this regards Kayamboo Suresh At 07:27 ßã 02/08/28 -0700, you wrote: Does anyone know why I would recieve this error, when attmepting to connect to mySQL via JDBC(driver=Connector/J 3.0 beta) I can connect if I provide no password (even if the account specifies a pwd)? I can connect correctly using MySQL Front ... but JDBC is giving me this error. javax.servlet.ServletException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JDBC - Access denied (using password: yes) - RESOLVED
Alright ... I figured it out (sort of)... When I created a user account I put the value '%' in the host field of the mysql.user table. I was following the example of the root account that was already specified in the table. Apparently if I make that if I change that '%' to 'localhost' its fine. I don't really understand why but it fixed it... Neal -Original Message- From: neal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 7:28 PM To: mySQL Subject: JDBC - Access denied (using password: yes) Does anyone know why I would recieve this error, when attmepting to connect to mySQL via JDBC(driver=Connector/J 3.0 beta) I can connect if I provide no password (even if the account specifies a pwd)? I can connect correctly using MySQL Front ... but JDBC is giving me this error. javax.servlet.ServletException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
users Permission Oddity
Here's an odd one. I am connecting via JDBC using an account that apparently has no permissions granted to it ... even select_priv (straight Ns across the table). And yet ... I can do select statements with it ... no problem. How could that be? Is is possible this could be related to the previous issue wherein I was able to connect using an account bob@% where a password was specified int he account, even though I provided no password while logging in? I should note that I am using MySQL 4.0.1 ... perhaps this explains these issues Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JDBC - Access denied (using password: yes)
Well, it looks like the issue was resolved by changing host from % to localhost. I don't understand what the % is, but that apparently that fixed it. I'm pretty sure its not the older driver issue ... this is the first install of connector/J I've ever put on this machine, and I'm using 3.0 Beta. :) Thanks. Neal -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 8:03 PM To: neal Cc: suresh; mySQL Subject: Re: JDBC - Access denied (using password: yes) neal wrote: Thanks for the response. I am using this (where 'bob' is both the uid and the pwd value): Connection myConn = DriverManager.getConnection(jdbc:mysql:///test?user=bobpassword=bob); That does not work. Dispite having specified a password of 'bob', this DOES work: Connection myConn = DriverManager.getConnection(jdbc:mysql:///test?user=bobpassword=); That's the wierd part. I'll try explicitly naming localhost but I think that is implied(?). Cheers. Neal -Original Message- From: suresh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 7:50 PM To: neal Subject: Re: JDBC - Access denied (using password: yes) Are you using Connection con = DriverManager.getConnection(jdbc:mysql://localhost/database_name?user=root ) ; If not try this regards Kayamboo Suresh At 07:27 ßã 02/08/28 -0700, you wrote: Does anyone know why I would recieve this error, when attmepting to connect to mySQL via JDBC(driver=Connector/J 3.0 beta) I can connect if I provide no password (even if the account specifies a pwd)? I can connect correctly using MySQL Front ... but JDBC is giving me this error. javax.servlet.ServletException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php I bet you're actually not using Connector/J. This is a bug from a _very_ old version of MM.MYSQL...Make sure MM.MySQL is not hanging around _anywhere_ on your CLASSPATH. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JDBC - Access denied REVISED = simply won't accept passwords when logging in
Let me revise the problem description: Both mySQL Front *AND* JDBC can connect if I do not specify a password when logging in...EVEN IF A PASSWORD IS SPECIFIED IN THE ACCOUNT. Yet, if I specify the password while logging in (a scenario that SHOULD work), I am declined. Obviously I am a mySQL newbie. Is there some place in mySQL that I must specify that it will use the passwords specified, when authenticating users? Thanks. Neal -Original Message- From: neal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 7:28 PM To: mySQL Subject: JDBC - Access denied (using password: yes) Does anyone know why I would recieve this error, when attmepting to connect to mySQL via JDBC(driver=Connector/J 3.0 beta) I can connect if I provide no password (even if the account specifies a pwd)? I can connect correctly using MySQL Front ... but JDBC is giving me this error. javax.servlet.ServletException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Saving and re-using SQL statements
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 use vi's e filename to get the file, but then when I :wq out of vi it restores the previous SQL statement I had input before grabbing the file with the e option. Thanks, Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Saving and re-using SQL statements
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: Saving and re-using SQL statements 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' syntax. But it sounds like you have some other issues, can u please shed more light on the problem you are having? In the meantime take a look at: http://www.mysql.com/doc/m/y/mysql.html and http://www.mysql.com/doc/B/a/Batch_mode.html Gurhan -Original Message- From: Neal Caidin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 3:14 PM To: [EMAIL PROTECTED] Subject: Saving and re-using SQL statements 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 use vi's e filename to get the file, but then when I :wq out of vi it restores the previous SQL statement I had input before grabbing the file with the e option. Thanks, Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php