Database persistent read error

2007-07-09 Thread eric
Hi Am trying to access a web page in browser and get results from an old mysql database. The database has since been updated, but still see the original items. On 3 computers, the same problem, on 2, have deleted apache and mysql, no change - uninstalled IE7 - reinstalled and eventually the pro

Variables not been updated when I fetch a cursor

2007-07-09 Thread Sergio Bobillier
Hello there, I have a problem, I wrote a stored procedure to retrieve some data from various tables and then put it in a temporary table to use it later, most of the procedure works just fine but there's something that doesn't and I can not guess what the error can be. Okay so, here's the thing:

回复: why can I not edit my databas e using mySQL administrator ?

2007-07-09 Thread xian liu
MySQL administrator mainly focus on MySQL server status monitor/use management/security/backup/restore etc. If you want to edite database, you should use MySQL query browser, it's included in MySQL GUI tools package. Weiqi Wang <[EMAIL PROTECTED]> 写道: Dear everyone: I'm trying to si

Re: error in login

2007-07-09 Thread Mario Guenterberg
On Mon, Jul 09, 2007 at 04:33:04PM -0500, Héctor S. Mendoza O. wrote: > The problem persists, with /usr/bin/mysql or with a php application, same > sympthoms > > On the local host (where the mysqld resides) I do the same command and get > a > > “ERROR 1045 (28000): Access denied for user 'web19_u1

RE: error in login

2007-07-09 Thread Héctor S . Mendoza O .
Gracias Carlos, I've tried that already with no results, I've left only the [EMAIL PROTECTED] and have no luck logging in from the same machine the mysqld is running, I can log in perfectly from anywhere. TIA Hector S. Mendoza O -Mensaje original- De: Carlos Proal [mailto:[EMAIL PROTEC

Re: error in login

2007-07-09 Thread Carlos Proal
Hola Hector, el problema son las 2 tuplas que mencionas, ya que debido a su jerarquia pueden hacer un conflicto que te evita conectarte correctamente, en tu caso si deseas que el usuario se conecte desde donde sea (%) elimina la tupla de la tabla user donde aparezca el localhost, esto puede s

RE: error in login

2007-07-09 Thread Héctor S . Mendoza O .
The problem persists, with /usr/bin/mysql or with a php application, same sympthoms TIA Hector -Mensaje original- De: Gerald L. Clark [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 09 de Julio de 2007 02:54 p.m. Para: "Héctor S. Mendoza O." CC: mysql@lists.mysql.com Asunto: Re: error in l

RE: why can I not edit my database using mySQL administrator ?

2007-07-09 Thread cfaust-dougot
Are you sure the MySQL user you have defined in your GUI tool has the proper table permissions? Just a thought -Chris From: Weiqi Wang [mailto:[EMAIL PROTECTED] Sent: Mon 7/9/2007 4:46 PM To: mysql@lists.mysql.com Subject: why can I not edit my database using

why can I not edit my database using mySQL administrator ?

2007-07-09 Thread Weiqi Wang
Dear everyone: I'm trying to simplify the operating of mySQL by using a GUI tool, mySQL administrator. But it seems that I was only allowed to view the databases which I have made up, but not allowed to edit them. Is it because I have to buy a lisence or something which I didn't buy? Thanks fo

Re: error in login

2007-07-09 Thread Gerald L. Clark
Héctor S. Mendoza O. wrote: Hello all… I’ve scratched my head for a while on this one, so if someone could shed some Light on it I would appreciate it very much I have an account setup, and know about the password settings regarding hosts. The account is named web19_u1, and has listed ‘%’ a

error in login

2007-07-09 Thread Héctor S . Mendoza O .
Hello all… I’ve scratched my head for a while on this one, so if someone could shed some Light on it I would appreciate it very much I have an account setup, and know about the password settings regarding hosts. The account is named web19_u1, and has listed ‘%’ and ‘localhost’ as posible hosts

Re: MySQL and 'ODBC'@'localhost' error

2007-07-09 Thread kapil kaushik
Hi All, Thanks a lot for your help. The thing is working now. Although I would like to mention a couple of points: 1. mysql -u root -p test_dev wrote: You didn't specify a user or password on your mysql command line when you redirected your input to your .sql file, and for some reason the defa

Re: Recursive queries

2007-07-09 Thread David T. Ashley
On 7/8/07, Steffan A. Cline <[EMAIL PROTECTED]> wrote: I am trying to set up a forum where there are main posts with replies and replies to replies. Rather than using nested queries in my middleware I am thinking there has to be some kind of recursive query where I can output the results in a fo

RE: MySQL and 'ODBC'@'localhost' error

2007-07-09 Thread Jerry Schwartz
You didn't specify a user or password on your mysql command line when you redirected your input to your .sql file, and for some reason the default is [EMAIL PROTECTED] You need to use the -p and -u options on the command line. Regards, Jerry Schwartz The Infoshop by Global Information Incorporat

Re: Recursive queries

2007-07-09 Thread Baron Schwartz
Hi, Steffan A. Cline wrote: I am trying to set up a forum where there are main posts with replies and replies to replies. Rather than using nested queries in my middleware I am thinking there has to be some kind of recursive query where I can output the results in a format like so: MAIN Rep

Re: off-topic unsubscribe concern

2007-07-09 Thread Martijn Tonies
> >> To unsubscribe:http://lists.mysql.com/mysql?unsub= > > If you don't want people to follow this link, why are you including > it? To stop the 'suffering', stop including junk that doesn't belong > in outgoing email. > > Jochem Stern, stern, but fair ;) Martijn Tonies Database Workbench -