MySQL Learning notes

Objective

Did so long front-end development, after communicating with colleagues, found that the database of short board more and more affected the follow-up development, review some of the previously learned SQL related knowledge.

Start with the installation first. First to download the latest version of the official website 5.7.17, after yesterday to today's toss, degrees Niang also found a lot of predecessors, finally still failed.

Decompression card in Mysqld–install This step, always prompt 0x000000007 such a mistake.

Install the version card at the start of the service location, always prompt:

Start the service,

Service failed to start

Check log, display error:

2017-10-01t09:00:42.847997z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-10-01t09:00:42.847997z 0 [Warning] ' no_zero_date ', ' no_zero_in_date ' and ' Error_for_division_by_zero ' SQL modes Should is used with strict mode. They'll is merged with strict mode in a future release.
2017-10-01t09:00:47.277250z 0 [Warning] innodb:new log files created, lsn=45790
2017-10-01t09:00:47.917287z 0 [Warning] innodb:creating FOREIGN KEY constraint system tables.
2017-10-01t09:00:48.213304z 0 [Warning] No existing UUID have been found, so we assume that's the first time that thi s server has been started. Generating a new uuid:045da655-a687-11e7-8e7f-00ff4820d3b6.
2017-10-01t09:00:48.257306z 0 [Warning] Gtid table is not a ready-to-be used. Table ' mysql.gtid_executed ' cannot be opened.
2017-10-01t09:00:48.399314z 1 [Note] A temporary password is generated for [email protected]: awvkhaxww8=p

After two days of wasted time, pause this version.

Re-select the old version of the official website, the normal process installation, once done, unexpectedly smooth, enter the password, immediately appeared the normal use of the interface, from the installation to the use of 10 minutes are not, almost let me have nothing to say, years of no contact on the lag so far?????

MySQL Learning notes