1045 Error accessing mysql db

2014-08-20 Thread Augori
After an operating system change (CentOS 5 to CentOS 6), my Python script could no longer connect with mysql database. I get the following error... mysql_exceptions.OperationalError: (1045, "Access denied for user 'foo'@ 'localhost ' (using password: YES)") I have granted all on all databases to

Re: mysqld_safe running a long time

2014-08-20 Thread Augori
Maybe it's because I'm accessing it through a C Panel SSH Shell that it acts differently than you expected. It doesn't matter anyway… I was able to exit the shell and regain control of my shell. I'm giving up on the upgrade approach for now, so let's consider this conversation concluded. On We

Re: mysqld_safe running a long time

2014-08-20 Thread Reindl Harald
Am 21.08.2014 um 01:05 schrieb Augori: > when I use the bg command, it says > > 1 job already in background > > and continues to run in the foreground. *bullshit* if it is running in foreground you can't enter anything because your terminal would be blocked, the bg command only works if you s

Re: mysqld_safe running a long time

2014-08-20 Thread Augori
Hi All, when I use the bg command, it says 1 job already in background and continues to run in the foreground. On Wed, Aug 20, 2014 at 11:04 AM, Reindl Harald wrote: > > > Am 20.08.2014 um 16:39 schrieb Augori: > > However, it's been 12 hours now and the thing is still restarting in safe > >

Stored procedure debuggers

2014-08-20 Thread Larry Martell
Does anyone know of any debuggers for stored procs that run on Mac and/or Linux? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: how to access Synology's mysql (mariadb) on the command line

2014-08-20 Thread Wybo
Yes, that worked - thank you very much! On 2014-08-20 22:51, shawn l.green wrote: Hello Wybo, I cleansed your reply and cc:'ed the list again to share the answer. On 8/20/2014 4:24 PM, Wybo wrote: Hi Shawn, Thanks for your prompt reply - I suppose I'll have to do that query via phpMysqlAdmin

Re: how to access Synology's mysql (mariadb) on the command line

2014-08-20 Thread shawn l.green
Hello Wybo, I cleansed your reply and cc:'ed the list again to share the answer. On 8/20/2014 4:24 PM, Wybo wrote: Hi Shawn, Thanks for your prompt reply - I suppose I'll have to do that query via phpMysqlAdmin. When I do that, the only host that appears is localhost. However, when I browse th

Re: how to access Synology's mysql (mariadb) on the command line

2014-08-20 Thread shawn l.green
Hi Wybo, On 8/20/2014 3:47 PM, Wybo wrote: My Synology station is on 192.168.178.27, the database listens to port 3306, on my FritzBox I forwarded port 3306 to 192.168.178.27, I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/ But when I try: mysql --host=192.168.178.27 --pass

how to access Synology's mysql (mariadb) on the command line

2014-08-20 Thread Wybo
My Synology station is on 192.168.178.27, the database listens to port 3306, on my FritzBox I forwarded port 3306 to 192.168.178.27, I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/ But when I try: mysql --host=192.168.178.27 --password=* --user=wybo I get: ERROR 1045 (2

Re: inconsistent optimization

2014-08-20 Thread shawn l.green
Hi Jim, On 8/20/2014 11:04 AM, Jim wrote: Without going into specific details on queries... Using mysql 5.1 as provided with CentOS6, I've noticed some queries providing what I can best explain as inconsistent optimization. The database can be quieted to just controlled queries and at times the

Re: inconsistent optimization

2014-08-20 Thread Jim
innodb On 8/20/2014 1:22 PM, Martin Gainty wrote: Jim/Jaime What engine are you implementing?/ Qual mecanismo de MySQL que você está implementando? Saludos desde Sud America Martín Date: Wed, 20 Aug 2014 13:54:46 -0300 Subject: Re: inconsistent optimization From: edua...@gerencianet.com.br T

RE: inconsistent optimization

2014-08-20 Thread Martin Gainty
Jim/Jaime What engine are you implementing?/ Qual mecanismo de MySQL que você está implementando? Saludos desde Sud America Martín > Date: Wed, 20 Aug 2014 13:54:46 -0300 > Subject: Re: inconsistent optimization > From: edua...@gerencianet.com.br > To: j...@lowcarbfriends.com > CC: mysql@lists.m

Re: mysqld_safe running a long time

2014-08-20 Thread Reindl Harald
Am 20.08.2014 um 18:55 schrieb Augori: > Thanks! But if it's running in the background, how will I know when it has > completed? completed what?! http://www.catb.org/esr/faqs/smart-questions.html#beprecise what did you not understand in the paragraph below? >> mysqld_safe has *nothing* to do

Re: inconsistent optimization

2014-08-20 Thread Eduardo Fontinelle - Gerencianet Pagamentos
Well, Try to start checking the IOPs vs Disc. Check your iowait and the cache size. Could you send a "create table" and the query for us? Atenciosamente, *Eduardo Fontinelle* *Chief Technology Officer | G**erencianet* Phone: +55 (31) 3603-0812 2014-08-20 12:04 GMT-03:00 Jim : > Without

Re: mysqld_safe running a long time

2014-08-20 Thread Augori
Thanks! But if it's running in the background, how will I know when it has completed? On Wed, Aug 20, 2014 at 11:04 AM, Reindl Harald wrote: > > > Am 20.08.2014 um 16:39 schrieb Augori: > > However, it's been 12 hours now and the thing is still restarting in safe > > mode and I can't tell if i

Re: mysqld_safe running a long time

2014-08-20 Thread Reindl Harald
Am 20.08.2014 um 16:39 schrieb Augori: > However, it's been 12 hours now and the thing is still restarting in safe > mode and I can't tell if it's making progress. The command I typed was > > /usr/bin/mysqld_safe --skip-grant-tables& > > I think I forgot to include the ampersand (&) at the end

inconsistent optimization

2014-08-20 Thread Jim
Without going into specific details on queries... Using mysql 5.1 as provided with CentOS6, I've noticed some queries providing what I can best explain as inconsistent optimization. The database can be quieted to just controlled queries and at times the same query will return very quickly when

mysqld_safe running a long time

2014-08-20 Thread Augori
Hi all, mysql db has been starting in safe mode for 12 hours. I don't know if I should stop it or if I do, what will happen. I'm hoping one of you can help. Here's how I got into this mess: After a operating system change (CentOS 5 to CentOS 6), my Python script could no longer connect with mys