`

mariadb遇到Cannot change ownership of the database directories to the

阅读更多

修改了 /etc/my.cnf 将datadir改了,datadir=/data/mysql

无法启动,报错:

Mar 14 13:59:29 localhost.localdomain mariadb-prepare-db-dir[10433]: Cannot change ownership of the database directories to the 'mysql'

Mar 14 13:59:29 localhost.localdomain mariadb-prepare-db-dir[10433]: user.  Check that you have the necessary permissions and try again.

Mar 14 13:59:29 localhost.localdomain mariadb-prepare-db-dir[10433]: Initialization of MariaDB database failed.

Mar 14 13:59:29 localhost.localdomain mariadb-prepare-db-dir[10433]: Perhaps @sysconfdir@/my.cnf is misconfigured or there is some problem with permissions of /data/mysql.

 

 

是由于/data/mysql的文件拥有者导致的,修改所有者重启:

 

chown -R mysql:mysql /data/mysql

 

 

分享到:
评论

相关推荐

    Migrating to MariaDB: Toward an Open Source Database Solution

    The book discusses the drivers for making the decision and change, walking you through all aspects of the process from evaluating the licensing, navigating the pitfalls and hurdles of a migration, ...

    MariaDB Cookbook(PACKT,2014)

    It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world. This practical guide unlocks the advanced features of MariaDB’s capabilities,...

    mariadb-10.3.6-winx64.zip

    While we do our best to make the world’s best database software, the MariaDB Foundation does not provide any guarantees and cannot be hold liable for any issues you may encounter. The MariaDB ...

    MariaDB.High.Performance

    MariaDB.High.Performance 英文原版,mariadb详细介绍。 MariaDB is a new database that has ... It is also powerful enough to be the database of choice for some of the biggest and most popular websites i

    mariadb5-win32

    MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. To accomplish this, Monty Program works to hire the best and brightest ...

    Practical PHP 7, MySQL 8, and MariaDB Website Databases, Second Edition

    The PHP required is taught in context within each project so you can quickly learn how PHP integrates with MariaDB and MySQL to create powerful database-driven websites. Each project is fully ...

    MariaDB and MySQL common Table Expressions and Window Functions Revealed

    These new features in MariaDB and MySQL help you to write queries without having to wade through a quagmire of brittle self-joins and other crazy techniques from the past. Your queries will generate ...

    QT5.14的MariaDB/MySQL驱动DLL

    QT5.14下的MingW编译器MariaDB数据库32和64位驱动。 1.将sqldrivers下的两个文件分别放到mingw73_32(64)\plugins\sqldrivers目录 2.将bin下的libmariadb.dll分中放到mingw73_32(64)\bin目录 资源中的DLL在5.14.1下...

    mariadb-10.3.22-winx64.zip

    MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress....

    mariadb-10.0.7-winx64.zip

    While we do our best to make the world’s best database software, the MariaDB Foundation does not provide any guarantees and cannot be hold liable for any issues you may encounter.

    MariaDB环境包,安装MariaDB出现错误:Failed to start mariadb.service: Unit not found。

    mariadb安装依赖包 boost-program-options-1.53.0-27.el7.x86_64.rpm galera-4-26.4.2-1.rhel7.el7.centos.x86_64.rpm perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm perl-Compress-Raw-Zlib-2.061-4.el7.x86...

    MariaDB and MySQL Common Table Expressions and Window Functions Revealed

    These new features in MariaDB and MySQL help you to write queries without having to wade through a quagmire of brittle self-joins and other crazy techniques from the past. Your queries will generate ...

    针对mariadb报错问题

    原因:卸载mariadb时,必须停止服务 mariadb 和 mysql 卸载时建议不要使用yum remove 命令进行卸载 解决方案: 1,注意事项:先清理相关路径文件 rm -rf /var/lib/mysql/* rm -rf /etc/my.cnf 2,检查查看后台该指令...

    mariadb驱动,kettle连接mariadb驱动

    MariaDB是MySQL的一个分支,由MySQL的创始人Michael Widenius创建,旨在保持开源数据库的自由和开放性。它与MySQL高度兼容,但引入了许多增强功能,包括更好的性能、更高的稳定性和更多的存储引擎选择。Kettle是一款...

    mariaDB数据库驱动jar包

    `mariadb-java-client-1.5.2.jar`是MariaDB官方提供的Java连接驱动,用于让Java应用能够通过JDBC(Java Database Connectivity)接口与MariaDB数据库进行通信。这个驱动实现了JDBC API,使得Java开发者可以使用标准...

Global site tag (gtag.js) - Google Analytics