MariaDB 10.1源码安装执行mysql_install_db报错"system tables failed"
发表于:2024-10-01 作者:千家信息网编辑
千家信息网最后更新 2024年10月01日,--初始化MySQL数据库的数据文件失败[root@localhost maria]# ./scripts/mysql_install_db --user=mysql --datadir=/maria
千家信息网最后更新 2024年10月01日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
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria
Please check all of the above before submitting a bug report
at http://mariadb.org/jira
报错原因:
与/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 (http://www.percona.com) 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 http://mariadb.com/kb 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 http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
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:
http://mariadb.com/kb/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
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria
Please check all of the above before submitting a bug report
at http://mariadb.org/jira
报错原因:
与/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 (http://www.percona.com) 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 http://mariadb.com/kb 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 http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
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:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
数据
文件
成功
再次
原因
数据库
方法
冲突
源码
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
我的世界服务器2009
佛山戴尔服务器诚邀品鉴
软件开发wbs任务表
删除数据库后台
网络安全学生含金量高的证
京东有多少服务器
网络安全防范知识手抄报
手机下载软件连不上服务器
网络安全等级保护的五个基本动作
数据开发和软件开发
实现无线网络安全的途径
长春华为鲲鹏服务器直销价格
网络安全保障书
南京家教行业软件开发去哪找
数据库中比较统计的函数
软件开发工具课程设计
安徽网络安全监管
php服务器教程视频学习
报警数据库作用是什么
怎么看云顶之弈手游服务器
上海志愿者活动数据库
徐汇区数据软件开发服务保障
网络侦察技术与网络技术侦查
哈尔滨软件开发园
访问服务器很慢
行政审批软件开发商
知网有网络安全论文吗
数据库删除后不能恢复吗
潍坊经信委 网络安全
网络安全国家联盟官网