Shulou(Shulou.com)06/01 Report--

The following to understand some of the problems often encountered when initializing the MYSQL database, I believe you will benefit a lot after reading, the text is not much in the essence, hope that some of the problems often encountered in the initialization of the MYSQL database this short article is what you want.

Prompt for missing perl and data::dumper when initializing MYSQL database

At this time, two packages need to be installed.

Yum install perl

Yum install autoconf

Prompt innodb database file size error when initializing MYSQL database

2018-08-28 18:01:51 26794 [ERROR] InnoDB: auto-extending data file. / ibdata1 is of a different size 768 pages (rounded down to MB) than specified in the .cnf file: initial 131072 pages, max 0 (relevant if non-zero) pagesystems 2018-08-28 18:01:51 26794 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data 2018-08-28 18:01:51 26794 [ERROR] Plugin 'InnoDB' init function returned error.2018-08-28 18:01:51 26794 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2018-08-28 18:01:51 26794 [ERROR] Unknown/unsupported storage engine: InnoDB2018-08-28 18:01:51 26794 [ERROR] Aborting

This is because there are other my.cnf files in the system. As long as the initialization file my.cnf is specified during initialization, it is OK.

/ opt/mysql/scripts/mysql_install_db-- datadir=/data/mysqldata/3306/data-- basedir=/opt/mysql-- defaults-file='/data/mysqldata/3306/my.cnf' Installing MySQL system tables...2018-08-28 18:04:30 0 [Note] / opt/mysql/bin/mysqld (mysqld 5.6.31-log) starting as process 26865... OKFilling help tables...2018-08-28 18:05:03 0 [Note] / opt/mysql/ Bin/mysqld (mysqld 5.6.31-log) starting as process 26889... OKTo start mysqld at boot time you have to copysupport-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER! To do so Start the server, then issue the following commands: / opt/mysql/bin/mysqladmin-u root password' new-password' / opt/mysql/bin/mysqladmin-u root-h mysql01 password' new-password'Alternatively you can run: / opt/mysql/bin/mysql_secure_installationwhich will 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. / opt/mysql/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test Perl mysql-test-run.plPlease report any problems at http://bugs.mysql.com/The latest information about MySQL is available on the web at http://www.mysql.comSupport MySQL by buying support/licenses at http://shop.mysql.comWARNING: Found existing config file / opt/mysql/my.cnf on the system.Because this file might be in use, it was not replaced,but was used in bootstrap (unless you used-- defaults-file) and when you later start the server.The new default config file was created as / opt/mysql/my-new.cnf Please compare it with your file and take the changes you need.WARNING: Default config file / etc/my.cnf exists on the systemThis file will be read by default by the MySQL serverIf you do not want to use this, either remove it, or use the

-- defaults-file argument to mysqld_safe when starting the server

After reading the summary of some problems often encountered in the initialization of MYSQL database, many readers will want to know more about it. If you need more industry information, you can follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.