MariaDB 10.1原始碼安裝執行mysql_install_db報錯"system tables failed"
--初始化MySQL資料庫的資料檔案失敗
[root@localhost maria]# ./scripts/mysql_install_db --user=mysql --datadir=/maria_data/
Installing MariaDB/MySQL system tables in '/maria_data/' ...
2016-06-17 17:31:21 140423554045920 [Note] ./bin/mysqld (mysqld 10.1.14-MariaDB) starting as process 13621 ...
Installation of system tables failed! Examine the logs in
/maria_data/ for more information.
The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:
shell> ./bin/scripts/mysql_install_db --defaults-file=~/.my.cnf
You can also try to start the mysqld daemon with:
shell> ./bin/mysqld --skip-grant --general-log &
and use the command line tool ./bin/mysql
to connect to the mysql database and look at the grant tables:
shell> ./bin/mysql -u root mysql
mysql> show tables;
Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /maria_data/ that may be helpful.
The latest information about mysql_install_db is available at
MariaDB is hosted on launchpad; You can find the latest source and
email lists at
Please check all of the above before submitting a bug report
at
報錯原因:
與/etc/my.cnf相沖突
解決方法:
將/etc/my.cnf改名
[root@localhost maria]# mv /etc/my.cnf /etc/my.cnf_5.7
--再次初始化資料檔案成功
[root@localhost maria]# ./scripts/mysql_install_db --user=mysql --datadir=/maria_data/
.....
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: Waiting for purge to start
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: Percona XtraDB () 5.6.29-76.2 started; log sequence number 1616819
2016-06-17 17:37:16 139706685712128 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue 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 the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at or the
MySQL manual for more instructions.
You can start the MariaDB daemon with:
cd '.' ; ./bin/mysqld_safe --datadir='/maria_data/'
You can test the MariaDB daemon with mysql-test-run.pl
cd './mysql-test' ; perl mysql-test-run.pl
Please report any problems at
The latest information about MariaDB is available at
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from MariaDB
Corporation Ab. You can contact us about this at sales@mariadb.com.
Alternatively consider joining our community based development effort:
/en/contributing-to-the-mariadb-project/
[root@localhost maria]# ./scripts/mysql_install_db --user=mysql --datadir=/maria_data/
Installing MariaDB/MySQL system tables in '/maria_data/' ...
2016-06-17 17:31:21 140423554045920 [Note] ./bin/mysqld (mysqld 10.1.14-MariaDB) starting as process 13621 ...
Installation of system tables failed! Examine the logs in
/maria_data/ for more information.
The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:
shell> ./bin/scripts/mysql_install_db --defaults-file=~/.my.cnf
You can also try to start the mysqld daemon with:
shell> ./bin/mysqld --skip-grant --general-log &
and use the command line tool ./bin/mysql
to connect to the mysql database and look at the grant tables:
shell> ./bin/mysql -u root mysql
mysql> show tables;
Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /maria_data/ that may be helpful.
The latest information about mysql_install_db is available at
MariaDB is hosted on launchpad; You can find the latest source and
email lists at
Please check all of the above before submitting a bug report
at
報錯原因:
與/etc/my.cnf相沖突
解決方法:
將/etc/my.cnf改名
[root@localhost maria]# mv /etc/my.cnf /etc/my.cnf_5.7
--再次初始化資料檔案成功
[root@localhost maria]# ./scripts/mysql_install_db --user=mysql --datadir=/maria_data/
.....
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: Waiting for purge to start
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: Percona XtraDB () 5.6.29-76.2 started; log sequence number 1616819
2016-06-17 17:37:16 139706685712128 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue 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 the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at or the
MySQL manual for more instructions.
You can start the MariaDB daemon with:
cd '.' ; ./bin/mysqld_safe --datadir='/maria_data/'
You can test the MariaDB daemon with mysql-test-run.pl
cd './mysql-test' ; perl mysql-test-run.pl
Please report any problems at
The latest information about MariaDB is available at
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from MariaDB
Corporation Ab. You can contact us about this at sales@mariadb.com.
Alternatively consider joining our community based development effort:
/en/contributing-to-the-mariadb-project/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26506993/viewspace-2120402/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mariaDB 10.1原始碼安裝原始碼
- MariaDB 10.1原始碼安裝流程(CentOS 6.5)原始碼CentOS
- MariaDB 10.1原始碼安裝報錯"Unknown CMake command "CHECK_CXX_SYMBOL_EXISTS""原始碼Symbol
- RHEL 7 安裝oracle rac 11.2.0.4執行root.sh報錯ohasd failed to startOracleAI
- MariaDB原始碼除錯原始碼除錯
- laradock 執行報錯 Service 'workspace' failed to build:AIUI
- 安裝RAC 執行root.sh指令碼報錯,解決辦法指令碼
- 安裝或執行clone報錯 Unable to find 'kshell' in path
- centos7.4原始碼安裝php,swoole,nginx,redis,mariadbCentOS原始碼PHPNginxRedis
- 安裝mysql原始碼出錯MySql原始碼
- sh指令碼執行報錯指令碼
- windows下安裝python3.6.4完成,執行報錯WindowsPython
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- 10g rac安裝crs,執行root.sh報錯
- samba原始碼安裝及除錯Samba原始碼除錯
- MariaDB安裝
- 執行yarn報錯-node_modules\pngquant-bin: Command failedYarnAI
- 原始碼編譯安裝 httpd2.4+MariaDB5.5+php5.4(LAMP)原始碼編譯httpdPHPLAMP
- 安裝android studio報錯Failed to install Intel HAXM.AndroidAIIntel
- OEL6.8上安裝11.2.0.2執行root.sh報錯
- 執行指令碼diagcollection.pl報錯指令碼GC
- 當在linux系統中安裝原始碼包出錯時,執行make clean在重新安裝Linux原始碼
- MariaDB 安裝配置
- 安裝ionic 報錯 安裝canvas報錯 解決辦法Canvas
- 11.2.0.4單例項ASM安裝報錯ohasd failed to ... line 73.單例ASMAI
- 安裝GRID CONTROL The OPMN Process Manager failed to start報錯處理AI
- sqlldr執行報錯:error while loading shared libraries: libclntsh.so.10.1:SQLErrorWhile
- nginx安裝報錯Nginx
- 安裝VUE報錯Vue
- 安裝CLUSTER碰到 Assertion failed offset fFileSize錯誤AI
- 35_安裝mariadb
- 【已解決】pip已經安裝好了模組,執行程式碼還是報錯說沒安裝行程
- Idea除錯Rocketmq原始碼編譯執行Idea除錯MQ原始碼編譯
- 安裝MySQL5.7報錯:The action ‘Install’ for product ‘MySQL Server 5.7.19’ failed.MySqlServerAI
- 安裝報錯,輸入新的admin密碼後提交報錯.密碼
- 執行用例報錯
- ./mongod命令執行報錯Go
- linuxmysql執行報錯LinuxMySql