Re: What does this error mean?
Hello. Please, check if the problem exists on the latest release (4.1.13 now). It might be a bug like: http://bugs.mysql.com/bug.php?id=9703 "Octavian Rasnita" <[EMAIL PROTECTED]> wrote: > Hi, > > I have tried the following query and it works fine. It takes 11 seconds and > this is a little too much, but this is another issue. > > The problem is that if I delete the following condition from it: > > a.id_categories=31 > > The query gives the following error: > > ERROR 1032 (HY000): Can't find record in '' > > What can I do to make it work? > > Thank you. > > select straight_join sql_calc_found_rows > a.hash, > a.pre_title, > a.title, > a.post_title, > substring(a.body, 1, 250) as preview, > a.hash, > a.date, > a.time, > length(a.body) as size, > a.id_categories, > n.name as newspaper, > sc.category, > count(act.id) as visitors, > count(aco.hash) as comments > from > articles a > inner join newspapers n on(a.id_newspapers=n.id) > inner join sections s on(a.id_sections=s.id and n.id=s.id_newspapers) > inner join sections_categories sc on(a.id_categories=sc.id) > left join articles_count act on(a.hash=act.hash_articles) > left join articles_comments aco on(a.hash=aco.hash_articles) > where > a.id_categories=31 > and a.date between '2005-01-01' and '2005-12-31' > and a.active_view=1 > group by a.hash > order by visitors > limit 0,30; > > Teddy > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What does this error mean?
Hi, I have tried the following query and it works fine. It takes 11 seconds and this is a little too much, but this is another issue. The problem is that if I delete the following condition from it: a.id_categories=31 The query gives the following error: ERROR 1032 (HY000): Can't find record in '' What can I do to make it work? Thank you. select straight_join sql_calc_found_rows a.hash, a.pre_title, a.title, a.post_title, substring(a.body, 1, 250) as preview, a.hash, a.date, a.time, length(a.body) as size, a.id_categories, n.name as newspaper, sc.category, count(act.id) as visitors, count(aco.hash) as comments from articles a inner join newspapers n on(a.id_newspapers=n.id) inner join sections s on(a.id_sections=s.id and n.id=s.id_newspapers) inner join sections_categories sc on(a.id_categories=sc.id) left join articles_count act on(a.hash=act.hash_articles) left join articles_comments aco on(a.hash=aco.hash_articles) where a.id_categories=31 and a.date between '2005-01-01' and '2005-12-31' and a.active_view=1 group by a.hash order by visitors limit 0,30; Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What does this error mean: "Duplicate entry '273' for key 1"
Hi! On Feb 05, Daniel R. Anderson wrote: > I got the following error on a perl script: > > "Duplicate entry '273' for key 1" > > I googled for it and found a thread telling me to DROP the table and re > CREATE it. So I did, and my script is working fine. My question: why > did this happen, why did dropping and recreating work, and what can I do > in the future if this happens and I've got things in my database I don't > want to DROP? The error means: CREATE TABLE test (a int primary key); insert test values (273); insert test values (273); If you got it for any other reason (which seems to be the case, as DROP+recreate helped) the answers would be: "why did this happen" - because you hit a bug (probably) "what can I do in the future if this happens" - submit a bugreport, including a repeatable test case on http:/bugs.mysql.com. This way you can make sure it won't happen for the third time :) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What does this error mean: "Duplicate entry '273' for key 1"
Paul DuBois wrote: At 15:50 + 2/5/04, Daniel R. Anderson wrote: I got the following error on a perl script: "Duplicate entry '273' for key 1" It means you tried to set the value of the column corresponding to key one to 273, and there was already a record that had that value. I googled for it and found a thread telling me to DROP the table and re CREATE it. So I did, and my script is working fine. My question: why did this happen, why did dropping and recreating work, and what can I do in the future if this happens and I've got things in my database I don't want to DROP? Can't tell why it happened without more information about your situation. The table had no rows when I did this insert. So there couldn't possibly be a problem with a duplicate key. I think there was a problem with the table I dropped and recreated. I was getting other weird errors and searching the archives told me to REPAIR TABLE them. So something's messed up. -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What does this error mean: "Duplicate entry '273' for key 1"
At 15:50 + 2/5/04, Daniel R. Anderson wrote: I got the following error on a perl script: "Duplicate entry '273' for key 1" It means you tried to set the value of the column corresponding to key one to 273, and there was already a record that had that value. I googled for it and found a thread telling me to DROP the table and re CREATE it. So I did, and my script is working fine. My question: why did this happen, why did dropping and recreating work, and what can I do in the future if this happens and I've got things in my database I don't want to DROP? Can't tell why it happened without more information about your situation. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What does this error mean: "Duplicate entry '273' for key 1"
On Thursday 05 February 2004 15:50, Daniel R. Anderson wrote: > I got the following error on a perl script: > > "Duplicate entry '273' for key 1" > > I googled for it and found a thread telling me to DROP the table and re > CREATE it. So I did, and my script is working fine. My question: why > did this happen, why did dropping and recreating work, and what can I do > in the future if this happens and I've got things in my database I don't > want to DROP? That's using a sledgehammer to put in a pin, and knocking the wall down instead. What it means is that you have an index (primary key or otherwise) on a column. You've defined that that index is a unique index, so there can only be one of that value in that column in the table. You've then tried to insert the same value twice. Two of the same != unique. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What does this error mean: "Duplicate entry '273' for key 1"
I got the following error on a perl script: "Duplicate entry '273' for key 1" I googled for it and found a thread telling me to DROP the table and re CREATE it. So I did, and my script is working fine. My question: why did this happen, why did dropping and recreating work, and what can I do in the future if this happens and I've got things in my database I don't want to DROP? Thanks in advance, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What does this error mean??!!
Thnx - Deryck H - http://www.comp-u-exchange.com - Original Message - From: "Attila Soki" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 05, 2001 8:42 PM Subject: Re: What does this error mean??!! > hi, > > try to execute this query too: > FLUSH PRIVILEGES; > > bye, > > ati > > - > 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: What does this error mean??!!
hi, try to execute this query too: FLUSH PRIVILEGES; bye, ati - 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: What does this error mean??!!
Well, I did the grant and still cannot connect. This is so annoying. Well, I tried putting these grants:: GRANT ALL ON *.* TO anonymous@"mydomainthatisnotshowninthisemail.com"; GRANT ALL ON *.* TO anonymous@anonymous; GRANT ALL ON *.* TO ""@""; So far, none have worked. any suggestions? I want anyone to be able to access my database. - Deryck H - http://www.comp-u-exchange.com - Original Message - From: "Venu" <[EMAIL PROTECTED]> To: "Deryck Henson" <[EMAIL PROTECTED]> Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, September 05, 2001 12:12 AM Subject: RE: What does this error mean??!! > > )-Original Message- > )From: Deryck Henson [mailto:[EMAIL PROTECTED]] > )Sent: Tuesday, September 04, 2001 10:10 PM > )To: [EMAIL PROTECTED] > )Cc: MySQL > )Subject: Re: What does this error mean??!! > ) > ) > )Would you be so kind as to do that step by step? I'm very new to this and > )don't know half this stuff (although I am starting to learn books, etc.). > )Please. Not tryin to get you mad or anything but I dont have a clue on how > )to go about doing that. > > Hummmaaa ok, here is the link, which guides you step by step in > depth than me. > http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm > inistration.html#Privilege_system > > Regards, venu > -- > For technical support contracts, go to https://order.mysql.com/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer > /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ><___/ www.mysql.com > ) > )- Deryck H > )- http://www.comp-u-exchange.com > )- Original Message - > )From: "Venu" <[EMAIL PROTECTED]> > )To: "Deryck Henson" <[EMAIL PROTECTED]>; "Joshua J. Kugler" > )<[EMAIL PROTECTED]> > )Cc: "MySQL" <[EMAIL PROTECTED]> > )Sent: Wednesday, September 05, 2001 12:00 AM > )Subject: RE: What does this error mean??!! > ) > ) > )> > )> )-Original Message- > )> )From: Deryck Henson [mailto:[EMAIL PROTECTED]] > )> )Sent: Tuesday, September 04, 2001 9:55 PM > )> )To: Joshua J. Kugler > )> )Cc: MySQL > )> )Subject: Re: What does this error mean??!! > )> ) > )> ) > )> )I know that!!! But how do I fix it? On the DSN, I put uid and > )> )pwd to blank > )> )because I did the same in the ODBC UserDSN setup window. > )> > )> Execute GRANT ALL ON *.* TO "some"@"something.com" IDENTIFIED BY > )> "mypassword" at the root level, and then try to connect it. This > )gives all > )> types of access to user "some" from "something.com". > )> > )> Regards, Venu > )> -- > )> For technical support contracts, go to https://order.mysql.com/ > )>__ ___ ___ __ > )> / |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTECTED]> > )> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer > )> /_/ /_/\_, /___/\___\_\___/ Woodside, California USA > )><___/ www.mysql.com > )> > )> ) > )> )- Deryck H > )> )- http://www.comp-u-exchange.com > )> )- Original Message - > )> )From: "Joshua J. Kugler" <[EMAIL PROTECTED]> > )> )To: "Deryck Henson" <[EMAIL PROTECTED]>; "Deryck Henson" > )> )<[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> > )> )Sent: Tuesday, September 04, 2001 7:02 PM > )> )Subject: Re: What does this error mean??!! > )> ) > )> ) > )> )> It means that access for the user connecting from the domain > )> )something.com > )> )> has been denied. You don't have permissions set up properly. > )> )> > )> )> j- k- > )> )> > )> )> On Tuesday 04 September 2001 15:59, Deryck Henson wrote: > )> )> > [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' > )to database > )> )> > 'dbasename' > )> )> > > )> )> > I get this every time I try to connect with mysql. > )> )> > )> )> -- > )> )> Joshua Kugler, Information Services Director > )> )> Associated Students of the University of Alaska Fairbanks > )> )> [EMAIL PROTECTED], 907-474-7601 > )> )> > )> )> - > )> )> Before posting, please check: > )> )>http://www.mysql.com/manual.php (the manual) > )> )>http:/
RE: What does this error mean??!!
)-Original Message- )From: Deryck Henson [mailto:[EMAIL PROTECTED]] )Sent: Tuesday, September 04, 2001 10:10 PM )To: [EMAIL PROTECTED] )Cc: MySQL )Subject: Re: What does this error mean??!! ) ) )Would you be so kind as to do that step by step? I'm very new to this and )don't know half this stuff (although I am starting to learn books, etc.). )Please. Not tryin to get you mad or anything but I dont have a clue on how )to go about doing that. Hummmaaa ok, here is the link, which guides you step by step in depth than me. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#Privilege_system Regards, venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA <___/ www.mysql.com ) )- Deryck H )- http://www.comp-u-exchange.com )- Original Message - )From: "Venu" <[EMAIL PROTECTED]> )To: "Deryck Henson" <[EMAIL PROTECTED]>; "Joshua J. Kugler" )<[EMAIL PROTECTED]> )Cc: "MySQL" <[EMAIL PROTECTED]> )Sent: Wednesday, September 05, 2001 12:00 AM )Subject: RE: What does this error mean??!! ) ) )> )> )-Original Message- )> )From: Deryck Henson [mailto:[EMAIL PROTECTED]] )> )Sent: Tuesday, September 04, 2001 9:55 PM )> )To: Joshua J. Kugler )> )Cc: MySQL )> )Subject: Re: What does this error mean??!! )> ) )> ) )> )I know that!!! But how do I fix it? On the DSN, I put uid and )> )pwd to blank )> )because I did the same in the ODBC UserDSN setup window. )> )> Execute GRANT ALL ON *.* TO "some"@"something.com" IDENTIFIED BY )> "mypassword" at the root level, and then try to connect it. This )gives all )> types of access to user "some" from "something.com". )> )> Regards, Venu )> -- )> For technical support contracts, go to https://order.mysql.com/ )>__ ___ ___ __ )> / |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTECTED]> )> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer )> /_/ /_/\_, /___/\___\_\___/ Woodside, California USA )><___/ www.mysql.com )> )> ) )> )- Deryck H )> )- http://www.comp-u-exchange.com )> )- Original Message - )> )From: "Joshua J. Kugler" <[EMAIL PROTECTED]> )> )To: "Deryck Henson" <[EMAIL PROTECTED]>; "Deryck Henson" )> )<[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> )> )Sent: Tuesday, September 04, 2001 7:02 PM )> )Subject: Re: What does this error mean??!! )> ) )> ) )> )> It means that access for the user connecting from the domain )> )something.com )> )> has been denied. You don't have permissions set up properly. )> )> )> )> j- k- )> )> )> )> On Tuesday 04 September 2001 15:59, Deryck Henson wrote: )> )> > [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' )to database )> )> > 'dbasename' )> )> > )> )> > I get this every time I try to connect with mysql. )> )> )> )> -- )> )> Joshua Kugler, Information Services Director )> )> Associated Students of the University of Alaska Fairbanks )> )> [EMAIL PROTECTED], 907-474-7601 )> )> )> )> - )> )> 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 )> ) ) - 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: What does this error mean??!!
Would you be so kind as to do that step by step? I'm very new to this and don't know half this stuff (although I am starting to learn books, etc.). Please. Not tryin to get you mad or anything but I dont have a clue on how to go about doing that. - Deryck H - http://www.comp-u-exchange.com - Original Message - From: "Venu" <[EMAIL PROTECTED]> To: "Deryck Henson" <[EMAIL PROTECTED]>; "Joshua J. Kugler" <[EMAIL PROTECTED]> Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, September 05, 2001 12:00 AM Subject: RE: What does this error mean??!! > > )-Original Message- > )From: Deryck Henson [mailto:[EMAIL PROTECTED]] > )Sent: Tuesday, September 04, 2001 9:55 PM > )To: Joshua J. Kugler > )Cc: MySQL > )Subject: Re: What does this error mean??!! > ) > ) > )I know that!!! But how do I fix it? On the DSN, I put uid and > )pwd to blank > )because I did the same in the ODBC UserDSN setup window. > > Execute GRANT ALL ON *.* TO "some"@"something.com" IDENTIFIED BY > "mypassword" at the root level, and then try to connect it. This gives all > types of access to user "some" from "something.com". > > Regards, Venu > -- > For technical support contracts, go to https://order.mysql.com/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer > /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ><___/ www.mysql.com > > ) > )- Deryck H > )- http://www.comp-u-exchange.com > )- Original Message - > )From: "Joshua J. Kugler" <[EMAIL PROTECTED]> > )To: "Deryck Henson" <[EMAIL PROTECTED]>; "Deryck Henson" > )<[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> > )Sent: Tuesday, September 04, 2001 7:02 PM > )Subject: Re: What does this error mean??!! > ) > ) > )> It means that access for the user connecting from the domain > )something.com > )> has been denied. You don't have permissions set up properly. > )> > )> j- k- > )> > )> On Tuesday 04 September 2001 15:59, Deryck Henson wrote: > )> > [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' to database > )> > 'dbasename' > )> > > )> > I get this every time I try to connect with mysql. > )> > )> -- > )> Joshua Kugler, Information Services Director > )> Associated Students of the University of Alaska Fairbanks > )> [EMAIL PROTECTED], 907-474-7601 > )> > )> - > )> 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 > ) - 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: What does this error mean??!!
)-Original Message- )From: Deryck Henson [mailto:[EMAIL PROTECTED]] )Sent: Tuesday, September 04, 2001 9:55 PM )To: Joshua J. Kugler )Cc: MySQL )Subject: Re: What does this error mean??!! ) ) )I know that!!! But how do I fix it? On the DSN, I put uid and )pwd to blank )because I did the same in the ODBC UserDSN setup window. Execute GRANT ALL ON *.* TO "some"@"something.com" IDENTIFIED BY "mypassword" at the root level, and then try to connect it. This gives all types of access to user "some" from "something.com". Regards, Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA <___/ www.mysql.com ) )- Deryck H )- http://www.comp-u-exchange.com )- Original Message - )From: "Joshua J. Kugler" <[EMAIL PROTECTED]> )To: "Deryck Henson" <[EMAIL PROTECTED]>; "Deryck Henson" )<[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> )Sent: Tuesday, September 04, 2001 7:02 PM )Subject: Re: What does this error mean??!! ) ) )> It means that access for the user connecting from the domain )something.com )> has been denied. You don't have permissions set up properly. )> )> j- k- )> )> On Tuesday 04 September 2001 15:59, Deryck Henson wrote: )> > [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' to database )> > 'dbasename' )> > )> > I get this every time I try to connect with mysql. )> )> -- )> Joshua Kugler, Information Services Director )> Associated Students of the University of Alaska Fairbanks )> [EMAIL PROTECTED], 907-474-7601 )> )> - )> 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 ) - 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: What does this error mean??!!
I know that!!! But how do I fix it? On the DSN, I put uid and pwd to blank because I did the same in the ODBC UserDSN setup window. - Deryck H - http://www.comp-u-exchange.com - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]> To: "Deryck Henson" <[EMAIL PROTECTED]>; "Deryck Henson" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Tuesday, September 04, 2001 7:02 PM Subject: Re: What does this error mean??!! > It means that access for the user connecting from the domain something.com > has been denied. You don't have permissions set up properly. > > j- k- > > On Tuesday 04 September 2001 15:59, Deryck Henson wrote: > > [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' to database > > 'dbasename' > > > > I get this every time I try to connect with mysql. > > -- > Joshua Kugler, Information Services Director > Associated Students of the University of Alaska Fairbanks > [EMAIL PROTECTED], 907-474-7601 > > - > 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: What does this error mean??!!
It means that access for the user connecting from the domain something.com has been denied. You don't have permissions set up properly. j- k- On Tuesday 04 September 2001 15:59, Deryck Henson wrote: > [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' to database > 'dbasename' > > I get this every time I try to connect with mysql. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - 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
What does this error mean??!!
[TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' to database 'dbasename' I get this every time I try to connect with mysql. - Deryck H - http://www.comp-u-exchange.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