Re: syntax to create a user called starsky

2012-02-29 Thread Chris Tate-Davies
of password for a user called starsky! -- *Chris Tate-Davies* *Software Development* Inflight Productions Ltd Telephone: 01295 269 680 15 Stukeley Street | London | WC2B 5LT *Email:*chris.tatedav...@inflightproductions.com mailto:chris.tatedav...@inflightproductions.com *Web:*www.inflightproductions.com

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Chris Tate-Davies
: [FAILED] Nothing at all is written to the error log. But if I start it with mysqld_safe it comes up and works fine. Anyone know what could be going on here? -larry -- *Chris Tate-Davies* *Software Development* Inflight Productions Ltd Telephone: 01295 269 680 15

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Chris Tate-Davies
On 06/02/12 13:33, Larry Martell wrote: On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies chris.tatedav...@inflightproductions.com wrote: Have you tried: mysql --verbose -uusername -ppassword To output more information When would I use that? If I try to start it with 'service mysqld start

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Chris Tate-Davies
On 06/02/12 14:34, Reindl Harald wrote: Am 06.02.2012 15:28, schrieb Chris Tate-Davies: On 06/02/12 13:33, Larry Martell wrote: On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies chris.tatedav...@inflightproductions.com wrote: Have you tried: mysql --verbose -uusername -ppassword

Re: hide server-version at connect?

2012-01-10 Thread Chris Tate-Davies
On 10/01/12 15:41, Chris Tate-Davies wrote: On 10/01/12 13:34, Johan De Meersman wrote: - Original Message - From: Johnny Withersjoh...@pixelated.net Security through obscurity? That sentence has been overused way too much. If you want to remove all obscurity from your security, just

Re: hide server-version at connect?

2012-01-10 Thread Chris Tate-Davies
that this particular layer is not the first priority. Indeed, have a read of http://en.wikipedia.org/wiki/Defence_in_depth *Chris Tate-Davies* *Software Development* Inflight Productions Ltd Telephone: 01295 269 680 15 Stukeley Street | London | WC2B 5LT *Email:*chris.tatedav

Re: Chinese characters not displaying in Workbench latest version

2011-11-21 Thread Chris Tate-Davies
displays them? it sounds to me as if the display lacks something, not so much MySQL. -- Chris Tate-Davies chris.tatedav...@inflightproductions.com - Registered Office: 15 Stukeley Street, London WC2B 5LT, England. Registered in England number 1421223

Re: In case you all missed it.

2011-11-11 Thread Chris Tate-Davies
On Fri, 2011-11-11 at 16:38 +, Mark Goodge wrote: On 11/11/2011 16:29, Curtis Maurand wrote: mysql select date_format(now(),'%m-%d%-%y %h:%i:%s') AS time; +---+ | time | +---+ | 11-11-11 11:11:11 | +---+ 1 row in set

Re: Questions about Mysqldump

2011-09-15 Thread Chris Tate-Davies
that are need to changed in my.cnf to make backup restore faster. Thanks -- *Chris Tate-Davies* *Software Development* Inflight Productions Ltd Telephone: 01295 269 680 15 Stukeley Street | London | WC2B 5LT *Email:*chris.tatedav...@inflightproductions.com mailto:chris.tatedav

Re: Triggers - Accessing all NEW data

2011-09-13 Thread Chris Tate-Davies
, You'll have to write your own function for that. Cheers -- Luis Motta Campos is a DBA, Foodie, and Photographer -- *Chris Tate-Davies* *Software Development* Inflight Productions Ltd Telephone: 01295 269 680 15 Stukeley Street | London | WC2B 5LT *Email:*chris.tatedav...@inflightproductions.com

Re: Triggers - Accessing all NEW data

2011-09-13 Thread Chris Tate-Davies
, at 16:23, Chris Tate-Davies wrote: Hello. I want to know if there is a special way I can access all the data in the NEW/OLD data? I realise I can access it by referencing NEW.fieldname but I want to serialise the NEW object so I can save as a string. Is this possible or do I need to write

Triggers - Accessing all NEW data

2011-09-08 Thread Chris Tate-Davies
Tate-Davies* *Software Development* Inflight Productions Ltd Telephone: 01295 269 680 15 Stukeley Street | London | WC2B 5LT *Email:*chris.tatedav...@inflightproductions.com mailto:chris.tatedav...@inflightproductions.com *Web:*www.inflightproductions.com http://www.inflightproductions.com