MYSQL_INSTALL_DB Running Results

Source: Internet
Author: User
Tags crc32

#/usr/local/mysql/scripts/mysql_install_db >--defaults-file=/etc/my.cnf >--BASEDIR=/USR/LOCAL/MYSQ L >--datadir=/var/mysql/data >--user=mysqlinstalling mysql system tables ... 2015-12-20 00:00:55 0 [Note]/usr/local/mysql/bin/mysqld (mysqld 5.6.25) starting as Process 5720 ... 2015-12-20 00:00:55 5720 [note] innodb:using Atomics to ref count buffer pool pages2015-12-20 00:00:55 5720 [note] InnoDB : The InnoDB memory heap is disabled2015-12-20 00:00:55 5720 [Note] innodb:mutexes and rw_locks use GCC atomic BUILTINS20 15-12-20 00:00:55 5720 [note] innodb:memory barrier is not used2015-12-20 00:00:55 5720 [note] innodb:compressed tables Use zlib 1.2.32015-12-20 00:00:55 5720 [note] innodb:using CPU crc32 instructions2015-12-20 00:00:55 5720 [note] InnoDB: Initializing buffer pool, size = 128.0m2015-12-20 00:00:55 5720 [Note] innodb:completed initialization of buffer pool2015 -12-20 00:00:55 5720 [Note] innodb:the first specified data file./ibdata1 didn't exist:a new database to is created!2015-12-20 00:00:55 5720 [Note] innodb:setting file./ibdata1 size to MB 2015-12-20 00:00:55 5720 [Note] Innodb:database physically writes the file full:wait ... 2015-12-20 00:00:55 5720 [note] innodb:setting log file./ib_logfile101 size to ~ mb2015-12-20 00:00:56 5720 [note] Inno db:setting log file./ib_logfile1 size to mb2015-12-20 00:00:57 5720 [Note] innodb:renaming log file./ib_logfile101  To./ib_logfile02015-12-20 00:00:57 5720 [Warning] innodb:new log files created, lsn=457812015-12-20 00:00:57 5720 [Note] Innodb:doublewrite Buffer not found:creating new2015-12-20 00:00:57 5720 [Note] innodb:doublewrite buffer created2015- 12-20 00:00:57 5720 [Note] innodb:128 rollback segment (s) is active.2015-12-20 00:00:57 5720 [Warning] innodb:creating FOREIGN KEY constraint system tables.2015-12-20 00:00:57 5720 [Note] innodb:foreign key constraint system tables Created2 015-12-20 00:00:57 5720 [Note] innodb:creating TablespacE and datafile system tables.2015-12-20 00:00:57 5720 [Note] innodb:tablespace and datafile system tables created.2015-12 -20 00:00:57 5720 [note] innodb:waiting for purge to start2015-12-20 00:00:57 5720 [note] innodb:5.6.25 started;  Log sequence number 02015-12-20 00:00:58 5720 [note] Binlog end2015-12-20 00:00:58 5720 [note] innodb:fts optimize thread exiting.2015-12-20 00:00:58 5720 [Note] innodb:starting shutdown ... 2015-12-20 00:01:00 5720 [Note] Innodb:shutdown completed; Log sequence number 1625977OKFilling help tables ... 2015-12-20 00:01:00 0 [Note]/usr/local/mysql/bin/mysqld (mysqld 5.6.25) starting as Process 5742 ... 2015-12-20 00:01:00 5742 [note] innodb:using Atomics to ref count buffer pool pages2015-12-20 00:01:00 5742 [note] InnoDB : The InnoDB memory heap is disabled2015-12-20 00:01:00 5742 [Note] innodb:mutexes and rw_locks use GCC atomic BUILTINS20 15-12-20 00:01:00 5742 [note] innodb:memory barrier is not used2015-12-20 00:01:00 5742 [note] innodb:compressed tAbles use zlib 1.2.32015-12-20 00:01:00 5742 [note] innodb:using CPU crc32 instructions2015-12-20 00:01:00 5742 [note] in Nodb:initializing buffer pool, size = 128.0m2015-12-20 00:01:00 5742 [Note] innodb:completed initialization of buffer PO ol2015-12-20 00:01:00 5742 [note] innodb:highest supported file format is barracuda.2015-12-20 00:01:00 5742 [note] InnoD b:128 rollback segment (s) is active.2015-12-20 00:01:00 5742 [Note] innodb:waiting for purge to start2015-12-20 00:01:0 0 5742 [Note] innodb:5.6.25 started; Log sequence number 16259772015-12-20 00:01:00 5742 [note] Binlog end2015-12-20 00:01:00 5742 [note] Innodb:fts optimize Thread exiting.2015-12-20 00:01:00 5742 [Note] innodb:starting shutdown ... 2015-12-20 00:01:01 5742 [Note] Innodb:shutdown completed; Log sequence number 1625987OKTo start mysqld at boot time with Copysupport-files/mysql.server to the right place fo R your systemplease REMEMBER to SET A PASSWORD for the MySQL root USER! To does so, start the SERVer, then issue the following commands:/usr/local/mysql/bin/mysqladmin-u root password ' new-password '/usr/local/mysql /bin/mysqladmin-u root-h R6 password ' New-password ' Alternatively you can run:/usr/local/mysql/bin/mysql_secure_instal  Lationwhich would also give you the option of removing the testdatabases and anonymous user created by default. This isstrongly recommended for production servers. See the Manual for more instructions. You can start the MySQL daemon with:cd. ; /usr/local/mysql/bin/mysqld_safe &you can test the MySQL daemon with mysql-test-run.pl CD mysql-test; Perl mysql-test-run.plplease Report No problems at Http://bugs.mysql.com/The latest information on MySQL is available On the web at Http://www.mysql.comSupport MySQL by buying support/licenses at Http://shop.mysql.comWARNING:Found Existin G Config file/usr/local/mysql/my.cnf on the system. Because This file might is in use, it is not replaced,but is used in bootstrap (unless you used--defaults-file) and when you later start the server. The new default Config file is created as/usr/local/mysql/my-new.cnf,please compare it with your file and take the Chang Es you need. Warning:default config file/etc/my.cnf exists on the systemthis file would be is read by Default by the MySQL Serverif you D O Want to use this, either remove it, or use the--defaults-file argument to Mysqld_safe when starting the server

MYSQL_INSTALL_DB Running Results

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.