Re: access denied error

2008-10-10 Thread Jesse
Sorry to have bothered you. I believe I found the problem. I had a 1 (One) in the password instead of a l (L). it was working from the command prompt, because I was typing it in the same way, but from the application, it was stored. So, basically, I had the password wrong. Thanks, Jesse

How could i check the following values in MySQL Server 5.0

2008-10-10 Thread Sudhir Menon
Thanks Amit ... Thanks Regards Sudhir

Re: How could i check the following values in MySQL Server 5.0

2008-10-10 Thread mos
At 09:11 AM 10/10/2008, Sudhir Menon wrote: Thanks Amit ... Thanks Regards Sudhir Sudhir, What following values? I think you're missing part of your post. (send text only) Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

access denied error

2008-10-10 Thread Jesse
I have a PHP application that I inherited. I have it running on a Ubuntu 8.04 virtual machine. I have set up a user to access the MySQL database, and from the command prompt, I can access it just fine. For instance, from the Ubuntu prompt, if I type MySQL -umyuser -p, it asks me for the

Re: access denied error

2008-10-10 Thread Jim Lyons
What is the PHP connect string? Are you connecting to the database you have access to? are you connecting as the same user (myuser)? Do other php applications work, so you know it's not a php-mysql issue? On Fri, Oct 10, 2008 at 6:59 AM, Jesse [EMAIL PROTECTED] wrote: I have a PHP application

RE: Finding gaps

2008-10-10 Thread Jerry Schwartz
Thanks. Although I've been around SQL for quite a while, I've never really gotten the hang of self-joins. From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 8:22 PM To: US Data Export; mysql@lists.mysql.com Subject: Re: Finding gaps Jerry, Here is a

RE: Trouble with large data in MySql

2008-10-10 Thread Mary Bahrami
Maybe you can paste back the results from an 'explain' statement...also would be helpful to see the indexes on this table. Show create table smas \G; -Original Message- From: Karthik Pattabhiraman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 3:30 AM To:

MySQL TPC benchmark

2008-10-10 Thread Sachin Gaikwad
Hi all Is there a MySQL TPC benchmark available to download ? If someone is aware of such a thing, let me know. Thanks, Sachin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL TPC benchmark

2008-10-10 Thread Sachin Gaikwad
On Fri, Oct 10, 2008 at 6:29 PM, Martin Gainty [EMAIL PROTECTED] wrote: Hello Sachin have you looked at using Benchmark Suite? http://dev.mysql.com/doc/refman/5.0/en/mysql-benchmarks.html Yes, I am looking at it now. But still I need TPC benchmark which is standard in transactions world! If I