Re: TIMESTAMP with implicit DEFAULT value is deprecated
Posted by:
Rick James
Date: January 08, 2014 12:16PM
> mysql -u root -p mypassword
No space between "-p" and "mypassword".
What do you get from
SHOW VARIABLES LIKE '%explicit%';
> 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.
> 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?
> 2014-01-06 07:39:37 1508 [ERROR] mysqld: unknown option '-p'
Have you fiddled with the arguments to mysqld?
What is docfxit, anyway?
> The server at MyDomainName is taking too long to respond.
Is docfxit involved in that?
Subject
Written By
Posted
Re: TIMESTAMP with implicit DEFAULT value is deprecated
January 08, 2014 12:16PM
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.