Re: access denied error
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 - Original Message - From: Jim Lyons To: Jesse Cc: MySQL List Sent: Friday, October 10, 2008 8:28 AM Subject: Re: access denied error 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 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 password and after typing it in, I'm in. I can also see the only database I've given that user access to, and I tried a simple SELECT and it worked fine. However, when I access the database through the PHP application, I get the error, Access denied for user 'trucksma_db'@'localhost' (using password: YES) Can anyone tell me what the issue could be here? Why would I have access denied through the PHP application, but not through the MySQL client? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
How could i check the following values in MySQL Server 5.0
Thanks Amit ... Thanks Regards Sudhir
Re: How could i check the following values in MySQL Server 5.0
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:http://lists.mysql.com/[EMAIL PROTECTED]
access denied error
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 password and after typing it in, I'm in. I can also see the only database I've given that user access to, and I tried a simple SELECT and it worked fine. However, when I access the database through the PHP application, I get the error, Access denied for user 'trucksma_db'@'localhost' (using password: YES) Can anyone tell me what the issue could be here? Why would I have access denied through the PHP application, but not through the MySQL client? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access denied error
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 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 password and after typing it in, I'm in. I can also see the only database I've given that user access to, and I tried a simple SELECT and it worked fine. However, when I access the database through the PHP application, I get the error, Access denied for user 'trucksma_db'@'localhost' (using password: YES) Can anyone tell me what the issue could be here? Why would I have access denied through the PHP application, but not through the MySQL client? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
RE: Finding gaps
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 workaround for 4.1.22: SELECT a.id+1 AS 'Missing From', MIN(b.id) - 1 AS 'To' FROM tbl AS a, tbl AS b WHERE a.id b.id GROUP BY a.id HAVING `Missing From` MIN(b.id); +--+--+ | Missing From | To | +--+--+ |3 |3 | |5 | 17 | +--+--+ PB US Data Export wrote: Well, 5.x accepted the query. It's been running for awhile, now, so I'll find out later if it did what I need. -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 5:25 PM To: Jerry Schwartz; mysql@lists.mysql.com Subject: Re: Finding gaps I must be missing something obvious; or does this not work in 4.1.22? Looks like a 4.1.22 bug. PB Jerry Schwartz wrote: I'm finally getting back to this issue, and I've read the bits on artfulsoftware. The example SELECT a.id+1 AS 'Missing From', MIN(b.id) - 1 AS 'To' FROM tbl AS a, tbl AS b WHERE a.id b.id GROUP BY a.id HAVING a.id MIN(b.id) - 1; Looks like exactly what I want. However, when I try it (prod is my tbl, prod_num is my id) I get mysql select a.prod_num + 1 AS `Missing From`, - MIN(b.prod_num - 1) AS `To` - from prod as a, prod as b - where a.prod_num b.prod_num - group by a.prod_num - having a.prod_num min(b.prod_num) -1 ; ERROR 1054 (42S22): Unknown column 'a.prod_num' in 'having clause' I must be missing something obvious; or does this not work in 4.1.22? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 5:26 PM To: Stut; mysql@lists.mysql.com Subject: Re: Finding gaps Is there any elegant way of finding the gaps? You'll find some ideas under (and near) Find missing numbers in a sequence at http://www.artfulsoftware.com/infotree/queries.php. PB - Stut wrote: On 17 Sep 2008, at 22:12, Jerry Schwartz wrote: I have records that should be sequentially (not auto-increment) numbered, but there are gaps. Is there any elegant way of finding the gaps? Why do they need to be sequential? When this requirement comes up it's usually for illogical reasons. -Stut -- -- No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1677 - Release Date: 9/17/2008 5:07 PM -- -- No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.7.6/1713 - Release Date: 10/7/2008 6:40 PM _ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.7.6/1713 - Release Date: 10/7/2008 6:40 PM
RE: Trouble with large data in MySql
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@lists.mysql.com Subject: Trouble with large data in MySql Hi, We have 4 tables in which we have approximately 40 Million records per month. We are having trouble getting results from MySql as it takes about 4-5 hours to complete for each query. We are using this primarily for reporting purposes. My table schema is as follows SMAS Table: Column Name Type Key adnetwork adnetworkResponse campaignName clientRequest logkey loggingTime logmodule pageName propertyName requestId requestSystemId serverResponse sessionId siteName sucess systemId varchar(3999) text varchar(3999) varchar(3999) varchar(3999) timestamp varchar(3999) varchar(3999) varchar(3999) varchar(3999) varchar(3999) text varchar(256) varchar(3999) int(11) varchar(3999) MUL MUL Currently, SMAS table has 40Million records and our query takes 5 hours to execute. My my.cnf file is as follows and all tables are InnoDB. [mysqld] datadir=/mnt/data-store/mysql/data socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid innodb_data_home_dir=/mnt/data-store/mysql/data innodb_data_file_path=ibdata1:15G:autoextend innodb_buffer_pool_size=3G max_connections=200 tmpdir=/mnt/data-store/tmp [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid My query is as follows on SMAS table select campaignName, siteName, adnetwork,date_format(loggingTime ,'%d/%m/%Y') logDate, count(distinct requestid) adpages from SMAS where sucess = 1 GROUP BY 1,2,3,4; Any help will be highly appreciated. -Karthik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL TPC benchmark
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
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 dont get it I have to survive with sql-bench only. Sachin HTH Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Fri, 10 Oct 2008 18:21:01 -0400 From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySQL TPC benchmark 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] See how Windows connects the people, information, and fun that are part of your life. See Now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]