Linux installation mysql-server-5.6.22 logs

Source: Internet
Author: User
Tags crc32 deprecated documentation

Recently in the study of MySQL installation, read a lot of online information, said a lot of the first time with the root of the way, have not succeeded.

Look at the installation log carefully, in fact, people are to create a random password, and have prompted how to change the password, completely not so troublesome.


[Email protected] src]# RPM-IVH mysql-server-5.6.22-1.rhel5.i386.rpm
Preparing ... ########################################### [100%]
1:mysql-server ########################################### [100%]
2015-01-29 09:51:25 0 [Warning] TIMESTAMP with implicit the DEFAULT value is deprecated. --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-29 09:51:25 28245 [Note] innodb:using mutexes to ref count buffer pool pages
2015-01-29 09:51:25 28245 [Note] innodb:the InnoDB memory heap is disabled
2015-01-29 09:51:25 28245 [Note] innodb:mutexes and rw_locks use InnoDB ' s own implementation
2015-01-29 09:51:25 28245 [Note] innodb:memory barrier is not used
2015-01-29 09:51:25 28245 [Note] innodb:compressed tables use zlib 1.2.3
2015-01-29 09:51:25 28245 [Note] innodb:using Linux native AIO
2015-01-29 09:51:25 28245 [Note] innodb:not using CPU CRC32 instructions
2015-01-29 09:51:25 28245 [Note] innodb:initializing buffer pool, size = 128.0M
2015-01-29 09:51:25 28245 [Note] innodb:completed initialization of buffer pool
2015-01-29 09:51:25 28245 [Note] innodb:the first specified data file./ibdata1 did not exist:a new database to be creat ed!
2015-01-29 09:51:25 28245 [Note] innodb:setting file./ibdata1 size to MB
2015-01-29 09:51:25 28245 [Note] Innodb:database physically writes the file full:wait ...
2015-01-29 09:51:25 28245 [Note] innodb:setting log file./ib_logfile101 size to + MB
2015-01-29 09:51:25 28245 [Note] innodb:setting log file./ib_logfile1 size to + MB
2015-01-29 09:51:26 28245 [Note] innodb:renaming log file./ib_logfile101 to./ib_logfile0
2015-01-29 09:51:26 28245 [Warning] innodb:new log files created, lsn=45781
2015-01-29 09:51:26 28245 [Note] innodb:doublewrite buffer not found:creating new
2015-01-29 09:51:26 28245 [Note] Innodb:doublewrite buffer created
2015-01-29 09:51:26 28245 [Note] innodb:128 rollback segment (s) is active.
2015-01-29 09:51:26 28245 [Warning] innodb:creating FOREIGN KEY constraint system tables.
2015-01-29 09:51:26 28245 [Note] innodb:foreign key constraint system tables created
2015-01-29 09:51:26 28245 [Note] innodb:creating tablespace and datafile system tables.
2015-01-29 09:51:26 28245 [Note] innodb:tablespace and datafile system tables created.
2015-01-29 09:51:26 28245 [Note] innodb:waiting for purge to start
2015-01-29 09:51:26 28245 [Note] innodb:5.6.22 started; Log sequence number 0
A random root password has been set. You'll find it in '/root/.mysql_secret '.
2015-01-29 09:51:26 28245 [Note] Binlog End
2015-01-29 09:51:26 28245 [Note] innodb:fts optimize thread exiting.
2015-01-29 09:51:26 28245 [Note] innodb:starting shutdown ...
2015-01-29 09:51:28 28245 [Note] Innodb:shutdown completed; Log sequence Number 1625977


2015-01-29 09:51:28 0 [Warning] TIMESTAMP with implicit the DEFAULT value is deprecated. --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-29 09:51:28 28267 [Note] innodb:using mutexes to ref count buffer pool pages
2015-01-29 09:51:28 28267 [Note] innodb:the InnoDB memory heap is disabled
2015-01-29 09:51:28 28267 [Note] innodb:mutexes and rw_locks use InnoDB ' s own implementation
2015-01-29 09:51:28 28267 [Note] innodb:memory barrier is not used
2015-01-29 09:51:28 28267 [Note] innodb:compressed tables use zlib 1.2.3
2015-01-29 09:51:28 28267 [Note] innodb:using Linux native AIO
2015-01-29 09:51:28 28267 [Note] innodb:not using CPU CRC32 instructions
2015-01-29 09:51:28 28267 [Note] innodb:initializing buffer pool, size = 128.0M
2015-01-29 09:51:28 28267 [Note] innodb:completed initialization of buffer pool
2015-01-29 09:51:28 28267 [Note] innodb:highest supported file format is Barracuda.
2015-01-29 09:51:28 28267 [Note] innodb:128 rollback segment (s) is active.
2015-01-29 09:51:28 28267 [Note] innodb:5.6.22 started; Log sequence Number 1625977
2015-01-29 09:51:28 28267 [Note] Binlog End
2015-01-29 09:51:28 28267 [Note] innodb:fts optimize thread exiting.
2015-01-29 09:51:28 28267 [Note] innodb:starting shutdown ...
2015-01-29 09:51:30 28267 [Note] Innodb:shutdown completed; Log sequence Number 1625987




A RANDOM PASSWORD have BEEN SET for the MySQL root USER!
You'll find that password in '/root/.mysql_secret '.

You must change this password on your first connect,
no other statement but ' SET PASSWORD ' would be accepted.
See the Manual for the semantics of the ' password expired ' flag.

Also, the anonymous user has been removed.

In addition, you can run:

/usr/bin/mysql_secure_installation

Which would also give you the option of removing the test database.
This is the strongly recommended for production servers.

See the Manual for more instructions.

Problems at http://bugs.mysql.com/

The latest information about MySQL was available on the Web at

Http://www.mysql.com

Support for MySQL by buying support/licenses at http://shop.mysql.com

New Default Config file was created as/usr/my.cnf and
Would be used by default by the server when you start it.
You could edit this file to the Change server settings

Linux installation mysql-server-5.6.22 logs

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.