MySQL Forums
Forum List  »  Newbie

Re: TIMESTAMP with implicit DEFAULT value is deprecated
Posted by: Docfxit Inc.
Date: January 06, 2014 09:55AM

Thank you for the reply...

Rick James Wrote:
-------------------------------------------------------
> To run command(s) in mysql, use
>
> Start > run > cmd -- this will bring up a DOS-like
> "command" shell.
> mysql -u root -- this will bring up the _client_
> application for talking to mysqld. (You will also
> need -p if you have a password for "root".)
> SHOW PROCESSLIST; -- or other SQL commands
> exit; -- to leave mysql client
>
> The output will be on the cmd window.

I ran your suggestion. This is the output
C:\Programs\MySQL\MySQL Server 5.6\bin>mysql -u root -p mypassword
mysql: unknown variable 'explicit_defaults_for_timestamp=TRUE'

I have also seen suggestions on the internet suggesting this:
C:\Programs\MySQL\MySQL Server 5.6\bin>mysql -u root -p mypassword
mysql: unknown variable 'explicit_defaults_for_timestamp=1'

> > I don't have the file mysqld.err on this PC.
>
> I find that hard to believe. It may be in a
> directory that is inconveniently hidden by the OS.

I have searched my hard drive including hidden files
I don't have mysqld.err on the hard drive.
I did find docfxit.err
Is that ok? Should I change it to mysqld.err? (To follow standards)
If so how can I do that?

What is in the file is:
<cut>
2014-01-04 08:21:29 5224 [ERROR] Invalid (old?) table or database name 'Time_'135514'
2014-01-04 08:21:29 5224 [ERROR] Invalid (old?) table or database name 'Time_'135514'
2014-01-05 08:16:06 5224 [ERROR] Invalid (old?) table or database name 'Time_'135514'
2014-01-05 08:16:06 5224 [ERROR] Invalid (old?) table or database name 'Time_'135514'
2014-01-06 07:39:37 1508 [Note] Plugin 'FEDERATED' is disabled.
2014-01-06 07:39:37 1c88 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-01-06 07:39:37 1508 [Note] InnoDB: The InnoDB memory heap is disabled
2014-01-06 07:39:37 1508 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-01-06 07:39:37 1508 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-01-06 07:39:37 1508 [Note] InnoDB: Not using CPU crc32 instructions
2014-01-06 07:39:37 1508 [Note] InnoDB: Initializing buffer pool, size = 61.0M
2014-01-06 07:39:37 1508 [Note] InnoDB: Completed initialization of buffer pool
2014-01-06 07:39:37 1508 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode
2014-01-06 07:39:37 1508 [ERROR] InnoDB: The system tablespace must be writable!
2014-01-06 07:39:37 1508 [ERROR] Plugin 'InnoDB' init function returned error.
2014-01-06 07:39:37 1508 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-01-06 07:39:37 1508 [ERROR] mysqld: unknown option '-p'
2014-01-06 07:39:37 1508 [ERROR] Aborting
<cut>

Thank you,

Docfxit

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.