MySQL Forums
Forum List  »  Newbie

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

Thank you for the reply...

Rick James Wrote:
-------------------------------------------------------
> > mysql -u root -p mypassword
>
> No space between "-p" and "mypassword".
>
> What do you get from
>
> SHOW VARIABLES LIKE '%explicit%';

I have removed the spaces.
I created a bat file called:
MySQLShowVariables.bat
---Start of bat file
@Echo On
set user=root
set password=MyPassword
set host=localhost
C:
CD C:\Programs\MySQL\MySQL Server 5.6\bin
mysqld -u%user% -p%password% --init-file=D:\Dnload\MySQLShowVariables.txt --console

CMD
--End of bat file

I created a txt file called:
MySQLShowVariables.txt
--Start of txt file
SHOW VARIABLES LIKE '%explicit%';
--End of txt file

When I run it I get:
C:\Programs\MySQL\MySQL Server 5.6\bin>mysqld -uroot -pMyPassword --init-file=D:
\Dnload\MySQLShowVariables.txt --console
2014-01-09 08:43:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

> > 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?
>
> docfxit.err is OK. But confusing when talking to
> us. Let's leave the name alone. Just remember
> the name and location.

Ok

> > 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!
>
> That is the serious error. This is on Windows?
> Somehow the directory where ibdata1 wants to be is
> not read-write by mysqld? Or mysqld is running as
> some not-so-priviledged user? Did Docfxit set
> this up?

This is in Windows7
This is where ibdata1 is:
C:\Programs\MySQL\MySQL Server 5.6\data\ibdata1

The permissions for the file are:
Network Service Full
System Full
Administrators Full
Users Read, Execute
LoggedInUser Full

Yes Docfxit set this up.

> > 2014-01-06 07:39:37 1508 [ERROR] mysqld: unknown
> option '-p'

I discovered the -p was because I used the password option in the bat file. When I removed the -pMyPassword the error doesn't show any more.

> Have you fiddled with the arguments to mysqld?

No.

> What is docfxit, anyway?
Docfxit is a user on the system.

> > The server at MyDomainName is taking too long to
> respond.
>
> Is docfxit involved in that?
I'm not sure what you are asking?

Thank you,

Docfxit



Edited 1 time(s). Last edit at 01/09/2014 11:30AM by Docfxit Inc..

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.