mysql --explicit_MySQL 5.6 中的 TIMESTAMP 和 explicit_defaults_for_timestamp 参数

最新推荐文章于 2024-03-11 10:59:06 发布

透明流动虚无

最新推荐文章于 2024-03-11 10:59:06 发布

阅读量117

点赞数

文章标签： mysql --explicit

本文链接：https://blog.csdn.net/weixin_35744067/article/details/113418293

版权

[root@localhost mysql]# scripts/mysql_install_db --user=mysql

Installing MySQL system tables...2015-08-13 14:20:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2015-08-13 14:20:09 0 [Note] ./bin/mysqld (mysqld 5.6.26) starting as process 1934...2015-08-13 14:20:09 1934 [Note] InnoDB: Using mutexes to ref countbuffer pool pages2015-08-13 14:20:09 1934 [Note] InnoDB: The InnoDB memory heap isdisabled2015-08-13 14:20:09 1934 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation

2015-08-13 14:20:09 1934 [Note] InnoDB: Memory barrier is not used

2015-08-13 14:20:09 1934 [Note] InnoDB: Compressed tables use zlib 1.2.3

2015-08-13 14:20:09 1934 [Note] InnoDB: Using Linux native AIO

2015-08-13 14:20:09 1934 [Note] InnoDB: Not using CPU crc32 instructions

2015-08-13 14:20:09 1934 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2015-08-13 14:20:09 1934 [Note] InnoDB: Completed initialization of buffer pool

2015-08-13 14:20:10 1934 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!

2015-08-13 14:20:10 1934 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB

2015-08-13 14:20:10 1934 [Note] InnoDB: Database physically writes the file full: wait...

2015-08-13 14:20:10 1934 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB

2015-08-13 14:20:11 1934 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB

2015-08-13 14:20:12 1934 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0

2015-08-13 14:20:12 1934 [Warning] InnoDB: New log files created, LSN=45781

2015-08-13 14:20:12 1934 [Note] InnoDB: Doublewrite buffer not found: creating new

2015-08-13 14:20:12 1934 [Note] InnoDB: Doublewrite buffer created

2015-08-13 14:20:12 1934 [Note] InnoDB: 128 rollback segment(s) are active.

2015-08-13 14:20:12 1934 [Warning] InnoDB: Creating foreign key constraint system tables.

2015-08-13 14:20:12 1934 [Note] InnoDB: Foreign key constraint system tables created

2015-08-13 14:20:12 1934 [Note] InnoDB: Creating tablespace and datafile system tables.

2015-08-13 14:20:12 1934 [Note] InnoDB: Tablespace and datafile system tables created.

2015-08-13 14:20:12 1934 [Note] InnoDB: Waiting for purge to start

2015-08-13 14:20:12 1934 [Note] InnoDB: 5.6.26 started; log sequence number 0

2015-08-13 14:20:14 1934 [Note] Binlog end

2015-08-13 14:20:14 1934 [Note] InnoDB: FTS optimize thread exiting.

2015-08-13 14:20:14 1934 [Note] InnoDB: Starting shutdown...

2015-08-13 14:20:16 1934 [Note] InnoDB: Shutdown completed; log sequence number 1625977

Filling help tables...2015-08-13 14:20:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.

Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2015-08-13 14:20:16 0 [Note] ./bin/mysqld (mysqld 5.6.26) starting as process 1957 ...

2015-08-13 14:20:16 1957 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2015-08-13 14:20:16 1957 [Note] InnoDB: The InnoDB memory heap is disabled

2015-08-13 14:20:16 1957 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation2015-08-13 14:20:16 1957 [Note] InnoDB: Memory barrier is notused2015-08-13 14:20:16 1957 [Note] InnoDB: Compressed tables use zlib 1.2.3

2015-08-13 14:20:16 1957 [Note]InnoDB: Using Linux native AIO2015-08-13 14:20:16 1957 [Note] InnoDB: Notusing CPU crc32 instructions2015-08-13 14:20:16 1957 [Note] InnoDB: Initializing buffer pool, size = 128.0M2015-08-13 14:20:16 1957 [Note] InnoDB: Completed initialization ofbuffer pool2015-08-13 14:20:16 1957 [Note] InnoDB: Highest supported file format isBarracuda.2015-08-13 14:20:16 1957 [Note] InnoDB: 128 rollbacksegment(s) are active.2015-08-13 14:20:16 1957 [Note] InnoDB: Waiting for purge tostart2015-08-13 14:20:16 1957 [Note] InnoDB: 5.6.26 started; log sequence number 1625977

2015-08-13 14:20:17 1957 [Note] Binlog end

2015-08-13 14:20:17 1957 [Note]InnoDB: FTS optimize thread exiting.2015-08-13 14:20:17 1957 [Note] InnoDB: Starting shutdown...2015-08-13 14:20:18 1957 [Note] InnoDB: Shutdown completed; log sequence number 1625987OKTo start mysqld at boot time you have tocopy

support-files/mysql.server to the right place foryour system

PLEASE REMEMBERTO SET A PASSWORD FOR THE MySQL root USER!To do so, start the server, thenissue the following commands:

./bin/mysqladmin -u root password 'new-password'./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'Alternatively you can run:

./bin/mysql_secure_installation

which will also give you theoption ofremoving the test

databasesand anonymous user created by default. This isstrongly recommendedforproduction servers.

See the manualformore instructions.

You can start the MySQL daemonwith:

cd . ; ./bin/mysqld_safe &You can test the MySQL daemonwith mysql-test-run.pl

cd mysql-test ; perl mysql-test-run.pl

Please reportany problems at http://bugs.mysql.com/The latest information about MySQLis available onthe web at

http://www.mysql.com

Support MySQLby buying support/licenses at http://shop.mysql.com

Newdefault config file was created as ./my.cnf andwill be usedby default by the server whenyou start it.

You may edit thisfile tochange server settings

WARNING:Default config file /etc/my.cnf exists onthe system

Thisfile will be read by default bythe MySQL serverIf you do not want to use this, either remove it, or usethe--defaults-file argument to mysqld_safe when starting the server

[root@localhost mysql]#